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.Â
Install MongoDB on Windows – SQL in Sixty Seconds #091
Today I am going to demonstrate in this SQL in Sixty Seconds Video how to install MongoDB on Windows. Let us see how we can do that in video.
SQL in Sixty Seconds – Need Your Feedback
I decided to spend more time in building the videos and have created three videos in the last three weeks. It is time when I need your feedback.Â
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.Â
SQL SERVER Management Studio – Update Column Statistics Via SSMS
Today we will see how we can update Column Statistics via SSMS (SQL Server Management Studio). This feature was broken earlier and now fixed in SSMS 18.6.
SQL SERVER – Input and Output Parameter for Dynamic SQL – Simple Example
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.