One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.
SQL SERVER – Delete Statement and Index Usage
The client wanted to know if the index help with the DELETE command as well. The answer is yes, Indexes do help with the DELETE statement.
Nonclustered Primary Key – SQL in Sixty Seconds #119
I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key.Â
What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291
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.