Windows 2000 features many enhancements that make it a better database platform than Windows NT 4.0. It's no accident that SQL Server achieved its highest Transaction Processing Performance Council (TPC) TPC-C benchmark scores running on Win2K...
SQL Server 2000 received two awards in late February: Datamation's Product of the Year 2000 for data warehousing and Business Intelligence (BI) and the eWEEK 2001 eXcellence award for enterprise systems development. For the Datamation award...
Microsoft and Unisys announced in late February that SQL Server 2000 running on a Windows 2000 Datacenter Server-based Unisys machine obtained the highest database performance results ever recorded in a Windows environment for SAP's e-commerce...
The Index Tuning Wizard is a tool that accepts a workload of activity against your SQL Server and makes recommendations about creating appropriate indexes for the workload. The input workload can be a trace file or table, among other options. In ...
Editor's Note: Send your SQL Server questions and comments to SQL Server MVP Brian Moran at savvy@sqlmag.com...
Everything your mother didn't tell you about SQL Server data types
Basket analysis is tricky with an OLAP product
Develop your SQL-DMO programming skills in Access projects