The small white to ask:

(1) the SQL Server memory too high what reason? Besides the select which operation will put the data into memory?
I checked on the net, the result of a select statement found out into memory, where the meaning of it into memory, in order to pick up the query? If I update the data, in addition to the content of the database itself will update, the last time the result of the select values in the memory will follow to update? If you don't update, it into memory is meaningless? So I add the statement, the memory will also increase?

For example, there was a row in the database:

Name check-in date
Zhang SAN 2019.7.26

I query a zhang SAN check-in date, the results of the query to the written into the memory: zhang SAN 2019.7.26

Then I heard the update data, change the zhang SAN check-in date to 2019.7.27, then into memory before the data are became: zhang SAN 2019.7.27?
My check-in date, if the query again zhang SAN is to obtain the results directly from memory?

2. If my database operations, is disconnected cycle have to connect to the database and database, regular operation is to select and update, add very little, my SQL server memory or kept up, is that normal?

3. Set up a connection to the database memory limit, database exactly this limit will have an impact on the normal operation of the database?


Have bosses help below the answer, thank you bosses!!!!!! Bow!!!!!!