David Jackson (11/7/2008)

---

🙂 You'll like this

Hugo's Tally Method first, my hopeless loop second.

[font="Courier New"]

CPU Reads Writes ...

While I agree that a datatype change to an existing production table may not be a work-around, I do...

Chris Harshman (11/6/2008)

---

Why did they have to make the answer really be a response to 2 separate questions? UNION ALL is not a workarround for a column defined as...

Thanks for the heads-up on the potential metadata problem. I haven't stumbled on this problem yet, but it would have only been a matter of time. Clever work-around!

Yes, I recognized the play on Poe, which is what I really enjoyed about it - and I find it much scarier than a raven! 🙂

Abbs (10/31/2008)

---

Once upon a nightmare query, while I pondered, weak and weary,

Over many a quaint and curious part of code,

While I nodded, nearly napping, suddenly there came a hacking,

Someone gently...

drnetwork (10/22/2008)

---

... if I tried to do that with my product (a higher education ERP), it would be a little different. In my case real money is changing hands and...

I very much agree with the article's comment that developers interact with users more directly. That's my favorite part of a project!

As for the large number of changes -...

I had a similar data shadow problem a few years ago, when my husband and I were turned for a bank load due to the activites of another couple in...

Kenny,

Thanks for pointing out the performance implications of using a CTE versus a temp table multiple times in a query.

Very clever! I never thought to delete from a CTE!

Wayne,

Wow, good job investigating system tables/views and triggers! (although I did not expect you to drop everything to do it - - I was just reply to your question.)

Your...

Pieter,

The Error message implies that you can't use SET ANSI_PADDING OFF with XML data methods, and this script uses an XML datatype, but I couldn't find a good explanation in...

Yes, I noticed the same thing when I tested the audit program on a test database. I don't know why the "rename" step (or whatever the system REALLY does)...

Steve,

Thanks for the link to a very interesting article. I have long been suspicious of social networking sites. But the internet, in general, has the potential to have...