I...

The first place I came across using a numbers table was from a Joe Celko book. I take a slightly different approach, typically using a view (with the following...

Something that I have...

I would like to “second the motion” of putting an article together around this.

I ran into this situation a while back, and I started using code / procedures similar to what has been presented so far. I then decided to look at...

I think that would be very helpful. I've been browsing for more detail on this subject (Generate RSS from SQL Server) since I posted my question and the tendency...

I haven't had the chance to review all of the series that you have here, but from what I have read so far it is really helpful. I do...

Nice article: I've had to create HTML emails from SS for a while and have had to do all of my work in stored procedures.

I'm curious, have you considered doing...

I've thought about this over the years for any number of reasons. The "best" idea I came up with was to use "printed digital information". Some years back...

I haven't had the chance to test performance (BETWEEN versus >= and <=...), I'm lucky if I get any chance to go back and "cleanup" stuff that I write.

I am...

Relating to default values and NULL's: in the areas where I do most of my work (performance data, DW, and reporting) I have a couple of scenarios where I need...

I don't suppose they removed the subsidies on Ethanol as well? That was one of those that I...

Nice editorial. A couple of "opinions";

micro-nuclear is great, and even though it could be used in some locations, I want to see that used in spacecraft. Imagine what...

I was thinking about stuff along these lines last night after posting my reply.  My application is fundamentally a data warehouse.  It loads up bulk data on an hourly basis, runs...

"If your index design is bad enough to offset the performance gain of raid 10 then it'll be 4 times worse on raid 5, sorry but that is such an absurd...