The argument that reducing logical reads isn’t crucial because they occur in memory and are fast compared to physical reads is indeed valid on the surface. However, it’s […]
Getting Set Options for a Session
While browsing StackOverflow, I came across an interesting use case for the Set Options feature in SQL Server. I have created a few YouTube videos on the different […]
What happens when you delete a column in MS SQL Server?
What sounds like a simple question as expected can have a complex answer in MS SQL Server. This is a good thing because there is a myriad of […]
Generational Inequity
What is generational Inequity? Generational Inequity refers to a phenomenon influencing various aspects of life such as politics, commerce, and even the judiciary. To best understand generational inequity, […]
Is there a difference between using NOT IN and <>
This was a question that came up during a SQL Session I conducted recently. We were reviewing some code in a procedure and it has logic similar to […]
Is there a difference between using <> and ! = when it comes to inequality
I was asked this question recently when I conducted a SQL Session and it felt like a very simple and easy question to answer and something I am […]
How to Setup and Configure Query Store in MS SQL Server
Query Store is a powerful feature in Microsoft SQL Server that serves as a performance monitoring and troubleshooting tool. It essentially acts as a database-wide flight data recorder, […]
How to use Query Store DMVs to troubleshoot performance issues
Troubleshooting MS SQL Server is something that comes from years of experience and there is a certain amount of pride that comes with mastering the level of knowledge […]
Is Using Top operator good for your query?
Using the TOP operator in T-SQL procedures is a common practice among developers. It’s often employed to limit the number of records, either to fetch the first value […]
Azure AI Video Indexer
Azure AI Video Index as its name suggests can help create metadata about a video based on its content. The idea being you can upload a video and […]