Mutiple Inserts. Normal method VS Union ALL method

I know the eternal war between DBA’s and Developers rages on :D, While most developers prefer to make multiple inserts. DBA’s always use UNION all. While highly debatable which is fast performance wise. But if you are doing thousands of insert’s UNION ALL is definitely faster. I have narrowed down inserts from 40 second to … Continue reading Mutiple Inserts. Normal method VS Union ALL method

Advertisements

Access Oracle tables from SQL Server 2005

In a heterogeneous environment it sometimes becomes necessary to access information across different database. In this exercise I will demonstrate how you can access Oracle db tables in SQL Server 2005. 1. First you need to install Oracle client on the SQL server 2005 server. You can install using the instant client option. I am … Continue reading Access Oracle tables from SQL Server 2005

Microsoft SQL Server for Oracle Professionals.

Database Architecture In Oracle, a database refers to the entire Oracle RDBMS environment and includes the following components: • Oracle database processes and buffers (instance). • SYSTEM tablespace containing one centralized system catalog, which is made up of one or more datafiles. • Other optional tablespaces as defined by the database administrator (DBA), each made … Continue reading Microsoft SQL Server for Oracle Professionals.