Microsoft® SQL Server™ 2000 extends the performance, reliability, quality, and ease-of-use of Microsoft SQL Server version 7.0. Microsoft SQL Server 2000 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing

by Doug Kerwin – Learn the basics of how to scale your SQL Server databases.

SQL Server 2000 Enterprise Edition installs SQL Server executables and program files on both of my clustered servers simultaneously. If one of my servers goes down, how can I rebuild the server and reinstall SQL Server on that node?

Most of you have probably created your own SQL Server user-defined functions (UDFs), but did you know that Microsoft ships a fair number of its own UDFs, especially in the most recent SP3? In this article, Baya Pavliashvili and Kevin Kline explore a subset of them that are related to traces.

Don’t miss your opportunity to win recognition for your hard work! Enter the 2003 SQL Server Magazine Innovator Awards competition today. The deadline for entries is August 1, 2003.

By Barbara Darrow – Microsoft has gotten Yukon out the door. Sort of. The company Tuesday dropped the so-called “private beta” of the next-generation SQL Server to some 500 customers and partners, sources close to the company confirmed. Another 1,500 copies are slated for release by the end o

Microsoft adopted a standardized naming schema for all SQL Server hotfix patches or updates that the company creates or distributes.

By Greg Robidoux – In this article, Greg talks about implementing and controlling all aspects of change management in SQL Server.

Q. Why doesn’t SQL Server permit an ORDER BY clause in the definition of a view? A. SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard.

By Brian Moran – Many DBAs forget the performance impact of auto-growing files when managing space for tempdb. (R, $)