Out of sheer curiousity I mucked with the build a bit to see if the substring or the crossapply was the determinator.

The substring is the faster function. I didn't...

(450 row(s) affected)

Table '#Tally______________________________________________________________________________________________________________000000000193'. Scan count 450, logical reads 1350, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table '#tmp________________________________________________________________________________________________________________000000000194'. Scan...

Hm, nice alternative Gus, thanks. Never thought about using Cross Apply like that against Tally.

I used the #Tally to make the code directly consumable. 🙂

I'd originally avoided the substring...

Can you post the two sqlplans? My guess is something went awry in the predicate selection or something similar.

Brandie Tarvin (2/8/2011)

---

Okay, I have to ask. Did you...

:laugh: The fact that it's usually silly or the fact that it doesn't ever seem to be the same one 3 weeks in...

Jack Corbett (2/8/2011)

---

Ferguson (2/8/2011)

---

I am not saying I would not consider you, but I will try to answer your perhaps rhetorical question.

Someone who as a young adult decides to put...

autoexcrement (2/7/2011)

---

Craig, do you think this set of SSMS tools would be appropriate? It claims to be able to autogenerate the CRUD wrappers you suggested. Seems like it will be...

Same parameters?

Ferguson (2/7/2011)

---

Summary:

Senior DBA required for physical administration of very large databases (>1TB) in both OLTP and OLAP environments on Microsoft SQL Server. The position’s primary responsibilities will be...

Michael Valentine Jones (2/7/2011)

---

You say this:

"Senior DBA required for physical administration of very large databases (>1TB) in both OLTP and OLAP environments on Microsoft SQL Server. "

OLAP may mean that...

Sounds like another table as a FK assigned against this one.

You're in SQL 2k8... hit up BOL and review the MERGE command.

SanDroid (2/7/2011)

---

Steve Jones - SSC Editor (2/7/2011)

---

I never said I would fire someone that asked for a raise twice. You totally misread that. I said that if you were soliciting...

To throw a little fuel on the fire...

Everyone embellishes. Everyone stretches. Why? Because noone rational wants to take the position 'below' them, with less pay, less benefits,...