Anything running on a computer consumes memory and CPU, and often I/O. This includes SSMS.

There's a couple different ways to do this, here's a quick and simple approach:

select ServerName, InstanceValues.value('(./@CLASSNAME)[1]', 'varchar(64)') AS ClassName,

InstanceValues.value('(PROPERTY[@NAME="Caption"]/VALUE)[1]', 'varchar(64)') AS Caption,...

The short answer: add ', type' to the Submenu XML statement:

for xml raw ('Submenu'), type

IF NOT EXISTS(SELECT * FROM Customer WHERE col1 = @x AND col2 = @y AND @col3 = @z)

BEGIN

-- do stuff

END

Backups occasionally fail or get corrupted by storage. Full backups do not break or clear the log chain. If last night's backup is not recoverable, you can use the prior...

In the bulk-logging recovery model, transaction log backups contain all data pages that were modified as a result of the transactions in the transaction log backup. (Yes, the full modified...

Ninja's_RGR'us (8/10/2011)

---

Eddie Wuerch (8/10/2011)

---

Having 512GB of memory lets me think you have a lot of CPUs in that box as well.

If you're seeing loads of CMEMTHREAD waits in SQL Server...

Having 512GB of memory lets me think you have a lot of CPUs in that box as well.

If you're seeing loads of CMEMTHREAD waits in SQL Server 2008 R2 on...

Simply put, one or more of the varchar values you are converting to datetime won't convert - it's just a case of bad data. A value like '1/1/10000' looks like...

A CXPACKET wait is experienced by a thread in a parallel query after it has finished its portion of the work, and is waiting for the other threads to complete...

You're on the right track.

Please see this post for some more info:

http://www.sqlservercentral.com/Forums/Topic1025419-1292-1.aspx#bm1025536

-Eddie

I'm just jumping in to stir stuff up 🙂

First, I'm goin g to agree with Kevin that an HP consultant is a nice way to spend money without getting results....

To answer some questions:

1. Win2008 will take care of the partition alignment (default = 1MB), so you're correct there. Nothing to mess with.

As for the GUID partitions, read the heck...

tfifield (6/30/2011)

---

Paul,

That one is bloody brilliant! It would never have occurred to me to use an OUTPUT clause from an UPDATE for an INSERT.

Remind me to buy you a...

sys.dm_db_task_space_usage

the space usage is only for tempdb, so any session with an entry here is consuming tempdb space.

Session_id corresponds to session_id in sys.dm_exec_connections and sys.dm_exec_sessions.