In the beginning of my IT career, I was a developer. I wrote a lot of bad code that didn't… [...]

You are out doing your scheduled sweeps of the environment and you notice a huge I/O consumer is one of your update procedures. Your initial thought may be to panic because how can you test data that is changing? You have several methods to tuning queries that adjust data that allow data to revert between […]

The post Tuning Basics – Updating an Update appeared first on dbWonderKid.

SQL Server 2022 was announced yesterday at Microsoft's Ignite Conference. Here are some of the items that caught our attention.… [...]

What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]

Replay like a Rockstar! Want to save money, validate performance, and make sure you don't have errors while migrating to… [...]

Today, I want to focus on a free tool that everyone can use when benchmarking queries or performance tuning their… [...]