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

index fragmentation. Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 1:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
USE EXEC dbo.sp_spaceused TO FIND OUT INTERNAL FRAGMENTATION.
Post #1446331
Posted Thursday, April 25, 2013 2:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:57 AM
Points: 2,729, Visits: 2,646
sufiyan.sarguroh (6/8/2012)
And does the index rebuild/reorg reduce internal frag too ?


Yes it does.

Regards
IgorMi

Post #1446340
Posted Thursday, April 25, 2013 2:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 3:48 AM
Points: 2,274, Visits: 767
iamsql1 (4/25/2013)
USE EXEC dbo.sp_spaceused TO FIND OUT INTERNAL FRAGMENTATION.


that 100% categorically does not give you internal fragmentation, external fragmentation or any other kind of fragmentation.. it tells you the size of the file and how it is used


MVDBA
Post #1446348
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse