Is it possible to limit the resources used NOT with Resource Governor, but with the C# connection statement, or the query itself.
It would be nice to control resources at runtime.
All web searches/ documention I have found so far points me to the Resource Governor.
But I would like to be more dynamic.