Hoy, por primera vez, he leído el mensaje entero que da el Enterprise Manager del SQL Server cuando llevas un rato si usar los datos de una consulta y me he quedado flipando con el rollo que meten:
"Some time ago, you retrieved data from the database with the query or view whose name is Tables. The returned rows appear in the Results pane and the database server continues to retain the result set int its local memory, which consumes valuable server resources. Because you have not recently used the Results pane, it will be automatically cleared in one minute. This will empty the results pane, discard unsaved changes, and free the resources on the database server. then, if you want to reestablish the result set, you can rerun the query or view.
Do you want to prolong your work with the Results pane and continue to consume resources on the database server?"
Ya puestos a darle aspecto de historia podrían haberlo puesto así:
"Once upon a time, in the SQLServer Kingdom, an evil developer who used to retrieve data from the database servers. All that queries were consuming server resources from the kingdom and the other processes were sad because they couldn't use all the memory they wanted. That's why the king decided to kill all queries that weren't for more than 5 minutes. You've reached this moment and you may choose your destiny:
Will you follow the path of the evil developer or will you let the server to free the resources?"
Aunque probablemente la forma más persuasiva sería:
"You, motherfucker, are consuming a lot of resources and not using them. I will kill you and all your fucking processes unless you start working."