Other News

Community

Optimize Your Applications

(Dinesh Priyankara) The application you have written, either web-based or windows-based, need to be run fast without making end-user annoyed. I have seen many applications that have very low-level performance but can be easily optimized for some extent. For example, we need to load all shippers to d

Community

Microsoft Locks Up XML Patent

(Alexander Wolfe) The speculation as to whether Microsoft intends to patent XML technology is over. Microsoft has been granted United States patent 6,687,897 for “XML script automation.” The patent, award by the U.S. Patent and Trademark Office on February 3, appears to deal with basic XML f

Community

Beyond Processing Power

(Peter Coffee) When technologies move from the laboratory to the enterprise IT stack, they must make the transition from dancing bear to chorus line. Research projects can claim success if they dance at all, whether or not they dance well, but an enterprise solution must dance consistently—and well

Community

Uses For Derived Tables

(Robert Marda) A derived table is a select statement inside parenthesis, with an alias, used as a table in a join. A simple example is: SELECT a.LastName, b.State FROM UserTable a INNER JOIN (SELECT UserID, State FROM AddressTable) b ON a.UserID = b.UserID