index – SQL Padawan

Query Store Usage Scenarios

What is Query Store? Query Store is a tool to troubleshoot query performance by capturing a range of information about

What’s a heap table? I would say it’s a table without clustered index. What’s the characteristic of a heap table?

A simple script to know how much space the tables are taking from the disk. SELECT t.name AS TableName ,

The most common and widely used index that we know are nonclustered index. These indexes are created using the famous