There is a very good blog by Jimmy may with some SQL Queries that gives you Wait Type, Finds out if there are IO issues, Blocking etc. Check this blog....

I know that there are ways to reduce the Noise in the event logs of Windows Server 2008. By default it logs everything. But it will recycle the log too...

T1 transfers around 1.5 Mbps. And you have over 100 GB to transfer. I do not know the exact calculation but if someone else is using the same T1, the...

That is the Snapshot running. Wait for all the tables inserted. After that it wont be that sluggish. But still you will face performance issues when there are lots of...

Lynn, Atleast you knew that something would happen to the certificate after sometime. I did not.. :hehe:

Continuous replication would have been a better option. But still if you are going to have bulk updates you will still have the issues. Another thing you might want to...

Grant Fritchey (3/3/2010)

---

My attitudes towards those that are certified? That's nice. But if I don't know them, I'm going to assume less knowledge from that individual instead of more based...

Paul White (3/3/2010)

---

If the criteria for winning...

No problem at all. Enjoy tuning queries. It is fun..:-)

So far I have been hired at all places without having to show any of my certificates. Not even my Degree certificate from my university.

Couple of my friends have been...

You could try to do a Command line set up to get the performance tools. I read in another site how to do this. On command prompt go to the...

It has been a long time since I have read anything to study. I usually read to just gain my knowledge. Reading to take a test is way different than...

Thanks for the feed back both of you. When I see answers and questions from the Certified professionals I loose faith in them. That is why I started this topic....

Replication is designed to do this pretty fast. But since you have latency, it takes more time to get this done. Any data manipulation will need a lock on the...

So you dont see the Sub menu of Performance tools? Strange.. It is actually part of the SQL Server 2008 Set up CD.