I have seen information about how sort order affects performance in SQL Server 6.5, but I can not find similar information about sort-order performance in SQL Server 2000 or SQL Server 7.0. I am trying to decide if using binary sort makes sense for my SQL Server 2000 application. What is the perform
Other News
Check Out the SQL Server Playback Program
By Brian Moran – Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, and the company is now actively seeking a new round of SQL Server Playback customers to get ready for the Yukon rollout in 2003.
How to Perform a SQL Server Performance Audit
by Brad M. McGehee – Over the last five years that I have been a SQL Server DBA, I have put together a mental checklist that I use when it comes to performance tuning SQL Servers. I use this checklist as a guide when I perform a “performance audit” a (new to me) SQL Server for the first time. I […]
Lawmaker: Oracle deceived California
By Alorie Gilbert – A California legislator accused Oracle and its business partner Logicon of being “part and parcel of defrauding the state of California” after he reviewed an e-mail exchange between the two companies that discussed how to handle Oracle’s pending $95 million software contract with
Data-shaped SQL clauses
Since it’s introduction in ADO 2.0, data shaping has remained largely on the fringes of Visual Basic arcanum. Relegated to the back pages of musty manuals, you may have overlooked this useful aspect of ADO. If you’re not familiar with data-shaping, in essence, it lets you create recordsets within
Built-in XML: Oracle’s sales salvation?
By Wylie Wong – The software maker said it plans to ship a new release of its 9i database later this week or early next week. Topping the list of new features in the release is more fluency in XML (Extensible Markup Language), a Web standard for exchanging information that is a cornerstone of Web se
Enhance SQL Server Security
by Walter Myers III and David Byres – The best cure is prevention. That’s why user authentication is the cornerstone of any software security system. And it seems easy: You can authenticate users with SQL Server’s own security mechanism, typically by passing a set of security credentials in ADO code
IBM Web Services Guru Predicts WSDL Future
By Gavin Clarke – If you think the alphabet soup of web services acronyms is bad – with SOAP, WSDL, UDDI, WS-Security and WS-Routing to name but a few – then hold on to your spoon. Things are going to get much, much worse.IBM's director of e-business standards Bob Sutor, predicts between
Specializing domains in DITA
By Erik Hennum – In current approaches, DTDs are static. As a result, DTD designers try to cover every contingency and, when this effort fails, users have to force their information to fit existing types. The Darwin Information Typing Architecture (DITA) changes this situation by giving information
Eric van der Vlist on W3C XML Schema
Eric van der Vlist, a regular contributor to XML.com, has just completed writing XML Schema: The W3C's Object-Oriented Descriptions for XML for O'Reilly, to be published in June 2002. In this interview he explains the importance of XML schema languages, and his motivations for writing the bo