How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217

Question: How Does QUOTED_IDENTIFIER Works in SQL Server?
Answer: If you search on the internet, you may find quite lots of notes about it. So this blog post, explains it in very simple words.

Replacing SQL Cursors with Alternatives to Avoid Performance Issues

In this article, we’ll look at some alternatives to using SQL cursors which can help to avoid performance issues caused by using cursors.

T-SQL correlated queries

The Performance of Window Aggregates Revisited with SQL Server 2019

T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?

Fun addition

Short Variables

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.

Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.