My 1.5 cents:

Consider using a LINKED Server to the 2000 machine.

Write SPROCS to do the actual work (with TRANSACTIONS if you like).

SPROCS can be evoked from SSIS via an EXEC...

Hello Fabio:

As other posters have suggested - be certain you are making apples-to-apples comparisons, i.e., everything else should be THE SAME except for the SQL Server versions.

Otherwise, you'll get false...

SPtiruttani (6/20/2011)

---

We are using the free version of MS SQL Server 2005 for in the organization. Now the data growing

and reaches to 2.7GB. So for free version Microsoft provides...

My previous company did not virtualize SQL Server databases hardly at all.

Our experience was more along the lines of virtualizing other services: IIS; brute force sound file servers/services; miscellaneous application...

Thanks, but I think your responses indicate that did not understand, or directly address, what I wrote/meant.

Having been in IT for 23 years, working with several platforms/languages/RDBMS, developing/supporting/integrating more applications than I can remember, and working in a variety of businesses, models and roles, I could...

I agree that many IT people do not understand the operational business subject matter, and as I implied good quality communication is essential in any relationship.

And I also agree that...

This article contains some interesting subtexts; not the least of which is the underlying root reason why this adversarial relationship between IT and "other business units" (OBU) exist.

I also think...

I believe our spouses or significant others can and should make demands on us to reasonably reduce our work hours, simply because our work lives affect their lives (and the...

I believe that Abed misses or eludes the entire point / need for the occasional use of cursors, bad though they may be:

To loop through a record set and...

Andy -

First - very good article.

I pretty much agree on all points, with the exception of relatively small temp tables, or those generated by Inline/Multi-statement table functions - that,...