mdonnelly (2/27/2009)

---

David McKinney (2/27/2009)

---

mdonnelly (2/27/2009)

---

This would have been on the bubble of being excusable had the original article...

john.arnott (8/6/2008)

---

Now I'll confess this is the first time I've tried using the Tally table method for anything, so just made one in my sandbox db, but without an index...

60s and 70s 😀

Great article and great solutions to an "interesting" requirement set!

I admit I didn't read the original post, but the assumption Chris's and Phil's solutions rely on (that duplicate rows are...

Sure, I just can't think of any code I'd run in a loop, cursor or otherwise! 😀

I'm serious about my comment on "Wall Clock" benchmarking, though. I don't know...

OK, never mind. Looks like I might have been preaching to...

Oops, I meant

"Select sum(site_frontage) as TheAnswer from Site"

I apologize for jumping into the middle of this thread, but I must be missing something. What's wrong with

"Select sum(SF) as TheAnswer from Site"?

Or is the whole point...

jcrawf02 (6/13/2008)

---

When I began reading this article, I wondered why it had been chosen to be re-posted, as I've read several other articles by Jeff, Matt, et al that demonstrate...

I'm having the same problem. Performance monitor is not running, but the error still appears when sql server service is restarted. OS is Windows 2000 V 5.00.2195 (sp4)....

Great post Jeff,

I'm jumping in a little late, but here's my 2 cents:

"if you did have someone to fix it, it wouldn't have been written to cause a problem...

CORRECTION.  The prior posted sql may have duplicates.  The following should work better:

--List tables, columns and column descriptions

select SO.name as 'table', SC.name as...

This may not have been mentioned in the article because it's too obvious, but I consider a database relational diagram to be one of the most important pieces of documentation...

Another great article, Steve!

I know it's good to keep it short, but I would expand the "Null math" section to include awareness of the ANSI_NULLS option and its effect on...

"Actually comparisons of a NULL (or a non-NULL value) to a NULL results in UNKNOWN.  Your point is taken though:  The WHERE clause only returns results for rows...