(Corra) In MySQL 5.1 Cluster Certification Study Guide at page 151 there’s the following sentence: “InnoDB operates with the REPEATABLE READ isolation level, which still allows phantom reads but suppresses non-repeatable reads”.
Other News
CodeSnip: Practical Use of Translate Function in Oracle
(Deepankar Sarangi) This code snippet will allow the user to find out the total number of comma separated phrases being stored as a single string. Anybody trying to get the total number of phrases present in that column will face difficulty, as a group of phrases in a row would appear as a single ph
VB 6 and USB Flash Disks
(Hannes du Preez) If you are as curious as I am, you have probably wondered whether or not it is possible to determine if a memory stick was plugged in or taken out. To answer your question, yes you can! As the saying goes: Curiosity killed the cat. In this case, if you are not careful, curiosity ca
ASP.NET Case Study: Hang on WaitOne, WaitAny or WaitMultiple
(Tess Fernandez) One of the synchronization methods in .NET is the ResetEvent. It comes in two flavors, the AutoResetEvent which resets itself immediately after it is set, and the ManualResetEvent which as the name suggests you have to manually reset.
Create a Database Manually – When & Why?
(Sean Hull) Oracle is a complicated beast to administer; why make our lives more difficult? A lot of people ask that question when they look at a command line interface. My response is always the same. If you’re trying to use the database, interfacing with it through an application, you’re an end
DTS vs SSIS: A basic overview
In today’s blog post, we will give a basic introduction of SSIS (SQL Server Integration Services) and provide a comparison of some of those features with DTS (Data Transformation Services), it’s predecessor.
Generate dynamic SQL statements in SQL Server
(Tim Chapman) When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool — although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly.
Let’s deprecate UPDATE FROM!
(Hugo Kornelis) I guess that many people using UPDATE … FROM on a daily basis do so without being aware that they are violating all SQL standards.
SQL Server 2008: FILESTREAM performance
(Paul S. Randal) During the various courses I’ve been teaching, people are interested in how FILESTREAM performance compares with storing BLOBs in the database itself. I have some performance graphs based on measurements the dev team made – these have been presented publicly by myself and the dev te
Oracle BI EE 10.1.3.3/2 – Downgrading Repositories
(Venkatakrishnan J) For those of you who have worked across multiple versions of BI EE, you would have noticed that the Repository files( .rpd files) are not backward compatible(but they are a upward compatible) i.e One cannot use a rpd file created with a higher version of the Admin tool in a lower