Posted by arlene

SQL Server 2000 introduces the Copy Database Wizard and an enhanced version of the Index Tuning Wizard. Let’s take a look at both of these wizards, starting with the Index Tuning Wizard.
Tuning Indexes
The Index Tuning Wizard will assess your workload and give you suggestions for creating optimal indexes and statistics for your databases. The wizard [...]

Posted by arlene

As you move into a multi-user environment, security, user, and resource management will become key to the performance and integrity of your application. Some of these security features are available on Windows 2000 only.
Understanding Kerberos and Security Delegation
Unfortunately, we cannot take advantage of these new enhancements. We are not running Windows 2000—maybe that’s a good [...]