timscronin (4/26/2013)

---

I need to create a solution for a mutl instance (needed by 3rd party app) 2012 failover solution. I will have 2 physical high end servers (128 gig...

I have seen quite a few refactors addressing huge logical reads from nested loops on lots of rows (bad estimates usually the root cause) changed to scans and hashes taking...

That's just FUBAR right there!! :w00t:

That's an awesome discussion of some very deep scalability issues!! I look forward to the blog post!

allmhuran (4/24/2013)

---

My apologies, I have been off the forum for a while...

Head pulled, and I have you on my list of posters who really know their SQL engine! 🙂

WOW! That's quite a statement!! :crying:

Abu Dina (4/23/2013)

---

Thanks Kevin. I wil try the join hints and report back

Here is one of the CLR TVFs I use to score Email addresses:

using System;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.Net;

using System.Data.SqlClient;

using...

Abu Dina (4/23/2013)

---

TheSQLGuru (4/23/2013)

---

Abu Dina (4/22/2013)

---

Record linkage.

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

Abu Dina (4/22/2013)

---

Record linkage.

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

Sanz (4/15/2013)

---

I have a dedicated Server for SQL Server. SQL Server runs on SQL Server 2008 Standard edition with SP2 applied. The machine is a 64 bit windows machine with...

Table variable? User Defined Function? Up-to-date stats? CTE(s)? Improper datatypes? Incomplete join or valid join that has Cartesian? UDFs and Cartesians are my best guess. Will need to...

I am glad you saw this one Paul! I didn't think anyone else could give as clear of a description of why the OP was getting the observed behavior.

You REALLY CANNOT do clustering or "always on" based on some forum posts. PLEASE do yourself a favor and get some professional help!!

I concur Craig. Rigorous testing will ABSOLUTELY prove that the OR stuff is MUCH worse performing than a dynamic sql solution over the full variety of input values. ...