gregwhite83 (12/7/2009)

---

Hi All,

I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What...

daniel.phone (12/7/2009)

---

Grant Fritchey (12/7/2009)

---

daniel.phone (12/4/2009)

---

0 vote down

star

Please help me with the following questions as soon as possible….

1) True or False, specifying a join hint will force join order?

2) When...

Don't have it in front of me, but it's on the netbook that I'm running it (albeit, very slowly, just needed a place to carry with me for working on...

daniel.phone (12/4/2009)

---

0 vote down

star

Please help me with the following questions as soon as possible….

1) True or False, specifying a join hint will force join order?

2) When joining two small...

I'm running R2 on Windows 7, no problems. You can.

In addition to posting the code as Lynn suggests, also try capturing an execution plan or two (more than one if they're changing for each execution).

Two answer part of your...

S.K. (12/6/2009)

---

I don't think this statement is...

Lynn Pettis (12/7/2009)

---

davidandrews13 (12/7/2009)

---

excellent! using Madhivanan's link i've now got rid of my cursor 🙂

i dont think it makes to much difference in this situation because its currently only bringing...

GilaMonster (12/4/2009)

---

SQL's not stupid enough to store a...

Just be aware that dynamic SQL can lead to the exact same types of problems you were facing with this procedure. It's worth knowing ahead of time. The one way...

GilaMonster (12/4/2009)

---

The title's actually Inside SQL Server 2005: The Storage Engine....

If I understand the question, the best resource I know for this is Kalen Delaney's book: Inside SQL Server 2008: The Storage Engine. Absolutely fantastic.

They're from the DTA and because of that, I'd test the heck out of them to validate that they need to be there. The DTA is not to be trusted....

timothyawiseman (12/4/2009)

---

Grant Fritchey (12/4/2009)

---

I don't entirely agree with #4 though. Certification just doesn't seem to be worth much and when you factor in the cheat guides, it becomes worth less....

For this one.