In 2005, a DDL trigger might be the best way. As jezemine mentioned, log to a table, then set up a job that runs and joins this to logins. Anything...

You want to walk a hierarchy.

http://www.sqlservercentral.com/columnists/sSampath/recursivequeriesinsqlserver2005.asp

Jason,

I think you've brought up a great point and I think SQL Developer is different than DBA. I've got a couple weeks focusing on DBAs, more the admin, full time...

Chris,

I think for sure you'd qualify as a junior DBA or be able to get hired as one.

I'm sure that there skills are all over the board for some people,...

The only way I know of is to audit logins and then delete or disable those that have not logged in within xx days.

Another easy way to do this is build a query to get the status and insert this data into a table in another db every minute. That way you don't...

Absolutely. This should only be used on development machines for testing parallelism in queries.

Yes. The cores don't matter to SQL Server, it just sees what the OS presents. And licensing is by sockets, not cores, so you license by the CPU sockets. 2...

These aren't necessarily the tasks a junior does on day 1, but they're the basic skills. And they apply to basic cases.

Being able to find a blocking connection doesn't...

Paul, I tend to agree with you on the last point. A manager should be trying to help people do their job, removing distractions and providing motivation.

However I do often...

We republish popular articles periodically. It gives new people to the site a chance to catch them.

int.

Save space, makes more sense.

A phone number isn't really a number. It's a string of numerical characters.

A PK is a the way of uniquely indentifying each row within a table. It is implemented in SQL Server by means of a unique index. This can be clustered...

The two posters above are what I understand.

Please post an update if you figure something out as this would be a major bug to know about.

I'd follow Sugesh' advice, but also perhaps connect with SSMS and run the same query outside of the stored procedure when it's slow and grab the execution plan. This will...