tosscrosby-60625 (1/4/2010)

---

CirquedeSQLeil (1/4/2010)

---

GSquared (1/4/2010)

---

Well, while we're adding pictures: For a potentially limited time only, the goofy looking guy in the picture on my posts is indeed me. I took...

CirquedeSQLeil (1/4/2010)

---

GSquared (1/4/2010)

---

Well, while we're adding pictures: For a potentially limited time only, the goofy looking guy in the picture on my posts is indeed me. I took the...

Well, while we're adding pictures: For a potentially limited time only, the goofy looking guy in the picture on my posts is indeed me. I took the picture myself...

I don't depend on people to do the...

I have an Android phone instead of an iPhone, but it's in the "same difference" category. Tons of uses.

I'd used "smartphones" before, and never had much use for them...

I'd like to dig into SSRS and into CLR more.

David.Poole (12/30/2009)

---

One trick I found if I want to improve query performance where I need to query a character field larger than 900 bytes is to have a column that...

And to add even more to it: Happy New Year everyone! May the best of your past be surpassed by the worst of your future!

It doesn't have any bearing on the effectiveness of the clustered index. I'd have to know what the purpose of the index query you have is, and what it...

You're welcome.

Did you follow MS's recommendations on upgrading from 2000 to 2005, including updating useage?

It's been an interesting year for me (Thread-heads will know exactly what I mean). SSC being a stable point in an often tumultuous environment is definitely one of the...

It sounds like you have a problem with an execution plan. Updating the stats resets those. That's the more likely culprit.

When the queries are running slowly, save the...

Lowell (12/30/2009)

---

i think filenames/paths with spaces need to be wrapped in double quotes, right?

also, are you not CALLING the datapump? why is the DIR command in there?

exec master.dbo.xp_cmdshell '"C:\Program Files\Monarch...

You're welcome.