Configuring SQL server files for best performance

by Joe Hunter 30. March 2011 22:16

Some guidelines that may help to improve performance in SQL server by reducing disk contention:

- Put data files on separate drive from OS files

- Put transaction log files on a separate drive from data files, reduces contention between data and transaction log files

And if at all possible put tempdb on a separate drive.

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008Reference is here Now...how to put this into a stored procedure? Exporting data from SQL Server to Access using a Linked ServerSo I found out the hard way that to export data from SQL Server to Microsoft Access requires that th...Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servername