Just send the CEO your resume and say you can cut off that price by at least 20%... Hired ;).

Damn, there were still Dbas left Friday night. I guess I missed them all. It was like a ghost town right after the last session has started.

Might also be a good time to ask for a laptop while you're at it :hehe:.

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. ...