Sounds like the application is beginning a transaction and never committing/rolling back. Tracking down why is the next step.

If the activity from that particular application is low enough or you...

If you want it to be exactly a two, preceded by a comma, followed by a comma, followed by a number, then you'll want something like this:

CREATE TABLE #strings (some_string...

There are a couple reasons for this I've run across.

It's possible for really complicated queries to exceed the allowed nesting level for the XML returned.

For those you can use sys.dm_exec_text_query_plan...

Brandie Tarvin (4/19/2016)

Phil Parkin (4/19/2016)

Ed Wagner (4/19/2016)

Are...

Further on that, you could just configure the error output of the conversion task to redirect the rows on error. Just send that to a flat file or destination of...

Let's take a step back for sanity's sake 🙂

Is there actually a performance issue (e.g., queries taking longer on the new server than on the old server), or is the...

There have been a few such issues in 2012 and 2014. Here are some of them:

https://connect.microsoft.com/SQLServer/feedback/details/833842/checkdb-takes-considerably-longer-on-sql-2012-vs-sql-2008-r1-r2-with-many-partitions

https://support.microsoft.com/en-us/kb/3092702

https://support.microsoft.com/en-us/kb/3029825

http://www.sqlskills.com/blogs/paul/dbcc-checkdb-performance-and-computed-column-indexes/

What specific build are you on?

Cheers!

First things first: could you post the CREATE statement for the view referenced by the query (Stage_PLEMP_UniqueRecords_View)?

Having said that, it seems to me that it's mostly a matter of chance...

There many potential causes for the observed behavior, and I could only wildly speculate based on the information given (just one example would be queries that use parallelism regressing when...

By default you can only have 2 RDP sessions connected at a time. To allow more you would need to install the RD Session Host role service. You would also...

The LEFT JOIN Server.DB.dbo.unv_Employee very much looks like 4-part naming referencing a linked server. If so, that will likely be the remote rowset referred to.

Check to see what changes...

As indicated by Eric, you may be better off choosing a different approach entirely.

However, try schema-qualifying the reference to the SEQUENCE. There's been some screwiness around that: http://sqlblog.com/blogs/maria_zakourdaev/archive/2014/09/02/choosing-sequence-instead-of-identity-watch-your-step.aspx

Also, from https://support.microsoft.com/en-us/kb/2958429:

1347204...

I sometimes lapse into using "different than", but I usually use "different from". It's just more consistent, since I can say both "x is different from y" and "x differs...

Confirmed that the parsing there is quite inefficient; if the strings involved are long enough, then doing that parsing can certainly take many seconds.

Here's a quick demo showing how that...

The aspnet_profile table stores a couple ntext columns (*shudder*), so that's where the LOB reads come from.

Since the execution time is entirely CPU, and the number of reads are pretty...