Read committed snapshot is the read committed isolation level, implemented with row versions. It's not a separate isolation level like Snapshot is.

Hence you see Read Committed as the isolation level.

Have a read through this: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

Ok, so once you've taken the steps given in the message, try again.

Why are you suggesting restoring the database multiple times with the data and log files in different places each time? That's going to have the same effect as if you...

Why would they be 'much quicker' than temp tables? The reduced logging isn't going to come into play until there's a lot of data, same with the not needing to...

Maybe start by having a chat with your IT Security people and IT management around what policies you have around data access and related areas.

I still don't understand why you're putting brackets around DISTINCT as if it was a function. All that's going to do is confuse people who read the code.

Agreed, table variables can be terrible for performance. In fact, that's the main reason why multi-statement table-valued functions are often so bad (the last bullet point), because they use table...

Yup, that's RTM. You need to apply SP3 at least, preferably SP4 to this machine.

But SELECT @@VERSION, did u see the...

To start, turn traceflag 1204 off and use the 'newer' one that was introduced in SQL 2005 and which produces better deadlock graphs with more details. 1204 often doesn't produce...

Unfortunately, if you are splitting the partition and existing data belongs in the new partition, you're just going to have to accept that it will take time and you'll need...

Why the distinct when you have a group by, and why are you wrapping...

gentong.bocor (12/28/2014)

---

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Standard Edition on Windows NT...

You use SPLIT to create new partitions. If it's taking time, it implies that there's data in the table that has to be moved to the new partition. This is...

To seek, you need a predicate, something to seek for. A seek is defined as a navigation down the index tree to find a value. You do not have anything...