Do you know how long your query took to execution? Well, let us learn that today in SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.
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.
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.
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.
Multi Tables – 1 Drop Statement – SQL in Sixty Seconds #134
It was taking time as well as require to write them one at a time. In today’s blog post we will see how we can drop multiple tables with a 1 drop statement.
Remove Trigger for Delete – SQL in Sixty Seconds #133
I am involved in the Comprehensive Database Performance Health Check. Today we will discuss how we can remove triggers for the Delete statement.