I would not assume that poor code scales linearly.  With double the users or data, do you need another 2 or 32 servers? 

If you want to just add another server to...

Perhaps another process is making the connections? 

Maybe CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID))) will work.  If not, try assigning the value to a local variable first or printing it out before passing it to the procedure.  Something in http://technet.microsoft.com/en-us/library/ms175575.aspx might help. ...

There is always a bottleneck.  Waiting on resources is normal in any process that is not blocked.  The root blocker can be idle, running, or waiting on a resource and not be blocked.  The...

I'm working on it in my spare time - which is short today. 

Much of the code has been hacked from stuff I've found here on sqlservercentral.  It would only be fair for me to share it; however, I will need to check with my boss. 

I've...

The process is not really blocking itself - one thread of the process is blocking another thread of the same process.  There will be one thread that is either the...

In the last case you are ordering by the "numbers" 1 and 2, 2 and 1, or 2 and 1.  These numbers are not aliases to columns, just values.  For...

In the last example, rather than trying to alter the ORDER BY syntax with one case statement, use a case statement for each element in the ORDER BY

ORDER BY

    CASE @OrderBy...

Out of curiosity, would a backup-restore (using a disk backup for speed) defrag a db? 

Sometimes the only information available to identify the source of the process will be the net_address (MAC).  As a last resort, it can be used to track down the network card...

The IO_COMPLETION is about 10% and 40% of the wait in the two ten minute durations.  The CXPACKET and PAGELATCH_SH are about 75% and 55% in the same two durations.  Are the...

Also, everything we perceive is basically electromagnetic in nature.  If EM fields behave in such a way to appear to compress and slow down, then the human machine based on...

I was very curious about inertia as a kid.  The old SF books by E.E. “Doc” Smith were a fun read.  I believe Feynman calculated the inertia of a...

I think the point is that you can't use a variable or expression to specify the column.  You also can't use a variable to specify syntax or table names.  You...