You are right about that ETL developer is a separate profession with a 38 point steps developed and published by Ralph Kimbal one of the two people who implemented the...

I don't know about FTP but you can email/postal mail the .bak file tell the person to put the .bak in the Backup sub folder in SQL Server folder then...

Funny you cannot please everyone but DTS and SSIS are not the same thing one is a data transfer tool which got extended by users for other things, SSIS is...

Securables is new fancy word for object permissions.

http://msdn2.microsoft.com/en-us/library/ms191465.aspx

The result is dependent on what is in your AND filter now 2000 is funny it let people write code that 2005 will reject so I think you should run your...

I am glad I could help, in the future don't search in Oracle site search in Google with what you need I do the same with MSDN2.

Actually the download in the link below is what you need because 10g will not let you skip the installation of MTS in a Windows box.  8i is crappy a...

I don't think you should create role before users you may have run into orphaned permissions they are in the Master but not in the database you created the permissions. ...

LEFT JOIN AD ON A.[A] = AD.[A] AND A.A = 1

LEFT JOIN AD ON A.[A] = AD.[A] AND A.A = 3

Both are not using the same filter.

Per ANSI SQL 1999 the WHERE clause in a JOIN operation is a filter like the AND operator, and no LEFT JOIN can never be INNER JOIN because OUTER JOIN...

I dont think so but you can see the dependencies in the database diagram in Management Studio so you know what to change, it is easier in 2005 than 2000. ...

ALTER Table Drop Constraint, ALTER Table Change Column, ALTER Table Add Constraint, ALTER Procs, ALTER Views and you can fix the dependency with Management Studio.  A lot of details but...

Microsoft XQUERY is very simple return the table with the SELECT add the XQUERY filters and apply predicates as needed at the end of the XQUERY, taking advantage of one...

The reason for that is very simple 2000 does not shred or decompose the XML

UNION is the slowest operation for combining data because it performs implict distinct to eliminate duplicates, subquery is the same as INNER JOIN the fastest.  If you don't want to...