compatibility level 80 in sql server 2005

Hi,
I have a general question about the implications of setting sql server 2005
database to compatibility level 80. It will take me some time to convert and
test the existing db schema and app to fully support sql 2005, so for now I
use this compatibility feature.
Besides not being able to use the new features of sql 2005 will setting to
compatibility level 80 effect negatively the db response time, performance,
etc...?
And if there are no problems with that temporary solution does anybody know
about any resources or articles on the web that I could provide to my
clients who are concerned about setting the compatibility level to 80?
Thank you,
VadimThere are some features in 2005 you won't be able to take advantage of but
for the most part it should not affect performance. But my question is why
are you at 80? Did you try it at 90 and have issues? Did you run the
Upgrade Advisor against your 2000 db and traces to see what issues you have
if any?
--
Andrew J. Kelly SQL MVP
"Vadim" <vadim@.dontsend.com> wrote in message
news:%23qPp0BniGHA.4716@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have a general question about the implications of setting sql server
> 2005 database to compatibility level 80. It will take me some time to
> convert and test the existing db schema and app to fully support sql 2005,
> so for now I use this compatibility feature.
> Besides not being able to use the new features of sql 2005 will setting to
> compatibility level 80 effect negatively the db response time,
> performance, etc...?
> And if there are no problems with that temporary solution does anybody
> know about any resources or articles on the web that I could provide to my
> clients who are concerned about setting the compatibility level to 80?
> Thank you,
> Vadim
>|||Andrew J. Kelly wrote:
> There are some features in 2005 you won't be able to take advantage of but
> for the most part it should not affect performance. But my question is why
> are you at 80? Did you try it at 90 and have issues? Did you run the
> Upgrade Advisor against your 2000 db and traces to see what issues you have
> if any?
> --
> Andrew J. Kelly SQL MVP
>
> "Vadim" <vadim@.dontsend.com> wrote in message
> news:%23qPp0BniGHA.4716@.TK2MSFTNGP03.phx.gbl...
> > Hi,
> > I have a general question about the implications of setting sql server
> > 2005 database to compatibility level 80. It will take me some time to
> > convert and test the existing db schema and app to fully support sql 2005,
> > so for now I use this compatibility feature.
> > Besides not being able to use the new features of sql 2005 will setting to
> > compatibility level 80 effect negatively the db response time,
> > performance, etc...?
> > And if there are no problems with that temporary solution does anybody
> > know about any resources or articles on the web that I could provide to my
> > clients who are concerned about setting the compatibility level to 80?
> >
> > Thank you,
> >
> > Vadim
> >
For backward compatibility details look into in BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm
Regards
Amish Shah|||Hi Andrew,
Yes, the main and I think only problem is sql syntax for linking tables for
inner and outer joins, I currently syntax compatible with Oracle and Sql
Server 7/2000, Microsoft just discontinued support for that syntax so I'll
have to chnage and test the whole app to make sure it works properly and it
takes time.
Thank you for your reply,
Vadim
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eXcp8MqiGHA.3496@.TK2MSFTNGP02.phx.gbl...
> There are some features in 2005 you won't be able to take advantage of but
> for the most part it should not affect performance. But my question is why
> are you at 80? Did you try it at 90 and have issues? Did you run the
> Upgrade Advisor against your 2000 db and traces to see what issues you
> have if any?
> --
> Andrew J. Kelly SQL MVP
>
> "Vadim" <vadim@.dontsend.com> wrote in message
> news:%23qPp0BniGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I have a general question about the implications of setting sql server
>> 2005 database to compatibility level 80. It will take me some time to
>> convert and test the existing db schema and app to fully support sql
>> 2005, so for now I use this compatibility feature.
>> Besides not being able to use the new features of sql 2005 will setting
>> to compatibility level 80 effect negatively the db response time,
>> performance, etc...?
>> And if there are no problems with that temporary solution does anybody
>> know about any resources or articles on the web that I could provide to
>> my clients who are concerned about setting the compatibility level to 80?
>> Thank you,
>> Vadim
>|||Thank you, Amish, good info but they don't mention how this affects the
performance internally, although based on the previous post it seems like
there are no performance issues.
I'll try also to run the upgrade advisor.
Vadim
"amish" <shahamishm@.gmail.com> wrote in message
news:1149742077.528427.325660@.u72g2000cwu.googlegroups.com...
> Andrew J. Kelly wrote:
>> There are some features in 2005 you won't be able to take advantage of
>> but
>> for the most part it should not affect performance. But my question is
>> why
>> are you at 80? Did you try it at 90 and have issues? Did you run the
>> Upgrade Advisor against your 2000 db and traces to see what issues you
>> have
>> if any?
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Vadim" <vadim@.dontsend.com> wrote in message
>> news:%23qPp0BniGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> > Hi,
>> > I have a general question about the implications of setting sql server
>> > 2005 database to compatibility level 80. It will take me some time to
>> > convert and test the existing db schema and app to fully support sql
>> > 2005,
>> > so for now I use this compatibility feature.
>> > Besides not being able to use the new features of sql 2005 will setting
>> > to
>> > compatibility level 80 effect negatively the db response time,
>> > performance, etc...?
>> > And if there are no problems with that temporary solution does anybody
>> > know about any resources or articles on the web that I could provide to
>> > my
>> > clients who are concerned about setting the compatibility level to 80?
>> >
>> > Thank you,
>> >
>> > Vadim
>> >
> For backward compatibility details look into in BOL
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm
> Regards
> Amish Shah
>