How do you identify index used for query? It is a popular question in my health checks, and this SQL in Sixty Seconds video shows the easy way.
SQL SERVER – Single Table Scan for Multiple Aggregated Operators
Today we will discuss how a single table scan for multiple aggregated operators helps to improve performance. Let us learn about it today.
How to Force Index on a SQL Server Query? – Interview Question of the Week #281
Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.
SQL SERVER – Total Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors
Today we will be discussing how to list Total Data Pages In Memory Buffer Pool with the help of sys.dm_os_buffer_descriptors.
SQL SERVER – Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors
We reached the point to investigate the data in memory for a single database. Here is the script to list all the database pages in SQL Server Buffer Pool.
How to Alter Index to Add New Columns in SQL Server? – Interview Question of the Week #278
Question: How to Alter Index to Add New Columns in SQL Server?
Answer: It is not possible to Alter Index definition to add or remove columns.
Rebuild All Indexes for a Single Table – SQL in Sixty Seconds #086
Recently, while working with a client we ended up on a very interesting situation with a client where we had to Rebuild All Indexes for a Single Table.