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

Moving Indexes Expand / Collapse
Author
Message
Posted Tuesday, September 16, 2008 8:47 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:00 AM
Points: 21,397, Visits: 9,612
I think this wipes out the stats : AND I.is_hypothetical = 0

I'm not sure though, I have not done such tasks in a very long while.

Check out INDEX_PROPERTIES as well.
Post #570307
Posted Tuesday, September 16, 2008 4:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:40 PM
Points: 8, Visits: 77
Stats? I think it would be a good practice to update stats every so often. This is outside the scope of moving indexes... Mmmm?
Post #570680
Posted Tuesday, September 16, 2008 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:40 PM
Points: 8, Visits: 77
My tests do not show any _WA_
Post #570683
Posted Wednesday, September 17, 2008 4:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 4, 2012 2:04 AM
Points: 263, Visits: 324
I have to say as a novice in the DBA continuum... I really appreciate the detailed comments surrounding the code snippets explaining why each piece was done this way (specifically the WHERE clauses with the system table columns). Frequently, I get bogged down in the details of included code as I am digging through BOL to figure out why someone included specific criteria.

Great info - thanks!

J.
Post #570900
Posted Wednesday, October 22, 2008 4:45 PM
SSC Eights!

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

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:26 AM
Points: 891, Visits: 1,958
Excellent article, Thom! I love working with system tables, they hold so much cool information and really show how SQL Server is a meta-data system. Conveniently, I think I'll have an index move in the near future, so your code will really come in handy.
Post #590171
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse