databasejournal.com databasejournal.com

Introducing Database Daily, All the Database Technology Information and Trends You Need in One Newsletter

Internet.com has created a new newsletter, Database Daily, to deliver the latest enterprise database technology information and trends directly to you everyday. Like the other 15 million technical professionals in the Internet.com network-including 8 million interested in development-you need information in order to make smart decisions, and we have that information. In addition to the in-depth tutorials you've come to expect from...

databasejournal.com databasejournal.com

Server Consolidation and Virtualization

by Rod Colledge This article is excerpted from the upcoming book SQL Server 2008 Administration in Action by Rod Colledge and published by Manning Publications. It examines the objectives and implications of server consolidation and virtualization. For the book’s table of contents, Author Forum, and other resources, go to http://manning.com/colledge/. The arrival of personal computer networks marked a shift away from big...

databasejournal.com databasejournal.com

Multi Table Loop

by JP Vijaykumar This article examines how to loop through multiple tables to process the data.drop table temp_jp10; create table temp_jp10(col1 number,col2 varchar2(20)); insert into temp_jp10 values(2,'RAMA'); insert into temp_jp10 values(4,'SITA'); insert into temp_jp10 values(6,'HANUMAN'); drop table temp_jp01; create table temp_jp01(col1 number,col2 varchar2(20)); insert into temp_jp01 values(1,'RADHA'); insert into temp_jp01...