Architecture and Design
Learn how to get your SQL Server solution off to a good start with proper architecture and design.
| Inside the SQL Server 2000 User Mode Scheduler Ken Henderson profiles the User Mode Scheduler (UMS) that handles thread scheduling in SQL Server 2000. Learn how UMS provides more control and allows the server to scale better than it could with the Windows scheduler. |
| SQL Server Memory Management Check out the first installment of Ken Henderson's new column, SQL Server for Developers. He gives you the inside look at SQL Server memory management and why you should care about it. |
| Database Design Get an introduction to logical and physical database design using SQL Server 2000. |
| Visual Database Tools Get a list of database design and development tools in the Visual Studio integrated development environment (IDE). Create database objects such as tables, columns, keys, indexes, relationships, constraints, and views using the Database Designer, the Table Designer, and the Query and View Designer. |
| Creating SQL Scripts See how to create scripts for creating and modifying SQL Server objects using the Visual Studio IDE. |
| Documenting and Scripting Databases Get an overview of the benefits of scripting, plus links to the various methods of generating a script for a SQL Server object. |