DC's Weblog

Some more SQL Server 2005 pointers

deepakc — Thu, 22 Jun 2006 10:39:00 GMT

Whitepapers

Forcing Query Plans
http://www.microsoft.com/technet/prodtechnol/sql/2005/frcqupln.mspx

Working with TempDB
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc

Physical Database Storage
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/PhysDBStor.doc

An Overview of SQL Server 2005 for the Database Developer

Processing XML Showplans Using SQLCLR in SQL Server 2005

Using CLR Integration in SQL Server 2005

XML Support in Microsoft SQL Server 2005

XML Options in Microsoft SQL Server 2005

What's New in FOR XML in Microsoft SQL Server 2005

XML Best Practices for Microsoft SQL Server 2005

Usage Scenarios for SQL Server 2005 Native Web Services

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR

Knowledge Base - SQL Server 2005 Clustering

Best practices for setting up domain groups when you install a SQL Server 2005 cluster
http://support.microsoft.com/kb/915846

Clustered SQL Server do's, don'ts, and basic warnings

http://support.microsoft.com/kb/254321

TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using Microsoft Virtual Server
http://support.microsoft.com/kb/891798

The Microsoft SQL Server support policy for Microsoft Clustering
http://support.microsoft.com/kb/327518

How to install SQL Server 2005 Analysis Services on a failover cluster
http://support.microsoft.com/kb/910230

How to use the Add or Remove Programs item in Control Panel to add or remove components for stand-alone installations and clustered installations of SQL Server 2005
http://support.microsoft.com/kb/922670

How to manually re-create the resource-specific registry keys for SQL Server cluster resources
http://support.microsoft.com/kb/810056

How to run the SQLdiag utility on a clustered instance of SQL Server or on virtual SQL Server
http://support.microsoft.com/kb/233332

How to impede Windows NT administrators from administering a clustered instance of SQL Server
http://support.microsoft.com/kb/263712

How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005
http://support.microsoft.com/kb/917825

How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed
http://support.microsoft.com/kb/295732

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005
http://support.microsoft.com/kb/909801

You must specify the domain groups for the clustered SQL Server services when you install a SQL Server 2005 failover cluster
http://support.microsoft.com/kb/910708

You receive error messages when you try to set up a clustered instance of SQL Server 2005
http://support.microsoft.com/kb/910851

You receive an "Invalid Class String" error when SQL Server connects to a Cluster Server through the Cluster Administrator
http://support.microsoft.com/kb/298147

You may receive a connection error message when you try to connect to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed after you installed SQL Server 2005
http://support.microsoft.com/kb/905618

You receive a "SQL Server does not exist or access denied" error message when you try to connect to a SQL Server named instance in a cluster by using TCP/IP sockets
http://support.microsoft.com/kb/888228

The SQL Server service cannot start when you change a protocol parameter for a clustered instance of SQL Server 2000 or of SQL Server 2005 to a value that is not valid
http://support.microsoft.com/kb/912397

The SQL Server 2005 Setup program does not remove all IP address clusterresources when you uninstall SQL Server 2005
http://support.microsoft.com/kb/922209

Migrate a SQL Server 2000 Analysis Services cluster to a SQL Server 2005 Analysis Services cluster
http://support.microsoft.com/kb/910233

A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server 2005 or in SQL Server 2000 .
http://support.microsoft.com/kb/883732

SQL Server 2000 and SQL Server 2005 support for mounted volumes
http://support.microsoft.com/kb/819546

Failover cluster resource dependencies in SQL Server
http://support.microsoft.com/kb/835185

Error message when you install SQL Server cluster on Windows Server 2003-based computers where Terminal Services is installed: "Setup failed to perform required operations on the cluster nodes"
http://support.microsoft.com/kb/301520

Error message when you change the SQL Server service account for a clustered instance of SQL Server 2005: "The system cannot find the file specified."
http://support.microsoft.com/kb/915698

Error message when you install a SQL Server 2005 failover cluster on a node: "The drive specified cannot be used for program location"
http://support.microsoft.com/kb/913815

Error message when you change the IP address on a SQL Server failover cluster node: "Bind failed"
http://support.microsoft.com/kb/319578

Error message when you run SQL Server Setup on a failover cluster: "Setup failed to perform required operations on the cluster nodes"
http://support.microsoft.com/kb/818548

BUG: The cluster setup may fail when you try to upgrade SQL Server 2005 to SQL Server 2005 Service Pack 1
http://support.microsoft.com/kb/917410

BUG: Installation may fail, and you may receive an error message when you try to install SQL Server 2005 64-bit on a 64-bit server
http://support.microsoft.com/kb/907261

SQL Server 2005 Readme and installation requirements
http://support.microsoft.com/kb/910228

Changes to the readme file for SQL Server 2005
http://support.microsoft.com/kb/907284

Knowledge base - Miscallaneous
BUG: The query does not use the indexed view in SQL Server 2005 Enterprise Edition
http://support.microsoft.com/kb/912389

The part of a script that is defined on an indexed view is not generated when you script an SMO object that is related to the indexed view in SQL Server 2005
http://support.microsoft.com/kb/918480

How to populate a SQL Server 2005 database by using information from Active Directory
http://support.microsoft.com/kb/319716

Miscellaneous

MSDN SQL Server Developer Center

MSDN On-demand Webcasts

MSDN Live Webcasts

SQL Server 2005 Hands-On Labs

SQLCLR Hands-On Lab Manual

Microsoft SQL Server TechCenter on TechNet

SQL Server 2005 Resources

deepakc — Thu, 22 Jun 2006 10:22:00 GMT

Thanks very much to all who attended our SQL Server 2005 sessions at TechEd India 2006. I remember many attendees asking for the links on the resources slides of both sessions - so I thought it would be convenient to put it here. Cheers - DC

SQL Server 2005 – Operations
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx

Whitepapers
Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
Statistics Used by the Query Optimizer in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
SQL Server 2000 I/O Basics
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

Webcasts
Troubleshooting Performance Problems In SQL Server 2005
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275646&EventCategory=5&culture=en-US&CountryCode=US
Performance Diagnosis in SQL Server 2005
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275586&EventCategory=5&culture=en-US&CountryCode=US
Suportability features for SQL Server 2005
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275593&EventCategory=5&culture=en-US&CountryCode=US

PASS 2005 PSS Service Center Labs
http://www.microsoft.com/downloads/details.aspx?FamilyID=9b8098a7-e75f-462a-b296-e80199c9f323&displaylang=en

Blogs
SQLCAT: http://blogs.msdn.com/sqlcat
WINCAT: http://blogs.msdn.com/wincat
Slava Oks’ blog: http://blogs.msdn.com/slavao

Product Feedback
http://lab.msdn.microsoft.com/productfeedback/

External Links:
NUMA FAQ: http://lse.sourceforge.net/numa/faq

Books:
Inside Microsoft SQL Server 2005: Query Processing and Optimization (Vol 3)
The Guru's Guide to SQL Server Architecture and Internals (SQL Server 2000)

Helpful SQL Server 2000 pointers

deepakc — Thu, 18 May 2006 14:07:00 GMT

Hi All,

Here is a consilidated list of useful SQL Server 2000 links categorized by the appropriate SQL Server 2000 subject area/technology. These links are carefully selected based on our experience and have proved extremely useful for us as well as our customers. This has generated rave reviews internally as well as on the field and I hope you find it useful as well :)

Blocking/Deadlocks
224453 INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems http://support.microsoft.com/?id=224453
832524 SQL Server technical bulletin - How to resolve deadlocks http://support.microsoft.com/?id=832524
263889 INF: SQL Blocking Due to [[COMPILE]] Locks http://support.microsoft.com/?id=263889
75722 INF: Reducing Lock Contention in SQL Server http://support.microsoft.com/?id=75722
323630 INF: Resolving Blocking Problems That Are Caused by Lock Escalation in http://support.microsoft.com/?id=323630
295108 INF: Incomplete Transaction May Hold Large Number of Locks and Cause http://support.microsoft.com/?id=295108
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375
324885 Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis http://support.microsoft.com/?id=324885
215520 INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level http://support.microsoft.com/?id=215520
48712 INF: Handling Timeouts Correctly in DB-Library http://support.microsoft.com/?id=48712

ADO/OLEDB:
269882 HOWTO: Use ADO to Connect to a SQL Server That Is Behind a Firewall http://support.microsoft.com/?id=269882
183059 PRB: ODBC Syntax Required for Retrieving Parameter Information http://support.microsoft.com/?id=183059
229564 PRB: SQL Application Role Errors with OLE DB Resource Pooling http://support.microsoft.com/?id=229564
262447 HOWTO: Persist/Load OLE DB Rowset to/from XML with ATL OLE DB Consumer http://support.microsoft.com/?id=262447
247931 INF: Authentication Methods for Connections to SQL Server in Active http://support.microsoft.com/?id=247931
190991 HOWTO: Trap for ADO Connection Errors Using WithEvents http://support.microsoft.com/?id=190991
191572 INFO: Connection Pool Management by ADO Objects Called From ASP http://support.microsoft.com/?id=191572
237844 HOWTO: Enable ODBC Connection Pooling in a Visual Basic ADO Application http://support.microsoft.com/?id=237844
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User http://support.microsoft.com/?id=307002
325338 OLE DB Provider for SQL Server Does Not Cancel a Batch Statement When http://support.microsoft.com/?id=325338
306216 PRB: Error "Unable to Load Communication Module" in ASP/ADO/SQL Server http://support.microsoft.com/?id=306216
253240 PRB: Errors Not Returned When Stored Procedure Statement Fails http://support.microsoft.com/?id=253240

Analysis Services
279489 INF: How to Connect to Analysis Server 2000 By Using HTTP Connection http://support.microsoft.com/?id=279489
294287 INF: How to Automate an Archive or Backup of OLAP Database http://support.microsoft.com/?id=294287
840667 PRB: Unexpected errors with ADO and ADO MD in .NET Framework applications http://support.microsoft.com/?id=840667
301901 INF: TCP Ports Used by OLAP Services when Connecting Through a Firewall http://support.microsoft.com/?id=301901
308023 HOW TO: Cluster SQL Server 2000 Analysis Services in Windows 2000 http://support.microsoft.com/?id=308023
323048 INF: Using Data Definition Language with SQL Server 2000 Analysis http://support.microsoft.com/?id=323048
322706 INF: Microsoft Corp. SQL Server Analysis Services (White Paper) http://support.microsoft.com/?id=322706
325484 Support WebCast: Introduction to XML for Analysis Services http://support.microsoft.com/?id=325484
327396 Support WebCast: Performance Tuning Analysis Services http://support.microsoft.com/?id=327396
324961 Support WebCast: Microsoft SQL Server 2000 Analysis Services: How to http://support.microsoft.com/?id=324961
828343 Support WebCast: Dynamic Dimension Security in Microsoft SQL Server 2000 http://support.microsoft.com/?id=828343
303408 INF: The Impact of Using Changing Dimensions http://support.microsoft.com/?id=303408
306990 INF: When to Create a Virtual Dimension Instead of a Physical Dimension http://support.microsoft.com/?id=306990
322596 INF: Creating Large-Scale, Highly Available OLAP Sites (White Paper) http://support.microsoft.com/?id=322596
322719 INF: Powerful and Accessible Analysis for Business (White Paper) http://support.microsoft.com/?id=322719
231951 INF: Permissions That You Must Have to Administer an OLAP Server http://support.microsoft.com/?id=231951
306408 INF: Use of Multiple Hierarchies Versus the Creation of Separate http://support.microsoft.com/?id=306408

CE:
325229 Support WebCast: Microsoft SQL Server 2000 Windows CE Edition Overview http://support.microsoft.com/?id=325229
273580 HOWTO: Look Up Error Codes Related to SQL Server CE http://support.microsoft.com/?id=273580
814852 INF: How to Enable Encryption Support for SQL Server CE Databases http://support.microsoft.com/?id=814852
320785 HOW TO: Create a Database, a Table, and Run a Query (SQL Server CE http://support.microsoft.com/?id=320785
279552 HOWTO: Delete a SQL Server CE Database in an Application http://support.microsoft.com/?id=279552
279761 HOWTO: Use the ADOCE 3.1 Seek Method with SQL Server CE http://support.microsoft.com/?id=279761
814851 FIX: SQL Server CE Application Fails on Pocket PC 2002 Emulator on http://support.microsoft.com/?id=814851
272210 INFO: System Tables in SQL Server CE Database http://support.microsoft.com/?id=272210
274112 INFO: SQL Server CE Performance Tips and Efficient Memory Handling http://support.microsoft.com/?id=274112
276985 HOWTO: Use SQL Server CE OLE DB Provider-Specific Properties in eVB http://support.microsoft.com/?id=276985
325818 PRB: SQL Server CE 2.0 in Visual Studio .NET 2003 Does Not Support http://support.microsoft.com/?id=325818
301217 HOW TO: Prebuild a Database in SQL Server CE http://support.microsoft.com/?id=301217
814850 INF: Compacting a SQL Server 2000 CE Database by Using Visual Basic .NET http://support.microsoft.com/?id=814850
330971 SQL Server 2000 Windows CE Edition 2.0 for Visual Studio .NET 2003 http://support.microsoft.com/?id=330971
304058 HOWTO: Perform Replication by Using SSCERelay and ActiveSync http://support.microsoft.com/?id=304058
SQL CE FAQ http://support.microsoft.com/default.aspx?scid=/support/sql/content/sqlce/sqlcefaq.asp
CE Main Page http://www.microsoft.com/sql/CE/default.asp
SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices
http://msdn.microsoft.com/msdnmag/issues/01/06/sqlce/default.aspx
Troubleshooting Microsoft SQL Server 2000 Windows CE Edition Connectivity Issues
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_troubleconnect.asp" \o "http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_troubleconnect.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_troubleconnect.asp
Pocket PC 2002 SDK
http://www.microsoft.com/downloads/details.aspx?FamilyId=2DBEE84A-BD94-4167-B817-2B2E548B2E92&displaylang=en
323143 FIX: SQL Server CE Is Missing Oledb.lib File for eMbedded Visual C++ 4.0 http://support.microsoft.com/?id=323143

Clustering:
SQL Server Books Online (BOL)
SQL Server 2000 Clustering Whitepaper, http://www.microsoft.com/SQL/techinfo/administration/2000/failovercluster.asp
815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server http://support.microsoft.com/?id=815431
327322 PRB: SQL Server 2000 Enterprise Manager Polling May Cause ClientToken http://support.microsoft.com/?id=327322
325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup http://support.microsoft.com/?id=325485
274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for All.... http://support.microsoft.com/?id=274446
233332 INF: How To Run SQLDIAG On a Clustered/Virtual SQL Server http://support.microsoft.com/?id=233332
254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings http://support.microsoft.com/?id=254321
243218 INF: Installation Order for SQL Server 2000 Enterprise Edition http://support.microsoft.com/?id=243218
260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering http://support.microsoft.com/?id=260758
319723 INF: Kerberos Support for SQL Virtual Servers on Server Clusters http://support.microsoft.com/?id=319723
307336 INF: How to Change a Clustered SQL Server Network Name http://support.microsoft.com/?id=307336
239885 INF: How to Change Service Accounts on a SQL Virtual Server http://support.microsoft.com/?id=239885
244980 HOWTO: Change the Network IP Addresses on a Virtual SQL Server http://support.microsoft.com/?id=244980
319016 HOW TO: Change Domains for a SQL Server 2000 Failover Cluster http://support.microsoft.com/?id=319016
304282 PRB: Full Text Resource Fails to Come Online on a Cluster with "Event ID... http://support.microsoft.com/?id=304282
270126 PRB: How to Manage Client Connectivity to Both SQL Server 2000 Virtual http://support.microsoft.com/?id=270126
298723 BUG: SQL Mail Not Fully Supported for Use in Conjunction with Cluster http://support.microsoft.com/?id=298723" \o "http://support.microsoft.com/?id=298723http://support.microsoft.com/?id=298723
815431 PRB: You Cannot Successfully Install a Named Instance of SQL Server 2000 http://support.microsoft.com/?id=815431
305793 How to Replace a Disk That Is on a Windows 2000 or a Windows 2003 Server http://support.microsoft.com/?id=305793
216964 How to Administer a Server Cluster Remotely http://support.microsoft.com/?id=216964
168801 How to Turn On Cluster Logging in Microsoft Cluster Server http://support.microsoft.com/?id=168801
278007 Available Features in Windows Server 2003 Clusters http://support.microsoft.com/?id=278007
258750 Recommended Private "Heartbeat" Configuration on a Cluster Server http://support.microsoft.com/?id=258750

Connectivity:
812817 Support WebCast: Microsoft SQL Server 2000: Troubleshooting Connectivity http://support.microsoft.com/?id=812817
324608 Support WebCast: Troubleshooting Database Connectivity Issues in http://support.microsoft.com/?id=324608
270126 PRB: How to Manage Client Connectivity to Both SQL Server 2000 Virtual http://support.microsoft.com/?id=270126
138541 HOW TO: Odbcping.exe to Verify ODBC Connectivity to SQL Server http://support.microsoft.com/?id=138541
293107 PRB: TCP\IP Port in Use by Another Application http://support.microsoft.com/?id=293107
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access http://support.microsoft.com/?id=328306
811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message http://support.microsoft.com/?id=811889

Disaster Recovery:
325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and Restore http://support.microsoft.com/?id=325257
Designing a Backup and Restore Strategy, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_63eh.asp
829024 INFO: Microsoft SQL Server 2000 Operations Guide http://support.microsoft.com/?id=829024
307775 INF: Disaster Recovery Articles for Microsoft SQL Server http://support.microsoft.com/?id=307775
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836

DTS:
269074 INF: How to Run a DTS Package as a Scheduled Job http://support.microsoft.com/?id=269074
316043 HOW TO: Log Data Transformation Services Package Execution to a Text File http://support.microsoft.com/?id=316043
240221 HOW TO: Handle Errors in Data Transformation Services "Package" and.... http://support.microsoft.com/?id=240221
221193 HOW TO: Install Data Transformation Services (DTS) Event Handlers in.... http://support.microsoft.com/?id=221193
241249 HOW TO: Obtain a List of DTS Packages http://support.microsoft.com/?id=241249
249236 HOW TO: Return Multiple Columns in a DTS Lookup Query http://support.microsoft.com/?id=249236
315661 HOW TO: Run a SQL Server Data Transformation Services Package from.... http://support.microsoft.com/?id=315661
319951 HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation http://support.microsoft.com/?id=319951
323685 HOW TO: Troubleshoot DTS Packages That You Run from Visual Basic http://support.microsoft.com/?id=323685
321525 HOW TO: Use DTS Package Events in Visual Basic .NET http://support.microsoft.com/?id=321525
242543 INF: DTS Row Level Restartability After an Unexpected Failure http://support.microsoft.com/?id=242543
239454 INF: ScriptPkg Tool Generates DTS Object Model Code to Help Use DTS http://support.microsoft.com/?id=239454
286124 INF: How to Reschedule a DTS Package http://support.microsoft.com/?id=286124
252987 INF: Execute a SQL Server DTS Package from Active Server Pages http://support.microsoft.com/?id=252987
http://www.sqldts.com (not a Microsoft affiliated site)

Log Shipping:
314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping http://support.microsoft.com/?id=314515
323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White Paper) http://support.microsoft.com/?id=323135
325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping http://support.microsoft.com/?id=325220
821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping http://support.microsoft.com/?id=821786
321247 HOW TO: Configure Security for Log Shipping http://support.microsoft.com/?id=321247
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync" Errors http://support.microsoft.com/?id=329133

Move a Database:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach http://support.microsoft.com/?id=224071
221465 INF: Using the WITH MOVE Option with the RESTORE Statement http://support.microsoft.com/?id=221465
240872 HOW TO: Resolve Permission Issues When You Move a Database Between http://support.microsoft.com/?id=240872
246133 INF: How To Transfer Logins and Passwords Between SQL Servers http://support.microsoft.com/?id=246133
274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL http://support.microsoft.com/?id=274463
168001 PRB: User Logon and/or Permission Errors After Restoring Dump http://support.microsoft.com/?id=168001
264474 PRB: System Database Backups Cannot be Restored on a Different Build of http://support.microsoft.com/?id=264474
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836

MSDE:
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) http://www.microsoft.com/sql/msde
815013 HOWTO: Upgrade an Instance of Microsoft SQL Server 2000 Desktop Engine http://support.microsoft.com/?id=815013
325023 INFO: Upsize SQL Server 2000 Desktop Engine to SQL Server http://support.microsoft.com/?id=325023
325003 HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the http://support.microsoft.com/?id=325003
321518 INFO: When to Choose MSDE 2000 as the Database Engine for Your http://support.microsoft.com/?id=321518
324998 HOW TO: Obtain and Install SQL Server 2000 Desktop Engine (MSDE 2000) http://support.microsoft.com/?id=324998
241397 HOWTO: Back Up a Microsoft Data Engine Database with Transact-SQL http://support.microsoft.com/?id=241397
817788 Support WebCast: Microsoft SQL Server 2000 Desktop Engine (MSDE) http://support.microsoft.com/?id=817788
285097 INF: How to Change the Default Login Authentication Mode to SQL While http://support.microsoft.com/?id=285097
328747 INF: Recovery Planning for Microsoft SQL Server 2000 Desktop Engine http://support.microsoft.com/?id=328747
319930 HOW TO: Connect to Microsoft Desktop Engine http://support.microsoft.com/?id=319930
325022 INFO: MSDE Security and Authentication http://support.microsoft.com/?id=325022
318124 HOW TO: Set Up Development Environment from MSDN Professional http://support.microsoft.com/?id=318124
322336 HOW TO: Verify and Change the MSDE System Administrator Password http://support.microsoft.com/?id=322336

Performance References:
Inside SQL Server 2000 by Kalen Delaney http://www.insidesqlserver.com
The Guru's Guides (Transact-SQL, Architecture and Internals, Stored Procedures and XML) http://www.khen.com/books.htm
224587 INF: Troubleshooting Application Performance with SQL Server http://support.microsoft.com/?id=224587
243586 INF: Troubleshooting Stored Procedure Recompilation http://support.microsoft.com/?id=243586
298475 INF: Information Required to Successfully Troubleshoot Application http://support.microsoft.com/?id=298475" \o "http://support.microsoft.com/?id=298475http://support.microsoft.com/?id=298475
175658 How To Gather Information for Effective Troubleshooting of Performance http://support.microsoft.com/?id=175658
319942 HOW TO: Determine Proper SQL Server Configuration Settings http://support.microsoft.com/?id=319942
297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5 http://support.microsoft.com/?id=297864
314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO http://support.microsoft.com/?id=314648
311826 INF: Index Tuning Wizard Best Practices http://support.microsoft.com/?id=311826
Index Tuning Wizard 2000, http://msdn.microsoft.com/library/techart/itwforsql.htm
Index Tuning Wizard 7.0, http://msdn.microsoft.com/library/techart/msdn_sqlindex.htm
Troubleshooting the Index Tuning Wizard, http://msdn.microsoft.com/library/psdk/sql/tr_servtools_48ro.htm
195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work http://support.microsoft.com/?id=195565
197297 INF: Comparison of Join Techniques http://support.microsoft.com/?id=197297
324692 Support WebCast: How to Collect and Analyze Performance Data in http://support.microsoft.com/?id=324692
325263 Support WebCast: SQL Server 2000 Profiler: What's New and How to http://support.microsoft.com/?id=325263
815337 Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in http://support.microsoft.com/?id=815337
283886 HOW TO: View SQL Server 2000 Performance Data http://support.microsoft.com/?id=283886
139609 PerfMon: High Number of Pages/Sec Not Necessarily Low Memory http://support.microsoft.com/?id=139609
268343 Umdhtools.exe: How to Use Umdh.exe to Find Memory Leaks http://support.microsoft.com/?id=268343
286350 HOWTO: Use Autodump+ to Troubleshoot "Hangs" and "Crashes" http://support.microsoft.com/?id=286350
316365 INFO: ROADMAP for How to Use the .NET Performance Counters http://support.microsoft.com/?id=316365
150934 How to Create a Performance Monitor Log for NT Troubleshooting http://support.microsoft.com/?id=150934" \o "http://support.microsoft.com/?id=150934http://support.microsoft.com/?id=150934
130926 Using Performance Monitor to Identify a Pool Leak http://support.microsoft.com/?id=130926
146005 Optimizing Windows NT for Performance http://support.microsoft.com/?id=146005
248345 How to Create a Log Using System Monitor in Windows 2000 http://support.microsoft.com/?id=248345
275685 INF: Importing Performance Monitor Logs into SQL Server http://support.microsoft.com/?id=275685

Replication:
Replication Overview http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp
315642 INF: Information That PSS Needs to Troubleshoot SQL Server Replication http://support.microsoft.com/?id=315642
312292 HOW TO: Enable Replication Agents for Logging to Output Files in SQL http://support.microsoft.com/?id=312292" \o "http://support.microsoft.com/?id=312292http://support.microsoft.com/?id=312292
321822 HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted http://support.microsoft.com/?id=321822
320499 HOW TO: Manually Synchronize Replication Subscriptions by Using Backup http://support.microsoft.com/?id=320499
320123 HOW TO: Add Columns in a Rollup Subscriber Topology http://support.microsoft.com/?id=320123
321176 HOW TO: Set Up Alternate Synchronization Partner in SQL Server 2000 http://support.microsoft.com/?id=321176
323046 INF: Transactional Replication Performance Tuning and Optimization http://support.microsoft.com/?id=323046
322324 INF: Transactional Replication Performance Tuning and Optimization http://support.microsoft.com/?id=322324
241149 INF: How to Automate Replication over a Dial-Up Connection http://support.microsoft.com/?id=241149
291001 INF: How to Use sp_scriptdynamicupdproc to Improve the Performance of http://support.microsoft.com/?id=291001
305127 PRB: How to Generate a Snapshot of a Published Table and Apply It to the http://support.microsoft.com/?id=305127
285106 PRB: SQL Server Enterprise Manager Reports That the Replication Agent Is http://support.microsoft.com/?id=285106
304535 PRB: ANSI Warnings May Incorrectly Show Replication Agents As Failed http://support.microsoft.com/?id=304535
301217 HOW TO: Prebuild a Database in SQL Server CE http://support.microsoft.com/?id=301217
324992 HOW TO: Use Replication with SQL Server 2000 Desktop Engine (MSDE 2000) http://support.microsoft.com/?id=324992
303789 INFO: Using MSDE 2000 With SQL Server CE RDA and Replication http://support.microsoft.com/?id=303789

Merge Replication
322233 INF: Diagnosing and Troubleshooting Slow Partitioned Merge Replication http://support.microsoft.com/?id=322233
325120 Support WebCast: Microsoft SQL Server 2000: Merge Replication http://support.microsoft.com/?id=325120
315521 INF: How to Troubleshoot SQL Server Merge Replication Problems http://support.microsoft.com/?id=315521
322910 INF: Managed Range Identities in Merge Replication http://support.microsoft.com/?id=322910
307356 INF: Understanding Merge Replication Article Processing Order http://support.microsoft.com/?id=307356
315514 INF: Understanding Merge Replication Conflict Detection and Resolution http://support.microsoft.com/?id=315514
319646 HOW TO: Program the SQL Merge Control by Using Visual C# .NET http://support.microsoft.com/?id=319646
309400 FIX: Merge Replication Non-Convergence Fixes in SQL Server 2000 SP2 http://support.microsoft.com/?id=309400

Security:
Security Resources http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp
10 Steps to Help Secure SQL Server 2000 http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp
322712 Microsoft SQL Server 2000 SP3 Security Features and Best Practices http://support.microsoft.com/?id=322712
SQL Server 2000 Administrator's Pocket Consultant: SQL Server 2000 Security http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspx" \o "http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspxhttp://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspx
813944 SQL Server 2000 Security Tools http://support.microsoft.com/?id=813944
309422 INF: Consideration for a Virus Scanner on a Computer That Is Running SQL http://support.microsoft.com/?id=309422
829024 INFO: Microsoft SQL Server 2000 Operations Guide http://support.microsoft.com/?id=829024
SQL Server 2000 C2 Administrator's and User's Security Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx
SQL Server 2000 Resource Kit, Chapter 10--Implementing Security http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1061.mspx
817384 HOWTO: Use Kerberos Authentication for Microsoft SQL Server 2000 http://support.microsoft.com/?id=817384
Troubleshooting Kerberos Delegation White Paper http://www.microsoft.com/downloads/details.aspx?FamilyID=99b0f94f-e28a-4726-bffe-2f64ae2f59a2&displaylang=en
811889 How to troubleshoot the "Cannot generate SSPI context" error message http://support.microsoft.com/?id=811889
Download the latest version of books online: (303839 Updates to SQL Server Books Online for SQL Server 2000 http://support.microsoft.com/?id=303839). Sample topics from SQL Server 7.0/2000 Books Online (BOL): Managing Security, Planning Security, Security Architecture, Security Audit Event Classes, Password Protection, Authentication Modes, Replication Security, Security and Authentication Permissions

SQL Mail:
321183 HOW TO: Troubleshoot Your SQL Mail Issue http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail http://support.microsoft.com/?id=311231
263556 INF: How to Configure SQL Mail http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems http://support.microsoft.com/?id=315886
Per SQL Server 2000 Books Online: "SQL Server uses two services to handle mail. MSSQLServer processes mail for all of the mail stored procedures. SQLServerAgent does not use SQL Mail to send e-mail. Instead, SQLServerAgent uses its own mail capabilities that are configured and operated separately from SQL Mail."
Per SQL Server 2000 Books Online regarding the DTS Send Mail task (which does not use SQL Mail or SQL Agent Mail): "With the Send Mail task, you can send an e-mail message as a task. For example, if you want to notify a database administrator about the success or failure of a backup operation, you can link a Send Mail task to the preceding backup task. To use a Send Mail task, you need to install MAPI with a valid user profile on the instance of Microsoft® SQL Server™ you are running."

SSL Encryption:
314636 FIX: Cannot Use Non-Administrator Account to Start SQL Server and Force.... http://support.microsoft.com/?id=314636
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server http://support.microsoft.com/?id=276553
322144 SECDoClientHandShake Cannot Connect to SQL Server http://support.microsoft.com/?id=322144
257591 Description of the Secure Sockets Layer (SSL) Handshake http://support.microsoft.com/?id=257591
316898 HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft.... http://support.microsoft.com/?id=316898
324777 WebCast: Microsoft SQL Server 2000: How to Configure SSL Encryption http://support.microsoft.com/?id=324777
318605 INF: How SQL Server Uses a Certificate When the Force Protocol http://support.microsoft.com/?id=318605
325757 INF: Using SQL Server 2000 with FIPS 140-1 Ciphers http://support.microsoft.com/?id=325757
302409 FIX: Unable to Connect to SQL Server 2000 When Certificate Authority.... http://support.microsoft.com/?id=302409
311111 FIX: RPC Clients Unable to Login to SQL Server with Windows.... http://support.microsoft.com/?id=311111

Stored Procedures:
The Guru's Guides (Transact-SQL, Architecture and Internals, Stored Procedures and XML) http://www.khen.com/books.htm
262499 INF: Using Output Parameters with sp_executesql http://support.microsoft.com/?id=262499
183001 Retrieving Output Parameters From Stored Procedure http://support.microsoft.com/?id=183001
152174 INF: Output Parameters, Return Codes and the ODBC Driver http://support.microsoft.com/?id=152174
811482 INF: Handling SQL Server Error Messages When a Stored Procedure is Used http://support.microsoft.com/?id=811482
321903 HOW TO: Return Errors and Warnings from a SQL Server Stored Procedure in http://support.microsoft.com/?id=321903
321902 HOW TO: Call Stored Procedures with Optional Values in ADO.NET http://support.microsoft.com/?id=321902
300488 HOWTO: Run SQL Server Stored Procedures from an ASP Page http://support.microsoft.com/?id=300488
245179 HOWTO: Process Multiple Recordsets and Messages in ADO http://support.microsoft.com/?id=245179
306574 HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual http://support.microsoft.com/?id=306574
310070 HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and http://support.microsoft.com/?id=310070
310130 HOW TO: Execute SQL Parameterized Stored Procedures by Using the ODBC http://support.microsoft.com/?id=310130
311274 HOW TO: Handle Multiple Results by Using the DataReader in Visual C# .NET http://support.microsoft.com/?id=311274
310650 INFO: Known Issues with the Visual Basic T-SQL Debugger and SQL Server http://support.microsoft.com/?id=310650
243428 HOW TO: Move Extended Stored Procedures Out of Process http://support.microsoft.com/?id=243428

Transaction Logs:
873235 How to stop the transaction log of a SQL Server database from growing http://support.microsoft.com/?id=873235
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375
272318 INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC http://support.microsoft.com/?id=272318
256650 INF: How to Shrink the SQL Server 7.0 Transaction Log http://support.microsoft.com/?id=256650
315512 INF: Considerations for Autogrow and Autoshrink Configuration http://support.microsoft.com/?id=315512
307487 HOW TO: Shrink the Tempdb Database in SQL Server http://support.microsoft.com/?id=307487
281122 INF: Restore File and Filegroup Backups in SQL Server http://support.microsoft.com/?id=281122
303229 PRB: Transaction Log Backup Job Created with Database Maintenance http://support.microsoft.com/?id=303229
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836
272093 INF: Effects of Nonlogged and Minimally Logged Operations on Transaction http://support.microsoft.com/?id=272093
286280 INF: Effect of Database File Additions or Deletions on Database Recovery http://support.microsoft.com/?id=286280
230785 INF: SQL Server 7.0 and SQL Server 2000 Logging and Data Storage http://support.microsoft.com/?id=230785

Transaction Units:
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375
198024 INFO: Understanding ADO Transactions with MS SQL Server http://support.microsoft.com/?id=198024
238163 HOWTO: Implement Nested Transactions with ADO and SQL Server http://support.microsoft.com/?id=238163
295108 INF: Incomplete Transaction May Hold Large Number of Locks and Cause http://support.microsoft.com/?id=295108
295027 INF: Limited Support for Savepoint in Distributed Transactions in SQL http://support.microsoft.com/?id=295027

Windows 2003
815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server http://support.microsoft.com/?id=815431
329329 PRB: Windows Server 2003 Support for SQL Server 2000 http://support.microsoft.com/?id=329329
815430 INF: How to Suppress the Appshelp Message in an Unattended Installation http://support.microsoft.com/?id=815430
817064 HOW TO: Enable Network DTC Access in Windows Server 2003 http://support.microsoft.com/?id=817064
301520 SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based http://support.microsoft.com/?id=301520
313037 INF: Upgrading SQL Server Clusters to Windows Server 2003 http://support.microsoft.com/?id=313037
327270 SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server http://support.microsoft.com/?id=327270
811430 INF: SQL Server 2000 Supports IPSec on Windows Server 2003 Cluster http://support.microsoft.com/?id=811430
281662 Windows 2000 and Windows Server 2003 Cluster Nodes As Domain Controllers http://support.microsoft.com/?id=281662
Windows Server 2003 Clustering Services http://www.microsoft.com/windowsserver2003/technologies/clustering/default.mspx
821751 INFO: Availability of Windows Server 2003 COM+ 1.5 Rollup Package 1 http://support.microsoft.com/?id=821751