Microsoft articles

Home About me and Nucleus Partners Links Articles, tips etc. My blog Microsoft articles Newsgroups Course demo files Sync logins SMTP Alerter

There is a goldmine of articles available at Microsft's website. Below are some URLs that can help you finding an article for the topic and version of SQL Server that you are interested in. Tip: In general, INF KB articles can have very valuable general technical information. SQL Server 2005 SQL Server TechCenter SQL Server Best Practices Technical articles, database engine SQL Server articles at MSDN SQL Server 2000 Technical articles Technical articles, database engine SQL Server articles at MSDN Microsoft Knowledgebase MS Knowledgebase Some of my favorite articles, in no particular order: 2008 Database Encryption in SQL Server 2008 Enterprise Edition 2005 An Introduction to SQL Server Service Broker Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 Comparing Tables Organized with Clustered Indexes versus Heaps Database Concurrency and Row Level Versioning in SQL Server 2005 Database Mirroring Best Practices and Performance Considerations Database Mirroring in SQL Server 2005 Forcing Query Plans How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888 (excellent information about scheduling) Improving Performance with SQL Server 2005 Indexed Views International Features in Microsoft SQL Server 2005 Online Indexing Operations in SQL Server 2005 Partial Database Availability Partitioned Tables and Indexes in SQL Server 2005 Predeployment I/O Best Practices Reducing Database Size by Using Vardecimal Storage Format Physical Database Storage Design SQL Server 2005 Express Edition User Instances SQL Server 2005 Row Versioning-Based Transaction Isolation SQL Server 2005 Waits and Queues SQL Server I/O Basics, Chapter 2 SQL Writer in SQL Server 2005 Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild Troubleshooting Performance Problems in SQL Server 2005 Working with tempdb in SQL Server 2005 2000 Microsoft SQL Server 2000 Index Defragmentation Best Practices SQL Server 2000 I/O Basics SQL Server 2000 Operations Guide KB articles Comparing SQL Collations to Windows Collations Resolving Blocking Problems That Are Caused by Lock Escalation in SQL Server To Identify the Cause of Recompilation in an SP:Recompile Event SQL Blocking Due to [[COMPILE]] Locks Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability Troubleshooting Stored Procedure Recompilation Troubleshoot the Performance of Ad-Hoc Queries How to monitor blocking in SQL Server 2005 and in SQL Server 2000 Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage How to configure SQL Server to use more than 2 GB of physical memory Large memory support is available in Windows Server 2003 and in Windows 2000 Job to Monitor SQL Server 2000 Performance and Activity How to View SQL Server 2000 Blocking Data How to View SQL Server 2000 Activity Data To View SQL Server 2000 Performance Data New Concurrency and Scheduling Diagnostics Added to SQL Server Concurrency Enhancements for the Tempdb Database Description of the waittype and lastwaittype columns in the master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005