Another reason to write what you mean. What's the use of saving 5 characters if you then have to think longer about what it means?

Nice question, but I wouldn't call a reference to a non-existing object a syntax error; the actual syntax is correct

I work in data migration. Client is a large financial entity who is moving an acquired portfolio into their own systems. We load the source data (source system is still...

Currently, I am working on a server on a client's network. Client has the policy of nightly dbcc checkdb and log back up, and weekly a database shrink on all...

Hi Mala,

Very nice article, thanks so much.

Would this model still be so simple to navigate when you'd have composite keys's? I've been writing a solution to answer similar questions without...

Why does the link point to the Brazilian documentation?

Good question. Could use a bit more explanation though. Interesting what happens if you replace ISNULL with COALESCE.

Sorry people for the confusion. As many have pointed out, I made a mistake with the tmp schema. In my databases I always have a tmp schema, which is emptied...