(Marco Gralike) Learned yesterday an important lesson on the Oracle OTN XMLDB forum. A question was asked why a count via a full table scan was quicker than the same example while using an XMLIndex. “XMLIndex performance regarding // (any descendant))”. The poster used the // xpath expression to do
Other News
Bloom Filters
(Greg Rahn) The other day I was reading the 11g Database VLDB and Partitioning Guide and came across the below execution plan for a partial partition-wise join between sales and customers.
Partial Methods
(Paul Kimmel) Have you heard of partial classes? Partial classes permit defining part of a class in one place and another part somewhere else, usually in another file. Partial classes exist in part so Microsoft can hide the Visual Studio designer plumbing from you. There is nothing sinister here; it
Rich Ajax Platform, Part 1: An introduction
(Chris Aniszczyk and Benjamin Muskalla) Asynchronous JavaScript + XML (Ajax) and the concept of Web 2.0 has spread through the development community as a way add liveliness to Web-based applications. The Rich Ajax Platform (RAP) is a way to build Ajax-enabled Web applications by using the Eclipse de
Asked and Answered: DB2 for z/OS Buffer Pools and CPU Time
(Robert Catterall) Will tuning DB2 for z/OS buffer pools lead to a reduction in package CPU time in a DB2 monitor accounting report? I expected to see a reduction in elapsed time and suspension time. I expected SRB time to shrink, but I thought the CPU time reported for each package would remain mor
Rebuilding Indexes Online in SQL Server 2005
In one of our previous blog post, we covered how to enable or disable an index. As mentioned in the post, one way to enable the index is by rebuilding it. In this blog post, we will discuss how to rebuild the index online. Apart from rebuilding index, one can create and drop indexes also online.
Documenting a Microsoft SQL Server database
This article describes how to document your Microsoft SQL Server database. The principles are similar for all versions of SQL Server, although SQL Server 2005 and above contain a number of neat enhancements to database documentation capabilities. The article includes database naming conventions, add
Forming Queries Part 4: SET Options
(Buck Woody) As you can imagine, the database engine doesn’t just accept data input and store the elements for later retrieval. There is an entire processing engine around accepting, changing and reviewing the data. There are a lot of parameters the engine uses to get at the data. Many of these para
Images in the Database – Reader Feedback Continues
SelectViews Show The Weekly SQL Server show about all sorts of different things from how-to to commentary has been updated. This weeks show: Replication Troubleshooting, Managing SQL Server as a Part-Time DBA, Web 2.0 Book(s) Reviewed, Noise and News in the DB world. Also, the 60-Second SQL Server Tip of the Day, Upcoming Events and Information About the Virtual Conference. […]
RSS/XML Data-Binding to Data Control with Row Limitations
(xbadenx) I built a SEO CMS for the company I work for. One of our clients wanted to include dynamic RSS data on output pages. Since the system can output the entire site to any server environment, this was simple. In this case, the client’s ASP.Net environment would be able to handle the dynamic da