Jeff Moden (8/3/2015)
... and don't forget to rebuild the indexes on EVERY table because even one-off shrinks are going to fragment the hell out of your database.
+1
All too often I see people defragging and then shrinking. That makes no sense and is a huge waste of time. You always need to defrag after shrinking, so don't bother with doing that prior to the shrink.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events