table scripts, sample data and expected outputs would be VERY helpful here. And if you want good performance too please include index scripts and numbers of rows per table....

some people create database names that REQUIRE brackets (like 12345), so I would try something like this:

from [' + name + '].dbo.mytable ...

same goes for table names too, btw

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.