Check BOL for sys.dm_db_task_space_usage. It displays tempdb usage by spid (session_id).

Once you get the session_id of some of the worst offenders, you can join up to sys.dm_exec_sessions, sys.dm_exec_requests, and/or...

Why bother with CR+LF at all? This isn't VB. Just leave them in the string an be done with it. This works with many targets:

SELECT @body =...

http://www.microsoft.com/sql/howtobuy/licensing.mspx

If a physical processor is available to the OS on which SQL Server is installed, then you must license that processor, regardless of any SQL Server service-specific affinity settings.

You're mixing the two styles of CASE:

CASE column|@val|const

WHEN column|@val|const THEN column|@val|const

WHEN column|@val|const THEN column|@val|const

ELSE column|@val|const

...

Additional ammo for those still deciding if they can/will go is the early-bird discount for the following year: Once you attend a summit, you can register for the next...

The SQL 2005 service pack installs are cluster-aware, just like the base installations. Run the SP on the active node, and it will detect everything. If you supply...

I think the only thing you can do is to add [font="Courier New"]AND Status <> 1[/font] to the WHERE clause, so you don't re-update rows that already have the value...

That price looks like a one-CPU Enterprise+SA processor license. If you think you may ever upgrade to SQL 2008, pick up SA.

We are only going to need about 25...

9:1:4505200

database:file:page

Database 9 (select * from sys.databases where database_id = 9)

File 1 (select * from master.sys.master_files where database_id = 9 and file_id = 1)

Page 4505200

To see what object (table) uses that...

We picked up Red Gate's SQL MultiScript tool for the data team (actually, we got the whole toolbelt, but this was a big reason for it), and cleaning out logins...

Log-ship the database to the new LUN:

1. Restore a recent backup on the server as a database with a different name.

2. Restore all log backups.

3. Add a step to your...

Or, better yet, just write your backup job to walk through sys.databases, and backup every online user database.

In SQL Server Management Studio:

Tools -> Options -> Environment -> Keyboard

-Eddie

Why the requirement to to make connection property changes so easily? Once the instance is virtualized, the connection string doesn't change.

If your virtual server name is VirtServ1, then the...

I would like know where you read that log shipping is being phased out, because either somebody needs to be corrected in a big way, or you missed the point...