Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Optimization Rss

   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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,983 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: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 6,113 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 | 3,294 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,168 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: MSSQLTips.com | Category: ip addresses
Rating:  Rate this |   Briefcase | 3,453 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: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,704 reads
   Items 1 to 6 of 6   
 
Tags
performance (2)    
analysis services (ssas) (1)    
data types (1)    
duplicates (1)    
implicit conversion (1)    
indexing (1)    
ip addresses (1)    
log throughput (1)    
performance tuning (1)    
reporting services (ssrs) (1)    
stairway series (1)    
string (1)    
transaction logs (1)    
t-sql (1)