Best Practice Analyzer

I recently installed & ran the best practice analyzer on all of our
production SQL Servers. The only report we ended up being compliant with was
the full-text which we don't use. There are so many different standards that
this tool is looking for. Are there any that are more important than others
that you really should pay attention to? I can see the benefits of some of
the suggestions but how much difference is there really between using a
insert into table without specifying the columns and using insert into table
with the columns listed out? I understand that some of these standards are
for maintainability of code but are they all really worth the effort of going
through several hundred SPs? I am just trying to get a handle of how to
realistically use this tool. Any input on how others have used this tool in
their DBA roles would be appreciated!
Thanks!
John
there are quite a few that are pretty darn important.
the one you mention is for maintainability purposes only
if you failed every area, I would guess that you may have some serious
issues.
I thought the tool listed a severity level...It's been over a year since
I've used it on our prod DB's
Greg Jackson
PDX, Oregon
|||Greg,
We didn't fail every other one. We just always had maybe one that didn't
pass in a certain area. We only were fully compliant on the full-text. I
didn't see a severity level but I will have to look at it again.
John
"pdxJaxon" wrote:

> there are quite a few that are pretty darn important.
> the one you mention is for maintainability purposes only
> if you failed every area, I would guess that you may have some serious
> issues.
> I thought the tool listed a severity level...It's been over a year since
> I've used it on our prod DB's
>
>
> Greg Jackson
> PDX, Oregon
>
>
|||Anything security or recovery related would be first and foremost on my
list...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"John D." <John D.@.discussions.microsoft.com> wrote in message
news:2942010E-7A6D-46EC-B05D-64913D957782@.microsoft.com...
>I recently installed & ran the best practice analyzer on all of our
> production SQL Servers. The only report we ended up being compliant with
> was
> the full-text which we don't use. There are so many different standards
> that
> this tool is looking for. Are there any that are more important than
> others
> that you really should pay attention to? I can see the benefits of some
> of
> the suggestions but how much difference is there really between using a
> insert into table without specifying the columns and using insert into
> table
> with the columns listed out? I understand that some of these standards
> are
> for maintainability of code but are they all really worth the effort of
> going
> through several hundred SPs? I am just trying to get a handle of how to
> realistically use this tool. Any input on how others have used this tool
> in
> their DBA roles would be appreciated!
> Thanks!
> John
|||How important are the ANSI compliant settings? Most of them on our databases
were turned to off but the BPA suggested they be turned on. I looked them up
in BOL and don't see why they couldn't be turned on but I don't know if there
is enough to make the change. Part of me wonders if something is going to
blow up if I turn them on. Anybody have any experience with this?
John