Database created XML, to only incorporate data contained within the data base. It is difficult to flexibly represent some data, because they deal with individual rows and not hierarchical data. The data that does not change frequently, the XML data is generated only upon changes, and not the client
Other News
Troubleshooting Bad Execution Plans
(Greg Rahn) One of the most common performance issues DBAs encounter are bad execution plans. Many try to resolve bad executions plans by setting optimizer related parameters or even hidden underscore parameters. Some even try to decipher a long and complex 10053 trace in hopes to find an answer. Wh
Secure connections to PostgreSQL
(Vincent Danen) The PostgreSQL database server is arguably one of the best SQL servers available, but it’s not as easy for beginners to get a handle on it as other SQL databases, such as MySQL. Where MySQL stores all of its credential information within the SQL database itself, PostgreSQL takes a tw
Lambda Expressions and Currying in VB9
(Paul Kimmel) I am a linguaphile. That is, I love cool language features such as operator overloading, generics, Lambda Expressions, ternary operators, and anything and almost everything about OOPy languages. For that reason, C++ has probably always been my favorite language, but I seldom write C++
Oracle Security, Part 2: Your read only accounts aren’t that read only
(Tanel Poder) Couple of years ago an interesting fact floated up in Oracle-L – a regular user with only SELECT privilege on a table can successfully execute a SELECT FOR UPDATE against it, locking all rows and even lock the whole table using LOCK TABLE command. Locking a table in exclusive mode woul
ADF Faces 11g: Reloading the Matrix – using the Pivot Table component
(Lucas Jellema) In the past months I have been writing several times about the Matrix component I developed for ADF Faces to be used in several of our projects. Yesterday I demonstrated this component in my presentation at OOW 2007 on ADF Faces. This morning I decided to take a look the the new Pivo
Selecting a Garbage Collector
(Jim Mischel) One of the less publicized features of the .NET garbage collector is that there are actually three flavors of garbage collection available. From a conceptual standpoint, all three work in much the same way. But the details of their implementations are quite different, and as such have
Stored procedure to find fragmented indexes in SQL Server
(Michelle Gutzait) SQL Server tables and indexes tend to become fragmented over time because of data modifications. In large I/O operations, performance of applications using these fragmented indexes and tables can be adversely affected. (R)
MDX Essentials: Set Functions: The MeasureGroupMeasures() Function
(William Pearson) In this lesson, we will expose another useful function in the MDX toolset, the MeasureGroupMeasures() function. The general purpose of the MeasureGroupMeasures() function is to return a list of all measures within a specified measure group. The MeasureGroupMeasures() function is us
Compression: Whats the difference between SQL2005 and SQL2008?
(Euan Garden) Compression was added to SQL Server 2005 as part of SP2 and it was added via a new “type”. The primary goal here was to catch up on some of the changes in customer apps during the development life of SQL 2005. One of the problems with a 5 yr release is at some point you get locked […]