Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Optimization Rss

Search for any content tagged optimization

   Items 1 to 6 of 6   

Finding and Eliminating Duplicate or Overlapping Indexes

Duplicate & Overlapping Indexes can be a drag on write speed and disk resources. How do we find and eliminate them quickly and effectively?  Read more...
By Edward Pollack 2014/06/16 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 7,889 reads

Comparing Different Data Types

Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.  Read more...
By Edward Pollack 2014/05/19 | Source: | Category: datatypes
Rating: |  Discuss |   Briefcase | 6,223 reads

Reporting Services Performance and Optimization

This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.  Read more...
By Additional Articles 2013/12/24 | Source: SQLCAT | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,015 reads

Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput

This level takes a deeper look at how log fragmentation can affect the performance of operations that need to read the log, such as log backups, or the crash recovery process.  Read more...
By Gail Shaw, Tony Davis 2013/04/17 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,727 reads

Optimal Storage of IP addresses in a SQL Server database

Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?  Read more...
By Additional Articles 2011/12/07 | Source: | Category: ip addresses
Rating:  Rate this |   Briefcase | 3,686 reads

Optimize a SQL Server Analysis Services Measure Group Partition for Performance

In this tip you will learn how to design aggregations for a partition and optimize it for performance. Solution  Read more...
By Additional Articles 2011/08/26 | Source: | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 3,117 reads
   Items 1 to 6 of 6