Primary Key vs. Clustered Index

(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.) In today’s blog posting I want to talk about a very important topic in SQL Server that ...

Read more

Heap Tables and %%lockres%%

(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.) In today’s blog posting I want to show you a undocumented function in SQL Server, and how ...

Read more

Why the Query Hint NOLOCK is a bad idea

(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.) A few weeks ago I have presented my Performance Tuning Workshop in Utrecht/Netherlands. On the 3rd day ...

Read more

Is a Index Scan always a Index Scan?

(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.) A few weeks ago, someone posted an interesting question on Twitter: Q: While watching a Summit14 recording, ...

Read more
SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top