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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:28 PM
Points: 17,729, Visits: 15,597
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: Today @ 1:12 AM
Points: 78, Visits: 491
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