#1 Ideally, check in the change management script system.

#2 See #1 if #1 fails :hehe:.

No seriously, other than asking around (assuming the default trace has been rolled over), you can...

PaulB-TheOneAndOnly (11/18/2011)

---

I'm in agreement with both Grant and Gail.

Your training time would be much better used if focusing on what should be your area of expertise which is to be...

We should stop arguing like...

In that kilt?

yes!

icocks (11/18/2011)

---

Dave Ramsey would frame the question this way: "Given your current financial circumstances, would spend $100,000 of your savings to go on on a space shuttle ride?".

I'd personally take...

Eric M Russell (11/18/2011)

---

Ninja's_RGR'us (11/18/2011)

---

SPACE, anytime.

100K is easy-ish to come buy with more work. Space is another story and not enough of a motivator to work towards for that...

What's the version of the db on the remote server?

This is missing a double quote before the db name.

WHERE name = REMOTE_TEST'''

SPACE, anytime.

100K is easy-ish to come buy with more work. Space is another story and not enough of a motivator to work towards for that long (for me atm...

You mean you can't go in the format property and do something like yyyy-MM-dd?

p-nut (11/17/2011)

---

agiangone (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

My view of index hints is simply that to use it you must somehow think that you're smarter than all the guys at ms combined and all...

Ya in 5 days you get it working better or acceptable. You're not done!

We might be able to find low hanging fruits in the execution plan, but that's about...

Please upload the ACTUAL execution plan.

The bad one and the good one too.

I have a low fee for stuff like that. Normal time to optimize this is around 5+...

Evil Kraig F (11/17/2011)

---

AGH, my eyes! ... and formatting is eaten.

Can you edit your posts and wrap your code with the 'ifCode' shortcuts you see on the left? ...

My view of index hints is simply that to use it you must somehow think that you're smarter than all the guys at ms combined and all the trillions of...

MyDoggieJessie (11/17/2011)

---

I've always been curious about which value should be set as a fillfactor and why as well...clearly there's different reasons for it when it's a clustered or non-clustered index,...