fbpx

Performance Tuning

Clustered Index vs Heap

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 in the Cloud

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

Benchmarking Queries with SentryOne Plan Explorer

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