Let us see in today’s SQL in Sixty Seconds video how one can identify the index used for the query a popular question asked in Health Check.
SQL SERVER – Killing DBCC SHRINKFILE Process – Is it Safe?
Shrinking the data file is a very bad thing and you can read it. Now let us learn about if Killing DBCC SHRINKFILE Process is safe or not?
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.
Stress Testing with oStress – SQL in Sixty Seconds #087
One of the things which we cover in my  Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.
SQL SERVER – SSMS – SET ROWCOUNT – Real-World Story
Let us today talk about SSMS Query Execution configuration for SQL Server where SET ROWCOUNT settings gave us an interesting challenge with query tuning.
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.
How to Check Database Performance Facets in SQL Server? – Interview Question of the Week #270
Question: How to Check Database Performance Facets in SQL Server?
It is very simple to find out the facets of SQL Server Just follow the diagrams listed.