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...

please provide the query plan(s).

My guess is the index is being scanned, so the updlock may indeed block it all.

p.s. are you sure this is a SQL2012 instance ? The...

an index sonsists of two parts :

a keys section and an included-columns section.

Books online shows how many columns or bytes each can have.

http://msdn.microsoft.com/en-us/library/ms143432.aspx ( see "Columns per index key")

This ref...

not only my signature 😉

In general: my...