Lynn Pettis (9/9/2009)

---

GilaMonster (9/9/2009)

---

The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon...

Adam Machanic (9/9/2009)

---

This one I can actually answer 😀

Put the eggs in the pan with cold, salted water

Bring to a boil

Immediately upon...

I think Jack has the thing (Data Conversion Task) that I was trying to remember. You can always do it in scripts also, put that's probably the harder way...

GSquared (9/8/2009)

---

CirquedeSQLeil (9/8/2009)

---

But maybe, just maybe, two european swallows flew to Mauritius, procurred a coconut and presented it to two african swallows. That solves that.

Now if we only knew...

??? . It isn't?!? Dag'nabbit, you...

We cannot see the error from here. Could you tell us what it is?

You might want to take a look at this Connect issue: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=473669&wa=wsignin1.0

Are any of your CLR assembles installed with the UNSAFE permission set?

I don't know of any Freeware that does this (I actively looked for it about a year ago). A colleague of mine tried to write his own after that...

Good analysis and writeup.

And yep, I'd agree, looks like an optimizer bug in SQL Server 2005, though as you imply, it seems to be fixed in 2008.

You cannot change datatypes just via mapping. You will need to use a script component or a SQL Transform or component where you can explicitly apply one of the...

Here's the link to Grant's latest book, which I can highly recommend: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_3?ie=UTF8&s=books&qid=1252289317&sr=1-3

You do realize that a Rollback will undo your triggers actions also, don't you?

If you can give us the table definitions and some sample data, we can show you how to do this.

Kwisatz78 (9/4/2009)

---

As the title says I am experiencing High % Disk Time but low Avg. Disk Queue Length on a production machine. THe period measured is during a typical...