程序人生

导航

2015年10月30日

URL Regex expression

摘要: 转载:http://blog.csdn.net/weasleyqi/article/details/7912647首先,正则表达式:String check = @"((http|ftp|https)://)(([a-zA-Z0-9\._-]+\.[a-zA-Z]{2,6})|([0-9]{1,3}... 阅读全文

posted @ 2015-10-30 14:10 Leon.Cao 阅读(661) 评论(0) 推荐(0) 编辑

2014年10月21日

Replication

摘要: Peer-to-peer replication: http://msdn.microsoft.com/en-us/library/ms151196(v=sql.120).aspxMerge replication: http://msdn.microsoft.com/en-us/library/m... 阅读全文

posted @ 2014-10-21 15:23 Leon.Cao 阅读(397) 评论(0) 推荐(0) 编辑

2014年9月11日

Online design tool

摘要: http://www.gliffy.com/ 阅读全文

posted @ 2014-09-11 10:31 Leon.Cao 阅读(180) 评论(0) 推荐(0) 编辑

2014年4月13日

Partitioning & Archiving tables in SQL Server (Part 2: Split, Merge and Switch partitions)

摘要: Reference:http://blogs.msdn.com/b/felixmar/archive/2011/08/29/partitioning-amp-archiving-tables-in-sql-server-part-2-split-merge-and-switch-partitions.aspxIn the 1st part of this post, I explained how to create a partitioned table using a partition function as well as a partition schema. Now I’ll co 阅读全文

posted @ 2014-04-13 15:58 Leon.Cao 阅读(501) 评论(0) 推荐(0) 编辑

Partitioning & Archiving tables in SQL Server (Part 1: The basics)

摘要: Reference:http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspxDatabase partitioning is a feature available in SQL Server(version 2005 and Up) which lets you split a table among multiple files which can be beneficial for large tabl 阅读全文

posted @ 2014-04-13 15:57 Leon.Cao 阅读(302) 评论(0) 推荐(0) 编辑

2014年3月28日

Winmail.dat(TNEF) issue on outlook

摘要: http://www.dwheeler.com/essays/microsoft-outlook-tnef.html 阅读全文

posted @ 2014-03-28 17:04 Leon.Cao 阅读(229) 评论(0) 推荐(0) 编辑

How to Take Control of Your Line Height in Outlook.com

摘要: Reference to:http://www.emailonacid.com/blog/details/C13/line_height_and_outlook.com 阅读全文

posted @ 2014-03-28 17:02 Leon.Cao 阅读(113) 评论(0) 推荐(0) 编辑

2014年3月5日

Good Practices to Write Stored Procedures in SQL Server

摘要: Reference to:http://www.c-sharpcorner.com/UploadFile/skumaar_mca/good-practices-to-write-the-stored-procedures-in-sql-server/Use proper indentation for the statements in SQL Server. It will improve the readability.Write the proper comments between the logics. So the others can understand quickly.Wri 阅读全文

posted @ 2014-03-05 13:21 Leon.Cao 阅读(198) 评论(0) 推荐(0) 编辑

2013年11月25日

SQL Server performance tips

摘要: Refer to:http://harriyott.com/2006/01/sql-server-performance-tipsA colleague of mine has been looking at SQL Server performance, and come up with a great set of tips (mostly gleaned fromthis website):Does your SQL statement have a WHERE clause?I know this sounds obvious, but don't retrieve more 阅读全文

posted @ 2013-11-25 13:21 Leon.Cao 阅读(214) 评论(0) 推荐(0) 编辑

2013年6月27日

How to pronounce symbols on keyboard

摘要: Refefrence:http://answers.yahoo.com/question/index?qid=20100607151104AAtQxhc~ “tilde” or “tweedle” or “squiggly line”. Also used as a “swung dash” and in mathematics with other signs to mean “approximately” and in logic sometimes used to mean “not”. Seehttp://en.wikipedia.org/wiki/Tilde,` “grave acc 阅读全文

posted @ 2013-06-27 15:56 Leon.Cao 阅读(1140) 评论(0) 推荐(0) 编辑