we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
How to Skip Top N Rows in SQL Server? – Interview Question of the Week #237
Question: How to skip top N Rows in SQL Server and retrieve the rest of the rows? Answer: I had asked the above question in one of the interviews last week.
SQL SERVER – Retrieving N Rows After Ordering Query With OFFSET
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