oltp

CURSOR FETCH on SQL Server

although CURSOR and FETCH is classified as ‘evil‘ in SQL server, but sometimes we cannot avoid using it. Cause in some scenarios, pivot and other similiar method to perform looping and transformation is not sufficient enough. here’s a link of good example implementing cursor. all example copy from microsoft sites, http://msdn.microsoft.com/en-us/library/ms180152.aspx A. Using FETCH in […]

OLTP vs OLAP

In many Business Intelligence implementation cases,¬† there’s a certain difficulty for IT Pro to explain or describe the difference¬† between OLTP (OnLine Transactional Process) and OLAP (OnLine Analytical Process).¬† I hope the table below might help a little. source: 360decisions *Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id

Scroll to top