Archive for the “oltp” category

CURSOR FETCH on SQL Server

by diditho on June 22, 2010

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 (…)

Read the rest of this entry »

OLTP vs OLAP

by diditho on April 24, 2009

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 (…)

Read the rest of this entry »