10 2012 档案
摘要:Provisioning a New SQL Server Instance – Part Threeby Glenn Berry, 18 September 2012 0 commentsOnce you've installed and configured SQL Server 2012, there are some tasks that should be done to ensure that maintenance, monitoring and alerting systems are in place to keep the instance running smoo
阅读全文
摘要:NutsAndBolts_V1.1.zip
阅读全文
摘要:ProblemMany companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.
阅读全文
摘要:Using powershell:powershell (New-Object Net.WebClient).DownloadFile('http://www.google.com', 'result.txt')You must use single quotes and not double quotes for this to work
阅读全文
摘要:进来发现blog太多内容,现在能想到的不是多copy点什么,而是我可以删掉些什么,那些太过花哨而没有用的东西
阅读全文
摘要:Red Gate系列之一 SQL Compare 10.2.0.1337 Edition 数据库比较工具 完全破解+使用教程Red Gate系列之二 SQL Source Control 3.0.13.4214 Edition 数据库版本控制器 完全破解+使用教程Red Gate系列之三 SQL Server 开发利器 SQL Prompt 5.3.4.1 Edition T-SQL智能感知分析器 完全破解+使用教程Red Gate系列之四 SQL Data Compare 10.2.0.885 Edition 数据比较同步工具 完全破解+使用教程Red Gate系列之五 .NET Refle
阅读全文
摘要:How to receive Deadlock information automatically via emailBy Geoff Albin, 2012/09/21 (first published: 2010/12/13) Receive Deadlock detail via email.I had spent many hours on Google trying to find the best way to send a notification on deadlock occurrences. While it was a fairly straight forward pr
阅读全文
摘要: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
阅读全文
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
阅读全文
摘要: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
阅读全文
该文被密码保护。