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 «««7891011

T-SQL: Why “It Depends” Expand / Collapse
Author
Message
Posted Thursday, March 25, 2010 1:09 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
BlackHawk-17 (3/25/2010)
Based on this article from the CSS SQL Server Engineers team I think you are on the wrong path.

Compact is not defragment. It goes back to the Paul Randall explanation - move pages to open space and trucate the remainder.

Regards;
Greg


Thanks for the reference. That is good info.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #890179
Posted Tuesday, April 6, 2010 1:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 1:39 AM
Points: 78, Visits: 487
Excellent article.

It's likeThe Einstein Theory of relativity. In a place with big numbers rows behave different, Newton's theory does not correspond exactly.
Post #897349
« Prev Topic | Next Topic »

Add to briefcase «««7891011

Permissions Expand / Collapse