Phrases that should be outlawed “It works on my machine” Well, if it works on your machine and nowhere else, then we’ll take your machine and use it to do the work. Otherwise, go and fix it. Too bad Bill Ingval can’t turn this into a sign. It would be like a dunce hat placed over the desk of the […]
Other News
Bedeviled by SQL Server lock escalation? Trace flags can help
(Serdar Yegulalp) Lock escalation in SQL Server is the mechanism that trades up smaller, fine-grained locks for bigger, coarser ones for efficiency’s sake.
Generating XML schemas from XML data
(Kore Nordmann) Already some time ago I published a tool on Github which allows you to generate (or learn) XML schemas from XML data. You provide the tool with a set of XML files and you get a nice, human readable, XML schema (XSD, DTD, …) from that.
A certification primer for XML and related technologies
(Pradeep Chopra) XML has spread like wildfire throughout the IT industry, creating a broad range of opportunities for developers. What’s the best way to take advantage of such opportunities? In the competitive world of software development, it’s important to stand above the crowd.
SQL Server Xquery with LINQ To SQL
(Chris Cavanagh) LINQ To SQL doesn’t provide a way to include Xquery expressions in queries. The simplest solution is to create SQL user-defined functions that perform the Xquery for you and return scalar results.
DB2 Data Warehouse DSNZPARMS Part 2
(Dave Beulke) Last week we talked about the first alphabetic group of DB2 data warehouse DSNZPARMS that can improve your access paths and overall application performance. This week the second set of DSNZPARMS are discussed.
Exchange Partition in Oracle
(Advait Deo) Some times we faced a need to convert our existing table from non-partition table to a partition table or vice-versa. Or moving a partition of one partition table to another partition. Or make one of the table as a partition of some partition table. Or make a partition of one of the par
Using OEM reports to show PSU levels across the estate
(John Hallas) The reporting capabilities of OEM are very good, although sometimes it is hard to find which views the data you want is held in. This post is about sharing how to build a report which details how many databases are at each PSU patch.
Implicit rounding on INSERT
(Gary Myers) Last week I had another quiz on the PL/SQL Challenge. There was a twist in its tail which meant that only about a quarter of players got it right.
DB2 vs Oracle complexity study
(Leons Petrazickis) Triton Consulting recently conducted an objective assessment of several routine DBA activities, comparing Oracle Database 11gR2 and DB2 9.7: