Viewing 7 posts - 16 through 22 (of 22 total)
Again thanks to both of you...
I don't know why but my mind simply discarded the possibilty of "Updates" making changes to indexes(pages). I was stuck in an Insert/Delete only mentality...
July 23, 2007 at 3:24 pm
I think Rubes is on to me... and I "kinda" understand his date example.
Rubes makes sense to me in that not only are inserts and deletes important at the ROW level,...
July 23, 2007 at 2:46 pm
Thanks but not better yet...
I understand that I "cannot" do such a thing on a heap, or for that matter on a clustered index either - I still specify things...
July 23, 2007 at 2:24 pm
Thanks again Noel - I just replied to you on another thread
But, still missing my point a bit. I understand the difference between...
July 23, 2007 at 2:05 pm
Thanks Noel,
I assume that since you did not differ with my initial assumptions that you believe them to be correct. What I meant by "Unique Keys" is what SQL Server...
July 23, 2007 at 1:59 pm
Thanks, but missing my point somewhat ...
Whatever it "is" (I know it's not a column but an index on a column), an object, whatever you wish to call it - my...
July 23, 2007 at 1:52 pm
How this relates to the real world is this...
1) No clustered Index = A Heap
2) Add some Non-clustered indexes to a table and you still have...
October 23, 2006 at 7:28 am
Viewing 7 posts - 16 through 22 (of 22 total)