You do your homework, check which index are fragmented and rebuild them. Thinking all is well. Then just to be sure you run the check again to see how much better it got. Surprisingly, the frag % is even bigger!

…

The question is simple: is there any difference between the performance of the different service packs / editions of SQL Server? For example, is there a performance difference for the queries which run on SQL Server…

This week I am traveling. Visiting a few clients which are few hundreds km from our office.

It does feel great – the first client I visited on Monday morning even had my homecountry’s flag at the reception…

As you probably already know, you can add indexes on temporary tables to improve the performance, but you can probably improve the performance even more. The index can be build with Fill factor 100 to increase the rea…

If you look closely in your SQL Server errorlogs, you might notice that many of the carry the following error: ”The SQL Server Network Interface library could not register the Service Principal Name (SPN) for…

Great news: here is a free book on SQL Server R2 by Ross Mistry and Stacia Misner.

The book contains 10 chapters and is extensively covering the new features (everything you always wanted to know but were afraid to ask )…

Here is a good piece of food for thought: How do you replace only the first occurrence of a character in a string with another one, disregarding of how many occurrences there are?

Here is the question explanation: You h…

Eftersom licenskostnaderna skiljer sig ganska mycket så är det vanligt att välja Standard edition och många funderar varför man skall välj SQL Server 2008 Enterprise edition. Vad kan motivera den högre kostnaden…