Month: April 2015

Uninstalling SQL Server

Posted on by jayanth.kurup

I just realized today that I had the CTP for sql 2014 still installed on my laptop today. While trying to uninstall it from control panel (time period had expired by the way) I got the error below: The Operating System on this computer does not meet the minimum requirement Naturally being a CTP I…

Clustered Index vs Unique Non Clustered Index, which is better performance while still maintaining integrity of the data?

Posted on by jayanth.kurup

At a training recently we were talking about improving ETL performance for a process that loads about 3 million rows. While the answer is typically to load the data after dropping the indexes, in this case they wanted to load the data with indexes since the data would then be needed to perform looks up…