Hands up: who of you at least once in your DBA career has used the DBCC INPUTBUFFER command to retrieve the last SQL statement that a specific session has submitted to SQL Server? Almost all of you! We all know that DBCC commands are little bit awkward, because you can’t call them in a T-SQL …
Last week I taught an internal SQL Server Performance Tuning course to a customer in Switzerland. As usual we had a lot of fun, and at some point an attendee asked me one of the best questions of my life: “Can you disable a Clustered Index?” At first I was really scared about that question, …
Disabling Clustered Indexes in SQL Server – a really good idea? + read more
Today I have uploaded SQL Server Quickie #34 to YouTube. This time I’m talking about Statistics in SQL Server. Thanks for your time, -Klaus
Now the cat is out of the bag: Linus Torvalds – the father of the Linux Kernel – will join Microsoft! Wooohooo! As we have seen over the last weeks, Microsoft is currently going through a huge transformation, and is now more open to other technologies, like Linux. A few weeks ago, Microsoft announced SQL …
Every time you create a Primary Key constraint in SQL Server, the constraint is (by default) enforced through a Unique Clustered Index. This means that you need to have in that column (or these columns, if you have defined a composite Primary Key) unique values. And as a side effect your table data is physically …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
