MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
Administering  
Comparison  
General  
Know How  
Replication  
Tuning  
Undocumented  
UDF  
SQL 6.5  
FAQ  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 

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.


 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2010 Bits on the Wire, Inc