Why do we build a filter in T-SQL? Sometimes you want to […]

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

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

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

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

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

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

What does MASKED WITH FUNCTION do? Let’s assume that you want to […]

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

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