Default page size 8K

[DBAWinnipeg]

Hey everyone

is there ANYWAY possible to hack SQL Server 2000 to either increase or decrease the 8K page size.

Just trying to settle a bet so even if there is any reg hacks or ANYTHING at all (best practice or not)

Thanks



Thanks in advance!!!

Colin in da 'Peg

 

[JayKusch]

Nope! No Way!


Thanks

J. Kusch

 

[mrdenny]

Nope, the 8k page size is locked. It's not a setting you can adjust.

It's tied to the 32k cluster size that SQL Server uses.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)