Viewing 6 posts - 1 through 6 (of 6 total)
But why does the table allocation 'double' when adding a clustered index?
The only explanation I can think of, is that SQL server has the information 'twice' in the database:
- ones...
December 24, 2012 at 7:07 am
It would be nice that MSSQL tables would 'be' clustered or non clustered, but in fact they 'are' heaps with an optional 'clustered index' added to then.
Removing the clustered index,...
December 24, 2012 at 6:35 am
- That's using NTFS mounting points a presume?
May 4, 2011 at 5:19 am
Of course - thanks for mentioning this (sometimes one types faster then on thinks :-P)
May 4, 2011 at 1:54 am
Why not just 'create' the G: drive?
- ex: subst g: <anypath>
Then one does not have to run the SQL in Single User mode and such....
May 4, 2011 at 12:52 am
Hmm, I probebly have some setting different, because when I only 'click' the link nothing happens....
I need to press CTRL in order te actually click the link.
So it looks like...
April 6, 2010 at 12:54 am
Viewing 6 posts - 1 through 6 (of 6 total)