I also don't think it needs to be changed.

Definitely don't need "DBA Idol".

If specific forum sites were to implement MVP awards for their sites, they could certainly do it with...

I'll go with flash drives and e-mail clients as my toasters. I don't care which one I use, so long as it gets the job done.

Same for online e-mail....

Here's an article I wrote a while back on hierarchies in SQL. The article and the discussion cover the subject pretty well.

http://www.sqlservercentral.com/articles/T-SQL/65540/

I don't think anyone noticed when I hit 8k back in December. I...

SQL doesn't report the table affected, just the rows.

You could pretty easily modify the triggers so they would report what table they affect, but most often, you really don't need...

You're welcome.

HDDs can still end up with bad sectors too. And RAM can...

Yep. And it keeps improving as they improve...

My solution on the SQL challenge would be to dynamically generate a series of inner joins, one for each ball ID. Building the query string would take a few...

Have you looked at the Generate Scripts option in Management Studio? That'll create all the objects in a database, without any data.

MS Access is excellent for that. Link it to the SQL server, query building can be all drag-and-drop and clicking, without writing a line of code.

Reporting Services can do...

I use fn_trace_gettable in SQL 2005 and 2008 all the time. I've never yet had a problem with it. On the other hand, I always create my traces...

Like Lowell said, the Output clause can get that for you pretty efficiently. I've used that lots of times in lots of procs.

Is this based on the coding contest they announced here last week? It sure sounds like it.

The ways I know of to do this in SQL 2000 are either a correlated sub-query that has a max or min function in it to match it up to...