SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tag Performance Tuning Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (121)     .Net (2)     data flow Task (1)     partition alignment (1)    
T-SQL (75)     Availability (2)     Database Snapshots (1)     procedural programming (1)    
SQL Server 2005 (30)     Blogs (2)     Editorial - MP3 (1)     procedure cache (1)    
Administration (28)     cursors (2)     English Query (1)     Reporting Services (SSRS) (1)    
Miscellaneous (22)     Data Types (2)     Extended Events (1)     Resource Governor (1)    
Indexing (18)     Data Warehousing (2)     Fetch (1)     SAN (1)    
Configuring (15)     Database Weekly (2)     Foreign Key (1)     Search (1)    
Programming (15)     deadlock (2)     HP EVA (1)     Set Based (1)    
Basic Querying (12)     Distributed Queries (2)     Index Management (1)     Shrinking Databases (1)    
Hardware (10)     Editorial (2)     index seek (1)     SP writing tips (1)    
Stored Procedures (10)     I/O (2)     Index Useage (1)     SQL Puzzles (1)    
SQL Server 6.5 (9)     Indexed Views (2)     Index Utilization (1)     SQL Server (1)    
Advanced Querying (8)     Installation (2)     Indexes (1)     SQL Update (1)    
Monitoring (8)     Integration Services (SSIS) (2)     IP Addresses (1)     SQLServerCentral (1)    
SQL Server 2008 (8)     Memory Tuning (2)     IPv4 Addresses (1)     SS2K5 - XML (1)    
ADO (7)     OpenXML (2)     Isolation Levels (1)     Star Schemas (1)    
Database Design (7)     Profiler (2)     Linked Server (1)     Storage (1)    
DMV (7)     Storage Management (2)     Lock Pages in Memory (1)     SUBSTRING (1)    
Strategies (7)     Triggers (2)     Loop (1)     System Monitor (1)    
Backup and Recovery (5)     Troubleshooting (2)     Memory Management (1)     Table Hints (1)    
Basics (4)     ASP (1)     Name value pair (1)     Table Scan (1)    
Replication (4)     Auditing (1)     Naming Standards (1)     Test Data (1)    
Visual Basic 6 (4)     Best Practices (1)     News (1)     UDT (1)    
XML (4)     Blocking (1)     OLAP Server (1)     UpdateGrams (1)    
Analysis Services (SSAS) (3)     Cached Execution Plan (1)     Other (1)     WHERE (1)    
DTS (3)     Case Studies (1)     paging (1)     While Loop (1)    
Execution Plan (3)     Change Data Capture (CDC) (1)     Parameterized Queries (1)     XEvents (1)    
Security (3)     Compression (1)     partition (1)     XSL (1)    
User Defined Function (UDF) (3)    

Search for any content tagged Performance Tuning

   Items 1 to 20 of 298    Next 20 >>
 

An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.  Read more...
By Alok Dwivedi 2009/11/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 1 read

The Rich Rewards of Tuning SQL

The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.  Read more...
By Tony Davis 2009/11/02 | Source: SQLServerCentral.com | Category: Editorial
Rating: |  Discuss |  Briefcase | 60 reads

Poor Man's Enterprise Feature - Lock Pages in Memory

Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.  Read more...
By Amit Singh 2009/10/15 | Source: SQLServerCentral.com | Category: Lock Pages in Memory
Rating: |  Discuss |  Briefcase | 6,365 reads

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...   Read more...
By Additional Articles 2009/09/25 | Source: SQL-Server-Pro | Category: T-SQL
Rating:  Rate this |  Briefcase | 8,038 reads

Tuning the Performance of Change Data Capture in SQL Server 2008

Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.  Read more...
Rating:  Rate this |  Briefcase | 1,570 reads

Understanding Scans And Seeks

Whether a query uses Scan or Seek can have a big impact on the cost of excuting that query. This article examines when each is used and which is optimal.  Read more...
Rating:  Rate this |  Briefcase | 5,155 reads

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 3,180 reads

EVA Partition Alignment

Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?  Read more...
By Additional Articles 2009/09/09 | Source: SQL-Server-Pro | Category: Hardware
Rating:  Rate this |  Briefcase | 1,945 reads

Parameterized Queries

Previous T-SQL best practices articles have discussed different coding styles that led to slow and fast query executions, and ways to minimize cached plans. This article will be an extension on those concepts, focusing on how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.  Read more...
By Additional Articles 2009/09/03 | Source: Database Journal | Category: T-SQL
Rating:  Rate this |  Briefcase | 4,973 reads

Theoretical Performance Issue Handling

Theoretical performance issue handling or handling theoretical performance issues from new author R. C. van Dijk.  Read more...
By R. C. van Dijk 2009/08/24 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 4,420 reads

Back to basics: Optimizing SQL Server indexes

When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.  Read more...
By Additional Articles 2009/08/21 | Source: SearchSQLServer | Category: Indexing
Rating:  Rate this |  Briefcase | 6,075 reads

Storing IPv4 Addresses for Performance

An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries  Read more...
By Jean-Sebastien Carle 2009/08/19 | Source: SQLServerCentral.com | Category: IPv4 Addresses
Rating: |  Discuss |  Briefcase | 7,220 reads

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.  Read more...
By Additional Articles 2009/08/18 | Source: Microsoft MSDN | Category: Performance Tuning
Rating:  Rate this |  Briefcase | 2,689 reads

Twenty tips to write a good stored procedure

This article will provide some useful information to write a SP. I have emphasized on performance.  Read more...
By Arup Chakraborty 2009/08/10 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 36,550 reads

SQL Server 2008 Analysis Services Performance Guide

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.   Read more...
By Additional Articles 2009/08/04 | Source: Microsoft MSDN | Category: Analysis Services (SSAS)
Rating: (not yet rated)  Rate this |  Briefcase | 1,990 reads

Troubleshooting Performance Problems in SQL Server 2008

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...
By Additional Articles 2009/07/31 | Source: TechNet | Category: Troubleshooting
Rating:  Rate this |  Briefcase | 3,416 reads

Using the Resource Governor

SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.  Read more...
By Additional Articles 2009/07/20 | Source: TechNet | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,320 reads

Querying the Procedural Cache on Canada Day (July 1st)

The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.  Read more...
By Hugo Shebbeare 2009/07/08 | Source: SQLServerCentral.com | Category: Blogs
Rating: (not yet rated)  Rate this |  Briefcase | 415 reads

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...
By Nilav Baran Ghosh 2009/07/07 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 11,725 reads

Capturing I/O patterns using Process Monitor

In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.  Read more...
By Edward Elliott 2009/06/23 | Source: SQLServerCentral.com | Category: I/O
Rating: |  Discuss |  Briefcase | 6,521 reads
   Items 1 to 20 of 298    Next 20 >>
 
Most popular

Twenty tips to write a good stored procedure

This article will provide some useful information to write a SP. I have emphasized on performance.  Read more...
By Arup Chakraborty 2009/08/10 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 36,550 reads

Get Performance Tips Directly From SQL Server

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...
By Ian Stirk 2009/06/11 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 17,849 reads

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...
By Nilav Baran Ghosh 2009/07/07 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 11,725 reads