(Deepankar Sarangi) This code snippet will allow the viewer to select the nth highest value of a column from any table in Oracle database. This article also deals with the other possible methods of selection along with the risks involved in using them.
Other News
SQL Server Performance Baselines – What’s Missing?
(Linchi Shea) A frequently asked question is what counters should be included in a SQL Server baseline. The discussion then quickly proceeds to define a set of perfmon counters to be logged as the performance baseline. And often, people seem to have an urge to try to reduce the baseline to a small n
Read Only Accounts in Oracle
While working on a project recently, a question came up about read only accounts. As you might already be aware of, a user that has been granted only select access can still execute a “select for update” or even a “Lock Table” command to place locks on the table. It comes as a surprise to many (me
Oracle BI EE 10.1.3.3/2 – Getting different view link shortcuts in the Criteria Tab
(Venkatakrishnan J) Lets look at a nice customization feature that can be useful in quite a lot of situations. If you go the Criteria tab of any report you would see that you would basically have 4 different shortcuts for different views.
SQL Server 2005 Express Edition – Part 15 – Snapshot Replication
(Marcin Policht) In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we started exploring its replication characteristics. As we pointed out, this was one of the areas where its feature set has been significantly restricted compared with both its predecessor (MSDE
Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics
(Paul S. Randal) It seems like all I’ve been talking about on the forums the last couple of days is the correct order of operations in a maintenance plan. The biggest confusion seems to be about the effect of rebuilding an index on statistics, with some incorrect advice being given out on what to do
MicrAhoo! Acquisition and SQL Server
The Virtual Conference is NEXT WEEK! Have you registered yet? Don’t forget too, we have group rates available, just drop me a note. Featured Article(s) SQL Server 2008 ‘Katmai’ Change Data Capture (CDC) A brief overview of the CDC technology in SQL 2008. Single Backup Solution, Multiple Applications and Platforms If you’re tired of using different utilities and applications to […]
SQL 2005 XQuery Modify
(chrishayuk) I stumbled across this issue today. Simply I want to update all rows within my xml, where Organisation=”Default”, and replace it with the default organisation id.
Picking a .NET smart client communications technology
(Brian Noyes) Once you choose to develop a .NET application as a smart client application, you have a number of design decisions that you need to tackle. You need to design the presentation layer application (the client) as well as a back-end server architecture. You need to think about security, ho
Debugging DB2 v8.2 stored procedures from Data Studio?
(Grant Hutchison) Please ensure that if you plan to use Data Studio to debug stored procedures on a DB2 v8.2 AIX server that the server has Fixpack 15 applied. If you are using an earlier fixpack level on the server you plan to debug the server could be impacted during the debug session.