(Scott Lowe) SQL Server isn’t a product that Microsoft updates very often, so when they do release an upgrade, it has the potential to be significant. As such, there are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently

In SQL Server 2000, you receive an error message when you try to rebuild the master database. This problem occurs when the following conditions are true: • You are running SQL Server 2000 Service Pack 4 (SP4) 64-bit, and you have installed hotfix builds. Note This problem does not occur in SQL

This whitepaper provides information on the fundamental benefits of running SQL Server 2005 on Fujitsu PRIMEQUEST 400 Series Servers. (R)

(Greg Robidoux) The following steps will help you improve the performance of your SQL Server backups. Not every option will be right for your environment, but using as many of these best practices as possible will significantly improve your backup performance. (R)

(Arthur Fuller and Stephen Giles) Microsoft SQL Server 2005 contains a number of major new features, but the feature that we like the most is the SQL Server Management Studio. This tool is leaps and bounds beyond what was available in earlier versions of SQL Server. Here is a list of the 10 things t

When you try to delete records by running a Delete Transact-SQL statement in Microsoft SQL Server 2000, you receive the following error message: Server: Msg 601, Level 12, State 6, Procedure testprocess, Line 7 Could not continue scan with NOLOCK due to data movement.

W.H. Inmon) One of the most effective techniques for ensuring quality in the operational environment is the design review. Through a design review, errors can be detected and resolved prior to coding. The cost benefit of identifying errors early in the development life cycle is enormous. (R)

(William Pearson) In this article, we will continue our examination, begun in Set Functions: The DRILLDOWNMEMBER() Function, of the MDX surrounding drilling up and down within our Analysis Services cubes. As we have noted, drilling up or down occurs along the lines of drilling paths that are defined

Aggregate functions, a staple means of summarizing large volumes of data for serious database developers, are mainly used for generating business data reports. Aggregate functions allow you to retrieve summarized information from a table by operating on a set of data as a whole rather than on each d

After you apply Microsoft Windows Server 2003 Service Pack 1 (SP1), an error occurs when you try to access the Microsoft SQL Server 2000 Analysis Services performance monitor counter object.