If you update any column that is part of a unique or clustered index, SQL Server implements the update as a deferred update. A deferred update means that the UPDATE is sent to the Subscriber as a pair of DELETE and INSERT operations.
Tag: sql server
Software Prevents SQL Database Intrusions
By Tom Smith – Entercept Security Technologies on Monday rounded out its line of intrusion-detection software with a new version of its product designed specifically to thwart common SQL database attacks.
Adjust SQL Server fill factors
By Barrie Sosinsky – One parameter you should always be aware of is SQL Server’s fill factor. The fill factor determines how much of an extent is written to, and how many pages it can accommodate.
Follow the Roadmap for XML and SQL Server
by Lee Thé – Dave Reed, Microsoft’s general manager of Data Access and XML Technologies, talks about Microsoft’s roadmap for XML and SQL Server.
Microsoft Releases Database Tools For Mobile Developers
By Paul McDougall – Microsoft on Monday introduced an updated version of its SQL Server CE database for mobile devices as well as new developer tools to help support the product. The software vendor says SQL Server CE 2.0, which lets users of palmtop and smart-phone devices search and manipulate dat
Using ADO MD with .NET
By Russ Whitney – Developers who are using Visual Studio .NET to develop production applications are discovering .NET and COM interoperability isn’t simple. Here’s how to avoid a couple of common problems when you try to integrate .NET with your existing COM applications.
Save Space To Boost SQL Server Performance
by Neil Boyle – If you have ever looked at an Execution Plan for a SQL Server query (and if you haven’t, you should!) you will see that SQL Server produces an estimated “cost” for executing queries. This cost is not in money terms, obviously, but in terms of computer resources required to run the qu
Meta Data Browser Enhancement
Meta Data Browser is a new tool that you can use to browse the contents of a repository database. This tool is introduced in Microsoft® SQL Server™ 2000 Meta Data Services. You can run Meta Data Browser when you select Meta Data Services. Meta Data Services is available for each copy of SQL Server y
Instant SQL Server 2000 Applications
Book by Greg Buczek – I don’t know about you, but the way I have learned how to develop applications for the real world is to learn by example. I don’t see any point in trying to reinvent the wheel. If someone has already figured out how to do something, then I want to take advantage of that, not ha
SQL Server 2000’s user-defined functions add flexibility, cut coding time
By Martin Reid and Susan Harkins – Microsoft’s SQL Server may be a big dog in the enterprise database market, but its conspicuous lack of user-defined functions (UDFs) has stacked up poorly against other leaders of that pack. Oracle, DB2, and even Access (Microsoft’s desktop database) have offered U
