2007年12月_EricYeung

原创 Functional Dependencies & MultiValued Dependency

Functional Dependencies (FDs) 1->1A->B: If I know your vendor code, I can determine the vendor nameMultiValued Dependency (MVD) 1 -> *A->->B: If I know the customer code, I can determine the list of t

2007-12-10 10:16:00 918

原创 Database normal form

1 NF=====================================================================Acolumn is atomic, not array, no repeating semantic columnsanti-example:Customers(CustID INT, CustName VARCHAR(30)...)SQL 2005

2007-12-10 10:15:00 618

原创 SQL 2005 DataWarehouse Note

@2007 June 02MS BI Studiofact table (transaction table)dim table (master file: product, customer)BI Studio1)Datasource: Delphi ADOConnection2)Datasource View: ADOTable3)Cube4)Dimensionmainly involve:

2007-12-10 09:15:00 726

原创 Error checking V.S. Exception

1)Error checkingif (bad_condition) thenbegin ShowMsg("bad"); return ERROR_CODE_1;end; 2)raise exceptionif (bad_condition) then raise Exception.Create("bad")comparision:1)communicate with UI d

2007-12-10 08:46:00 624

原创关于SQL Server的ISOLATION

ISOLATION 是Connection的一个property，每个session都有自己的Isolation Level1）Read Uncommitted (不做控制)能读别人已修改未提交的databegin traninsert(can read data)2)Read committed不能读别人已修改未提交的databegin traninsert直到commit(can read d

2007-12-10 08:34:00 860

转载 Locking in Microsoft SQL Server (Quoted from mssqlcity)

Locking in Microsoft SQL ServerAlexander Chigrikchigrik@mssqlcity.comIntroductionTransaction Isolation LevelsLock typesLocking optimizer hintsDeadlocksView locks (sp_lock)LiteratureIntroductionIn this

2007-12-10 08:25:00 967

原创 C# terminate thread with stop variable

namespace FrameworkTest{ public partial class Form1 : Form { private bool stopThread = false; delegate void InsertListCallback(int index, object item); private void btnStart

2007-12-07 08:57:00 1144

原创 T-SQL Nested procedure & transactions

IF OBJECT_ID(sp_ThrowExp) IS NOT NULL DROP PROC sp_ThrowExpGOCREATE PROC sp_ThrowExpAS RAISERROR(Error occurs., 16, 1)GOIF OBJECT_ID(sp_OuterProc) IS NOT NULL DROP PROC sp_OuterProcGOC

2007-12-06 14:31:00 631

Trending Up...