I'm pretty sure you've already answered your own question. Create the structures in SQL Server 2008 and then use an ETL tool (like SSIS) to pump the data across.

What's wrong...

Jack's right. Those are two different applications in two different formats. You can't restore one from the other. In fact, you should do a search for MySQL conversion utilities, because...

Ah, cool. I'd say sacrifice the CPU for speed. Go with option 1. I like the use of single statement functions and the lack of hardcoded values. If had to...

It's clearly not a wash, one of the procedures is doing something more effeciently than the other, but the return times don't seem indicative of the resource cost. Can you...

I'm not that familiar with Access.

Whether or not the referenced project was coming from a file or a query, it's still storing the XML and dealing with it within Access...

Sorry, I misunderstood the intent of "it has" in that sentence. Of course 1 row out a billion could be returned by a seek.

Can you post the execution plan?

Have you...

I'm well and thoroughly confused by what business problem we're hoping to solve here. Or are we just engaged on an entertaining, though useless, mind excercise?

Unfortunately,...

I'd still say something else is operating on that machine. If you look at the batch requests/second, transactions/second, user connections, full scans... everything is pretty flat. Nothing is going up...

Here's a blog post over at Microsoft that might help

http://www.microsoft.com/technet/scriptcenter/resources/officetips/oct05/tips1020.mspx

Unless your system is more than one hundred billion records in size, it's unlikely that it's doing a seek and returning one billion records. Can you post the execution plan?

More information is needed. Can you capture a trace from SQL Server to see what's occuring within the database? Outside the database, you need to confirm that other processes aren't...

Best of the best, track down a class by Itzik Ben-Gan of Solid Quality Mentors. A company can even pay to have come locally and teach (as we have done...

The margin of error is, I believe, +-3ms. So anything within that range is not worth talking about. Other than that, it depends on the situation. I've had two versions...

You should also be looking at the execution plans to see how they're using/not using indexes. If you're getting widely disparate behaviors on one proc based on different data, you...