Link to home
Start Free TrialLog in
Avatar of soccerman767
soccerman767

asked on

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.    
ASKER CERTIFIED SOLUTION
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of soccerman767
soccerman767

ASKER

This database is set to simple recovery mode
not an issue