April 2015 | Get the most out of MSSQL !

Uninstalling SQL Server

Posted on April 7, 2015March 20, 2021 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 April 5, 2015March 20, 2021 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…