Question: How to Remove Quotes of QUOTENAME? I received based on my yesterday’s blog post SQL SERVER – QUOTENAME Function and Custom Quote Character.
Can an Index Reduce Performance of SELECT Query? – Interview Question of the Week #234
Question: Can an Index Reduce Performance of SELECT Query? There is a huge misconception that Indexes does not impact SELECT queries negatively.
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.
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.
What is Faster, SUM or COUNT? – Interview Question of the Week #231
Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.
What are the Different Types of SQL Server CHECKPOINT? – Interview Question of the Week #230
Question: What are the Different Types of SQL Server CHECKPOINT?
Answer: There are four different kinds of checkpoints in SQL Server.
How Dirty or Clean is SQL SERVER’s Memory? – Interview Question of the Week #229
Question: How Dirty or Clean SQL SERVER Database is (by Memory)?
This blog post is the follow up of the earlier blog post on the same subject.