well, consider it as if you were to write the from part in a (long) single line

In English, we read it from left to right, correct ?

Hence a left...

I'm glad SSC republished your fine article, Gianluca.

Nice work, great descussions.

did you try :

, CASE WHEN ss.enabled IS NOT NULL THEN 'Schedule is enabled'

...

please check out the procedure described at msdn: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005 : http://msdn.microsoft.com/en-us/library/ms143799%28v=sql.90%29.aspx

As documented in BOL: TRUNCATE TABLE (Transact-SQL)

Restrictions

You cannot use TRUNCATE TABLE on tables that:

Are referenced by a FOREIGN KEY constraint. (You can truncate a table that...

Tested it from home using SSMS2008R2 (sp2): Works like a charm 🙂

Now to get our company network admins to open the required port :crazy:

ref:Guidelines for Connecting to Windows...

What data type did you define the column you are refering to ?

/* Example using DateTime data type */

Select DATEADD(HH, datediff(HH, 0, getdate()) - 1, 0) FromHH

...

why are you storing numeric values in a varchar column. As experienced, this will get you in troubles.

( in most cases because of formatting issues or just because someone put...

How about this list:

What's New (SQL Server 2008) http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.100%29.aspx

What's New (SQL Server 2008 R2) http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.105%29.aspx

What's New in SQL Server 2012 http://msdn.microsoft.com/en-us/library/bb500435.aspx

I would examine the execution plan as a first step.

You can export it to a .sqlplan file if you want to, and add it as an attachment to your forum...

Tested your script at my slow box:

CPU(ms): 102009 Logical Reads: 10002259 Elapsed(ms): ...

First of all:

Get some understanding of what a deadlock is !

- http://msdn.microsoft.com/en-us/library/ms178104%28v=sql.105%29.aspx

tech art. on "How to resolve a deadlock"

- http://support.microsoft.com/kb/832524

The above articles may get you started with the...

You could also just fix the port number of your production instance.

It shouldn't change that much, unless someone just didn't pay attention to the port number the installed the instance.

Must...

It took me some time to crawl back into working position after reading this finding.

Completely astonished by the simplicity of the solution.

Huge thank you for notifying and publishing another...

Since your query doesn't return any columns of table mcpITEMTASKS, I would certainly remove the update lock !

hence ... all your deadlock problems for this query case will vanish !

The...