flysun0311

摘要： IntroductionImagine you are a doctor, or a physician. What do you do when one of your patients arrive feeling out of sorts and fallen ill?You will try to understand the cause of his/her illness, right? Yes. This is the most important thing to do first. Because, in order to cure your patient, you nee 阅读全文

摘要： IntroductionHello again!We are in the process of optimizing a SQL Server database, and so far we have done lots of things. We applied indexing in our database tables and then re-factored the TSQLs to optimize the data access routines. If you are wondering where we did all these and what are the thin 阅读全文

摘要： Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)By Al-Farooque Shubho, 1 Jun 2009 4.93 (113 votes)123454.93/5 - 113 votes5 removedμ 4.74, σa 1.14 [?] Prize winner in Competition "Best overall article of April 2009" IntroductionRemember w 阅读全文

摘要： http://www.codeproject.com/Articles/34372/Top-10-steps-to-optimize-data-access-in-SQL-ServerTop 10 steps to optimize data access in SQL Server: Part I (use indexing)By Al-Farooque Shubho, 28 Apr 2009 4.90 (115 votes)123454.90/5 - 115 votes2 removedμ 4.84, σa 0.94 [?] Introduction"It's been 阅读全文

摘要： http://www.codeproject.com/Articles/434467/SQL-Server-Governor-The-unknown-heroTable of contentsIntroductionWhat is the use of SQL Server Governor?How do we configure SQL Server Governor?See it workingSummarizing how the Governor worksIntroductionSQL Server is a massive RDBMS software. Even after so 阅读全文

该文被密码保护。 阅读全文

摘要： pstool下载地址：http://www.xfocus.net/tools/200508/PsTools.zippstool是一组本地与远程信息管理程序pstool用法1)psexecpsexec是一个远程执行工具，你可以像使用telnet一样使用它。它的使用格式为：psexec \\\\远程机器ip [-u username [-p password]] [-c [-f]] [-i][-d] program[arguments]它的参数有：-u后面跟用户名 -p后面是跟密码的,如果建立ipc连接后这两个参数则不需要。（如果没有-p参数，则输入命令后会要求你输入密码）-c <[路径]文 阅读全文

摘要： ============================================================================================================================================================================================================================================================================================================ 阅读全文

该文被密码保护。 阅读全文

摘要： Hi guysI am concerned on how the tech leaders have approached this topic. I expect from our leaders to tell us more than “it’s hard” – I know that much. The attitude of a leader is to say either “don’t do this, it’s a stupid idea” or else join in to make it happen.We will push this forward and have 阅读全文