SQL Clone
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,514 reads


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,229 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 | 3,015 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,846 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,904 reads
   Items 1 to 5 of 5