sql server select query

Question

When I run a SELECT query in SQL Server Management Studio that has a WHERE clause and the database is located on the network, is the query 'run' on the Server or my Desktop PC, eg. will the entire table be brought back from the server and then filtered on my PC or will the filtering be done on the Server?

Does this behaviour differ if I'm using MS Access to run the query against the (remote) database?

HP24 · Accepted Answer · 2012-10-30 10:52:33Z

1

Every Database has it's database engine which does all request handling. So, when you connect to a database server, it opens a channel and accept the request with parameters and then does all housekeeping and returns you the desired result back. It only returns the result of the query and it happens on the server.

answered Oct 30, 2012 at 10:52

HP24

1216 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql server select query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related