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

Guest Columnist: Ramya Makam

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.  Read more...
By Ramya Makam 2016/11/07 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,191 reads

SELECT INTO vs INSERT INTO on Columnstore

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.  Read more...
By Ramya Makam 2016/08/05 (first published: 2015/06/09) | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 17,153 reads

Mail Fails with SQLCMD Error

I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.  Read more...
By Ramya Makam 2015/03/19 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 2,801 reads

How does a View work on a Table with a Clustered Columnstore Index ?

This article is about how a view works when it is created on a table with clustered columnstore index on it.  Read more...
By Ramya Makam 2015/02/05 | Source: SQLServerCentral.com | Category: clustered columnstore
Rating: |  Discuss |   Briefcase | 5,823 reads

Clustered Columnstore Index Gives "Unable to find index entry" Error

The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table  Read more...
Rating: |  Discuss |   Briefcase | 1,882 reads
   Items 1 to 5 of 5