How to join a local table to a remote table by way of a linked server

Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.

Object_Id 1

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.