TheSQLGuru (4/23/2013)

---

Abu Dina (4/22/2013)

---

Record linkage.

How else would you do this if you want looks for duplicates...

Record linkage.

How else would you do this if you want looks for duplicates where

forename, surname,...

Lowell (4/22/2013)

---

your key types, being huge varbinarys, are preventing you from indexing; that's going to require a table scan.

is that a default varbinary size that someone/some application imposed? can you...

Salam, keefak?

You need to change your database collation. I did this on a test database and changed collation to Arabic_100_CI_AS but you may want to choose another collation depending on...

Lynn Pettis (4/18/2013)

---

Ananth@Sql (4/18/2013)

---

Thank you Dina

Your Explanation And presentation Makes Me Clear Of This Question.

And for a clarification tell Me...

It came down to the number of pages used by the index (fewer pages = less IO)

The top row is the clustsred index, the bottom row is the non clustered...

To illustrate this I did this simple test where I did a count(*) on a table (34 million records) with just a clustsred index (picture 1), I then created a...

Recently I've been doing lots of work on large data sets, wide tables (20+ columns) with mixture of Unicode and non-Unicode data types and IO becomes a real issue when...

Is this what you're after?!

Your computed column is calling a CLR implementation of the DoubleMetaphone phonetic algorithm. This isn't a SQL error as such.

What's the word(s) it's failing on?

Long shot but if I've understood this correctly, you don't want error in your tasks to bubble up to the sequence container?

If that's the case then why not add an...

Is restrciting SQL Server to 1 core really going to help performance?!

Long shot but what's the value for Max Degree of Parallelism set to? if it's still set to the default of 0 I would go with the MS recommendation of...

Maybe something like this? (used Jeff Moden's string splitter code below)

CREATE TABLE dbo.SSCHelp (RecordID INT, Column1 VARCHAR(50), Column2 VARCHAR(50), Column3 VARCHAR(50), Column4 VARCHAR(50), Column5 VARCHAR(50), Column6 VARCHAR(50))

;WITH SSC_CTE (RecordID,...

Apologies if the following is no good for you but have you tried using Adam Machanic's sp_WhoIsActive? http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

If you're able to trigger the action that runs some of the slow...