摘要：
IntroductionSorry for being so late in writing the last part of the article. I have a full-time job to earn my living, and for the last couple of months, I had been extremely busy with some of my client projects (Sounds like an excuse?).Any way, better late than never. It's good to be back again 阅读全文
posted @ 2012-10-05 15:44
Alex Tian
阅读(283)
评论(0)
推荐(0)
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)
摘要：
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 阅读全文
posted @ 2012-10-05 15:43
Alex Tian
阅读(344)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2012-10-05 15:42
Alex Tian
阅读(375)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2012-10-05 15:41
Alex Tian
阅读(335)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2012-10-05 15:40
Alex Tian
阅读(239)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2012-10-05 15:37
Alex Tian
阅读(259)
评论(0)
推荐(0)
浙公网安备 33010602011771号