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 […]