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
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: Tuesday, November 10, 2015 7:43 AM
Points: 963, Visits: 1,519
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