(Sudhakar Ramakrishnan) Remember the heady days of HTML version 1.0 to version 2.0, when mastering a new Web language was as simple as looking at the code behind a Web site? Remember the ease of learning that came with basic HTML? Remember being able to hack out some code, quickly view the presentat
Other News
Saving CPU in your multiple counts SQL statements
(Terry Purcell) When requiring multiple counts you can choose to write multiple SQL statements (or write a program) such as: SELECT COUNT(*) AS UNDER_40K WHERE SALARY < 40000 AND SELECT COUNT(*) AS ABOVE_40K WHERE SALARY >= 40000 Or you can choose to simulate these multiple counts in
Arrays and Lists in SQL Server
(Erland Sommarskog) In the public forums for SQL Server, you often see people asking How do I use arrays in SQL Server? Or Why does SELECT * FROM tbl WHERE col IN (@list) not work? This text describes several methods to do this, both good and bad ones. I also present data from performance tests of t
Next Generation SQL Server Part II – Yukon
(Vinod Kumar) Welcome to the Part II of the series where we take a closer look into Yukon . The release of the next version of SQL Server, code-named Yukon , is expected in early 2004(as per news reports). The Yukon release will include the .NET Common Language Runtime (CLR), which will allow develo
XML Acceleration: The Truth Behind the Myths – Don’t assume that bandwidth and processing will be problems
(Dan Foody) As information technology professionals progress in their knowledge and use of XML and Web services, the question of XML performance persists. In hallway chats, one might hear that “XML takes up too much bandwidth” or “XML takes too many CPU cycles to process.” Unfortunately, these b
Snapbridge Releases Free Beta Versions of XML Developers Tools
Snapbridge Software today released Beta versions of Snapbridge FDX Information Server Developers Edition and Snapbridge XStudio, XML development tools for creating information integration and content publishing solutions. Snapbridge FDX Information Server Developers Edition is a fully integrated dev
Four Horsemen of Internet see tough times
(Matt Krantz) Before the Internet bubble burst, there were four companies that, in Wall Street’s eyes, could do no wrong: Cisco, EMC, Sun Microsystems and Oracle. Prosperous records, real products and soaring profits earned them the nickname, “the Four Horsemen of the Internet.”
Styling RDF Graphs with GSS
(Emmanuel Pietriga) RDF models describe web resources using subject-predicate-object triples. Combined together, these triples form a graph structure, which cannot be easily conveyed by textual syntaxes such as RDF/XML, Notation 3 or N-Triple because of their one-dimensional nature. Visual editor
Merging two XML source trees
(John E. Simpson) Q: How do I merge two XML source trees into one? I’ve tried so many things that it’s driving me crazy: I want to merge or join two XML files. Which two files are to be merged are specified in a third file (call it merge.xml).
Oracle Optimizer: Moving to and working with CBO – Part 5
(Amar Kumar Padhi)We covered the various methods of generating statistics in the last installment; moving forward, let’s look at the data skewness problem and the use of the Monitoring option for updating statistics on the fly.