As an extension of the idea above, keep those variable items in a .ini file. As long as the .ini file is in the same physical location on each server,...

I know you believe you understand what you thought I said but I'm not quite sure that what you heard is what I meant.

Murphy was an optimist.

What can we do...

Likely that is part of the problem.

Is the clustered index on an identity field perhaps? If so, you could add in your where clause ...And carton.identity_field > 0. That will...

And is that showing a clustered index seek or a clustered index scan?

Having used both syntaxes I would agree without looking that the execution plan and query result would be the same. Given the amount of execution time I am guessing that...

My experience with DTS suggests that the task numbering has to do with the order of creation. If you have 10 tasks (created in order 1-10) with workflow that executes...

If each view contains an Order By clause, then you may eventually end up writing a view for every possible combination of Order By clauses. That is, potentially, a LOT...

I, too, have been on both sides of that interview table. Technical interviews can be as daunting for the interviewer as for the interviewee. But I always appreciate someone who...

SQL2005 integrates with SS and with many 3rd party source control applicaiotns.

True, SPs are not compiled but they can and frequently do use a previously created execution plan. Inline code does not.

And with regard to source control, granted it takes discipline...

Before you invest (although it is a GOOD idea) you might want to look more closely at paging just to keep things alive until Christmas.

Check to see if the Windows...

The nature of this site means that this had to happen eventually. Cheers to Steve for being a stand-up guy about it. No rationalizations or excuses here, just acceptance and...

A couple of other things to consider...

Columns frequently used in WHERE clauses are good index candidates.

Investigate your indexing solution versus your queries using Execution Plan. Be sure that you are...

I've been doing both DBA and development work in SQL since MS-SQL 4.2. When I started that I was also learning ASP (interdev 1.0). I still do web development (learning...

As a de-facto DBA who certainly prefers development to log checking, I couldn't agree more. We have been through a great deal of off-shoring. It was sold originally as handling...