Qualify what the problem may be is the first step.

Did it just start? Is it some users, or all users? Is it some queries, or all queries? Is it...

If the databases are on the same server then the wizard will copy the structure and the data. Even on different servers you can use linked servers with the...

Start here:

http://www.sqlservercentral.com/articles/T-SQL/63681/

You need to remove the semi-colon

Add this to the bottom:

WHERE [A]++[C]+[D]+[F]+[W]+[IB]+[IC]+[ID]+[IF]+[P]+[NP] > 4

What fields are you using to determine that there is a duplicate?

The query is using Claims.*. Are all of these fields needed?

Could another field, like a datetime, be causing the...

Well, looking on MS's support site, and a few other sites, this is typically caused by a linked server, or, MSDTC.

Run this:

SELECT @@SERVERNAME

And this

SELECT * FROM sysservers

Does the result from...

There are a number of references to this error, all related to the use if linked servers and how SQL Server handles loopback calls.

http://sqlblog.com/blogs/linchi_shea/archive/2009/12/18/the-transact-sql-prime-directive-a-bad-example.aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/13b6fa12-13a2-41e1-a581-3295adbccf69/transaction-context-in-use-by-another-session

There are more, Google this.

The thing...

You do not need to have a linked server to use the import / export wizard.

And, for a larger table, I...

Can't imagine how on earth every insert could cause a page split with any thought in advance given to setting the proper fillfactor. How bizarre. But it would...

A primary key does not have to be a clustered index.

A clustered index does not have to be the primary key.

When you...

See

Grant Fritchey

The Scary DBA

Author of:

SQL Server Query Performance Tuning

and

SQL Server Execution Plans

These are available here:

http://www.red-gate.com/community/books/

Otherwise,...

Great post, BTW.

For starters, there is no magic bullet. You kinda sorta found something that alleviated the symptoms, but it did not fix the problem.

As a starting point, take a...

I did the last time this question was asked.

I can;t remember the error that was thrown when it hit 32768.

pietlinden (2/26/2015)

---

Task 1: Find all records that begin with 'THE '. Play with RIGHT() to strip it off.

use update query to remove...