2012年8月28日
xp_instance_regwrite syntax
摘要： The stored procedure "master.sys.xp_instance_regwrite" is not documented in SQL Server Books Online (BOL), but is usefull. In general the syntax isEXECUTE [master].[sys].[xp_instance_regwrite] @rootkey = N'<name of root key>',@key = N'<key name>',@value_name = N 阅读全文
posted @ 2012-08-28 11:57 Alex Tian 阅读(624) 评论(0) 推荐(0)
DB Development Standard summary
摘要： 1.0 GoalDB is only the storage and we should not depend too much on DB . DB should be simple and stable.2.0 Four workflow Create new tableAlter tableCreate/Alter the sp and functionI/D/U flow3.0 Setup three different environmentsdev/beta/live4.0 Basic workflow __________________________ 阅读全文
posted @ 2012-08-28 11:03 Alex Tian 阅读(162) 评论(0) 推荐(0)
SQL 大数据量的优化例子讨论
摘要： 今天在itput上看了一篇文章，是讨论一个语句的优化： 原贴地址： http://www.itpub.net/viewthread.php?tid=1015964&extra=&page=1 一，发现问题 优化的语句：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->请问以下语句如何优化:CREATETABLEaa_001(ipVARCHAR2(28),nameVARCHAR2(10),passwordVARCHAR2(30)) 阅读全文
posted @ 2012-08-28 09:38 Alex Tian 阅读(183) 评论(0) 推荐(0)