After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.
SQL SERVER 2019 – Disabling Scalar UDF Inlining
Working on the Comprehensive Database Performance Health Check, we will learn how I helped a client by Disabling Scalar UDF Inlining in SQL Server 2019.
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.
SQL SERVER – Finding Day Name from Date
In today’s blog post we will a very simple script where we will find day name from any valid date. There are multiple ways you can do it.
What is Full Outer Join With Exclusion? – Interview Question of the Week #286
Question: What is Full Outer Join With Exclusion?
Answer: I got this question after reading my earlier blog post about Basic of JOINs.
SQL SERVER – Counter Temp Tables For Destruction Not Working
They realized their counter Counter Temp Tables For Destruction Not Working and wanted me to help them. Let us learn about it today.