Prev: find a certain table from sql server
Next: SQL Server 2008 functionality
From: Jason Huang on 8 Apr 2010 04:29
Hi,

I'm wondering if I set the COMPATIBILITY_LEVEL of my SQL Server 2008 db to
100, will this improve the efficiency of that db?
Thanks for help.


Jason


From: Tibor Karaszi on 8 Apr 2010 05:27
Jason,

No, compat level is not a perf thing - it is a language functionality thing.
OF course, there might always be some extreme cases where we do see some
different execution plan, but that is definitely exception (if such at all
occurs...).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:ufSrxWv1KHA.4832(a)TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I'm wondering if I set the COMPATIBILITY_LEVEL of my SQL Server 2008 db to
> 100, will this improve the efficiency of that db?
> Thanks for help.
>
>
> Jason
>
 | 
Pages: 1
Prev: find a certain table from sql server
Next: SQL Server 2008 functionality