Mike Byrd (10/16/2009)

---

cpu_busy io_busy ...

carl.anderson-1037280 (10/14/2009)

---

I would like to thank everyone for posting your comments and contributing to this discussion. I enjoyed reading along and have learned a few valuable tips and tricks...

cmallain (10/14/2009)

---

HI, sorry if this is wrong place to put this but the example:

with

list as (

select

name as value,

row_number()...

Tom Winter (10/14/2009)

---

Thanks Adam. I just found that solution somewhere else right after I posted. Here's all my references:

Coalesce is not the answer to string concatentation in T-SQL

http://msmvps.com/blogs/robfarley/archive/2007/04/08/coalesce-is-not-the-answer-to-string-concatentation-in-t-sql.aspx

FOR Clause (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms173812(SQL.90).aspx

TYPE...

Thank you, Dan and bitbucket, for your great references!

Kenneth Wymore (10/9/2009)

---

You never know what the future will hold so I think it pays to be diligent in advancing your own skills even if you can't put them into...

Some years ago, I tried to donate my old computers to a local school, and they flat-out didn't want them.

A few years later, a used computer store opened close to...

1) I think it's really important to understand the basics, so writing one's own tools is excellent for that. That said, there are plenty of people who are far...

Arshad Ali,

Thank you for an excellent, well-written article! (Note: the code to populate your sample table is missing the declares for @CTO, etc.)

gerald.drouin,

Clever solution!

Thanks, Andy,

I've been following along with these articles over the past few months, but didn't have the time to sit down and DO your examples. (Your explanations are GREAT,...

I haven't been to a conference in Vegas since 1983! I don't gamble at all, so the only interesting diversion I found for the evenings was "Fly-Away", the vertical...

Excellent video! I knew I could cascade deletes, but I didn't know I could manage changes using the foreign key. Thanks!

Thanks for the interesting example of what happens when you mix attribute-centric and element-centric mapping in one xml structure.

My husband has a sequestered disk fragment - ie. a piece of disk broke off and now moves and presses on the nerves going down to his legs. (We...

I used to get really steamed about the people who would take the last cup of coffee and walk out without starting a fresh pot, not because there wasn't any...