Here is a question asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.
SQL SERVER – Microsoft Official Support End Dates for Different Versions
Earlier this week, Microsoft SQL Server 2008 and 2008 R2 support ended. I am mentioning Microsoft’s Official Support End Dates for different versions.
How to Find Definition of Computed Column in SQL Server using T-SQL? – Interview Question of the Week #233
Question: How to Find Definition of Computed Column in SQL Server using T-SQL?
Answer: A very fair question, I received the other day.
Puzzle – DELETE Qualified Rows From Multiple Tables – Win USD 1000 Worth Class
Today we are going to see a very simple but brain teaser puzzle. This puzzle is about Deleting Qualified Rows From Multiple Tables.
SQL SERVER – Using Memory-optimized Tables and Native Stored Procedures – Video Course
SQL Server Performance Tuning video course on Pluralsight on the topic – Using Memory optimized Tables and Native Stored Procedures.
Impact of DBCC DROPCLEANBUFFERS on Memory – SQL in Sixty Seconds #085
Based on the request of many DBAs, In this SQL in Sixty Seconds video, I will show you the Impact of DBCC DROPCLEANBUFFERS on Memory
SQL SERVER – What is Wait Type Parallel Backup Queue?
Only official documentation which I could find was about wait statistics related to Parallel Backup Queue is very little available online.
SQL SERVER – Performance Monitoring Tool – SQLGrease
Today, we are going to see another SQL Server Performance Monitoring Tool – SQLGrease in the same spirit as I have evolved others.
SQL SERVER – Fix: Logical Name Mismatch Between Catalog Views sys.master_files and sys.database_files
In this blog, I am going to share my learning about the mismatch between catalog views sys.master_files and sys.database_files.
What is Source_Database_ID in Sys.Databases?- Interview Question of the Week #232
Question: What is Source_Database_ID in Sys.Databases and why it is mostly NULL? Very interesting question, I received indeed.