NIC settings for SQL 2005 and windows 2003?

All

Anyone know what is truly recommended for the NIC settings for SQL 2005 when
installed on Windows 2003?

Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set
to:

"Maximize date throughput for file sharing."

However, MSDN article states that the setting should be:

"Maximize data throughput for network applications."

Anyone have any definitive resource on actually what it should be set at?

Thank you

DBA DAB


.

Relevant Pages

  • NIC settings for SQL 2005 and Windows 2003?
    ... Anyone know what is truly recommended for the NIC settings for SQL 2005 when ... Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set ... "Maximize data throughput for network applications." ...
    (microsoft.public.sqlserver.tools)
  • Re: NIC settings for SQL 2005 and windows 2003?
    ... I have 3 SQL 2005 servers with AWE set and none ... Maximize data throughput for network applications (the option that ... Server automatically sets) ...
    (microsoft.public.sqlserver.connect)
  • Re: NIC settings for SQL 2005 and windows 2003?
    ... Maximize data throughput for network applications (the option that SQL ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.connect)
  • Re: select constant.field >> 10g float and double indicator
    ... > Mark C. Stock wrote: ... > I guess it uses some formatter which marks f as float. ... as BINARY_FLOAT and BINARY_DOUBLE data types in the 10g SQL Reference) ... instead of your original alias (of common usage but questionable etymology ...
    (comp.databases.oracle.misc)
  • Re: is this bad?
    ... >1) the ';' character must mark the end of a statement. ... >query sort by the first column then end the statement. ... You could remove all ';' marks from any SQL script and SQL ... Server will still happily execute it. ...
    (microsoft.public.sqlserver.programming)