Top 10 steps to optimize data access in SQL Server. Part II (Re-factor TSQLs and apply best practices)

In this article, we are going to focus on writing or refactoring the data access codes using the best practices. But, before we start playing the game, we need to prepare the ground first. So let’s do the groundwork at this very next step:

Using Server Side Traces for Dynamic Performance Evaluation

This article describes a method of gathering and analyzing performance data using SQL Trace.

Performance Improvement: Understanding

This article will cover the core understanding of the performance conversation

Performance Improvement: Understanding

I'm going to try to lay out some general guidelines for performance improvement through improving understanding about what performance is, how to measure it, and finally solutions to common problems. This article will cover the core understanding of the performance conversation.

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.

Indexes

I/O Requests Taking Longer Than 15 Seconds To Complete

This article describes the warning "SQL Server has encountered n occurrence(s) of I/O requests taking longer than 15 seconds to complete on file <filename> in database <dbname>".

Theoretical Performance Issue Handling

Theoretical performance issue handling or handling theoretical performance issues from new author R. C. van Dijk.

Disk Partitiona Alignment Best Practices for SQL Server

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.

Twenty tips to write a good stored procedure

This article will provide some useful information to write a SP. I have emphasized on performance.