I want to update a large table in 5,000-row batches, but I don’t know how to split up the data. The table doesn’t include an incremental numeric or integer primary key. How can I perform the update while maintaining good performance?

(Patrick Sand) When your SQL Server syntax doesn’t support the MINUS operator for finding the difference between two sets, you can use the following two queries, based on left/right outer joins to do the equivalent. My problem was to find new data (new in the current data but not in the previous mon

This intro to OLAP for developers from SQL Server Magazine shows you how to implement drillthrough and actions in SQL Analysis Services.

By Joe McKendrick – Will Web services ever move from vaporware to reality? Web services has been the “in” topic of vendors’ announcements, analysts’ pronouncements, and trade press articles for some time. While the complete technology architecture has not been implemented in any meaningful way in pr

By Brian Moran – SQL Server 2000 Enterprise Edition (64-bit) might not see the inside of your company anytime soon–if ever. But just the fact that such a powerful version exists is noteworthy.

By Michael Otey – Do you need the extra muscle that the 64-bit version of SQL Server 2000 brings to the table? See what’s new, what’s different, and what’s stayed the same in the latest version of SQL server for the enterprise.

SYWARE, Inc., a leading developer of intuitive, mobile database tools for business and personal productivity, announced sqlceEnable™, a new software tool that allows mobile professionals to create and print custom reports from any Pocket PC or Windows CE device using data from SQL Server CE database

This step-by-step article describes how to upgrade an instance of Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) to SQL Server 2000 Service Pack 3 (SP3).

By Lisa Vaas – Microsoft Corp. edged out Hyperion Solutions to nab the leadership position in the $3 billion OLAP market in 2002, according to the latest edition of The OLAP Report.The biggest single reason for Microsoft’s success is pricing, according to Nigel Pendse, the report’s author.

Alexander Chigrik compares SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits.