That would be the case if I was actually doing what's happening in that example.

In practice other constraints on the datasets ensure that the number of reads is in the...

I tend to use them all the time, when calling from an application bitmasks provide a easy way to filter data without having to add new parameters.

E.g.

create procedure...

My understanding is that bitwise operations do not utilize indexes which limits their effectiveness.

Run the following code and the bitwise operation requires many more reads than the = operation (yes...

I think this is an interesting and useful example so long as you know enough to not use it as is in real life 🙂

The xml scripting with CTE is...

I keep all my ex workermates on close call on MSN for situations just like this (tho you are on that list for some reason too tho I don't think...

Let me scare you a little Paul and tell you that Vanders helped me out already. Good to see a TM guy dishing out advice tho 😛

It doesn't appear to be that. I can rerun the query many times in either QA or profiler and still get the same results (consistantly fast or slow)

For now I've...

Great, thanks a lot. That looks like what I'm looking for 🙂

this is super handy.

does anyone know if i can truncate these tables at any time safely (for example before running a test load for example).