-
09 maj 2013 i Trace flags, Level 400, SQL Server allmänt, Steinar Andersen, SQL Server, Trace Flag, sv, en
Updated 2013-05-09 with TF 8002, 4130, 4135, 7826, 7827 We have in our blog written a lot about Microsoft SQL Server Trace Flags, so I thought it
-
15 april 2013 i T-SQL, Level 400, Håkan Winther, sv, en
First of all, I am not a fan of triggers because of a number of reasons, but i will not go into those in this blog. Anyway, triggers can be useful
-
05 april 2013 i T-SQL, SQL Server 2012, Level 400, Steinar Andersen, SQL Server, sv, en
Today I stumbled over a nice list of documented and undocumented DBCC commands. I verified the content against SQL Server 2012, and unfortunately it...
-
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
-
16 januari 2013 i T-SQL, Indexering, Level 400, SQL Server performance, Håkan Winther, SQL Server, sv, en
A HEAP in SQL Server is a table without a clustered index, and in this blog post I'll show you the curse of heaps. Run the code below and take a look...
-
02 december 2012 i SQL Server 2008, SQL Server 2008R2, Level 400, Håkan Winther, sv, en
This is another blog post in the Death by series, but has nothing to do with performance. Well, the case that led to this blog post had to do with
-
09 november 2012 i T-SQL, SQL Server 2012, Level 400, SQL Server performance, Steinar Andersen, performance, sv, en
As some of you might remember, I published this http://sqlservice.se/sv/start/blogg/sql-server-mystery-hekaton-tables-and-hekaton-procedures.aspx
-
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å...
-
25 oktober 2012 i Level 400, SQL Server best practices, SQL Server performance, Steinar Andersen, Trace Flag, sv
Om du vill ändra på Microsoft SQL Servers standardbeteende, finns det många inställningar du kan göra till exempel med hjälp av sp_configure, eller...
-
18 september 2012 i T-SQL, SQL Server 2008R2, SQL Server 2012, Level 400, SQL Server maintenance, Steinar Andersen, T-SQL, sv, en
The other day I had reason to think about how to get more reliable statistics about the number of commands beeing replicated between SQL Servers. As...