Here is the updated list for October 2020 of all the tools which I recommend. Do let me know if you use any of the above tools.
How to Add Constraint With No Validation? – Interview Question of the Week #299
Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
SQL SERVER – Identity and Constraint Confusion
What is going on with their server as I had no access to their data or schema. Let us learn about how identity and constraint confusion created problems.
Single Installer for SSMS and ADS – SQL in Sixty Seconds #138
Microsoft has recently released a single installer which now installs SSMS and ADS both together in a single Installation.Â
Find Outdated Statistics – SQL in Sixty Seconds #137
Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.
SQL SERVER – Find Oldest Updated Statistics – Outdated Statistics
The word which they had used was Outdated Statistics. Let us learn more about it in today’s blog post. Find Oldest Updated Statistics
Arrow in Execution Plan – SQL in Sixty Seconds #136
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.
SQL SERVER – Adding Values Containing NULLs
Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.
What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298
Question: What is EDGE in SQL Server Execution Plan?
Answer: It is the arrow or the line which goes from one operator to another operator.
5 Questions Answered OUTPUT Clause – SQL in Sixty Seconds #135
I have decided to create another SQL in Sixty Seconds video discussing the OUTPUT clause. In this video, we will discuss 5 questions.