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
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.
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.