What I learned at PASS – ETL in Queries.

I attended only a small number of the talks at PASS.  I really enjoyed Bob Ward’s talk on memory and Paul Randal’s talk on DBCC corruption/repair.  Otherwise, I spent a lot of time answering questions from customers.  LOTS of questions.  So many questions I pretty much lost my voice. Overall, I was amazed at how…

1

PASS in Seattle! W00t!

I hope to see folks at PASS – please look for me at the Ask the Experts booth for Query Processing/Performance.  I’m very interested in hearing about what kinds of ways you are using SQL Server and how we can make the product better!  Thanks,  Conor

2

Conor vs. Win2008 Hypervisor

I’ve been building a new machine and I have put Win2K8 Enterprise on it.  While I have no specific reason to enable the hypervisor other than my absolute, unbounded enjoyment at saying the word “hypervisor”, I also was going to try to run a few of the server-like programs that I use at the house (for…

1

The vote is in! (CHECK CONSTRAINTS vs. TRIGGERS vs. STORED PROCEDURE business logic)

Thank you for everyone who “voted” – a great day to talk about the issues of the day :). After much research, I’ve found that we live in a divided country.  Some of us like triggers.  Others wouldn’t be caught dead with a trigger and do lots of business logic validation within stored procedures.  Some…

2

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

Where’s Conor?

One of the interesting parts of working on products is that you have to build the features before you can talk about them.  So, I’m off building some new features about which I am very excited.  I can’t talk about them, of course, other than to say that I can’t wait for them to get out to customers!…

1

Whew! I’m done with the Optimizer Chapter for the next Inside SQL Server book!

I think I’m pretty much done with the chapter for the next Inside SQL Server book on the SQL Server Query Optimizer.  I’m just waiting for comments from a few technical reviewers. Lots and lots of code/query examples – too many!  I’m hoping that this will help both developers and DBAs understand the “why” behind…

0