SQL Server 2008
Indexing in SQL Server 2008 -Memory Optimization Tricks
By default, SQL Server 2008 dynamically manages the amount of memory allocated for index creation operations. If further memory is required for creating indexes, and the memory is obtainable based on the server memory configuration settings, the server will allocate additional memory for index creation operations. If extra memory is required but not available,... »
Installing SQL Server 2008 -A Step by Step Guide
SQL Server 2008 is relatively easy to install, but it does take a little knowledge of the process and a little planning. For most shops the planning phase can be minimal but there will be instances (like clustering) when you’ll need to plan quite a bit. This will not be one of those cases.... »
New SQL Server Utility and Utility Control Points in SQL Server 2008 R2
SQL Server Utility is a central repository for Database Engine instances that helps you collect performance data. Every instance of SQL Server Utility has a single control point that you must create. A control point is the central collection point for SQL Server Utility and is used to view performance information collected from managed instances... »


