fbpx

Search Results for "management view"

Query Store 101

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.

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 […]

Why is my SQL Server query slower than normal?

Have you ever had a query that runs frequently start to randomly go slower? We all have and without the…

September 2018 Training Opportunities

The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well…

Procure SQL’s Weekly Digest – February 14, 2024!

Here is some news, videos, tips, and links the Procure SQL team would like to share! Procure SQL made it…

Procure SQL’s Weekly Digest – February 7, 2024!

Here are some videos, tips, and exciting links the Procure SQL team would like to share! MLB's Databases Have you…