(Muthusamy Anantha Kumar) In part I of this article, we saw how to generate row numbers and delete a simple single duplicate row. This article walks you through how to delete multiple duplicate rows. This article uses the new feature Row_Number() function, common table expression and the ANSI co-rel

(Serdar Yegulalp) Most of us are by now familiar with external hard drives that attach to a computer through a USB 2.0 or 1394 interface. The prices on these units have stayed stable or dropped slightly, while the amount of storage available in the average drive has exploded — up to 250 GB or more.

(Arthur Fuller) If you install SQL Server 2005 simply by using the defaults, you’ll notice that the AdventureWorks database is not installed. Since many of the tutorials and examples rely on it, it’s important that you find and install the AdventureWorks database. This article explains where to obta

This article will explain how to use the new SQL Server Management Studio to perform basic SQL Server administration task. In particular, it introduces you to SQL Server Workbench, a tool which can help you administer one or more SQL Servers. It can be used for certain other functions as well.

(William Pearson) Authoring reports in Reporting Services is largely dependent upon the process of associating controls within the report body with fields that are created within one or more Datasets within the report file. While this is standard operational procedure, and is easily accomplished

(Scott Lowe) One of Microsoft’s most long-awaited releases, SQL Server 2005 has finally hit the market and brought with it significant new features and changes from previous versions.

(Jacques Surveyer) SQL Server 2005 crosses all the “-ties” — security, reliability, scalability, usability and manageability — as Microsoft completes the migration of SQL Server from a work-group database to a nearly enterprise-caliber platform. The problems, as we shall see below, are that Micros

IBM Director Server supports a variety of different databases running locally on the management server, as well as external databases running on other systems. The management server uses these databases to store inventory information. This Technote describes how to set up Microsoft SQL Server fo

After you use Microsoft Windows Installer 2.0 to apply a Microsoft SQL Server 2000 post Service Pack 4 (SP4) hotfix that is earlier than build 8.0.2156, you may not be able to apply SQL Server 2000 post SP4 build 8.0.2156 or a later build. Typically, this problem occurs when the following conditions

(Greg Robidoux) Having a backup plan in place is half the battle in keeping your SQL Server up and running. The other half involves the restore process. You need to restore SQL Server after a failure, when you need to restore to a standby server or when refreshing a reporting or development environm