Viewing 15 posts - 286 through 300 (of 380 total)
bkirk (5/12/2010)
September 4, 2013 at 1:20 pm
I like this definition -
If updating a row does not affect other records (though it affects secondary indexes) the table is a heap.
Very short exact and clear.
This might have come...
August 27, 2013 at 12:56 pm
L' Eomot Inversé (8/27/2013)
Heap is one of those words with rather a lot of different meanings.
So heap, like orthogonal and obtuse, have many different meanings. Only one of...
August 27, 2013 at 12:25 pm
Hugo Kornelis (8/27/2013)
PHYData DBA (8/27/2013)
Lot of words just to say C.... 😎
I think I managed to include almost all the words of each of the three definitions.
And that was no...
August 27, 2013 at 9:37 am
Hugo Kornelis (8/27/2013)
PHYData DBA (8/27/2013)
a: non-redundant, non-overlapping, or irrelevant.
b: can be used without consideration...
August 27, 2013 at 9:17 am
Hugo Kornelis (8/27/2013)
PHYData DBA (8/27/2013)
August 27, 2013 at 7:34 am
Hugo Kornelis (8/27/2013)
PHYData DBA (8/27/2013)
The two are orthogonal. The link you include is unrelated to what "heap" in a relational database means.
Orthogonal.... That is one heap of a word Hugo......
August 27, 2013 at 7:20 am
L' Eomot Inversé (8/27/2013)
August 27, 2013 at 7:16 am
Nice easy question... I always wondered why you can have a Primary Key on a heap and its still a heap if there is no clustered index on the PK....
August 27, 2013 at 7:06 am
Placing any part of our crucial Infrastructure on the public internet is begging for them to be hacked, destroyed, or owned over that connection.
Security is cheap and easy when compared...
August 27, 2013 at 6:54 am
David Lean (8/27/2013)
August 27, 2013 at 6:45 am
L' Eomot Inversé (8/26/2013)
August 26, 2013 at 10:15 am
Nice easy Monday question. Why I have yet to convert code to use table variables.
August 26, 2013 at 9:31 am
2. If there are duplicate records and they all have the same score, then remove all duplicates except one, preferably the one with the most data in the row.
If you...
August 26, 2013 at 9:15 am
twin.devil (8/7/2013)
Thanks for the comments guys....Actually this was a real time issue, when people just write queries in a hurry and forget to set the proper alias. 😎
This would have...
August 12, 2013 at 7:05 am
Viewing 15 posts - 286 through 300 (of 380 total)