Today I want to lay out today the foundation about how SQL Server executes a query. This is a very important topic, because everything else regarding performance tuning and troubleshooting is based on these concepts. The following pictures give you an overview about the most important components within SQL Server, that are used when we are …
In today’s blog posting I want to talk about the LaCie Rugged RAID USB 3/Thunderbolt enclosure that I have “tuned” for my personal needs a little bit . The “normal” configuration First let’s talk about the normal configuration of the LaCie Rugged RAID. The LaCie is shipped with 2x 2TB disks that you can use …
It happened silently, and we lost almost everything – our RAID 5 storage array crashed! No, I’m not talking about someone else, I’m talking today about our RAID 5 array at home, why it failed, and why I failed! RAID 5 – the basics A RAID 5 array is the cheapest solution if you want …
Your RAID 5 array is only as good as your backup! + read more
Today I have uploaded the 27th SQL Server Quickie to YouTube. This time I’m talking about the transaction isolation level Read Uncommitted in SQL Server. Thanks for your time, -Klaus
A few months ago I blogged about the challenges of Simple Parameterization in SQL Server. Today I want to continue this discussion by talking about Forced Parameterization in SQL Server. Forced Parameterization Simple Parameterization has a number of limitations in SQL Server. It will not happen if your SQL statements contain any of these: JOIN …
The pain of Forced Parameterization in SQL Server + read more
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.
