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 @ 4:35 AM
Points: 2,901, Visits: 2,927
sufiyan.sarguroh (6/8/2012)
And does the index rebuild/reorg reduce internal frag too ?


Yes it does.

Regards
IgorMi





Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1446340
Posted Thursday, April 25, 2013 2:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, June 26, 2014 8:49 AM
Points: 2,276, Visits: 779
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