(Hilary Cotter) Partitioning is the distribution of a table over multiple subtables that may reside on different databases or servers in order to improve read/write performance. Partitioning is typically done at the table level, and a database is considered partitioned when groups of related tables

When you install 64-bit editions of Microsoft SQL Server 2005, the following 32-bit versions of the following tools are installed: • SQL Server Management Studio • SQL Server Configuration Manager • Database Engine Tuning Advisor

(Bilal Ahmed) The concept of high availability is not limited to the enterprise world anymore. It has already sneaked through the doors of the SMB market, which brings up new potential challenges for DBAs. This paper discusses specifically two out of the many various options available for SQL Server

(Muthusamy Anantha Kumar) We all know the “TOP” clause returns the first n number of rows or percentage of rows thereby limiting the number of resulting rows displayed when we are selecting rows in a table.

(Greg Robidoux) A backup and restore process is critical to protecting your data when a failure occurs. The author identifies common SQL Server backup and recovery worst practices. (R)

Consider the following scenario: • You have a Transact-SQL script. • You configure the Microsoft SQL Server 2000 SQL Server Agent to run this script as a job.

(William Pearson) In this lesson, we will examine another function / property in the MDX toolset, the .UniqueName function. The general purpose of the .UniqueName function is to return the Unique Name of the object to which it is appended. .UniqueName can be used in conjunction with hierarchies, dim

(Douglas Reilly) Itzik Ben-Gan is a writer and mentor in the development community. He writes a monthly column for SQL Server Magazine and co-authored Advanced Transact-SQL for SQL Server 2000 . He is one of the founders of Solid Quality Learning, a global provider of education and solutions for the

(Greg Robidoux) You most likely refresh a development or test environment frequently with a recent production environment backup. Depending on what you are testing or developing, current data may be critical to ensuring your results are valid. Creating an automated task to restore the database regul

Consider the following scenario. You create a query that uses the UNION ALL operator more than 255 times. You submit this query from a client application to Microsoft SQL Server 2000. In this scenario, a stack overflow exception may occur, and SQL Server unexpectedly closes. When this problem occurs