Today, we will see the solution to very interesting question received by Martha about Retrieving N Rows After Ordering Query With OFFSET.
How to Remove Quotes of QUOTENAME? – Interview Question of the Week #235
Question: How to Remove Quotes of QUOTENAME? I received based on my yesterday’s blog post SQL SERVER – QUOTENAME Function and Custom Quote Character.
SQL SERVER – QUOTENAME Function and Custom Quote Character
The question was really not related to SQL Server Performance Tuning but DBA wanted to know if they can use any custom Quote Character for their string.
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.
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
Impact of CHECKPOINT On Memory – SQL in Sixty Seconds #084
Based on the request of many DBAs, In this SQL in Sixty Seconds video, I will show you the Impact of CHECKPOINT on Memory.
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.