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

Sean Lange (2/16/2015)

---

TomThomson (2/16/2015)

---

Sean Lange (2/16/2015)

---

Great back to basics question. I am shocked at the response rate.

I am really surprised that so...

For starters, you should read this article to gain a better understanding of tempdb and what it's for.

https://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx

There are many opinions on tempdb, this is only one of them.

Are...