December 21, 2012 at 1:37 am
Not going to affect the size or usage of the data file in any way.
sorry for my Friday hangover, I thought the complain is about log file 🙂
----------
Ashish
January 2, 2013 at 3:53 pm
I have 2 quick questions on Data file size usage behavior
1) I see that Indexes have heavy fragmentation levels: This effects the DML Performance for sure, but will this allow the data file size to grow extra than actual consumed space?
2) Will adding few indexes at appropriate places reduce the Data file to not pre capture so much disk space than actual consumed space.?
January 3, 2013 at 2:54 am
Mac1986 (1/2/2013)
1) I see that Indexes have heavy fragmentation levels: This effects the DML Performance for sure, but will this allow the data file size to grow extra than actual consumed space?
NO there is no 'extra' or 'actual consumed' kind of thing in index fragmentation level. framentation happens due to page split whch is dependent on fill factor.
Mac1986 (1/2/2013)
(2) Will adding few indexes at appropriate places reduce the Data file to not pre capture so much disk space than actual consumed space.?
NO. index addition always cost you space/disk and it helps you to retrieve the data faster but slow down your DML operation
for more details see this link http://blogs.msdn.com/b/pamitt/archive/2010/12/23/notes-sql-server-index-fragmentation-types-and-solutions.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2017 at 5:05 pm
I know it's an old thread. If you really want to shrink your datafile and release it back to disk, the fastest way would be create a new empty datafile in the same filegroup and empty
the existing one to the new datafile. The size of datafile should be equated to the size of would-be shrinked datafile. Once migrated, you can remove the old datafile.
This is the fastest way.. of course, shrinking data file is never recommended in many references.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply