When you run DBCC CHECKDB it creates a hidden database snapshot. The strange DBID may just be the database snapshot that was created by DBCC CHECKDB.

Spatio - I would use Jeff Moden's function for splitting strings:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

You would then have each "row" broken down and then you can write a statement to determine if the value...

Sounds like you need a baseline of the server and compare it after you add a new database. I would recommend you use Glenn Berry's DMV scripts to create that...

Are you in a virtualized environment or bare metal?

You can use the installation media too in the same way.

Under Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Installation Center

Select Maintenance -> Edition Upgrade

Are you just curious how your system is performing? Taking a baseline? Or is an issue you are dealing with and need help with? If you are having some performance...

Donald as long as you don't break the back chain you can restore to a point in time. So, once you restore Friday's backup you can continue that chain by...

If I understand your question you are asking if you have finished a restore, but a full (or diff) hasn't completed yet can you restore the database to a point...

Please read the link again on posting questions to the forum. There still isn't enough data here. We need actual CREATE TABLE and INSERT ...VALUES() type statements.

With that being said...

Is this "extra join" causing a performance issue? If not, I would recommend that you keep the table structure you have. If this is a new system load it with...

Strange question, but how accurate do you have to be? Can you simply use sp_WhoIsActive and capture the results, to a table, every x seconds/minutes? If you captured the results...

That query is a mess and hard to read for sure, but is the question why is a certain record not getting returned? If so, I would start with the...

Check out this script from Kendra Little:

http://www.littlekendra.com/2009/08/27/whos-using-all-that-space-in-tempdb-and-whats-their-plan/

Also, check out this post too:

http://www.sqlservercentral.com/Forums/Topic1078769-391-1.aspx

It should help you find who is behind the growth in tempdb

Here is a good site with the releases and links for the releases.

http://sqlserverbuilds.blogspot.com/

Also, if you subscribe to either Aaron Bertrand or Glenn Berry's blogs they send out the latest...