Data Pages – the Foundation of 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.) Pages are the foundation of SQL Server – everything in SQL Server is about pages. When we ...

Read more

Writing a book on Service Broker – a wise decision?

(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.) Last week Brent Ozar published a blog post, where he talked about how choose a successful topic ...

Read more

Restarting SQL Server – always a good 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.) I see it often in the field – sometimes people regularly restart SQL Server! We all hopefully ...

Read more

SQL Server Quickie #38 – Outer Joins

(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 uploaded SQL Server Quickie #38 to YouTube. This time I’m talking about Outer Joins ...

Read more

Does a RECONFIGURE statement flush the Plan Cache?

(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 got quite an interesting question from a weblog reader: does a RECONFIGURE ...

Read more
SQLpassion

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