|
|
| |
SQL Server Articles
Tuning and Optimization
Index Optimization Tips
Created by: Alexander Chigrik
In this article, Alexander Chigrik shows you how you can improve the speed of your
queries by choosing the proper indexes, what kinds of indexes SQL Server supports
and what is the advantage and disadvantage of using indexes in a particular situation.
|
Some tips about tempdb database
Created by: Alexander Chigrik
When SQL Server is installed the setup program creates tempdb database. Tempdb is
a system database used by SQL Server to store temporary tables and temporary stored
procedures for sorting, subqueries and so on. In this article, Alexander Chigrik
provides you with some basic tips on how to improve performance of this vital
SQL Server component.
|
Optimizing SQL Server Performance by using File and Filegroups
Created by: Alexander Chigrik
Learn how to optimize SQL Server Performance using files and filegroups.
|
|
|
|
