Question: What Happens If the Clustered Index is Disabled?
Answer: If you disable the clustered index, you can’t retrieve data from the table.
Alter Index Add Column – Workaround – SQL in Sixty Seconds #097
However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.
SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE. Â
Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090
How to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.
SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup
I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked questions and decided to answer.
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.