Viewing 9 posts - 1 through 9 (of 9 total)
Comeon! Anybody played with this option?
November 29, 2013 at 1:08 am
Lynn Pettis (4/6/2012)
GilaMonster (4/6/2012)
den_sidr (4/6/2012)
hi Lynn,are you sure that any nonclusted indexes are engaged in this process consequently?any links/docs?
Yes, absolutely sure.
All nonclustered indexes contain the clustered index key as a...
April 6, 2012 at 8:03 am
GilaMonster (4/6/2012)
Yes.And all nonclustered indexes contain the clustered index key.
thank you GilaMonster, i have checked that table - two nonclustered indexes(~15GB) have [date] field (based on which the clustered index...
April 6, 2012 at 3:55 am
GilaMonster (4/6/2012)
den_sidr (4/6/2012)
hi Lynn,are you sure that any nonclusted indexes are engaged in this process consequently?any links/docs?
Yes, absolutely sure.
All nonclustered indexes contain the clustered index key as a row locator....
April 6, 2012 at 3:34 am
SQLRNNR (4/5/2012)
In addition to what Lynn said, yes your disk fragmentation can play a part in that.
hi SQLRNNR, can you give me the tip how to check it .i am...
April 6, 2012 at 3:24 am
Lynn Pettis (4/5/2012)
And if you dropped the existing clustered index first, that also would have caused any currently defined nonclustered indexes to be rebuilt as well.
hi Lynn,
are you sure that...
April 6, 2012 at 3:05 am
Dev (12/3/2011)
December 6, 2011 at 5:04 am
Grant Fritchey (12/4/2011)
December 6, 2011 at 5:01 am
Jeff Moden (12/3/2011)
den_sidr (12/2/2011)
is it possible to map estimated plan (its parts) to currently running query?
for example i have a simple query has been running for...
December 6, 2011 at 4:57 am
Viewing 9 posts - 1 through 9 (of 9 total)