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
#1571275
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
#1571268
- That's using NTFS mounting points a presume?
May 4, 2011 at 5:19 am
#1319645
Of course - thanks for mentioning this (sometimes one types faster then on thinks :-P)
May 4, 2011 at 1:54 am
#1319576
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
#1319562
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
#1146308