I have previously ranted a few times about why a RAID 5 is a terrible idea for storing your Transaction Log, and why it is also very risky to store your data files on a RAID 5 volume. But in today’s blog post I want to show you how the RAID 5 parity information is …
As you might know, SQL Server uses internally Statistics to estimate how many rows are returned from a specific query. That process is called the Cardinality Estimation. Based on the output from the Cardinality Estimation the Query Optimizer generates an Execution Plan, which is cached and finally executed. In today’s blog posting I’m going to talk …
Today’s blog posting is a little bit off-topic, but still quite interested when you work in the IT area. Maybe a few of you already know it, but over the last few years I have worked (and I’m still working) on a quite interesting side project: I’m developing my own CPU based on primitive AND, …
Do you ever wanted to know how a simple CPU is actually implemented? + read more
Today I’ve announced my SQLpassion Online Trainings for May 2017. On May 15 I’m doing again a free webcast from 11:00 – 12:00 (GMT + 1), where I will talk about how to Troubleshoot Latches in SQL Server. And on May 16 I’m running again a one-day long webinar about how to troubleshooting SQL Server …
Today I have published my 3rd Web Cast on YouTube. In this Web Cast I talk about Extended Events in SQL Server. Thanks for your time, -Klaus
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.
