INF: ???????? ?????? ?????? ????? ?? SQL Server 6.5

?????? ????????? ?????? ?????????
???? ???????: 297864 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? ????? SQL Server ??????? ??? ??????? 6.5 ? ??????? 7.0. ????? vastly ????? ????? ???????? ???? ???????? ?????? ??????? ????????? ?????? ??? ???? ???? ?? SQL Server 6.5. ????? "???? ??????? ??" ??????? ????? ????? ???? ????? ?? ??? ??????? ???? ?? SQL Server.

???? ??? ?????? ???? ???? ????? ?? ??? ???????? ??? ??????? ????? ????? ??? ?????????. ????? ??? ??????? ?? ???? ?? ????? ?????? ???????? ???? ??? ?????? ??? ???????? ??????? ????. ????? ?? ?????????? ???? ??? SQL Server ??????? "???? Microsoft SQL Server 7.0" ?? "???? Microsoft SQL Server 2000" ?????? MSPress ?? ??? ????? ?????? "????? ??????? ?? Microsoft" ??????? ?? ??? "???????" ?? ??? ???????.

??????? ????

??????

????? ????? ????? ?? ?? ????????, ???? ?? ?? ???? ???? ???? ????????. ??? ???? ??????:
  • ???? ?? ?? ??????? ? ???? ??????? ? ????? ?????, ????? RAID ?????? ? ??????? ?????? ???????. ?? ????? ?? ???? ????? ???????? ????? ???? ?? ???? ?????? ???????? ??? ?????.

  • ??? ?????? ??????? ??????? ??? ????? ????????? ?? ????????? ?????? ???? ???? ??? ?????? ?? ?????? ?? ?????? ?? ?? ??????? ???? ?? ??????? ??? ???? ?? ????? ????????? ???????.

  • ???? ?? ??????? ???? ????? ??????? SQL Server ? ????? "???? ????? Windows Microsoft" (????? ?????? ???????) ?? ????? ????? ?? ??????? ?? ????? ??? ?????.

  • ??????? ???? ????? ??????? ?? SQL Server ????? ?? ????????? ????? ???? troublesome ??????? ??? ????? ??? ???????????.

???????

?????? ?? ?????? ?????? ?????? ?? ??????? ??? ?????? ?????? ??? ????? ?? SQL Server 6.5. ?? ??? ???????? ??????? ???? ???? ?????? ?? SQL Server 6.5 ????? ?????? ??????? ?? SQL Server 7.0 ?? SQL Server 2000; ???; ??? ?? ??? ??????? ??? ??????? ?? ????? ????? ????? ?????? ??? ???? ????? ?????????? ???? ????????? ?? ????? ??? ??????? ???? ?? SQL Server.
  • ?????? "????? ??? ??????" ????? ??? ???? ???? ??? ??????? ???? ?????? ?? ????? ?? ?????. ????? ?? ????????? ??? "????? ??? ??????" ???? ??? ?? ???:

    ??? ???? SQL ??? ??????

    Index Tuning Wizard for Microsoft SQL Server 7.0

    Index Tuning Wizard for Microsoft SQL Server 2000

    Troubleshooting the Index Tuning Wizard

    Designing an Index
  • ???????? ??? ?? "????? ??? ??????" ????, ?? ???? ??????? ?????? ???? ?? ???? ?????? ???????? ??? ?? ????. ???? ??????? ??????? ??? ??? ??? ?????? ????? ????? ???? ???? ???? ?????? ???????? hurts ?????? ? ????? ?????. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    297861INF: ???? ???? ??? ????
  • ??? ??? ????? ????? ?????? ??????? ?? ????? ????? ?? ??? ????? ?? ??? ?????? ??? ?????? ?? ????????? ??????. ??? ???? ??? ?? ???? ?????? ?? ??????? ?????? ?????? ?? ?????? seeks ??? ??, ?? ??? ???????? ???? ????. ?? ??? ??? ??? ?? ??? ?? ???? ?????? ?????? ???? ?? ????? ??? ?????? ??? ??? ?????? ????? ?????? ??????? ??????.
?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
311826INF: ???? ??? ????? ???? ?????????

????????

?? ???????? ????? ????? UPDATE ?????????? ????? ??? ????? ???????. ???? ????? ??? ?? ????? ?????? "????? ??????????" ?????? ???? ????. ??? ???? ????? ??? ????? ????? UPDATE ???????? ????? ??? ????? ???????? ?????? ???????? ???? ??? ?????? ??????? ?? ?????? ??????? ?????. ???? ??? ??????? ????? ?? ????????:
  • ??? ??? ??? ????? ?????? ???????? ??? ???????? ??? ????? ??? ?? ????? ?????. ?? ??? ????? ??????? ???? ??? ????? ?? ????? ???????? ?????? ?? ???? Microsoft ?????? ????? UPDATE ?????????? ??????. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    195565INF: ??? SQL Server 7.0 ? SQL Server 2000 Autostats ?????
  • ???????? ????? ?????? ?????? ??? ??????? ?????; ?????? ???? WITH FULLSCAN ?????. ????? ??????? ???? WITH FULLSCAN ????? ??? ????? ????? ????? UPDATE ????????; ??? ???? ?? ???? ??? ?????????? ???? ???? ???? ??? ??? ?? ??? ????? ???????? ????????.

?????

??? self-tune ???? ?????? ??????? ??? ????? ???? ?????? ?????? counter-productive. ???? ????? ??? ?????? ???? ????? proven ??? ????? ??? ????? ???? ????? ???? ???? ???? ?? ?????? ?? ???? ???????. ????? ??? ???? ??? ????? ????????? ?? ????????? ?????????? ??? ?????? ???? ?? ????? ????? ??????? ??? ?????? ?????? ??.
  • ?? ????? ??????? ???? ? ??? ????? ?????? ??????? ???????? ????? ?? ??? ????? ?????? ???? ?????? (???? ????? ??? ???????? ??????? ???????) OFF.

  • ????? ?????? ?????? ????? worker ???? ?????? ??? ???? ???? ?? ????????? 255 ???? ?? ???? detrimental ?????? ??? ???? ?????? ?????????.

?????? ??? ???? ?? ????????? ??? ??? ?????????? ???? "?????? ????? ?????" ??????? "sp_dboption" ?? "??? SQL Server ???????". ????? ????? ?????? ??? ??????? ??????? ?? "????? ??????? ?? Microsoft":
166967INF: ??????? SQL Server 6.5 ????? ???????
319942HOW: ??????? ????? ???? SQL ??????? ?????

??????? ??????

  • ????? ???? ????????? ??????? (???? ? ??? ? ????? ???) ???? ??? ??????? ??? ????????? ???????? ???? ?? ????????? ?? SQL Server 6.5. ???? ????????? ?????? ????? ?? SQL Server 7.0 ??????? ????? ?????? ?? SQL Server 6.5 ??? ??????? ?? ????? ?? SQL Server 7.0 ?? SQL Server 2000. ??? ?? ????? ?? ????? "OPTION ?????" ?? "??? SQL Server ???????":
    ???? ?????? ????????? ????? ????? ??? ??????? ???? ??????? ? ??? ???????? ??? <join_hint> <query_hint> ? ? <table_hint> ???? ??????? ??? ??? ???? ??????? ????? ???????? ?????????.
  • ????? ???? ???? ????? ???????? ?? ???? ??????????? ?????????? ???????. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    243586??????? ??????? ???????? Recompilation ????? ?????
  • ?????? ???? ???? ???? ?? SQL Server. ?????? ??? ??????? ??????? ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
    290211INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000
    274799INF: ????? ?????? ??? ???? ???? 3 Microsoft SQL Server 7.0
  • ???? ???? ???????? ??????????? (??????? ??? ?????? ???????? "??? ?????"). ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    280406PRB: ?? ??????? ?????? ?????????? ?? ???? ???????? ??? Non-???? ?????? ???????? ???? ??????? ??? ???? ???? ?? ?????
  • ???? ?? ?? ?? ???? ?????? ??????? ??????. ????? ????? ???????? ?? ????? ??? ?????? ??????? ???????? ??? ????? ????? ????? ?? ??????? "?????? ????? ??????? ? Filegroups" ?? "??? SQL Server ???????". ?????? ??? ??????? ?????? ??? ??? ???? ??????? ???????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    231347INF: ????? ?????? SQL Server ??? ????? ??? ????? ??????? ????????
  • ???? ??????? ?????? autoshrink ???? ?? ???? ??? ????? ???????? ??? ?????? ?? ?????.

  • ??? ??? ?????? ????? ???????? ????? ??? ???????? (???????? ?????? autogrow) ????? ????? ????? ??? ???? ???? ??? ??? ??????? ???? ????? ???????.
  • ??????? ???? ????? ??????? MDAC ??? ????? ????????? ???????. ?? ???? ???? ????? ????? ???? ??????? ?? ??????? ???? ???? ?????? ?? ????????? ???????. ?????? ??? "DLL ??????? ??????" ?????? ????? ??????? ???? ????? ??? ?????:

    DLL Help Database

  • ?? ?????? ?????? sp_dbcmptlevel ??? ??????? ???????. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    285165INF: ????? ?? ??????? ????? ?????? ????? ??? SQL Server 7.0 ??? SQL Server 2000 ??? ????? ??? ???????

?????

?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
315512INF: ???????? Autogrow ?????? Autoshrink

?????? ??? ??????? ??????? ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
243589INF: ??????? ????? ????? - ????? ????????? SQL Server 7.0 ?? ???
243586INF: ????? ????? Recompilation ??????? ?????
224587HOW: ???? ??????? ?? SQL Server ???????
243588HOW: ???? ????????? Ad-Hoc ???????
224453INF: ?? SQL Server 7.0 ?? 2000 ??? ?????
251004INF: ????? ?????? ??????? SQL Server 7.0
271509INF: ????? ?????? ??????? SQL Server 2000

???????

???? ???????: 297864 - ????? ??? ??????: 01/?? ?????/1425 - ??????: 4.5
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt kbinfo KB297864 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????297864

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com