During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.
Keyword Join or Inner Join – SQL in Sixty Seconds #099
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different?
Pluralsight Course – Open Source Cloud: Executive Briefing
I really appreciate the feedback and support and based on your comments, I have now finally built an Executive Briefing on the same topic.Â
How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288
Question: How to Get Rowcount of Every Table in SSMS?
Answer: After watching my earlier video on the fastest way to get the rowcount for 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.
Fastest Way to Retrieve Rowcount for a Table – SQL in Sixty Seconds #096
What is the fastest way to retrieve rowcount for a table? Whenever I am helping my clients with their SQL Server, I get this question.
Where are Table Variables Stored? – SQL in Sixty Seconds #095
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
Quantum Computing With an Example of Coin – SQL in Sixty Seconds #094
I decided to build a short video based on Quantum Computing with an example of a coin. I use the coin as a prop to explain how Quantum computing works.
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. Â
How to Uninstall SQL Server 2019 Instance? – SQL in Sixty Seconds #093
SQL Server 2019 is very easy but the real challenge is to uninstall SQL Server 2019 instance. Let us learn how we can do that in video.