EOMONTH

EOMONTH What is EOMONTH? Date manipulations are always associated with pain for […]

RAND

What is RAND? The RAND function gives you – not surprisingly – random numbers […]

SELECT FROM VALUES

What does SELECT FROM VALUES actually do? Whenever you needed a small […]

CHOOSE

What is CHOOSE? CHOOSE is certainly one of the less known functions in […]

DATEDIFF

What does DATEDIFF do? Today we’ll look at one of the most […]

COMPRESS

What is COMPRESS? If you have a large amount of data in […]

BULK INSERT

What’s a BULK INSERT? If you want to get larger amounts of […]

MAXDOP

What’s MAXDOP? You’ve probably noticed when viewing execution plans in SQL Server […]