What's the HASH JOIN hint for? ...

Yes.

One of my favourite QODs was the one that executed a procedure named GO.

Did you receive an error message when trying to run it?

Nawar.Tabaa (3/24/2010)

---

I prefer to implement the contents retrieval directly from SQL Server. Can you advise me of the best practice for acheiving this, whether to load source code as...

Yes, in some circumstances.

No, because you never know when someone else might find the question or discussion interesting and make another contribution.

Hey Wayne, nice...

The Dixie Flatline (3/24/2010)

---

Paul, I have to ask just when is Windows collation used? I would assume that since all the work is being done inside SQL that some...

Strictly speaking, this is not a parameter-sniffing issue. SQL Server picks a bad plan on this occasion due to a lack of accurate statistics. This results in SQL...

Everything anyone ever needs to know about compilation and recompilation:

http://msdn.microsoft.com/en-us/library/cc966425.aspx#XSLTsection127121120120

That link will take you to the section on statement-level recompilation.

Sticking with the design presented, here is one possible method:

CREATE TABLE #Sample

(

patient_no ...

Collation is so important when coding a routine that does a large number of comparisons or sorts, and not just because of the potential for errors as shown in this...

Hi Barry!

Thanks for taking the time to fix my solution Peter 🙂

I have another chance to look at this, and find the following interesting:

Setup:

CREATE TABLE #Table1

...

Glad...

Not a massive surprise, since you are updating the prospects_copy table with my code.

I provided the code as a...