Navigation

Search

Site Content

Syndicate

Home | SQL Server 2005 DBA

Top 10 Hidden Gems in SQL 2005

Mon, 12/10/2007 - 23:19 |  sqlguychuck
No votes yet

The SQLCAT team has posted some good information about seldom used tools that should be of interest to many us: http://sqlcat.com/top10lists/archive/2007/11/21/top-10-hidden-gems-in-sql-server-2005.aspx

Summary

  1. TableDiff.exe
  2. Triggers for Logon Events (New in Service Pack 2)
  3. Boosting performance with persisted-computed-columns (pcc).
  4. DEFAULT_SCHEMA setting in sys.database_principles
  5. Forced Parameterization
  6. Vardecimal Storage Format
  7. Indexing made easier with SQL Server 2005 - http://blogs.msdn.com/queryoptteam/archive/2006/06/01/613516.aspx
  8. Figuring out the most popular queries in seconds - using sys.dm_exec_query_stats. For more info see  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx
  9. Scalable Shared Databases - http://support.microsoft.com/kb/910378
  10. Soft-NUMA
Share this  |  Login or register to post comments |  Tags: DBA Recommended Reading, SQL 2005 DBA

Contact Us | Terms of Use | Trademarks | Privacy Statement
Copyright © 2010 SQLWebpedia. All Rights Reserved.

Creative Commons License
This work by Chuck Lathrope is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

Disclaimer for all content: No warranty is expressed or implied by the authors' or owner's of this website or content linked externally. Use at your own risk.