Updating your stats bad company 2
Now, don’t confuse shrinking the transaction log with shrinking data files.
Shrinking the log may be necessary if your log has grown out of control, or as part of a process to remove excessive VLF fragmentation (see Kimberly’s excellent posts on this here and here).
I say ‘never run a regular shrink operation of any kind’, and if you absolutely must run a data-file shrink, be aware of the problems it can cause.
Google Plus (stylized as Google ) is an Internet based social network that is owned and operated by Google.
If the index is larger than a few thousand pages, is typically not all in the buffer pool, and is scanned a lot, then possibly. It then moves it as far towards the front of the file as it can, and so on, and so on.
The service, Google's fourth foray into social networking, experienced strong growth in its initial years, although usage statistics have varied, depending on how the service is defined.
Three Google executives have overseen the service, which has undergone substantial changes leading to a redesign in November 2015.
The method I like to recommend is as follows: Basically you need to provision some more space before you can shrink the old files, but it’s a much cleaner mechanism.
If you absolutely have no choice and have to run a data file shrink operation, be aware that you’re going to cause index fragmentation and you might need to take steps to remove it afterwards if it’s going to cause performance problems.