To Steve's point in that article, most of the time set-based code will perform better than trying to "divide and conquer", but he was dealing with a trigger which meant...

yeah, or sys.syscomments. Chris, any idea what the difference is between sql_modules and syscomments? I'm trying to read BOL to understand, but to me it looks like it would be...

Thom, I'm not sure I'm totally following you, and you are just now clueing me into graphs, but can you show me how you're comparing the graph syntax to the...

I don't think we know enough to know how to answer you. It is possible to have charts with three series, but I don't think that's what you mean. Can...

Nice Joe! We have a function to do this, sourced from Jeremiah Peschka (http://facility9.com/2010/02/24/rounding-to-the-nearest-x-minutes), which works nicely when we need it, and allows for choosing your interval a...

I can't imagine it would be efficient, but you could look through the INFORMATION_SCHEMA views to do this, if you have to recreate it. that in combination with SP_MSFOREACHTABLE might...

Email server's down, I sent you an email about it.

running it across servers and need to use OPENQUERY() to make it work in a reasonable timeframe. so I'm cheating, pulling one record over to create a local mirrored table,...

...and now I'm wondering if I can't buy a Leap controller and a wand and program some shortcuts so I can code like a wizard....already use Dasher (http://www.inference.phy.cam.ac.uk/dasher/) to...

My code from today included the following comments:

--copy table values into new table, just to get columns...

I forgot you wanted to conditionally look for something or NULL. I think this is the CASE you wanted, replace the guts of the proc above with this:
[code...

I'm not entirely sure why you want a view here, if this is a recordset that you want to use regularly and JOIN to it, then you probably want to...