Pessimistic Concurrency 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.) SQL Server provides pessimistic and optimistic concurrency models that define how concurrent queries are executed. In todays ...

Read more

How to read an Execution Plan

(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 about a very “simple” topic: how to read an execution plan. At ...

Read more

How SQL Server executes a query

(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 lay out today the foundation about how SQL Server executes a query. This ...

Read more

The LaCie Rugged RAID Thunderbolt

(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 the LaCie Rugged RAID USB 3/Thunderbolt enclosure that ...

Read more

Your RAID 5 array is only as good as your backup!

(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.) It happened silently, and we lost almost everything – our RAID 5 storage array crashed! No, I’m ...

Read more
SQLpassion

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