There's an article on porting DTS to SSIS today but it doesn't say anything about the environment.

Should we assume that you cannot port DTS to SSIS on the...

The short explanation is good, but I would like to point out that the explanation of the XML indexes is quite good though the fact that this question addresses is...

It sounds as if it is the business logic checking that is slowing you down. So, linking to the FoxPro tables and using DTS as Francisco suggested might be...

I think you should all look into the use of ROLLUP in the GROUP BY clause and GROUPING in the column list.

Try

select

Case GROUPING([month])

WHEN 0 THEN [month]

...

If you are happy with your employer and your employer is happy with you, why go for certification anyway? What are your reasons for wanting certification?

To be certified on...

What was that role? db_ddladmin maybe?

That limitation stinks.

Judging by the replies, a lot of people will be surprised.

--Peter

Yes, using Intellisense is great, but that's another difference in development that would cause confusion if one is developing both script tasks and script components to access similar ReadOnlyVariables. ...

As Jamie pointed out, it is the difference between script components and script tasks.

Script components are classes that you write and you can add member variables (properties?) so that these...

Wow, that's really bad design to have such similar concepts implemented in such different ways. Is there a good reason for this?

I'll wait for SQL Server 2012. It...

I have to agree with Chris that the answer as given is not correct.

If we use the rule that we should pick the best answer then either one...

The answer implies that in-memory tables are not used, but

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977

Q4: Are table variables memory-only structures that are assured better performance as compared to temporary or permanent tables,...

faq100,

Try a multirow insert with values that violate a constraint on one or more columns on some of the rows.

With or without explicit or implicit transactions, no rows...

I think that total failure was the only right answer

If the WHERE clause used IN or EXISTS that two rows returned from the subquery would not cause a failure or...

Here's a link that covers the SQL Server 2005 pivot capabilities: devx