More Business Logic Validation

I’ve gotten a few data points, but I don’t think I’ve had enough yet to complete my sample.  I’m still looking for people willing to describe how and where they implement business logic in their database applications. 1. CHECK CONSTRAINTS 2. TRIGGERS 3. Mid-Tier 4. what’s business logic?? Please send me some details of why…

1

CHECK Constraints vs. TRIGGERS

I’ve been having a conversation with a customer about CHECK constraints and TRIGGERs, and I thought it would be good to survey some of our customers about how people use these features. I’m curious how many people encode business logic validation in CHECK constraints.  I’m also curious about what you would LIKE to encode in…

1

PASS Community Summit 2008 – Seattle

I just got all of my travel arrangements set up for PASS in Seattle.  I’m excited to get a chance to go to PASS again.  A good number of the product team will be manning various booths, ask the experts sessions, and panels.  I’ll be working 1-2 ask the experts sessions on queries, query optimization,…

0

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