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

Content with tags Stairway Series, Optimization Rss

   Items 1 to 2 of 2   
 

Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)

In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.  Read more...
By Hugo Kornelis 2016/11/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 761 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,772 reads
   Items 1 to 2 of 2   
 
Tags
batch mode (1)    
columnstore index (1)    
log throughput (1)    
transaction log (1)