It all depends on how your tempDB is being used. One thing to keep in mind is that the size of each of the tempDB files should be the same....

I was planning to set it up in our usual meeting room and use the projector, have a mic and make it more interactive.

Trey Staker (8/17/2010)

Roy Ernest (8/17/2010)

A trip to curacao is...

I have not contacted Confio. The contact info was the main issue. I did contact Quest, but no response from them. Redgate wanted us to give a demo of the...

Steve Jones - Editor (8/17/2010)

Roy,

I'll try to...

A trip to curacao is much better. Nice white...

Jeff, Thank You. Our user group would love that. maybe for September we could try that out? 🙂 Thanks once again. 🙂

I am disappointed. I was trying to get Redgate to sponsor a speaker for our user group. They came up with an idea that Brad could do a Net meeting....

When there is a local host file, the DNS entry is not needed if I am not mistaken.

Do you have both named Pipes and TCP/IP enabled? Does the target server allow remote connections?

Check your firewall rules from Subscriber to Publisher. UDP port 1434 should be open to connect using SSMS and 1433 should also be open. Are these two servers on different...

Check this link

You can rollback a connection attempt using logon triggers.

Quad core processor is considered as 4 processors.

Check this link for more tips on tempDb performance.

You do not need to restart the SQL Server service if you are using sp_configure with reconfigure option and override.

You should look at Logon triggers. This was introduced in SQL 2005 SP2 if I am not mistaken.