No, but autogrowth of data files blocks allocations of new extents because SQL Server blocks changes to the allocation pages, which keep track of which extents in the file are in use, during autogrowth.
Author: SSWUG Research
Build Your Own Lightweight XML DOM Parser
Microsoft’s MSXML parser is rich in functionality, but in some cases a full-featured parser is too large for resource-limited environments. Don’t count XML out yet though; you can write your own lightweight VB XML parser in fewer than 400 lines of code!
Vendors update XML for Analysis
By Joris Evers – Version 1.1 of the XMLA specification is the first version of the specification created in conjunction with the members of the XMLA Advisory Council, a group of business intelligence software vendors that back XMLA, according to a statement from Microsoft, Hyperion, and SAS.
XML Spy Tops as XML Editor
By Timothy Dyck – Altova GMBH’s XML Spy has long been a strong player in the XML space, and Version 5 of the XML editor raises the bar even higher. Of all the XML editors eWEEK Labs has seen—and we’ve seen a lot—the $990 XML Spy 5.0 Enterprise Edition provides the best overall combination of editing
Create and Modify SQL Server Indexes Properly
by Drew Georgopulos – Learn how to determine the state of your indexes and understand whether that state should be changed. See how evaluating the construction and location of your system’s indexes and deciding whether to adjust their fill factors and padding can improve the system’s performance.
Script to back up database controlfile
By MICHAEL DINH – The script will enable DBAs to backup the database controlfile in binary and ASCII format. When a DBA issues the command “alter database backup controlfile to trace;”, the result is a trace file written to the location defined by USER_DUMP_DEST, similar to mdl1_ora_25524.trc (which
Mixed Message for Oracle Users
When Oracle CEO Larry Ellison delivered his OracleWorld keynote this month via satellite while sailing off New Zealand, it suggested a desire on his part to be the center of customers’ attention without going out of his way to be in touch with them. We hope some of the other developments we noted du
HOWTO: Retrieve XML Data with an XPath Query in an ASP Client
This article demonstrates how to retrieve an eXtensible Markup Language (XML) data stream from a SQL Server 2000 mapping schema by using an XPath query for an Active Server Pages (ASP) client.The sample also allows you to test XPath queries against the mapping schema. Two methods are used to
SOAP Faces a New Challenger
By Darryl K. Taft – A new development approach to Web services transport is giving users of the popular Simple Object Access Protocol pause and could place some at a development crossroads.
XML document generator
By Shailesh Yagnik – Output in XML format is very useful for data tranformation in internet-based applications. In general, if you have XML formatted data then it is easier to convert it to any other format. Using a new package in Oracle 9i allows you to create a XML document from a SQL query. The f