I agree. Temporary tables are meant for temporary storage within a single connection's life on the server, not for the entire time an application is being used. You need a...

Hey Flo,

I think you might want to try Wesley's idea. Think about it like tempdb, if it's shrinking and growing depending on load within the range you specified, it might...

The Red Gate database documentation tool, SQL Doc, will do it I think.

The problem is, it's really easy to get a circular reference. All you need is a set of...

Bob Hovious 24601 (10/28/2009)

---

Gail, can I get your autograph if I buy a copy? (I'm buying one anyway, but hey.)

Come to think of it, I need to get...

Look me up in Vegas. I'm presenting there as well.

GilaMonster (10/28/2009)

---

I know a great deal about it. Would you be interested in my highly biased opinion? (I'm one of the...

Roy Ernest (10/28/2009)

---

I got into an accident yesterday. A four car pile up. Thankfully no one got hurt bad. My whole body is sore. Hit my chest badly on the...

Thanks for posting what worked. It's always good to know and it helps people who find the thread later.

From a performance standpoint that's a fairly wide clustered index. I sure would hesitate to make it wider, but the best way to fix it would be to add something...

If you can't trust your hosting organization, you need to get a different one. Those guys should be lawyered up to the max and under 17 layers of NDA. If...

Well now that I can do, but I usually...

I'm game. I don't care what I program in. My issue, and it's been my issue for a while, is that the "replacements" for SQL don't seem to be attempting...

Bob Hovious 24601 (10/27/2009)

---

Hey y'all. I think I finally have something that would make a good short article. Have any of you ever seen something...

Is that primary key dependent on a datetime or time field? You could be getting duplicate values during the insert under high loads.

Excellent! Thanks for reporting back what worked.