Today we are going to a very simple example of the Input and Output Parameter for Dynamic SQL. I have been working on SQL Server for almost 20 years.
Remove Bookmark Lookup – SQL in Sixty Seconds #089
We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.
Identify Index Used for Query – SQL in Sixty Seconds #088
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.