[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Adding non-clustered indexs to a 100 million record table SQL2005

I am about to attempt to add a compisite index to a 30 gig    100million record table while online.

You guys see any pitfalls in doing this?  I am certain this will not affect my transication log at all. Well 99% sure.    
0
soccerman767
Asked:
soccerman767
2 Solutions
 
Chris MangusDatabase AdministratorCommented:
As I mentioned in your other question, this is a very heavy duty operation and I wouldn't attempt it online.  Also, if you are in FULL recovery mode it WILL affect your transaction log.
0
 
radcaesarCommented:
No Issues, go ahead. But your create index will put a exclusive lock during its execution and I may leads to unavailability of the table at that time. So Its better to go offline for some time and perform it.

Also find some guidelines

http://msdn.microsoft.com/en-us/library/ms179325(v=SQL.90).aspx
0
 
soccerman767Author Commented:
This database is set to simple recovery mode
0
 
Alpesh PatelAssistant ConsultantCommented:
not an issue
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now