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 have uploaded my 1st Web Cast to YouTube. In this Web Cast I have talked today about SQL Server 2016 Service Pack 1. Make sure to signup for my next Web Cast on February 29 where I will talk about Troubleshooting CXPACKET Waits in SQL Server. Thanks for your time, -Klaus
A question that I get asked very often during my various SQL Server Consulting engagements is on how many NUMA nodes SQL Server is running on. Therefore I want to show you in today‘s blog post a few ways and techniques to find out how many NUMA nodes your SQL Server has. For a general …
I don’t know how often I have been asked this question in my life: “How can I move data between File Groups in SQL Server?”. You know the problem: you have a default configuration of a database with only a PRIMARY file group, and at some point in time you learn that a custom file …
How to move data between File Groups in SQL Server + read more
A classic question that I get asked very often during my various SQL Server consulting engagements is how much RAM do I need for SQL Server? This question has again a typical “It depends” answer. In today’s blog post let’s have a more detailed look into the various aspects on which “it depends”. New SQL …
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.
