I like that clean up. Fewer joins and a simpler query. Nicely done.

Thanks for making me look at the query again. I've still got a bit of the debugging...

That's a very good description of how to get started. If you need something a bit more fundamental, try this article on SimpleTalk[/url].

I wouldn't recommend that either for the same reasons. Itzik Ben-Gan has a great set of example scripts that show how using NOLOCK & other dirty read mechanisms can lead...

Easily done. You can set up a Profiler job to look exactly like what you want to monitor. Export that job to a SQL file using File, Export, Script Definition....

From the books online:

Setting Options Without Rebuilding

By using the SET clause in the ALTER INDEX statement, you can set the following index options without rebuilding the index:

ALLOW_PAGE_LOCKS

ALLOW_ROW_LOCKS

IGNORE_DUP_KEY

These options are...

[script]ALTER INDEX x ON z

REBUILD WITH (FILLFACTOR = 100);

[/script]

Off hours information of system slowness?

I'm guessing that setting a trace using Profiler and getting monitoring information using Performance Monitor will do what you need.

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