Using NULLIF to compare missing values to NULL is handy. It become especially useful ...

​Read More

When working with NULL, you’ll often find yourself wanting to replace these “missing” values, ...

​Read More

SQL server’s date functions provide you a set of function that you can use ...

​Read More

Use the Approximate Count Distinct function, APPROX_COUNT_DISTINCT, to return an estimate distinct count of ...

​Read More

Knowing when to use the SQL COALESCE function is a lifesaver when you’re dealing ...

​Read More