Well I did test them on my laptop. Chris's ran in 13 & 15 seconds, while Jeff's ran in 5.1 and 5.2 seconds.

Actually, Plan Guides might be able to do this. Unfortunately, I missed that session at PASS.

I am not sure, but full-text indexing might be what you are looking for.

Well..., there's Grant. But I don't think that he actually broke the skin.

😀

Great tips, Nicholas! This was my first year too, but I have been to many conferences and was pretty savvy about the tricks.

I will say that a good Laptop/Backpack...

Something like this:

DIM s as string

s = ""

If Commodity1=True then s = s + "Commodity1,"

If Commodity2=True then s = s + "Commodity2,"

...

If Commodity20=True then s = s + "Commodity20,"

s =...

Tony:

I see some UDF's in the Matrix workbench: They're not going to work on SQL Server 7.0. 🙂

Glad we could help.

Chris:

I just notice that you are putting "and" after your Hundreds, like this:

Technically, this is incorrect,...

Jeff:

Your function is called "NumberToWords" but you are calling "MoneyToWords", is this just a typo or am I missing something?

Jeff Moden (11/27/2008)

---

I asked only because my machine is a bit old (but I still love it!) and any timing differences are pretty well magnified. The 30k example you...

drjdewhurst (11/27/2008)

---

Thanks for your ideas guys.

In the end I simply ordered the table by the combined differences between the target latitude and longitude and the latitude and longitudes in the...

Try this:

Select * From INFORMATION_SCHEMA.ROUTINE_COLUMNS

I mean the...

Just a question: It looks like SWITCH will only work here for IDENTITY changes. Are there any other column changes that it will work for?