2014年7月23日
统计信息的备份恢复导入导出
摘要： Question:I want to understand when to export and import by dbms_stats statistics and learn when it is a good idea to export and import statistics.Answ... 阅读全文
posted @ 2014-07-23 21:12 princessd8251 阅读(415) 评论(0) 推荐(0)
诊断一句SQL不走索引的原因
摘要： from http://www.itpub.net/thread-1852897-1-1.html有论坛朋友在上面的帖子里问SQL为什么不走索引,正好这两天我也刚刚在看SQL优化，于是试着回答了一下.下面是原来的SQL:select o.order_id as orderIdfrom order_i... 阅读全文
posted @ 2014-07-23 20:45 princessd8251 阅读(1616) 评论(0) 推荐(1)
Calculating simple running totals in SQL Server
摘要： Running total for Oracle:SELECT somedate, somevalue,SUM(somevalue) OVER(ORDER BY somedateROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)AS RunningTo... 阅读全文
posted @ 2014-07-23 18:42 princessd8251 阅读(290) 评论(0) 推荐(0)
Upgrade Image&ntext to varbinarymax&nvarchar(max)
摘要： CREATE PROCEDURE SP_EXEC_WITH_LOG(@I_TICKETNO VARCHAR(10),@I_SQLSTR nvarchar(max))ASBEGIN DECLARE @QUOTATION_TRANSFER_STR nvarchar(max); SET @QUOTATIO... 阅读全文
posted @ 2014-07-23 17:41 princessd8251 阅读(233) 评论(0) 推荐(0)
Proxy settings in TortoiseSVN and command line svn client
摘要： The server file is created when you install TortoiseSVN, Eclipse or command-line Subversion. Use the appropriate path from the installation folder to ... 阅读全文
posted @ 2014-07-23 13:55 princessd8251 阅读(352) 评论(0) 推荐(0)