by Justin Gunther As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM cla
Other News
XSLDebugger v2: Start
Version 2.0 of the XSLDebugger has been released! Have you ever wished to debug an XSL transformation with the features of a debugger like those in Microsoft's Visual Basic IDE? The XSLDebugger is the answer to your debugging needs!
XSLT 1.1 Cancelled, Working Group moving directly to 2.0
Attendees to the first XSLT-UK conference last weekend were surprised to discover that the XSL Working Group have decided to cancel plans to develop XSLT 1.1. The 1.1 functionality will be added to the 2.0 specification instead.
Scientific American features the Semantic Web
Tim Berners-Lee, Ora Lassila and Jim Hendler have published a feature on the Semantic Web in May's edition of Scientific American. Once you've struggled through the obligatory computers-will-run-your-life rhetoric, the article is a good overview of the W3C's Semantic Web visio
Log Shipping with SQL Server 7.0
A low-cost way to high availability Log shipping is a robust yet low-tech, low-cost way to achieve high availability and disaster protection in your SQL Server environment. Log shipping automatically ships—copies and restores—a production server's transaction logs to a standby server, which stan
Getting The Best From The SQL Server Index Tuning Wizard
by Neil Boyle The Index Tuning Wizard is a handy tool shipped as part of the SQL Server 7.0 and SQL Server 2000 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance. Here, I will take a look at how to get the best results out of using the
XML Lifts The Burden Of Paper
Even in the electronic age, the legal profession is buried under paper. Now service providers are offering attorneys and courts ways to turn some of that paper into bits and bytes.
How to pass values into an XSLT stylesheet from ASP
By Trace C Wilson – A common question is 'how do I pass a value into a XSLT document'. In this example I will show you how we do it on VBXML.COM, explaining the different ways to pass values into the stylesheet.
XSLT IDEs from ActiveState
ActiveState have released two new IDEs for XSLT: a plug-in to Microsoft's Visual Studio .NET, and a Mozilla-based cross-platform IDE, Komodo.
SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK
by Michael Balloni – Relational databases, like Microsoft's SQL Server, use locks to prevent multiple users from making conflicting modifications to a set of data. When a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the