Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]
The post Query Store 101 appeared first on dbWonderKid.
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 […]
Have you ever had a query that runs frequently start to randomly go slower? We all have and without the…
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well…
Here is some news, videos, tips, and links the Procure SQL team would like to share! Procure SQL made it…
Here are some videos, tips, and exciting links the Procure SQL team would like to share! MLB's Databases Have you…