See how you can use new functions like DATEFROMPARTS to simplify otherwise really cryptic methods to obtain key dates (like the first day of the current month).

Get a first-hand look at some of the ways NOLOCK can produce incorrect data.