(Dmitry Tsuranoff) There are three major theoretical differences between temporary tables: create table #T (…) And table variables: declare @T table (…)
Other News
XML Parser Benchmarks: Part 2
(Matthias Farwick and Michael Hafner) In part 1 of this series we showed you the results of our event-driven parser benchmarks. The outcome of these benchmarks showed that the LIBXML2 SAX-like parser in C is superior over the other tested parsers. In second place followed the two Java pull-parser im
XML Data Binding
(Simon Sprott) XML Data Binding allows you to manipulate an XML document via a set of simple objects. The rules defining the ‘shape’ of the XML document are described in an XML schema. Typically, it is possible to read an XML document into an XML binding library and manipulate it programmatically vi
CLR Triggers for SQL Server 2005
(Soyuj Kumar Sahoo) As I discussed in my previous articles, now Microsoft SQL Server 2005 is integrated with Microsoft .NET Framework Common Language Runtime (CLR), so we can use any .NET Framework language to create database objects. The CLR provides the execution environment for all the server sid
The Baker’s Dozen: 13 Steps for Building an ASP.NET Database Lookup Page
(Kevin S. Goff) Lookup and navigation screens initially seem like no-brainers, when compared to other parts of an application—yet by the time a developer has met all the user requirements and requests, he/she has expended much more time than expected.
JDeveloper 11g: Contextually Linking the Stacked Bar Chart to an ADF Data Table – synchronize data component when clicking on chart
(Lucas Jellema) One of the powerful features for creating rich pages, including dashboards, is the ability to refresh and synchronize data components on a page by clicking an element in a chart. With the description of the stacked bar chart in Getting those Rich Charts going – Introducing the ADF Fa
Using Thread Pool Threads
(Jim Mischel) Thread pool threads are ideal for performing relatively short compute-bound operations that you want to execute in the background. For example, computing the cells in a spreadsheet, grammar- or spell-checking a document, and other such activities should be done in the background to pre
Use of join buffer is now visible in EXPLAIN
(Sergey Petrunia) Starting from 5.1.18, EXPLAIN output may show “Using join cache”, like in this example:
My new best friend – PHP’s create_function()
(Felix Geisendörfer) I meant to introduce you to my new best friend for quite a while but didn’t get around to do it so far. His name is ‘create_function’ and he’s a really useful co-worker. For those of you who just vaguely know him – don’t worry, he’s not so much like his ev(a|i)l cousin. Well, th
Building Integrated Applications with WebSphere Dashboard Framework
(Philip Monson, Sam Alexander, Lea Medhurst and Christine Miner) WebSphere Dashboard Framework gives application developers the power to create rich graphical interfaces to business data which allow the end user to make key decisons upon that data. WebSphere Dashboard Framework also provides powerfu