A third option is to use a third party tool like RedGates SQL Compare and Data Compare.

However, if this is going to be a repeatable procedure, I would take the...

Ryan D. (8/27/2009)

---

Thank for the reply, the issue I'm having is that the report is showing about 200 missing/recommend indexes. Based upon the different column values, which one should be...

Being able to answer this question without more information is like taking a shot in the dark.

Some of the things you might look for are to see if other users...

I want to emphasize what Lynn said about the cursor - WHY are you using a cursor to move data from table to table?

Besides the article that Lynn suggested, please...

Caching is what is causing your difference between first and subsequent runs.

First run has to build the actual execution plan and cache it, plus what Lynn said about the physical...

Here are a couple of things:

A way to determine memory pressure:

select * from sys.sysperfinfo where counter_name like '%page life expectancy%'

if the counters are below 300, you should probably get more...

I like to affix a cost / benefit value to the missing index (number of updates vs. number of lookups as part of it). From there, try to associate...

50-60 hr weeks are very common too:hehe:

Nothing like 30hrs straight to get the juices flowing:doze:

But as a DBA if something comes up that requires it, you have to grin and...

Just two-bits, at a former employer we used SQL, Oracle, DB2 and Teradata.

The Teradata and Oracle teams were about twice the size of the SQL and DB2 teams. We...

Sometimes when you buy a license you purchase an upgrade uption, sometimes not. This depends on the vendor. That is why it is a good idea to call...

Depending on the query, I would also test against CTE. I have found the same sort of result with TVFs when compared to procs as GSquared has found. ...

Technically the trigger and bcp option would work. The solution of using a scheduled stored proc is superior to the trigger. As for the SSIS scheduled job -...

And I will table the motion - CLR seems the best option for this type of requirement.

Not sure why the Encrypted Procs in prod on the 2005 box is an issue. Aren't the procs that you truly need to access in the 2000 box? ...

If you must implement a linked server, I highly recommend thoroughly testing your queries first and monitoring performance. With linked servers, you want to be careful with the security,...