datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
How to dedicate a server to SQL Server?

Remove all applications and processes which are not related to SQL Server. Leave only the SQL Server, Windows operating system, networking applications and services running. Any other unrelated application may have negative impact on SQL Server performance.

Related article:

How to configure the hard disks for optimal performance?

 

Exam Prep 70-461
Exam 70-461