Update SQL Server table statistics for performance kick
There is plenty to learn about using auto and manual update commands and avoiding false statistics -- two of many techniques that will fine-tune SQL Server statistics and boost performance.
Configuring SQL Server memory settings
Configuring SQL Server memory settings is crucial. Find out configuration recommendations for optimal RAM amounts, how to enable AWE, the best number of gigabytes for maximum server memory and the differences between 32- and 64-bit platforms.
Tricks to increase SQL Server query performance
Discover several tricks to increase SQL Server query performance, such as avoiding system table locking by knowing when to use the CREATE TABLE vs. SELECT INTO command. You'll also find a stored procedure method that improves query response time, as opposed to linked server queries that can unexpectedly slow down system performance.
Configure SQL Server 2005 tempdb for performance
Processing once reserved for the SQL Server 2000 transaction logs has been moved in SQL Server 2005, making it essential that you properly configure your SQL Server 2005 tempdb database for performance.
SQL Server tempdb best practices increase performance
Making a few adjustments to the database settings can quickly and efficiently increase the performance of your SQL Server tempdb. Discover some best practices for tempdb, including physical file settings, storage array configurations, statistics update options and how to index temporary tables.