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

MS Days 2009

???? ??? ?? ???????? ?? ???????? ???? ?????, ????? ? ??? ??????????. ???? 3 ??????????? (????? ?? ??????? ??????????, ???????? ?? ???? ?? ???? ??????? ?? ?? ??????????? ? ?????? ???????, ????????? ?? ???? ??????? ???-????? ????? 🙂 ????? ?? ??????????????? ???? ??????: ?? ?????? ?? ???? ??????? (Top 10 things..); ?? ??????? ???????????? ?…

0

От къде започна всичко..

?????? ??????? ??????? ?????????? ???????-??????, ????? ???????? ??? ??????????? ?? ???? ????. ?????? ????????????! ????? ?????? ?? ????? ?? ???? ?? ??????? ‘Magi’s life in SQL’ ????? ???? ?????? ?????? ? ?????? ?? ??????????? ?? ????????????? ??????????? ??? ?????. ???????? ?? ????? „???? ?? ?????” ? ????? ????? ?????? ? ????????? ??????????: „?? ????????? ??…

0

Welcome to my new blog!

Here we go, I have just created a blog! I didn’t know that it will take too long for me. My friends often say: What’s going on with you? Why don’t you publish? Well, everything is just on time. I suppose now I know and I feel that there is something I can share with…

1