摘要：
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... 阅读全文
摘要：
from http://www.itpub.net/thread-1852897-1-1.html有论坛朋友在上面的帖子里问SQL为什么不走索引,正好这两天我也刚刚在看SQL优化，于是试着回答了一下.下面是原来的SQL:select o.order_id as orderIdfrom order_i... 阅读全文
摘要：
Running total for Oracle:SELECT somedate, somevalue,SUM(somevalue) OVER(ORDER BY somedateROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)AS RunningTo... 阅读全文
摘要：
CREATE PROCEDURE SP_EXEC_WITH_LOG(@I_TICKETNO VARCHAR(10),@I_SQLSTR nvarchar(max))ASBEGIN DECLARE @QUOTATION_TRANSFER_STR nvarchar(max); SET @QUOTATIO... 阅读全文
摘要：
1.mod_cluster简介 mod_cluster 和mod_jk,mod_proxy类似，是一个基于httpd的负载平衡项目能够代理请求给基于Tomcat 网络服务器集群(支持任何独立的Tomcat，独立的JBoss Web或者JBoss AS的嵌入JBoss Web)。mod_cluste... 阅读全文
摘要：
The server file is created when you install TortoiseSVN, Eclipse or command-line Subversion. Use the appropriate path from the installation folder to ... 阅读全文