Useful links from Dan's blog

 

SQL ISV blog: http://blogs.msdn.com/sqlisv

SQL CAT Blog: http://blogs.msdn.com/sqlcat

Best Practices Site: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx

SQL Server AlwaysOn Partner program: http://www.microsoft.com/sql/alwayson/default.mspx

SQL Server Urban Legends: http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

SQL Server 2000 I/O Basics whitepaper: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

Disk Subsystem Performance Analysis for Windows: http://www.microsoft.com/whdc/device/storage/subsys_perf.mspx

Microsoft Windows Clustering: Storage Area Networks: http://www.microsoft.com/windowsserver2003/techinfo/overview/san.mspx

Windows Server System Storage Home: http://www.microsoft.com/windowsserversystem/storage/default.mspx

Microsoft Storage Technologies – Multipath I/O: http://www.microsoft.com/windowsserversystem/storage/technologies/mpio/default.mspx

Windows 2003 Storport Driver: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/storage/hh/storage/portdg_88563b10-e292-48f3-92de-65bf90530455.xml.asp

Virtual Device Interface Specification: http://www.microsoft.com/downloads/details.aspx?FamilyID=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&DisplayLang=en

SQL Server Consolidation on the 64-Bit Platform: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/64bitconsolidation.mspx

SQL Server Consolidation on the 32-Bit Platform using a Clustered Environment: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx

INF: Support for Network Database Files: http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

824190 Troubleshooting Storage Area Network (SAN) Issues: http://support.microsoft.com/?id=824190

304415 Support for Multiple Clusters Attached to the Same SAN Device: http://support.microsoft.com/?id=304415

280297 How to Configure Volume Mount Points on a Clustered Server: http://support.microsoft.com/?id=280297

819546 INF: SQL Server support for mounted volumes: http://support.microsoft.com/?id=819546

304736 How to Extend the Partition of a Cluster Shared Disk: http://support.microsoft.com/?id=304736

325590 How to Use Diskpart.exe to Extend a Data Volume: http://support.microsoft.com/?id=325590

Updated Books Online for SQL Server 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Shared Scalable Database: http://support.microsoft.com/?kbid=910378

Sunil gave us all we need to know and more on the TEMPDB. Check out the whitepaper he references: http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

In addition, do not forget to review Kalen Delaney's book as she goes into detail on the TempDB in her book on the Database Storage Engine.

Source: ...more notes from the field