If you use the read uncommitted, you can, not only get partially updated records, but duplicate or missing records since page splits and reorders due to changes in the data...

You might want to do a search of the scripts over on the left. Look for functions that convert comma delimited lists into a table. That way you don't have...

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...