If you run an UPDATE statement on the partitioning column of a partitioned view and the UPDATE statement includes an inner join to another table, a scan of each partition table may be performed. This problem occurs although a useful index exists on each table. Depending on the size of each partition
Other News
sp_DisplayDBTriggers :: (Script Library)
Category: Reporting and Analytics for SQL Server Tags: sql reports, sql reporting, sq Compatibility: SQL Server 2000 only Description:
Updating part of a foreign key
(Craig Mullins) I want to update an attribute that is part of a foreign key. I want to change this in both the parent and the child. What is the best way? Dropping the foreign key and afterwards creating it again is an option I do not really like. Maybe rebinds have to be done then? (R)
DB2 version 8 certification: Everything you need to know
(Howard Fosdick) Certification has arrived, no question. But as a DB2 professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? That last thought is key — knowing the inside story on DB2 certification before you proceed will
J2EE Connector Architecture
(Anthony Lai, Jyotsna Laxminarayanan and Lars Ewe) This article discusses some of the challenges of legacy system integration, then introduces the J2EE Connector Architecture (J2EE CA) and explains how it can significantly reduce the problems of integrating your legacy system. It also offers a compr
Bridging the XML divide between US, Europe
(Mark Brunelli) Analysts and veteran software developers say much can be learned about science, culture and history by examining the different attitudes and approaches that Americans and Europeans take toward modern technologies like XML. (R)
O’Reilly Open Source Convention
The O’Reilly Open Source Convention (OSCON) will be held July 26-30, 2004 at the Portland Marriott Downtown in Portland, OR. The theme this year is “Opening the Future: Discover, Develop, Deliver.” Technologists are creating innovations with open source and free software that will change the way
PRB: Errors May Occur When You Use SQL Server 2000 to Save a DTS Package as a Visual Basic File
SQL Server 2000 has the option to save a DTS package to a Visual Basic file. If a Microsoft SQL Server 7.0 package is saved as a Visual Basic file by using SQL Server 2000 tools, it may cause several run-time errors if you execute the Visual Basic script on a computer that has SQL Server 7.0 and Mic
SQL Server 2000 DTS Part 12 – Transactional Support
(Marcin Policht) In the concluding article of this series, we will discuss transaction support in SQL Server 2000 Data Transformation Services. Transactions within DTS packages serve the same purpose as in other SQL Server based operations – they provide the set of features described collectively us
Dump SQL Permissions
(Chad Miller) few years I was troubleshooting an issue with share and NTFS permissions and I ran across a nice little utility called DumpSec from SomarSoft which generates reports on permissions and user accounts for an Windows based system. You can obtain DumpSec from SomarSoft (http://www.systemt