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