I knew this day would come...Jeff's avatar has become self aware and is now gobbling up all replies to his posts.  soon it will...

my numbers come in marginally slower with a computed column than a matching "real" column in "forward matching".  Of course - I'm talking when BOTH columns are indexed.

meaning

Title like 'manager%'  --title is...

Well nothing obvious, or "low effort". 

That being said if you do this kind of stuff enough to justify the change in structure- you could look at using a computed...

That explains it - we have "EVIL TWINS" going on.  Two different products with the same acronym.

The "old" version of the product called MSDE is what's called Microsoft SQL DESKTOP...

Well - I find this syntax confusing - so let's talk about it for a minute.  Truncation in this case is the process of freeing up space in the physical...

Glad to be of help!

Reusing the accumulated values is a great idea.  Aggregate operations are a performance drag, so not doing them multiple times over would be encouraged

Keep in mind - MSDE = SQL2000 versus SQLExpress = SQL 2005.  There are also multiple "download points" for SQLExpress - you want to steer towards "SQLExpress with advanced services". ...

I was addressing your initial assessment that it was probably NOT a good idea to use a function (especially one that the OP wanted to return results) in a scenario...

not the same.  If you throw the one in up top - you're essentially saying - if the TOTAL for cause HC is 0 then don't divide by 0.  if...

Sounds to me like we got some categories with no data, or 0 in the benamt for all records.

Try putting this instead of the min(HcTot) -

Min(case when HCtot=0 then...

I'm not sure that those 3 are the ONLY requirements, which is why you're running into those struggles.

There's something about the nature of the operation needing to be able to be...

Here's why I don't think it's a fair test. By running it at a single size, with a single operation, and by using ONLY in an exclusionary way - I...

I'm using deterministic, because when you create that as a SQL UDF - SQL considers the UDF non-deterministic.  Try it and see.

SELECT

OBJECTPROPERTY(

Agreed as to accessing the base tables directly.  A function is overkill for this purpose.

And now - veering off-topic for a minute...

<off topic>

Michael - you only tested non-deterministic UDF's in your...

<quote>

Just this morning, our e-mail server went down. Was that an outage? An inconvenience yes. People were still able to work, they just had to use a device called a...