You could create an alias on the client end that specified TCP/IP.

(in the CLICONFG I would add a Alias and add the Server Alias to be SERVERNAME and the

Connection Paramters...

Good point Gila...there is also on the default profile a way to increase the max bcp i believe it is this and increase the record sizes from the default incase...

Yes that is the network setup - if it runs that fast on the server it isnt doing any additiona hops through routers and network traffic. Ask the network...

There is one error out there on the latest patches that references transactional replication.

What service pack are you on ...we are on CU6 and not had these problems...i have had...

oh you just installed the SP3 - what was your version before going to the SP3.

On a cluster ....we have three two active and one passive....Do you install on one...

We are on Cummulative Patch 6 for SQL Server and this is build 3228 and ours work fine.

Anyone on higher than 3228 - can you let us know if your...

I thought there was a sql sever advisory tool.....i forget name of it...like windows you can see which patches need to be ran.

But your need to test out the SQL...

Look on the MS site and look up SQL Server patches should provide you the details..

Your have to probrably ask MS which ones are best for your system........

It would be interesting to see what DBA are running daily on their system for their own performance reports.

Waits...statistics..

Connections

What they compare on a daily basic.....

What they capture and do you...

http://support.microsoft.com/kb/937137/

I would get the latest one out and apply to all of them.

Im on cumulative 6.

Perhaps i have to write a script that checks failed login get the IP then go read this server and read all services that are running ...........that be interesting little...

Im just the DBA and get told to remove this Database and their developers don't turn off the services corresponding to it - i find out because is see the...

Hope all goes well at your interview........good luck SQL is fun there a lot to it. Some people think it runs on it own..well to a certain degree it...

if your going for interview be sure to ask yourself ...what happens when it crashes how can i get it back up because if this is your week on the...