My comments vary. Usually we start off with the following:

/****************************

InstallDB: MyDB1

CreatedBy: Brandie

CreatedOn: 2012.09.26

Description: This proc pulls the orders made within the last week that were not

...

Daniel,

I would agree with Andrew. This sounds like a case of your services running under a local account instead of an plain vanilla Domain (Active Directory) account. Local accounts can...

Bhuvnesh (9/24/2013)

---

Brandie Tarvin (9/24/2013)

---

But it doesn't explain why the second update (which does much the same thing on different columns) is able to use its index. It does an Index...

Hrmm... You know, you're right. I can't think of any reason why it wouldn't work in the INCLUDE list...

Thanks.

The thing I'm concerned with is R2's extra capabilities. I'm developing stuff, but our environment is all regular 2008 (and the R2 is my personal copy that I have on...

mar1jxm (9/20/2013)

---

I have seen these type of cases when a Query Designer contains a SELECT INTO statement on a big table or it has several general T-SQL statements (IF, DROP...

GAH. I keep forgetting that I can't create an index on the Extract column because the column is too big.

I guess I'll have to live with the Key Lookup after...

Tell me about it.

Triangular join from hell with over 500 billion rows in one section. The comment says you are linking "3" records to...

*headdesk*...

This is no real best practice. And most people don't worry about the Transaction logs hitting at the "same time" as the Differential or Full backups because they deliberately create...

Wayne, YOU DA MAN!

I've been fighting a lot of fires lately and the coworker didn't quite understand everything you posted, so it's...

Here's the UPDATE statement with the Key Lookup. To be honest, it isn't taking very long to run. My biggest issue is with another part of the query. Still, I'd...

Running together with GO between parts of the statement. I'm about to run the two...

Which would explain why it did it after I set Statistics Time and Stitistics IO on AND...

Make sure you have a good recovery plan (and lots of backups) in case the upgrade goes wrong. My laptop wasn't an issue because it was my personal sandbox and...