▼
MSDN Library Visual Studio 6.0
▶
Welcome to the MSDN Library
▶
Visual Studio Documentation
▶
Visual Basic Documentation
▶
Visual C++ Documentation
▶
Visual FoxPro Documentation
▶
Visual InterDev Documentation
▶
Visual J++ Documentation
▶
Visual SourceSafe Documentation
▶
Tools and Technologies
▶
Microsoft Office Development
▶
Platform SDK
▶
SDK Documentation
▶
DDK Documentation
▼
Windows Resource Kits
▼
BackOffice Resource Kit
▶
BackOffice Resource Kit Part 1
▼
BackOffice Resource Kit Part 2
▼
SQL Server Resource Guide
▶
Introduction
▶
Part 1 - Product Guide and Strategies
▶
Part 2 - Understanding SQL Server Architecture and Components
▶
Part 3 - Planning and Implementing Your SQL Server Solution
▶
Part 4 - Maintaining Your SQL Server Solution
▶
Part 5 - Integrating with BackOffice
▶
Part 6 - Programming for Microsoft SQL Server
▶
Part 7 - Data Warehousing
▼
Part 8 - Reference
SQL Server Version History
▼
SQL Server 6.5 and SQL Server 6.0
System Tables
System Stored Procedures
Installation Defaults
FROM Clause and Table Names (*110)
SELECT DISTINCT with ORDER BY (*204)
Permission to Create Foreign Key (*237)
SELECT INTO or CREATE VIEW (*246)
RAISERROR and @@ERROR (*2701 or SETERROR Option)
Backup format
Startup Procedure: sp_sqlregister
Forward-only Cursors (*7502)
Plans for Cursors on Stored Procedures (*7502)
New Service: MS DTC
USE Statement in EXECUTE Resets on Completion
JOIN Syntax and Trace Flag 204
Objects Created in a Transaction
SELECT INTO
ISQL/w Maximum Connections
Global Variables Disallowed in CHECK and DEFAULT Constraints
Books Online
Vbsql.ocx Replaces Vbsql.vbx
Graphical SHOWPLAN
Extended Stored Procedures
Variables
ODBC ANSI Upgrade Changes
Future Concerns
▶
SQL Server 6.0 and SQL Server 4.2x
Reserved Keywords
Reserved Words Not Checked by Chkupg.exe
SQL Server Code Pages
▶
ANSI/OEM Conversion
Estimating Database Size
Calculating the Size of a Table with a Clustered Index
Calculating the Size of a 9,000,000-Row Table with a Clustered Index
Calculating the Size of a Table with a Nonclustered Index
Calculating the Size of a 9,000,000-Row Table with a Nonclustered Index
▶
Other Factors
Locking
▶
Locking in SQL Server 6.5
Locking Behavior of Cursors
▶
Part 9 - Tools
▶
SNA Server Resource Guide
▶
SMS Resource Guide. Supplement 1
▶
Exchange Server Resource Guide, Supplement 1
▶
Windows NT Server 4.0 Resource Kit
▶
Windows NT Workstation 4.0 Resource Kit
▶
Windows 95 Resource Kit
▶
Windows NT 3.51 Resource Kit
▶
Specifications
▶
Knowledge Base
▶
Technical Articles
▶
Backgrounders
▶
Books
▶
Partial Books
▶
Periodicals
▶
Conference Papers