En av de många fördelar när man jobbar som konsult hos oss är att man får se olika miljöer och olika verksamheter. Ofta kan våra kunder ha likartade problem men så är inte alltid fallet. Ibland stöter man på problem som ä…

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…

In SQL server 2008 you have a lot of DMV:s to use to tune your database, but SQL Azure is missing a lot of them, and it makes it a lot harder to tune your queries. One of the DMV:s I like a lot is sys.dm_os_wait_stats, but this…

When looking at a SQL Server 2008 R2 locking/blocking problem in an Dynamics AX 2009 installation, I wanted to see what was going on with regards to locks taken by the specific SPID allocated to the AX Batch. I created a…

A common problem in SQL server is non searchable arguments and it is killing the performance big time. What is a non searchable argument then? A non searchable argument is a T-SQL statement that can’t make use o…

One of the top 10 misstakes in SQL server is the use of SELECT *. By using SELECT *, you can’t make efficient use of nonclustered convering index and you are doomed to a clustered index scan or index seek + key looku…

You might have noticed that with some Microsoft SQL Server instances you can’t see the allocated memory in Windows Task Manager. If you look at the total allocated memory in Task Manager, it looks as it normall…

Ibland kan vi rätt tydligt se att man har använts SQL Servers Database Tuning Advisor för att skapa index. Detta eftersom man inte ändrat de föreslagna namnen på index  som börjar på _dta_index_. Rekommendation frå…