Do you need more than STATISTICS IO for Query Tuning?

(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.) The session option STATISTICS IO is my friend during query tuning engagements, because it tells you exactly ...

Read more

Plan Caching

(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.) Today I want to talk more about Plan Caching and its side-effects in SQL Server. As you might ...

Read more

The Performance Penalty of Bookmark Lookups in SQL Server

(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.) I have previously very often talked on my weblog about Bookmark Lookups in SQL Server, and how ...

Read more

SQLpassion Web Cast February 2017: CXPACKET Waits

(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.) Today I have published my 2nd Web Cast on YouTube. In this Web Cast I have talked ...

Read more

SQLpassion Online Trainings in March 2017

(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.) Today I’ve published my SQLpassion Online Trainings for March 2017. On March 27 I’m running again a ...

Read more
SQLpassion

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