(Iggy Fernandez) Filed under SQL curiosities. The Oracle documentation incorrectly states that “The execution order in EXPLAIN PLAN output begins with the line that is the furthest indented to the right. The next step is the parent of that line.
Other News
What does ISDEFAULT mean in v$parameter?
(Yasin Baskan) There is a common misunderstanding among DBAs about the column ISDEFAULT in the view v$parameter. Some think that when this column is TRUE it means the current value of the parameter is the default value. This leads to wrong conclusions and sometimes wrong settings for even production
Identifying and Evaluating I/O Bottlenecks in Oracle Database
(Jim Czuprynski) Discover the wealth of I/O performance tuning information that Oracle 11gR2’s Automatic Workload Repository (AWR) reports provide, and learn how to use that information to determine if any I/O performance bottlenecks actually exist, and how to form initial hypotheses to resolve thos
Whats the problem with reporting?
(Simon Sabin) Its the reports. Take this for example, it is a report generated during a demo of Report Builder 3.0 by someone in MS marketing. She says things like “..and you can see easily how my divisions are doing”. No you can’t you’ve just got a bunch of numbers.
Point-in-time restore of database backup?
(Tibor Karaszi) SQL Server 2005 added the STOPAT option for the RESTORE DATABASE command. This sounds great – we can stop at some point in time during the database backup process was running! Or? No, we can’t. Here follows some tech stuff why not, and then what the option is really meant for:
Create offline web applications on mobile and stationary devices with CouchDB
(Dietmar Krueger) One of the greatest challenges for mobile applications is the synchronicity of data. An interesting solution to the problem is to use the NoSQL database CouchDB. CouchDB, a document-oriented database, is an alternative to SQL databases. With CouchDB you can use cloud functions on m
Convert ASP.NET DropDownList into Multi Select ListBox using jQuery 18retweet
(Suprotim Agarwal) In this simple article, we will see how to convert an ASP.NET DropDownList into Multi Select ListBox, in order to select multiple items. This article is a chapter from my EBook called 51 Recipes with jQuery and ASP.NET Controls. The chapter has been modified a little to publish it
SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber
(Pinalkumar Dave) I strongly favor ORDER BY ColumnName.
IBM Cognos Proven Practices: Dynamic Reporting with Role-based Security
(Kanako Harada and Hatif Samgita) An outline of the steps that need to be taken in order to create reports and models that provide user-level security.
SQL Alerts
Featured Article(s) Tips for using alerts in SQL Server 2008 In this article, you can find some useful tips to work with SQL Server 2008 alerts. Featured White Paper(s) Why and How You Should Find and Fix Index Fragmentation In a high-volume database you need frequent critical maintenance. If you skip this important task, index fragmentation may ca… (read more) […]