Don't forget to add a 2nd, 3rd, 4th, and nth almost equally expensive server for Dev, QA, Testing and backup server(s). That may let them let you take a...

So James, are you the only Developper NOT NAMED Steve working on this projet?

This doesn't take into consideration that the code string in syscomments i split after each 4000 characters set.

You need to do a left join on colid + 1 and do...

That's too funny.

In this post, I was reffering to the fact that we cannot edit a topic (had made a typo in a prior post).

Now what's missing here is that...

Group by DOESN'T guarantee the order of the results. While it often does, this is not the way to do it. The only construct that guarantees the order...

That's already a great improvement. Thanks Steve. And Thanks Steve.. and Thanks Steve ;).

Do people really do this in offices??? I'd think they'd have better things to do... like making sure the server runs 100% OK.

Cool, I have a twin now :). Can you imagine what will happen to my post count when I start answering my own posts :D?

Select LastName, MIN(id) As mID FROM dbo.FOO GROUP BY LastName ORDER BY mID

I still don't get why you want to do this thought... have no clue what you want to...

There are good arguments from both sides. As a DBA, my job is to ensure the correct results with the BEST server performance. So the less work I...

Wow, we've also upgraded to a reunite with friends board. Cool new feature Steve :).

Can you catch the execution plans of the package? Try to see if there's a difference in the # of rows processed when executed to ship on Oracle. ...

Ya that's a cool feature. Do you know if there are some whitepapers on Microsecond tuning? I was thinking that Hala from MySpace.com could come up with one,...

Check out books online in the convert section. You'll get all 10 000 possible presentation you can have in SQL Server. That said, do the formatiing in the...

Sorry but I need to to be 100% clear. Kids cover your hears :

DON'T f*ck WITH SYSTEM TABLES, EVER.