It could be many things, but assuming you haven't forgotten to mention anything really important, one possibility is that the problem relates to one or more caches getting a bit...

Bruce W Cassidy (7/27/2009)

---

[font="Verdana"]I think the original author to the question is using the word "function" in the generic "block of functional code" sense, rather than the SQL function sense....

Matt Miller (7/27/2009)

---

Correct - even if it's not enforced currently (meaning - I have managed to get away with updating data through CLR functions), it's not within the design, and...

. (7/27/2009)

---

Hey Paul 🙂

Jeff already pointed out that it's not strictly correct, but I stand by my statement anyway. Just like string parsing or concatenation, if...

Hey Mark,

My initial thoughts are that (a) the application version is being compiled to more optimized code; or (b) because the external connection executes outside the hosted environment, it is...

This excellent short article by Jeff Moden will give you a good idea:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Thanks

I guess that makes sense in terms of the number of combinations available.

BTW congrats to the Springboks - they definitely deserved the win today, though we'll be back next week...

GilaMonster (7/26/2009)

---

Prices here range from R10 000 to R550, depending exactly what you ask for and what province you are in.

ITDPNDS may not be allowed in the US, but it...

Even if you break the view up, the window function (ROW_NUMBER) will prevent it from being indexed.

You can't use MIN, MAX, ROW_NUMBER = 1 or similar tricks with indexed views.

There...

klnsuddu (7/24/2009)

---

If I want install SQL Server 2005 Enterprise edition 64 bit on Windows server 2003 Enterprise edition 64 bit, for an insurance company application, How much minimum memory you...

Jeff Moden (7/26/2009)

---

It's more than a week's pay for a lot of folks. ...

Not strictly true - a CLR user-defined function can perform data access, including calling stored procedures.

The stored procedure code is subject to the same restrictions...

Yes they went up recently - it used to be $599.

Still, NZ$799 looks better as US$524 -...

Talking of number plates, a guy who used to work at my place had SQLDBA as his plate.

I quite fancy this one or this one

Anyone got any clever ideas for...

SQLZ (7/23/2009)

---

In this situation I would be inclined to put all of the data into one table and then partition the table with one partition for each month. Thereafter,...