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.
Other News
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.
Transform Data With XslTransform
by Randy Holloway – The XslTransform class enables you to leverage XML data in .NET apps by implementing XSLT transformations. You can find XslTransform in the System.Xml.Xsl namespace.
Documenting DTDs I: dtd2html
Documenting one’s deeds is usually not high priority for developers, and Web developers are no exception. Alas, once you have to look again at stuff you’ve done weeks or months ago, the usefulness of documentation becomes apparent.
Euro-XML
by Rick Jelliffe – The new European currency, the euro, has a symbol € in Unicode 3.2 as character U+20AC. How can we use it with XML?There are three ways of representing the euro in XML:
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
Six JDBC Tips for Enterprise Web Applications
By William C. R. Crawford – These simple guidelines can help you boost the performance of your Java applications. This article won’t discuss the specifics of JDBC or servlets in detail. If you’ve already learned the APIs themselves, the information here will help you apply them effectively. I
Adding Columns in a Synchronous Multi-Master Replicated Environment
So you find yourself in a synchronous multi-master replicated environment under Oracle 8i and need to add a column to a table. Greg Johnson’s step-by-step guide makes the process as painless as possible.
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