This question is really sort of a pointless general curiosity my co-worker & I had...
If I simply open a connection to a database in my local copy of sql server management studio & do nothing with it for the rest of the day, just simply leaving the db connection open, is data still being passed back and forth between my machine & the db server that whole time? Even some small minuscule amount?
Just a random question my co-worker and I were discussing. He felt there would need to be some small amount of data passed back and forth to keep the connection open to the db. I disagreed and felt once the connection's open, it doesn't pass data again until you perform an action. Just curious.
Thanks