Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Optimum Block Size for SQL Server 2003 Enterprise

Posted on 2004-09-17
2
Medium Priority
?
315 Views
Last Modified: 2006-11-17
Hello Techies:

We're building a IBM X445 SQL server. It has a 256 Meg Cache.  We will be using SQL Server 2003 Enterprise.  My question is:  What is the optimum block size for SQL Server 2003 enterprise?
0
Comment
Question by:sprysurfer
2 Comments
 
LVL 6

Expert Comment

by:mcp111
ID: 12086916
There is no SQL Server 2003. Is it SQL 2000?
0
 
LVL 8

Accepted Solution

by:
MartinCMS earned 2000 total points
ID: 12087257
Check out this site.... might be useful info for you concern...

http://www.ftponline.com/wss/2003_08/magazine/columns/sqlconnection/default_pf.aspx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question