We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90).
We will by upgrading it to 2008 at some point, but in the meantime I would like to know if having the database in a lower compatibility level is this going to have a negative effect on its performance?
I found this question that implies there could be a negative effect, but it's for an older version of SQL Server.
I have run into a problem where a tempdb database set to have unrestricted growth has used up all the available disk space (10x its norm). I am considering setting a maximum size limit, something big but just not all the space.
If a query pushes tempdb to the limit, I'm hoping the query that's using up the space will be killed off and free the space allowing everything else to work correctly. Is this likely to happen or will SQL Server stop completely?
Thanks for any answers.