Wednesday, March 7, 2012

changing Pagesize

Hi Experts,
What are the pros and cons in changing the pagesize to 16K?
Thanks!
Avi
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)
|||(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