(Jonathan Lewis) When Oracle tries to optimizer a complex SQL statement one of the first steps it takes is to transform it into something simpler. The ideal target (from the optimizer’s perspective) is to eliminate any subqueries and in-line views so that your SQL statement ends up as a list of tabl
Other News
Using Spring and Hibernate with WebSphere Application Server
(Tom Alcott, Roland Barcia, Jim Knutson, Sara Mitchell and Ian Robinson) The Spring Framework, commonly referred to as Spring, is an open source project that aims to make the J2EE environment more accessible. Spring provides a framework for simple Java objects that enables them to make use of the J2
Automatic recover of MEMORY table after a slave failure
(Il Corra) Using MEMORY tables in MySQL is very useful; they are stored in memory and they are usually not so big in order to avoid a huge utilization of RAM. They are very fast.
SQL Server Weekly Show Posted, Tagging and More
Watch The Latest SQL Server Weekly Show Daily DBA tips, tagging in the corporate world, our June winner and upcoming events. We also have our 60 second tip of the day, information about how to win $200 and more. – Watch Here Tagging, and Corporate Data Wanted to start passing along some feedback from readers – please keep those emails […]
Implicitly Created Database Objects [DB2 9 for z/OS]
(Craig Mullins) Today we continue our series on new features in DB2 V9 with a quick discussion of implicitly created database objects. To understand what this is, let’s first review the way DB2 works today (pre-V9). If you issue a CREATE TABLE statement and do not specify the database and table spac
Calling Oracle stored procedures from Microsoft.NET
(John Charles Olamendy) This article is intended to illustrate how to illustrate how to call Oracle stored procedures and functions from Microsoft.NET through the Microsoft.NET Oracle provider and its object model residing in the namespace System.Data.OracleClient. I will cover several possible scen
Non-generic collections will be removed from Silverlight 1.1
(Kevin Hoffman) I just read that the Silverlight 1.1 next release (they didn’t say if it would be another Alpha or if it would be Beta 1) is going to have some breaking changes in it. This is one of the few times in Microsoft history that I’ve actually been both pleased to see breaking changes and t
Using Change Scripts
(Dave Juth) Using change scripts to modify different instances of a database is a best practice and is supported by SQL Server’s client tools. For example, a typical scenario is to have a development database as well as a testing and a production database. To propagate changes across all of these it
Moving to RELAX NG
(GB Shah) We can define RELAX NG as a schema that does a better job than XML Schema. This is also a grammar-based language, but unlike XML Schema it does not use tags (< >). It uses braces, which most programmers are familiar with.
Getting Started with SQL Server 2005 Full Text Searching: Part 1 – The Catalog
(arcanecode) One of the coolest features of SQL Server 2005 is the ease with which you can implement full text searching. True, it was available in previous versions but 2005 makes it very easy to implement and use.