-
09 juni 2013 i Statistik, SQL Server 2008R2, SQL Server 2012, Håkan Winther, sv, en
Statistics on indexes and colunns is very important for the query optimizer in SQL server. If the statistics are inaccurate, you'll end up with query...
-
26 mars 2013 i SQL Server 2008R2, SQL Server 2012, Level 400, SQL Server performance, Håkan Winther, Trace flags, Statistik, SQL Server 2008, sv, en
A common problem with statistics is when it's based on an index with an incrementing column, like an IDENTITY column or a DATETIME column that is
-
10 februari 2013 i Statistik, SQL Server 2012, Håkan Winther, sv, en
It's been a while since my last blog post, due to a terrible cold that have forced me to bed, but now it's time for another blog post! In SQL server...
-
15 januari 2013 i Statistik, Level 300, SQL Server best practices, SQL Server performance, Håkan Winther, sv, en
If you have been following my blog serie about SQL server statistics, you have seen how statistics is used by the sql optimizer to create an execution...
-
31 december 2012 i T-SQL, Statistik, Level 300, SQL Server performance, Håkan Winther, SQL Server, sv, en
In my previous blog post, I covered some issues with incorrect statistics and in this post I’ll present another issue. The optimizer is using the
-
18 december 2012 i Statistik, Level 300, SQL Server performance, Håkan Winther, sv, en
Statistics are very important for the SQL query optimizer and is used for estimating number of records returned by a query. If the difference between...
-
31 oktober 2012 i T-SQL, Statistik, Indexering, Level 400, SQL Server maintenance, SQL Server performance, Steinar Andersen, SQL Server, sv
Denna vecka har jag tittat lite på prestandaproblem i SQL Server orsakade av parametersniffning. Jag tänkte skriva en längre blogpost om det, men så...
-
13 juli 2012 i T-SQL, Statistik, Level 300, Göran Rönnbäck, SQL Server, sv
När man analyserar och felsöker en server som innehåller flera databaser är det väldigt intressant att veta vilken av dessa databaser som förbrukar
-
03 juli 2012 i Statistik, Indexering, Level 400, SQL Server best practices, SQL Server maintenance, SQL Server performance, Steinar Andersen, sv, en
The last couple of years I have spent a lot of time of and on tuning SQL Server performance in combination with Dynamics Axapta. There are some good...
-
29 februari 2012 i Statistik, Level 400, Håkan Winther, sv, en
This is a sequal to previous blog posts about auto update stats in SQL Server, but the focus of this post is how to handle when you know for sure that...