(Charles Hooper) Yesterday I started reading another book on the topic of Oracle SQL (for the moment I will keep the title of the book a mystery). I am not much of a fan of ANSI style syntax – that syntax style is easy to read when there are just two tables involved, but I tend to become lost when
Other News
ORA-01722 with Full Table Scan
(Saurabh Sood) My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 “invalid number” after an upgrade to 11.1.0.7 from 10.2.0.4. The syntax of the query is like:
OBI 11g Hierarchy Drill-to and Drill-from Levels – Future Release – Doh!
(Christian Screen) So, one of the questions I constantly get when teaching, talking, or raving about the integration between Hyperion Essbase and Oracle BI (specifically 11g), aside from the native hierarchy drill-down capability, of course, is can a user drill down to level 0 or drill all the way b
Performance monitoring in MySQL
(Mark Callaghan) There are several types of performance monitoring. Some of them are made easier when workload metrics are summarized by database user, table and index.
Showing Edge Shaped Event Duration in StreamInsight using Debugger
(Allan Mitchell) Whilst writing some courseware I wanted to be able to see the start and end times of Edge shaped events from within the debugger.
SQL Server – ‘Saving changes is not permitted’ error
(Ged Mead) If you’re fairly new to SQL Server and you’re working in the SQL Server Management Studio, you might run into this problem when you try and make a change to the structure of a table.
SQL SERVER – Server Side Paging in SQL Server 2011 – Part2
(Pinalkumar Dave) The best part of the having blog is that SQL Community helps to keep it running with new ideas. Earlier I wrote about SQL SERVER – Server Side Paging in SQL Server 2011 – A Better Alternative.
Extremely pureXML in DB2 10 for z/OS
(Paolo Bruni, Neale Armstrong, Ravi Kumar, Kirsten Ann Larsen, Tink Tysor and Hao Zhang) The DB2 pureXML feature offers sophisticated capabilities to store, process and manage XML data in its native hierarchical format. By integrating XML data intact into a relational database structure, users can t
Customize the style of applications generated with the User Interface Generator
(Helen K. Griffith) This article describes how to modify the stylesheets generated by the IBM InfoSphere MDM Workbench User Interface Generator and customize the look and feel of the generated application. It uses a step-by-step approach to simply demonstrate editing the cascading stylesheets provid
Welcome to SSWUG for 2011
Welcome to SSWUG for 2011 Well, here is my first editorial for 2011. I’ve been doing the daily editorial now for SSWUG since July, and it has been a blast. I’ve tried a number of things this year such as career tips, how to tips, high level reviews of books, tools, blogs and web sites, as well as best practices. […]