September 17, 2014 at 9:32 am
Okey dokey. Being a dev I can shrink the database.
Would it also increase LOB index fragmentation?
September 17, 2014 at 9:56 am
balasach82 (9/17/2014)
Okey dokey. Being a dev I can shrink the database.Would it also increase LOB index fragmentation?
It will blast the fragmentation through the roof on just about everything which is exactly why it is such a bad thing to do. :w00t: Of course for testing and such it is a great way to force this condition.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 17, 2014 at 10:16 am
balasach82 (9/17/2014)
Igor,Shrinked log file. It didnt frag the indexes in the tables i am testing the Ola Hallengren script.
I have to understand the script to better customise it for my needs.
Correct. If you don't mind shrinking the log then go with database shrink, otherwise shrink the data files only.
Since it's dev, freedom is big.
Igor Micev,My blog: www.igormicev.com
September 18, 2014 at 6:38 am
<ignore missed the first post on the second page>
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply