Are you talking about the "black box" trace?

The only other thing I can think of is that transaction logs in SQL Server are sometimes referred to as "circular".  Of course...

Try this:

http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

I forgot to mention that if you are auditing logins (successfull) you might be able to put together a WAG.  Since most logins tend to be tied to one database...

Unless you've been running a trace I think you're pretty much out of luck with the sql server 2000 instances.

With 2005 the situation is a little better since you...

We aren't using mirroring, but for our log shipping targets I scripted out the maintenance jobs and created them on the target server, but disabled them.  In case we need...

Absolutely!  However, in a DW situation it isn't likely that it is a user transaction causing this, it is more likely that this is being caused by either the ETL...

I'm afraid that this one is going to be ugly.  There is no way to do this (that I know of) other than scripting out all your database objects in...

The problem is that application development and database design require two totally different skillsets and mindsets.  I've never met anyone who could effectively do both.  I've met a bunch of...

99% agree with Joe here.  I can always tell when a database has been coded by an application developer(s) they are universally terrible.  Keep them separate and design the database...

Call me a "purist" or whatever, I don't care.  This article is well written and this kind of stuff is fun and interesting (in limited quantities), but it is also...

Not a stupid question at all...  The answer however is debatable...

You don't.

In SQL 2k you could run

select serverproperty('LicenseType')

But...

I have had servers with over 1200 concurrent connections that work fine with the default value for worker threads.  Worker threads are a pooled resource and you might not even...

That's just the amount of time represented in the graph.  The value isn't directly editable, but if you right click on a counter and go to the General tab, if...

Using Unicode made no difference.  I just created a new column (Col2 nvarchar(24)) and ran the same queries (only the where clause changed to Col2) and got exactly the same...

I have pretty well settled on a standard (but evolving) list of questions that I have available.  However, unless I'm really grilling a senior level candidate I won't ask them all. ...