Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Creating an index Expand / Collapse
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: Friday, December 2, 2016 6:19 AM
Points: 968, Visits: 1,567
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


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