Hi
Does anyone know what kind of performance boost (if any!) is achieved if SQLExpress was changed from being Multi User to Single User.
We cannot easily 'figure' this out because our application (unfortunately) uses both LLBL and non-LLBL code – non-LLBL sometime ‘forget’ to close connection and hence the application does not work in Single User mode.
The idea is that if there is a huge improvement that we will spend time and effort converting to LLBL code. Else we live with it and focus on other area’s such as optimising the SQL /SP’s and remove duplicate codes.
Many thanks for your help in advance.