SQL Server Quickie #12 – Nested Loop Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 12th SQL Server Quickie to YouTube. This time I’m talking about the Nested Loop Join Operator in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #11 – Non Clustered Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 11th SQL Server Quickie to YouTube. This time I’m talking about Non Clustered Indexes in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #10 – Forwarding Records

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 10th SQL Server Quickie to YouTube. This time I’m talking about Forwarding Records on heap tables. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #9 – Clustered Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 9th SQL Server Quickie to YouTube. This time I’m talking about Clustered Indexes in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #8 – Hash Indexes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 8th SQL Server Quickie to YouTube. This time I’m talking about Hash Indexes in SQL Server 2014. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #7 – TempDb Latch Contention

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 7th SQL Server Quickie to YouTube. This time I’m talking about Latch Contention in TempDb. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #6 – THREADPOOL Starvation

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 6th SQL Server Quickie to YouTube. This time I’m talking about THREADPOOL Starvation in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #5 – Bookmark Lookup Deadlocks

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks in SQL Server. You can find the script used during the demonstration here as a download.


 

Thanks for watching!

-Santa Claus

SQL Server Quickie #4 – IAM Pages

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I’m talking about IAM Pages in SQL Server. You can find here the script I have used during the demonstration as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #3 – Allocation Units

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in SQL Server.


 

Thanks for reading & watching

-Klausy