CONVERT vs. CONVERT_IMPLICIT

Today’s question comes from a friend I have in Brazil. Please, tell-me one thing, is there any improvement in avoid Implicit Conversions forcing one explicit conversion? Or will QP behind the scenes execute the same SQL using the function CONVERT()? These are the same at runtime.  They do vary slightly in the binding rules, but I’m not…

1

Foreign Keys are our friends…

I often find customers who question the value of database-enforced integrity constraints.   While people often create primary keys, the foreign ones are perhaps a bit more …. well, foreign.  Let’s start at the beginning. In traditional, old-school database design, you take your business object and you divide it up into tables. A foreign key (FK)…

3