SQL Server 2005 Best Practices

There's no shortage of them!!!

https://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. These SQL Server best practices draw on the extensive experience and expertise from respected developers and engineers at Microsoft, who walk you through the specifics on solving particularly difficult issues. Technical White Papers Deep level technical papers on specific SQL Server topics that were tested and validated by SQL Development. The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode Precision Considerations for Analysis Services Users Scale-Out Querying with Analysis Services Using SAN Snapshots Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services XML Best Practices for Microsoft SQL Server 2005 Performance Optimizations for the XML Data Type in SQL Server 2005 SQL Server 2005 Security Best Practices - Operational and Administrative Tasks SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned Scale-Out Querying with Analysis Services SQL Server 2005 Analysis Services Processing Best Practices Predeployment I/O Best Practices Partial Database Availability Comparing Tables Organized with Clustered Indexes versus Heaps SQL Server 2005 Deployment Guidance for Web Hosting Environments Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios Implementing Application Failover with Database Mirroring OLAP Design Best Practices for Analysis Services 2005 DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005 TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild Loading Bulk Data into a Partitioned Table Database Mirroring Best Practices and Performance Considerations SQL Server 2005 Performance Tuning using Waits and Queues Analysis Services 2005 Performance Guide SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x Troubleshooting Performance Problems in SQL Server 2005   SQL Server Best Practices Toolbox Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005 Buffer Cache CPU and Optimization Indexes and Indexing Input/Output Performance Query Plan Re-Use Retrieving SQL Text and XML Plans SQLOS: Schedulers, Runnable Queue, Waiter List Tempdb Transactions and Locking Wait Statistics SQL Server 2005 Best Practices Analyzer DMV Stats   Top 10 Lists Summary lists (usually consisting of 10 items) of recommendations, best practices and common issues for specific customer scenarios by the SQL Server Customer Advisory Team. Analysis Services Query Performance Top 10 Best Practices Top 10 Best Practices for SQL Server Maintenance for SAP Top 10 Hidden Gems in SQL Server 2005 Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications OLTP Top 6 Performance Issues for OLTP Applications Storage Top 10 Best Practices   Best Practices in SQL Server Books Online Best Practices for Replication Administration Replication Security Best Practices Best Practices for Recovering a Database to a Specific Recovery Point

Blogs

• SQLCAT
• SQL ISV PM
• SQL Server Query Optimization Team
• SQL Server Programmability Team
• SQL Server Storage Engine Team
• SQL Server CLR Integration Team
• PSS SQL Server Engineers
• Slava Oks
• Prakash Sundaresan

Comments

• Anonymous
  January 01, 2003
  PingBack from http://geeklectures.info/2008/01/02/sql-server-2005-best-practices/

• Anonymous
  June 11, 2015
  Beijing on June 10 morning news, according to Bloomberg survey report GTM Research and the American Solar Energy Industries Association released the first quarter of this year, US home solar power system capacity increase of 76% over last year, to 437 megawatts (MW) ,Solar Batteries http://www.poweroak.net the nation's new generating capacity, more than half of which is a photovoltaic power generation. The report shows that a quarter of the US solar power capacity by 1.3 gigawatts (GW), the sixth consecutive quarterly increase of over 1 GW. The total annual installed capacity is expected to reach 7.9 GW, Solar Power Peneratorhttp://www.poweroak.net , Solar Power Pack http://www.poweroak.net representing an increase of 27%.
  The report predicts that by 2016 solar power will meet the electricity needs of about 800 million households in the United States to offset 45 million metric tons of carbon emissions, equivalent to removing 10 million cars. energy storage systemhttp://www.poweroak.net/energy-storage-system-c-1.html