Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Question on SET COMPATIBILITY_LEVEL

  
   Database Forums (Home) -> Server RSS
Next:  NetApp v3140 and Transaction Log placement Best P..  
Author Message
jasonhuang88881

External


Since: Dec 28, 2004
Posts: 27



(Msg. 1) Posted: Thu Apr 08, 2010 5:25 am
Post subject: Question on SET COMPATIBILITY_LEVEL
Archived from groups: microsoft>public>sqlserver>server (more info?)
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

 >> Stay informed about: Question on SET COMPATIBILITY_LEVEL 
Back to top
Login to vote
Tibor Karaszi

External


Since: Jan 29, 2004
Posts: 891



(Msg. 2) Posted: Thu Apr 08, 2010 6:25 am
Post subject: Re: Question on SET COMPATIBILITY_LEVEL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" wrote in message

> 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
>

 >> Stay informed about: Question on SET COMPATIBILITY_LEVEL 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
A new @@Error question. - Here is what I really need to accomplish: CREATE TABLE [dbo].[Table1] ( [c1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Table2] ( [c1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON..

silly question but.... - In SQL Server Business Intelligence Development Studio, how do i create subfolders in my projects ? when i deploy they always go to the root of my report server, where i have to move the reports into the relevant folders, however once i deploy again ..

SQL Server 2005 vs 2000 question - Hello: I'm looking at getting into the DBA field and would like to learn SQL Server 2005. Since 2005 is new, there are much more installations of 2000 out there. If I studied 2005, would I be able to apply most of that knowledge to 2000 also? Or is..

SQL 2000 Performance Question - I'm wondering what would yeild the best performance. Setting up a primary key column to auto increment it's value OR Creating a table to hold all "Next numbers to be used" and writting my own sp to handle unique numbers in a transaction. I re...

Backup question - Using sql server 2000... We are having issues with growing transaction log files... Is the following a safe practice ? Assume you create a "full" backup job using the Database Maintenance plan wizard... This will create Step 1 in an SQL Job...
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]