The SHRINKDATABASE Evil

I mentioned in my previous Fragmentation post to not use the SRHINKDATABASE during the maintenance, and to switch off auto-shrink option. Some of you probably believe me and just don’t use it, but some of you wait an explanation and don’t accept advises based on promises 🙂 Well, let me prove you what the shrinkdatabase…

2

Fragmentation – the database performance killer

Fragmentation is something that we don’t usually pay enough attention but it causes a very large percents of cases with performance degradation. Sometimes it plays a main destructive role for the overall performance of our database. Disk fragmentation There are different kinds of fragmentation. One type of fragmentation is a disk fragmentation, where the disk…

1

SQL Server 2008 SP1

Almost a month ago the SQL Server 2008 SP1 was launched. I had a question or some kind of complain that it cannot be installed or it hangs. So I decided to test it. Well, installation was ok, it passed successfully no matter if the instance is stopped or started. So you could apply SP1…

0