Hi all,

How can i set buffer on Sql server 2000 which is installed on windows 2000 advanced server,Now it's database size is 4 GB.How can i improve it's performance without split the database.Any one help me plz.Pla tell me the relation between Sql And Windows.How It depend On windows Os.

Plz help me

Pla tell me the relation between Sql And Windows.How It depend On windows Os.
SQL is a product and vendor LANGUAGE for DBMS access.
The SQL/Sever-2000 is a Microsoft product, implementing SQL, and has a ton
of Microsoft specific 'features'. Suggest you get the SQL/Server manual for
guidelines and operational considerations.