I tend to agree with Wayne. While a good general knowledge of all parts of systems (all parts of SQL as well as windows, etc.), is good, if there's something...

Sorry about the links. Not sure what's wrong, but I'll see if I can track it down.

There are lots of stored procs in AdventureWorks. I know some authors use it as well on this site:

http://www.sqlservercentral.com/articles/Administration/2771/

http://www.sqlservercentral.com/articles/Product+Reviews/3050/

Active threads does show all threads receiving a post since your last login. It doesn't show just what you participated in.

The "Recent Posts" above has a few other options.

Gail is correct, you need to query every table with a GUID. And every column.

Use Jeff's query to find the tables/columns and then query each of those.

Apologies, looks like they've been moved to Codeplex (http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en).

Check permissions on that file. Be sure that the SQL Server service can access it. There could be permissions on that particular...

SQL Slammer used 1434 and it can be a problem. This port is used to discover other SQL Server instances and is a pain if it's not open, but you...

The DMV for plans shows what's in cached, but that doesn't tell you what's been run recently. If you had lots of different procs run, you might see them getting...

I don't know that there's a good collection anywhere that you can reference. Lots of blogs and short notes/articles around. Search "VLDB SQL Server".

You will probably have to consider filegroups...

Question has been changed to say 2005. Thanks for the comments.

All answers have been marked correct.

Having both looked for lots of jobs and gotten a dozen, and hired people before, I'll say that the ad usually asks for more than we'd accept. Often every possibility...

We gave away the free admission to someone local. It's a promotion, not really a money maker, so we didn't want to sell it here.

Too often I see companies still...

If you're trying to check for success, then you can execute the batch as

sp_adduser 'aaa' ; select @@error 'error'

and that would return the error level. 0 would indicate no error.

In the example above, if there was an error, a one row, one column result set would be returned. The column would be named "returnval" and would have a 1....