In today’s blog posting I want to talk about a very important topic in SQL Server that always confuses people when they first work with SQL Server. It is about the difference between the Primary Key constraint and the Clustered Index. What is a Primary Key? Let’s talk first about the Primary Key constraint itself. …
In today’s blog posting I want to show you a undocumented function in SQL Server, and how you can use that function to find out on which pages records are stored. %%lockres%% The undocumented function that I want to show you today is called %%lockres%% and has to do with the locking implementation of SQL …
A few weeks ago I have presented my Performance Tuning Workshop in Utrecht/Netherlands. On the 3rd day – the most intensive one, where I cover Locking, Blocking, Deadlocking, Latching, Spinlocking – we have also talked about the NOLOCK query hint. Some people always refer to the NOLOCK query hint as the Turbo Booster in SQL …
A few weeks ago, someone posted an interesting question on Twitter: Q: While watching a Summit14 recording, unanswered by speaker: Is there a way to tell how much of index is scanned with a NC scan operator? One of the answers to this question was that a Non-Clustered Index Scan scans always the whole index. …
Today I have uploaded the 25th SQL Server Quickie to YouTube. This time I’m talking about the transaction isolation level Read Committed in SQL Server. Thanks for your time, -Klaus
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.
