I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
Patch Your SQL Server – SQL in Sixty Seconds #100
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?
Moving to Azure SQL Database: The Features You Give Up
Plan moving to Azure SQL Database by finding Agent jobs, cross-database references, CLR, FILESTREAM, linked servers, and recovery changes.
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.