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.
SQL SERVER – Increasing Speed of CHECKPOINT and Best Practices
I received this question as a follow up of my earlier blog post which I wrote about SQL SERVER – Impact of CHECKPOINT and DBCC DROPCLEANBUFFERS on Memory.
PostgreSQL – Storing Unicode Characters is Easy
One of the interesting features of PostgreSQL database is the ability to handle Unicode characters. In SQL Server, to store non-English characters, we need to use NVARCHAR or NCAHR data type. In PostgreSQL, the varchar data type itself will store both English and non-English characters.