Viewing 15 posts - 2,551 through 2,565 (of 3,348 total)
Alexander Kuznetsov (10/19/2010)
Did you verify how method 4 works under high concurrency? Can we get somewhat incorrect totals?
Hi Alex,
Examples of incorrect rsults for this method have already been posted in...
October 19, 2010 at 11:06 am
dave.farmer (10/19/2010)
Does anyone know if there's a similar fast count method for views?
Only if they are indexed. Or if the relationships between the underlying tables are such that you can...
October 19, 2010 at 4:59 am
vk-kirov (10/19/2010)
Hugo Kornelis (10/19/2010)
With this additional information, I'd argue that options 2 and 4 are both correct.
And what do you think about counting uncommitted records, is it such a reliable...
October 19, 2010 at 4:37 am
vk-kirov (10/19/2010)
Hugo Kornelis (10/19/2010)
October 19, 2010 at 3:09 am
Bob Cullen-434885 (10/19/2010)
Maybe I'm missing...
October 19, 2010 at 2:25 am
I liked the question - allthough with the exception of option 1 on really large (or busy) tables, all options will be blindingly fast, and you won't run this type...
October 19, 2010 at 2:23 am
da-zero (10/18/2010)
Very nice question, definately learned something today.Got it wrong, because the BOL page about CREATE SCHEMA didn't mention anything about batches.
Ah well...
It doesn't really stand out, but the information...
October 18, 2010 at 2:51 am
deepak.a (10/15/2010)
Hugo Kornelis (10/15/2010)
deepak.a (10/15/2010)
(...)
in the above Quesries second one (Query 2) thrown on error while creating the index on computed...
October 15, 2010 at 6:07 am
tilew-948340 (10/15/2010)
The first time I tried the PERSISTED, I got the divide by zero error AFTER the "show table" wich does not seem to be, as I understand it,...
October 15, 2010 at 4:50 am
deepak.a (10/15/2010)
(...)
in the above Quesries second one (Query 2) thrown on error while creating the index on computed column but the...
October 15, 2010 at 4:48 am
henrik staun poulsen (10/15/2010)
<<If you want to index a computed column, you must persist it.
Are you sure?
I've just added a computed column to one of our big tables (+4 billion...
October 15, 2010 at 3:38 am
deepak.a (10/15/2010)
Hi Hugo which is the best pratice for Computed columns having PERSISTED or without having PERSISTED option or having an index for the computed columns
It depends.
For non-indexed computed...
October 15, 2010 at 3:12 am
Carlo Romagnano (10/15/2010)
I answered TRUE, but reading and re-reading both question and answer, I do not understand why it's false. Please Hugo, help us to understand.
:laugh: I seem to have...
October 15, 2010 at 3:07 am
tilew-948340 (10/14/2010)
Hardy21 (10/13/2010)
If computed columns are persisted in nature (e.g. QTot AS QF1 + QF2 PERSISTED,) then you receive the error after "Insert Zeroes" print statement and "SELECT *...
October 15, 2010 at 12:30 am
I totally agree with the other comments: good question. I wanted to add a comment about the effect of persisting the computed column (by adding the PERSISTED option or by...
October 14, 2010 at 12:52 am
Viewing 15 posts - 2,551 through 2,565 (of 3,348 total)