Have you installed the relevant Oracle products on the workstation / server that you are running your SSIS packages from ? I would expect that as a minimum, you...

The 2 main reasons are

- Information Schema views are defined by the relevant ANSI standard and are available with any RDBMS that supports those standards

- Microsoft have done the...

I would expect that SQL would happily fail-over to the passive node. Since you have less RAM available on that node, you should expect performance to be lower since...

Table partitions were added in SQL 2005.

Without a trust, you can still do what you need. Replication can be setup so that SQL Logins are used by the relevant agents.

I am wondering why you would want to use snapshot replication to a table that has additional columns. The additional columns can't have any data in them - if...

Have you tried using the Database Tuning Advisor (this is in the Query menu in Management Studio) ?

This will analyse the query and make suggestions about indexes that can improve...

RTM stands for "Release To Manufacturer". This is what done when Microsoft is happy to formal release (i.e. sell) the product to you. In essence, Microsoft has created...

No. There are differences in the way that SQL 2005 stores data that make restoring to an earlier version impossible. When you restore a SQL 2000 database to...

You only need to specify "WITH" once...

RESTORE DATABASE test

--restore filelistonly

FROM DISK = 'D:\BACKUP\test_db_200809150315.BAK'

WITH NORECOVERY,

MOVE 'tws_dat' TO 'D:\Data\test.mdf',

...

You probably need code like

SELECT somenum, min (date)

from yourtable

group by somenum

SQL Server is quite smart about how it uses memory. It is in no way constrained to the about of RAM being approximately the size of the database. ...

This is exactly why adhoc updates to system tables are not allowed. If your UPDATE had been allowed to execute, you would have created a serious problem with the...

Licensing is up to you to be honest about. i.e. SQL Server will use whatever CPU's you let it use and will not complain - after all, it cannot...

Try...

Select * from table_a T2

where not exists

(Select * from table_b T1 where T2.material =

T1.material and T2.plant = T1.plant )

UNION ALL

Select * from table_b T2

where not exists

(Select * from...