I think it would have been a good idea to include the date: Jan. 7, 2012.

<sigh> I will be traveling that day, so will have to miss it. 🙁

L' Eomot Inversé (12/1/2011)

---

Hugo Kornelis (12/1/2011)

---

Well, I guess the issue...

Toreador (11/30/2011)

---

I've used it for generic audit tables, where we store something like table name, column...

Reminds me of the time, back in 1993 (in a world far, far away, in a different programming language), of having to figure out a program in which the author...

Thank you for an interesting question.

I liked the parameters with the dynamic t-sql string, so I thought I'd try it out. I don't work with linked servers,...

Excellent question! I learned a lot today.

Nils, thank you for the sql_variant_property.

I had to add a few more inserts into...

Just this weekend, my husband and I made our final decision on which solar leasing company to go with and signed the contract. We live in the Denver, Colorado...

Hugo Kornelis (10/24/2011)

---

PS: There's even one more way to achieve the intended change:

UPDATE TOP(1) Table1

SET Column1 = 0

WHERE Column1 = 1;

Since row order in a relational...

I enjoyed your article because it was relevant on multiple levels. Thank you for a well-written article!

With regards to your discussion of the iterative process of building the code, one step I didn't see was how to stop the infinite loop if the Collatz Conjecture does...

Excellent editorial. I, too, am sick of romantisized versions of a variety of violent cultures. Good point to draw the line on using these for personal development of...

Evil Kraig F (8/25/2011)

---

Wayne,

Excellent examples and a solid walkthrough, thank you.

Btw, for your question about real-use of range, you'd have to wrap the results in a distinct.

I'm thinking of log-entries....

Cool! Thanks for the...

So, here it is Friday, and I'm just getting around to reading Tuesday's newsletter...

James Stover (8/2/2011)

---

I usually eat alone because that's time I take to process challenges encountered in the...

reh (7/1/2011)

---

I got a "sabbatical" by enlisting in the Army Reserves a few years ago...got six months off for basic training and AIT, came back to work for a while,...