Posts Tagged “sql”
Linked Servers, How To Read MySQL On SSMS 2008
by diditho on July 19, 2011
A linked server configuration enables Microsoft SQL Server (MSSQL) to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages: Remote server access ; The ability to issue distributed queries, updates, commands, and transactions (…)
HeidiSQL Rock!
by diditho on July 13, 2011
Arrghh!! need to manage an old version of MySQL database. Turnout the vary of MySQL version is a serious problem to lot of free MySQL Graphic User Interface (GUI). Most of it, cannot manage old version of MySQL database, only (…)
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 (…)
