• Snargables (6/8/2016)


    What about querries? Should the same logic apply? It's been my experience that queries take longer to execute from my laptop as opposed to me remoting in and running them directly on the server.

    They can be different depending on the set options each batch is running under.

    SSMS has default set options and that might be different to the set options on how it is called from, say, the application.

    Also, set options could be different between ssms on server and your machine as you may have changed one of them from the defaults and not the other.

    Also, if you run on your laptop, you could have couple of MB result set, travelling over the network to be displayed on your laptop vs on server no network, so what you may be experiencing is increased latency on your laptop.

    The actual time to complete of the query inside the SQL application on the sqlserver should mostly be the same if you have same set options on 2 different SSMS on server and on remote machine.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]