We help IT Professionals succeed at work.

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

407 Views
Last Modified: 2012-05-11
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.    
Comment
Watch Question

Database Administrator
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
This database is set to simple recovery mode
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
not an issue
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.