When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
List All Parallel Queries – SQL in Sixty Seconds #098
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?
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.