While loop counter:

declare @Counter int;

select @Counter = 1;

while @Counter <= 100000

begin

print @Counter;

set @Counter = @Counter + 1;

end;

Same machine. 16 seconds first run, 14 seconds second run, 13 third run....

And, if you're asking me about hierarchy resolution with a cursor as opposed to a recursive CTE (asking me to put my code where my mouth is, essentially), here you...

Jeff Moden (1/26/2009)

---

GSquared (1/26/2009)

---

Jeff, something I have to ask:

You keep mentioning that recursive CTEs are worse than cursors. I can see that in some cases, but in cases like...

Will Summers (1/26/2009)

---

One of the big things that I would like to see is the ability to right click on a table and then enter a table description. Why...

Is that from when I told someone to stop using those on you, Jeff? Just last week, if I remember correctly.

I think my best example of "whoops! How did I miss that!?!" was my two-part article on audit trails and logging, and I completely forgot to include anything about server...

The other thing that can be done is work with non-profit/church/whatever groups as a volunteer.

I've never read anywhere that there's a maximum size to an index. Wouldn't make sense if there were, since the index really can't be bigger than the table. ...

I'd say that your best bet is to start with working out what tables you need, how portable your code is, and so on. SSIS can help with loading...

If you want them to be able to do anything within the instance, yes.

Take a look at CLR coding in SQL. Books Online has data on it. That might do what you need.

I'm not sure, but I think there's a way to get a data reader to deal with an empty recordset.

If that's not the best way to do this, there are...

If you use Case statements, include all necessary tests.

For this, you need to have something like:

case

when date1 > date2 and date1 > date3 then date1

when date2...

I'd say the first thing to do is to double-check the settings on your log file, and make sure it's actually allowed unlimited growth and that it's actually on a...

You might want to take a look at the Row_Number, Rank and Dense_Rank functions in Books Online. I'm not sure, but they seem to fit what you're looking for...