katedgrt (4/15/2009)

---

I haven't heard the term revisionist terminology before...

Actually,...

GermanDBA (4/15/2009)I know that if the series has the same quality that RBarryYoung produces here on a daily basis, it will be a wonderful primer for quite a few database...

Thomas (4/15/2009)

---

Couple of very simple solutions.

First one is SQL 2005/2008 only, won't work in 2000:

create table dbo.Numbers (Number int primary key);

go

insert into dbo.Numbers (Number)

select top 10000 row_number() over (order by...

Thomas (4/14/2009)

---

Agreed. Here's another example. You want to build a numbers table that simply contains a series of sequential integers. There are many uses for such a table in solving...

Bruce W Cassidy (4/14/2009)

---

Thomas (4/14/2009)

---

Set-based operations do not natively provide for chunking and thus we have cursors. Of course there are other ways around this problem, but at the end...

Thomas (4/14/2009)

---

A simple example of where set based operations break down is in very large data sets. I want to take a table of 10 million rows and copy it...

Thomas (4/14/2009)

---

Another common use of cursors is to script a DDL change. For example, I want to write a script that will alter all columns in all tables call "Foo"...

This is actually from Jacob Sebastiens Challenge #3, where the actual rules were: "Write a single query that can reverse the strings in this column without using the REVERSE() function".

FYI, my example is recursive.

By the way, there are a lot of tweaks, tricks and improvements that can be applied to primes-listing algorithms, though only a few of them would be worth it for...

Really? Huh, I learn something new every day!

Sorry, Christian, I missed...

Thanks, Steve, this one might be close to the single day record. :hehe:

FYI, folks: I wll be offline until tomorrow evening, so don't think that I am ignoring you... :-).

Brave. Stupid. It's a fine line. ...