Posts Tagged “sql server”
Shrink / Truncate Log File On SQL Server 2008
by diditho on June 30, 2010
The common T-SQL script to shrink/truncate log file is using the script below 1 2 3 USE [foo] GO DBCC SHRINKFILE(foo_log, 1) But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same (…)
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 (…)
SAP BW UD Connect and SQL Server Unicode Setting
by diditho on March 1, 2010
With UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this (…)
Part 2 : Geometry dan Geography di SQL Server 2008
by diditho on October 24, 2008
Ada 2 Jenis tipe data baru (spatial), pada SQL server 2008. Kedua jenis data tersebut adalah GEOMETRY dan GEOGRAPHY. 1. Geometry, pada permukaan datar. (Flat Earth Model). presentasi dari X dan Y 2. Geography, pada permukaan yang bulat. (Ellipsoidal Model). (…)
