Roy Ernest (11/3/2010)

---

Just wanted to give an update. Things are much better now. It did not rain much. The sky is still totally covered with cloud. Still raining but not...

jcrawf02 (11/2/2010)

---

Greg Edwards-268690 (11/2/2010)

---

jcrawf02 (11/1/2010)

---

Greg Edwards-268690 (11/1/2010)

---

jcrawf02 (11/1/2010)

---

Yes, I'm aware of that one, but with half the RAM, not helping me much. Cubes have been under-utilized here, mostly because it...

jcrawf02 (11/1/2010)

---

Greg Edwards-268690 (11/1/2010)

---

jcrawf02 (11/1/2010)

---

Well, that's kinda the point. I don't know what I don't know yet. It would be nice to have a way to dig through the data...

jcrawf02 (11/1/2010)

---

Thanks for the tests Greg, no need to play with 2007. You bring up a good point, because I won't be the only one here at work who tries...

jcrawf02 (10/28/2010)

---

trying to figure out what I *should* be doing to be most efficient when I want to go digging through some of our data. Don’t know if there are...

GSquared (10/29/2010)

---

Yes, this is a classic double-hop issue.

First, I recommend moving this out of a trigger and into a queued process. The trigger will cause problems because of transactionality....

jcrawf02 (10/28/2010)

---

trying to figure out what I *should* be doing to be most efficient when I want to go digging through some of our data. Don’t know if there are...

Short is way too descriptive.

Greg...

GilaMonster (10/26/2010)

---

Difficultly.

Officially going to prod on Friday. Project manager getting lots of praise for delivering project on time. I'm expecting another crapping...

I remember slammer well.

I was one vacation for a week, and I got back to find it had hit our network.

The only 2 servers not affected were ones I...

Sorry I missed your comment of * part way down.

When I copied your select statement to just have a look,

this L is actually upside down, although you don't really...

Instead of Select *

try listing the columns.

Run both in profiler and see if they are different plans.

Greg E

Steve Jones - SSC Editor (10/20/2010)

---

I know that some of these people are annoying, but let's try not to pile on too much. Just post that you expect them to...

I was thinking along the lines of a view (since it sounds like you have a DBA to talk to) to have the max date availble.

Without the structure, it's a...

Alvin Ramard (10/19/2010)

---

My input buffer filled up before I hit...