RSS Feeds

Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

SQL Azure

Developer

General DBA

ASP.NET / ADO.NET

SQL Azure

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...

SQL Server Destination remote server error

Setting Up Data And Log Files For SQL Server

Will Check Constraints Improve Database Performance?

Latest SQL Server Performance Tuning Articles

SQL Server Logical Reads – What do they really tell us?
SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading…

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion
Loading EBCDIC data into SQL Server is not a well documented process - this article provides a very useful guide to optimizing the performance of this operation.

Configuring the Maximum Degree of Parallelism
How to configure settings to limit the number of processors used in parallel query execution

Identify Missing Indexes Using SQL Server DMVs
This article explains how the Dynamic Management Views (DMV) in SQL Server can be used to identify missing indexes on a table

Obtaining Index Usage Information
This article shows how the sys.dm_db_index_usage_stats DMV can be used to tune your indexes, and maximize the performance of your database

Max Degree of Parallelism
This article discusses how you can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution

How to Create a Comma Separated Delimited Text File Using SQL Server 2008
This artilce shows how to generate a comma separated delimited text file using SQL Server

Creating Your Own Custom Data Collections
This article describes how to install the components that make up the Management Data Warehouse (MDW)

Analyze and Fix Index Fragmentation in SQL Server 2008
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation

Monitoring Index Fragmentation
The article describes a real world experience on managing index fragmentation

View all articles for this topic