Wednesday, March 7, 2012

changing Pagesize

Hi Experts,
What are the pros and cons in changing the pagesize to 16K?
Thanks!
AviYou can't change the page size in SQL Server 2000 - it's fixed at 8k.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||(or in any other version of SQL Server)
Gert-Jan
Paul Ibison wrote:
> You can't change the page size in SQL Server 2000 - it's fixed at 8k.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment