Speed is almost always a concern when working with databases. Many things contribute to your database’s performance: the operating system; hardware considerations, such as memory and disk space; and the design of the applications accessing the database. Your database’s design also plays an importan
Community
Speed Up SELECT DISTINCT Queries
The next time you find yourself using the SELECT DISTINCT statement, take a moment to see if it can be re-written for improved performance. You may be surprised at what a little re-coding can do for your application.
Symmetry Xchange integration Suite™ for B2B trading exchanges
SymmetryXi™ is a B2B XML Messaging solution that integrates corporate data sources, ERP and legacy systems using a cost-effective, component-based open standards architecture. SymmetryXi is a server-based XML Messaging solution combined with high-performance data access technology designed to delive
XML-Deviant: Parsing the Atom
Not every piece of data the XML programmer has to deal with comes neatly packaged in angle brackets. XML developers have been examining how W3C XML Schema could help out.
Use SET STATISTICS IO and SET STATISTICS TIME
This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries.
SQL Server Security
This comprehensive FAQ-type document discusses many of the major security concerns, patches and updates for SQL Server (largely focusing on SQL 7). A must read for any production shop.
Dynamically Selecting Which Element To Sort On Using Parameters
Many times it is desirable to specify at run-time upon which element our xml should be sorted on. Here's how we can do that.
MetraTech's QuickStart Puts ASPs On Fast Track to Profitable Services
MetraTech today released QuickStart, a streamlined, no-surprises XML billing package that eliminates the traditional lag between developing services and billing customers for them. QuickStart wraps essential elements from MetraTech's product set into a solution that ensures ASPs a fixed-price,
XML schema catches heat
After more than two years of development, the World Wide Web Consortium could be only weeks away from releasing its long-awaited XML Schema specification. But despite its release, the specification, which is designed to automate data exchange between companies, is coming under fire.
Certification Tips
Anny Warren writes about advice on taking exams – thinking about taking your first exam? Here are sixteen tips that will help you prepare!