Many times when we work with SQL Server based applications, we solve performance problems by adjusting parallellism settings to limit the genereration of parallell query plans. However, sometimes we need to do th…

The last week I posted a blog about auto update stats and this is a sequal to that blog post. I case you haven’t read it you should read it first.

If you tried the script last week, you noticed that  :

• the statistics d…

Recently while working on a TB size SQL Server database, I got the opportunity to verify something that I have suspected for some time, but not yet looked into properly. I am talking about how to optimize UPDATE STATIS…

Did you ever think that it would be great to cache SQL Server database query results, and only go back to query the database when data has changed? Well, you can do that, using Query Notifications.

Query notifications…

Recently, I had the pleasure of troubleshooting several Error 3624 on a SQL Server 2008 R2 instance. It seems to be related to bulk copying in data to a principal database in a mirroring setup. The principal never runs…

Efter att ha svävat omkring i molnet hela veckan tänkte jag att det nu är dags att komma ner på jorden igen

Härom dagen behövde jag snygga till lite data. Eftersom datat laddas om varje vecka så var det ju ett måste att aut…

I have received quite some attention after my previous blog post regarding SQL Azure and INSERT performance. Therefore I would like to comment on some of the questions and issues raised, as well as giving my opinion o…

EDIT: Also read this blogpost: http://sqlservice.se/sql-server/sql-server-performance/sql-azure-followup/ , that gives more context to the findings in this post.

Today we will take a look at the INSERT spee…