T-SQL Performance 1

MERGE

What's the Point of Using VARCHAR(n) Anymore?

The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.

EXECUTE

Read Uncommitted, locks, and transactions

HASHBYTES

TSQL function to detect SQL Agent job state

This article has a T-SQL function to detect the SQL Agent job state.

Aggregate Function Product()

The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.

INSERT OUTPUT

Twist in ISNULL function

Be careful while using the ISNULL function