Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Creating an index Expand / Collapse
Author
Message
Posted Friday, September 4, 2009 6:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:01 AM
Points: 914, Visits: 1,431
Can you install another Dev Edition instance in DEV then restore the PROD db, or if you can't then how about restoring the database in dev as a different name?

Also you'll want to check your query plans to make sure they're using the new index/indices.





Post #782864
Posted Sunday, September 6, 2009 6:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, October 3, 2010 3:50 AM
Points: 146, Visits: 178
the biggest issue will occur during playing with clustered index

EE is quite nice, but an online option needs a properly setup tempdb (i.e. enough space)
Post #783445
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse