Crash Recovery & Recovery Models

(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 released a SQL Server Quickie about Crash Recovery in SQL Server. There ...

Read more

Why do we need Intent Locks 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 blogged 2 years ago about why we need UPDATE locks in SQL Server. Today I want ...

Read more

Lock Escalations – do they always happen?

(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 blogged some time ago about the basics of Lock Escalations in SQL Server, and how even ...

Read more

SQL Server Quickie #35 – Crash Recovery

(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 #35 to YouTube. This time I’m talking about Crash Recovery ...

Read more

Indexes on VARCHAR Columns

(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.) Years ago I wrote about how SQL Server stores VARCHAR columns in the Navigation Structure of an ...

Read more
SQLpassion

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