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

Guest Columnist: Kenneth Igiri

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008  Read more...
By Kenneth Igiri 2016/01/18 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 2,788 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,060 reads

The Real World: Implementing AWE

Describes the gains experienced in my environment by implementing AWE.  Read more...
By Kenneth Igiri 2012/05/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,962 reads

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...
By Kenneth Igiri 2012/04/20 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 6,311 reads
   Items 1 to 4 of 4