It seems that COALESCE may be expanded to a CASE/WHEN, which causes the expression to get evaluated twice (link); ISNULL apparently doesn't have this behavior. This has a performance impact (i.e. when ...

Both IS NULL and IS NOT NULL get translated to the latter form as this maps nicely to the exists query. However for scripting this ends up with double methods which is inconvenient as it's a negation ...

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...

Learn the differences between Is Null and IsNull() in Access Your email has been sent How many null values exist? What is the difference between a null value and a blank entry? This article answers ...