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

Alexander Kovacs (11/3/2008)

Grant Fritchey (11/3/2008)

All you're doing with the -+- operators is simple math, a + adds an equivalent value and a - takes it away. +++@param is the same...

I don't understand the question?

All you're doing with the -+- operators is simple math, a + adds an equivalent value and a - takes it away. +++@param is the same...

From the sounds of it, you're planning on testing against your production system. That's a huge mistake. The chances of messing something up are just too high (and I'm assuming...

I'm just horribly disappointed that Godzilla did so poorly at the polls. I really thought he would have a shot at it...

Clearly not nearly enough people recall the SQL Server...