Tanken med denna blogg är att våra SQL server konsulter kan dela med sig av sina kunskaper när de stöter på roliga, svåra eller överraskande saker relaterade till SQL Server. På grund av att vi har en hel del besökare från andra delar av världen, är den mestadels på Engelska.
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…
Läs merRecently 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…
Läs merDid 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…
Läs merRecently, 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…
Läs merI 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…
Läs merEDIT: 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…
Läs merWhen 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…
Läs merCOPYRIGHT SQL Service | Strandbergsgatan 61, 112 51 Stockholm
Hemsida av webbdesigner på Grafix Studio
