我已活在虛擬世界中, 已分不清楚事物.
近來被多次人家擺上抬, 知道己經太遲.
為什麼人總是要有爭執
Tuesday, 31 March 2009
Wednesday, 25 March 2009
心淡
為何, 為何你要令我心淡
由這一分鐘開始計起 春風秋雨間
限我對你以半年時間 慢慢的心淡
付清賬單 平靜的對你熱度褪減
一天一點傷心過 這一百數十晚
大概也夠我 送我來回地獄又折返人間
心淡 心淡 心淡 心淡 心淡 心淡 心淡
想不起 怎麼會病到不分好歹
連受苦都甜美 我每日捱著 不睬不理
但卻捱不死 又去痴纏你
難道終此一生 都要這麼 不可爭一口氣
☆很謙卑 只不過是我太過愛你
連自尊都忘記 跌到極麻木 只好相信
又再爬得起 就會有轉機
若我不懂憎你 如何離別你 亦怕不會飛☆
＃由這一分鐘開始計起 春風秋雨間
限我對你以半年時間 慢慢的心淡
付清 賬單 平靜的對你熱度褪減
一天一點傷心過 這一百數十晚
大概也夠我 送我來回地獄又折返人間
春天分手 秋天會習慣 苦沖開了便淡 ＃
Repeat ☆ ＃
（說甚麼再平反）只怕被迫一起更礙眼
（往後這半年間）只愛自己 雖說不太習慣
畢竟有限 就當 過關
Repeat＃
由這一分鐘開始計起 春風秋雨間
限我對你以半年時間 慢慢的心淡
付清賬單 平靜的對你熱度褪減
一天一點傷心過 這一百數十晚
大概也夠我 送我來回地獄又折返人間
心淡 心淡 心淡 心淡 心淡 心淡 心淡
想不起 怎麼會病到不分好歹
連受苦都甜美 我每日捱著 不睬不理
但卻捱不死 又去痴纏你
難道終此一生 都要這麼 不可爭一口氣
☆很謙卑 只不過是我太過愛你
連自尊都忘記 跌到極麻木 只好相信
又再爬得起 就會有轉機
若我不懂憎你 如何離別你 亦怕不會飛☆
＃由這一分鐘開始計起 春風秋雨間
限我對你以半年時間 慢慢的心淡
付清 賬單 平靜的對你熱度褪減
一天一點傷心過 這一百數十晚
大概也夠我 送我來回地獄又折返人間
春天分手 秋天會習慣 苦沖開了便淡 ＃
Repeat ☆ ＃
（說甚麼再平反）只怕被迫一起更礙眼
（往後這半年間）只愛自己 雖說不太習慣
畢竟有限 就當 過關
Repeat＃
Tuesday, 24 March 2009
心痛
我無意中插了她一刀, 我現在被她插, 她恨我.
我有自毁的念頭, 因為我什麼好朋友都沒有, 我都想人關心, 想人呵護, 也許要求太過份了.
我無權怪她. 她是我唯一的一個人, 她走了. 我也想走了可惜無路可走
我很苦.
我有自毁的念頭, 因為我什麼好朋友都沒有, 我都想人關心, 想人呵護, 也許要求太過份了.
我無權怪她. 她是我唯一的一個人, 她走了. 我也想走了可惜無路可走
我很苦.
Sunday, 22 March 2009
呆子
我不知不覺把她的心刺傷了, 她可能會和我一刀兩斷吧, 雙衣為命的生活也要結束了. 日木之旅也可能變成夢幻泡影.
雖然害怕, 很害怕, 但是我本來什麼也沒有, 何必執著吧.
我被人恨, 我無言以對, 也許很多人也在恨我吧, 呆了, 望著天空, 看著星星, 我沒有智慧. 以和為貴是一門很高的藝術. 我又呆了. 看著鏡子, 這是我嗎? 身邊的人一個個地離開, 厭倦了吧.
雖然害怕, 很害怕, 但是我本來什麼也沒有, 何必執著吧.
我被人恨, 我無言以對, 也許很多人也在恨我吧, 呆了, 望著天空, 看著星星, 我沒有智慧. 以和為貴是一門很高的藝術. 我又呆了. 看著鏡子, 這是我嗎? 身邊的人一個個地離開, 厭倦了吧.
Friday, 20 March 2009
Wednesday, 4 March 2009
LINQ and Stored Procedure and DBA
I am a DBA + .Net developer. I got certified in SQL 2005 and .Net 1.1. I would like to share with you that the stored procedure offers much more functions than LINQ
1. Use of Lock Hint.
2. Control of deadlock free query in stored procedure. Writing deadlock free query requires the queries to be runnning in "specific order" between several tables
3. Use of recursive SQL with CTE
4. Use of SQL 2008 new data type such as hierachyID, spatial datatype
5. You can assign a query plan to a specific query or specify query hint. It can solve the Parameter sniffing issue. In SQL 2008, the FORSEEK option helps a lot
6 You want to do a SELECT sql using ORDER BY COLLATE the column by different collation in sql. This important especially working with 2 different db with 2 different collation. Especially in different language, the sorting order is different. Example: Try adventureworks
SELECT LastName, FirstName FROM Person.Contact
WHERE LastName LIKE 'R%'
ORDER BY FirstName COLLATE Latin1_General_CI_AS DESC, LastName DESC
For case sensitive search
SELECT LastName, FirstName FROM Person.Contact
WHERE LastName COLLATE Latin1_General_CS_AS LIKE 'r%' (NO RESULT DUE TO CASE SENSITVE)
7, Update 800+rows at a same time using OPEN XML. I have an application updating payroll hours for 300+ employees. Use of OPEN XML took a split seconds, use of seperate insert statement took at least 3 seconds
8 There has been complaints about paging millions of records using LINQ. In sql server, use of temp table and temp table variables in paging are very subtle. The performance differs from case to case
9 Use of PIVOT table
10 Use of Encryption function
1. Use of Lock Hint.
2. Control of deadlock free query in stored procedure. Writing deadlock free query requires the queries to be runnning in "specific order" between several tables
3. Use of recursive SQL with CTE
4. Use of SQL 2008 new data type such as hierachyID, spatial datatype
5. You can assign a query plan to a specific query or specify query hint. It can solve the Parameter sniffing issue. In SQL 2008, the FORSEEK option helps a lot
6 You want to do a SELECT sql using ORDER BY COLLATE the column by different collation in sql. This important especially working with 2 different db with 2 different collation. Especially in different language, the sorting order is different. Example: Try adventureworks
SELECT LastName, FirstName FROM Person.Contact
WHERE LastName LIKE 'R%'
ORDER BY FirstName COLLATE Latin1_General_CI_AS DESC, LastName DESC
For case sensitive search
SELECT LastName, FirstName FROM Person.Contact
WHERE LastName COLLATE Latin1_General_CS_AS LIKE 'r%' (NO RESULT DUE TO CASE SENSITVE)
7, Update 800+rows at a same time using OPEN XML. I have an application updating payroll hours for 300+ employees. Use of OPEN XML took a split seconds, use of seperate insert statement took at least 3 seconds
8 There has been complaints about paging millions of records using LINQ. In sql server, use of temp table and temp table variables in paging are very subtle. The performance differs from case to case
9 Use of PIVOT table
10 Use of Encryption function
Subscribe to:
Posts (Atom)
