The jacket might be optional, but you can't go wrong with it. Shirt and tie unless you've made inquiries already.

I always ask this in the telephone interview/pre-interview process to know....

It's out now. This was a reprint from late last year.

You can get the book here: http://www.sqlservercentral.com/books/books.asp?categoryid=12&categorynm=SQL+Server+2005

Your first one should work, but I'd be wary of stripping the alphas. They are your markers. Otherwise how do you know if "244" is 2 of 44 or 24...

http://msdn2.microsoft.com/en-us/library/ms189826.aspx

I haven't seen a good script to get this info, probably because it's a lot of work to store it in the first place. Everyone has to "build" their definitions...

You would have to build the select yourself using multiple tables. It's no different than a single table, just join the tables and reference the columns

You probably need a trigger to catch the inserts and compare them to the previous entries. Assuming you can do this and have some ordering criteria, I'd have the trigger...

Yes, setup a trace for those events and set the logging as a table. You can build a server side trace and have it run as a startup procedure.

This doens't make sense? You aren't setting a value for the variable in the firts cawe and not sure where you want rowcount to appear from the 2nd.

It's an AD/Domain issue. I've had similar issues that have driven me crazy as well. Search on SPN and try setting one for the machine. I've usually seen this with...

Most things are fairly expensive. Servers Alive (http://www.serversalive.com/salive/index.asp) used to be very reasonable.

Why not just compare to a date instead of converting to a char?

We've talked about this. Part of the issue is that so many people come back and add things to posts a week or month later. We don't want to prevent...

I'm sure I've made some ridiculous statements, with probably more to come, but I'm not sure this is one of them.

Porting costs are high and they subsantially impede the move...

Tend to agree with some of the research comments. If I had to get something done this week or next, I'd just buy a new server. However since I have...