Unfortunately, WSRM seems to have completely disappeared as of Windows 2012 R2!

We're planning for four SQL instances initially, but I could see this increasing to maybe 6 or 7. ...

Hi GilaMonster,

You got me thinking and I now agree - you're absolutely right!

I set SSMS to 'Discard Results after execution' so that no results are rendered in the display... The...

Hi GilaMonster - Thanks for the comments...I get the same type of results with SSIS and with SQLCmd. Would you expect SSMS connecting via shared memory to produce network...

An additional part to this problem!....

If this is a network problem, why does my SQL query use so little of the network bandwidth compared to file-transfers (see 2nd attachment)?

A file...

I've attached some wait statistics taken during the [font="Courier New"]SELECT *[/font] and [font="Courier New"]SELECT INTO[/font] queries.

With the [font="Courier New"]SELECT *[/font] command, there are network waits which aren't present with the...