Daqing Chu At WordPress

August 21, 2011

Filed under: Programming Notes — David Chu @ 6:13 pm
Tags:

This blog is about how to create a materialized view in SQL server database. By creating a materialized view, you can dramatically improve query performance. I learned this by my experience. Here are some key notes about the process.

[Read more…]

Advertisements

April 4, 2009

SQLite Manager Add-on for Fixfox

Filed under: Programming Notes — David Chu @ 10:22 pm
Tags: ,

toolsI found a very handy tool: SQLite Manager an add-on for FireFox. I have been using another application called as SQLite Database Browser in my Mac for my SQLite databases. FireFox add-on actually is much better than the application, at least from the UI.

Read full blog ».

March 14, 2009

Use sp_who2() to Get Current Log-in User Information

Filed under: Programming Notes — David Chu @ 7:26 pm
Tags:

Recently I have been working on Microsoft SQL Server 2005 to resolve some security issues. One question was to get the current log in user information.

Read full blog ».

March 6, 2009

Using EXEC() AT Continued

Filed under: Programming Notes — David Chu @ 5:18 am
Tags:

My previous blogs on this topic demonstrate a way to use EXEC(…) AT … to pass through a query to a linked server. The performance of this method is much better than a T-SQL query directly with the linked server. I tried it with an very big Oracle database table with great speed.

Read full blog »

February 28, 2009

Using EXEC() AT with Oracle DB

Filed under: Programming Notes — David Chu @ 11:53 pm
Tags:

My previous blog was about using OPENQUERY() method with an Oracle DB. The advantage of using this method call is to pass through a query to a linked server such as Oracle server and to leverage the Oracle server to do the job. The great benefit of this strategy is to obtain much fast performance compared using T-SQL query directly against an Oracle database object in local SQL server.

Read full blog »

February 25, 2009

Using OPENQUERY for Oracle DB

Filed under: Programming Notes — David Chu @ 9:43 pm
Tags:

Today I googled an alternative solution to run an Oracle PL/SQL query or stored procedure from Microsoft SQL server 2005. I am very impressed by the result of this alternative way.

Read full blog ».

February 22, 2009

T-SQL Tip: Combine Column Names as a String

Filed under: Programming Notes — David Chu @ 9:55 pm
Tags:

I found the following T-SQL query to build a string of selected column names together separated by command for a table. This string can be used then for another SQL query as a column list.

Read full blog »

Blog at WordPress.com.