Yes. You need to lookup Isolation Levels and NOLOCK in books on line or search bing\google for them. There is a lot to know about these topics. ...

Are you comparing the schemas or the data?

Defintely need more information. At the least the full query.

Who are dealing with at PASS? I know Andy Warren (Lead for SQLSaturday and on the PASS BoD) well so I have an in there. I was also...

What object(s) are you using in your report?

If you are using a table then you can put a group on the report grouping on branch and a page break at...

There are a lot of free resources out there as well as pay ones. I have a blog post here that lists many free resources.

I'm sure if you have the access to the remote servers then you could setup SSIS, dts on 2000, at the remote sites and "PUSH" the data to the central...

Best Practices are to have a drive (physical) for each system (C), data, logs, and backups on another drive. For really high performance systems it is recommended that you...

Can you connect using any other application? Can you check to make sure that the SQL Server allows remote connections? You can check that from SQL Server Surface...

Had a great time meeting Gus last night at our December OPASS meeting. He did a great job presenting on Auditing and Logging based on his articles from last...

This is not meant to be a criticism as I don't know when the article was written, but at least with the latest CTP, you can connect to SQL Azure...

Interesting. You might want to check back with them on that. I believe that PASS has warmed a bit to SQLSaturday. I know that PASS doesn't supply...

Have you considered doing it as a SQLSaturday. All the tools are available: website, messaging, some sponsor contacts. And, you get some coaching from people who have done...

Bru Medishetty (12/8/2009)

Thanks Alvin and appreciate your time. I...

Only when you write like Yoda. When...