Viewing 9 posts - 1 through 9 (of 9 total)
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...
May 23, 2009 at 11:11 pm
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.
May 22, 2009 at 10:53 pm
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...
May 21, 2009 at 7:32 pm
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...
May 18, 2009 at 8:50 pm
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...
April 27, 2009 at 3:48 am
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 😛
April 27, 2009 at 3:26 am
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...
April 26, 2009 at 11:11 pm
Great, thanks a lot. That looks like what I'm looking for 🙂
February 9, 2009 at 11:16 pm
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).
September 16, 2008 at 12:42 am