brekher,

A cursor would certainly work, but what you may want to look at is putting it in a temp table. Then take the top one value, processing it, and...

rhat (2/19/2008)

---

a.)

c.) Those that can....DO. Those that can't. Manage.

Yes, it's that simple. Pointy Haired Bosses are all around and aBound in the software world.

One of these days, the ones...

Awesome article, and one I concur with wholeheartedly, but there is one thing I would like to add. I have worked for a large number of managers and have...

RBAR is definitely...

localadm (2/12/2008)

---

Ian Yates,

You mentioned that you split the database containing BLOB into smaller chunks. I am very interested in that topic. I have a database of 0.5TB, and...

This was a well done and much appreciated column.

You are quite correct in pointing out that indexed views can add complexity in requiring things such as ANSI_Nulls, ANSI_WARNINGS,...

From a strict standpoint, there are ways around denying select rights that would not work on encryption, such as copying actual files and viewing them elsewhere. But...

Quadrilaterals always have four sides, so your table would never need more than four columns to completely describe each side, and by having some standard way of numbering them you...

I may be misunderstanding your question, and also the best way to store the information often depends on what you intend to do with it.

The obvious answer if you are...

This was an interesting and good article, but I am curious what trends you are seeing to make you say that BLOBs are becoming more common. I can certainly...

This is one of the more interesting articles on SQL I've seen so far. I am definitely interested to see the end product.

This was a great article. I moved into IT from another field of management fairly recently, and in my other field transparency meant everything within the organization. It...

rick (1/25/2008)

---

Grasshopper: I have to take issue with your statement that TSQL is a horrible language. From my 38 years first as a developer and then a DBA,...

What is the best way to learn to develop CLRs and learn first hand what they are useful for and when they are useful?

I may largely be echoing Jeff here, but why create insert statements?

Pull it in directly if you can. If you do not have a reason to use...