????? ????? ?????? ??? ?? ?????? ????? ????? ???????? ??????? ?????? ????? ?????? ?????????? ??? ?? SQL Server 2005 ??? SQL Server 2008

?????? ????????? ?????? ?????????
???? ???????: 914288 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

?????? ????? ????????? ?? Microsoft SQL Server 2005 ?? ?? Microsoft SQL Server 2008 ??????? ??????? ?? ????????? ?????? ??? ??????? ????:
  • ?????? ??????? ????? ????????
  • ???? ???????
  • ????? ?????? ???? ???? ?????
???? ???? ??? ?? ?????? ???? ??? ??? ????? ????????? ??? ??? ???? ????? ????? ???? ???? ????????? ??? ???? ??????.

?? ?????? ????? ??? ??????? ?? Microsoft ?????? ?????? ??? ?? ?????? ????? ????? ????????. ?????? ????? ??? ??????? ?? Microsoft ??? ???????? ????? ?? ????? ?????? ????? ??????? ????????? ?? ????? ????. ???? ??? ??????? ??????? ??????? ?????? ???????? ????? ??????????. ???? ??????? ???? ????? ??????? ???? ????????? ?????????.

??????? ????

??? ??? ?????? SQL Server 2005? ??? ????? ??????? ?????? ???????? ?????? ???? ?? ?? SQL Server ????? Studio ????? SQL Server 2005 Service Pack 2 ?? ????? ????. ??? ??????? ????????? ??????? ?? SQL Server ????? Studio ?? SQL Server 2005? ????? Script ?? ????? ??? ???? ???????? ??????? ??????? ???????? ?? ??? ??????? ????? ???? ????.

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

??? ????? ?????? ????? ?????? ??????? ?????????? ???? ?? ???? ???? ????? ????? ?? ?????? ??? ???????? ????? ????? ???????? ??????? ????? ?? ??????? ?????? ?????? ?????. ??? ????? ????? ???????? ???????? ???? ??????? ???????:
  • ???? ?????? ????? ???????? ??????? ???????? ?????? ????? ???????.
  • ????? ??????? ??? ?????? ???????? ????????.
?????? ??? ????? ????? ?????? ??? ?????? ??????? ????????? ??????? ?????? ?????? ????? ??? ???? ??????? ?????? ????? ??????? ?????? ????? ?? ????? ???? ???????? ????????. ?? ???????? ?? ???? ?????? ???????? ????? ????? ????? ??????. ??? ????? ??????? ?????? ?????? ?????? ???????? ????? ?? ??? ?????? ?????.

??? ???????? ????? ?? ????? ?????? ??? ??????? ????? ?????? ????????? ????? ??? ???? ??????? ???????:
  1. ??? Studio ????? ???? SQL.
  2. ?? ?????? ??????? ?? ?????? ????? ????????? ?? ??? ???? ????? ???????? ???? ???? ????? ???????? ?????.
  3. ?? ?????? ?????? ??? ????? ????????? ???? ??? ??????? ?? ???? ??? ????? ??????? ??????.
  4. ?? "????? ?????? ???"? ???? ?? ????? ????? ???????? ???????. ???? ?????? ???????? ????? ????? ???????? ?? ????? ???????? ??????? ???? ???????? ??? ?? ???? ??? ??????.
  5. ?? ???? ?????? ???????? ????? ????? ?????? ????????? ??????? ?? ?????? ?????????? ??? ?????? ???? ?? ????? ?? ?????? ??????.
    ?? ??? ??????????? ??? ??????
    ?????? ??????? ?????????? ??????
    ??????? ??????? Ansi????
    ?????? ??????? ?????? ??? ???????
    ????? ?????? ??? ???????? ???????????
    ????? ????? ??? ??????????
    ????? ??? ???????? ?????????
    ????? ????? ?????? ???????? ?????????
    ???????? ????? ?????? ??????????
    ?????? ????? ???? ???????? ?????????
    ???????? ???????? ????????????? ???????? ????? ??????? ????????
    ????? ???????? ?????????
    ?????? ??????? ??????????
    ?????? ????? ???????? ????? ?????? ?????? ?????? ? ?????? ????? ???? ???????? ????? ?? ?? ???? ?????? ?????? ?? ?? ????? ?????? ??? ???????? ???? ?????? ??????? ?????? ???? dbo.
  6. ???? ??? ??????.
  7. ???? ??? ???????? ????? ??? ??? ????? ??? ?????? ??? ???.
  8. ???? ??? ?????.

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

?? ???????? ????? ???????? ??????? ???? ??? ?????? ????? ?????? ??????? ???? ????? ?? ??????? ?????? ?????? ?????? ?????. ??? ???? ??? ??? ?? ????? ???? ?????? ????? ???????? ???????? ?????? ?? SCHEMABINDING? ??????? ??????? ?? ???? ???? sys.depends ?? ?? ?????? ???? ?????. ?? ???? ??? ????? ??? ???? ???????? ???????:
  • ??? ?????? ??? ????? ??????? ?????? ???? ????.
  • ?? ?????? ??? ????? ??????? ?????? ???????? ?? ??????? ??? ????. ?????? ???????? ????? ?????? ??? ????? ???????? ????? ???? ?? ?????? ??????.
????? ?? ???? ???????? ????? ?????? ?????? ??? ??? ???? ????? ???????? ????? ??? ?????? ?? ???????? ???????? ?????? ??? ??????? ????? ??????. ?? ???? ????? ??????? ???????? ????? ?????? ?????? ???? ??????? ???????:
  1. ?? SQL Server ????? Studio? ?? ?????? ????? ????????? ?? ??? ???? ????? ???????? ???? ???? ????? ???????? ?????.
  2. ?? ?????? ?????? ??? ????? ????????? ???? ??? ????? ?????? ???????? ?????? ??? ??? ????? ???? ?? ???? ??? ???.
  3. ???? ??? ??? ??? ?? ???? ??? ???.

    ??? ???? ??????? ????? ????? ???????? ????????. ????? ??? ??????? ??????? ???????? ????? ?? ????? ???????? ??????.
  4. ?? ?????? ?????? ??? ????? ????????? ???? ??? ??????? ?? ???? ??? ????? ??????? ??????.
  5. ???? ?? ????? ????? ???????? ??????? ??? ?? ???? ??? ??????.
  6. ?? ???? ?????? ???????? ????? ????? ?????? ????????? ??????? ?? ?????? ?????????? ??? ?????? ???? ?? ????? ?? ?????? ??????.
    ?? ??? ??????????? ??? ??????
    ?????? ??????? ?????????? ??????
    ??????? ??????? Ansi????
    ?????? ??????? ?????? ??? ???????
    ????? ????? ??? ??????????
    ????? ?????? ??? ???????? ???????????
    ????? ??? ???????? ?????????
    ???????? ????? ?????? ??????????
    ?????? ????? ???? ???????? ?????????
    ???????? ???????? ????????????? ???????? ????? ??????? ????????
    ???????? ????? ????? ?????? ?????????????
    ????? ???????? ?????????
    ?????? ??????? ??????????
    ?????? ????? ???????? ????? ?????? ?????? ?????? ? ?????? ????? ???? ???????? ????? ?? ?? ???? ?????? ?????? ?? ?? ????? ?????? ??? ???????? ???? ?????? ??????? ?????? ???? dbo.
  7. ?? ???? ????? ???????? ???? ??????? ??? ?? ????? ?????? ????? ???????? ???? ???? ????????? ????? ???.

    ??? ???? ??????? ??? ??? ????????? ???? ??????? ???? ??? ???????. ??? ??? ????????? ???? ????? ???? ??? ??? ????? ????????. ??? ??? ????????? ????? ?????? ???? ????? ?? ??? ????????? ??? ?????.
  8. ????? ???? ?????? ???? ????? ???????? ???? ??? ?????? ????? ?????? ?????????? ???? ??? ??????.
  9. ???? ???? ???? ??? ??? ???? ????? ???????? ???? ??? ???????? ?? ?????? 7. ?? ?? ???? ??????? ??? ??????? ???????? ??? ????? ?? ??????? ?? ?????? ????? ???????? ??????? ??? ?? ???? ??? ??????.
  10. ???? ??? ???????? ????? ??? ??? ????? ??? ?????? ??? ??? ????? ???? ??? ??????? ?? ?????? 3.
  11. ???? ??? ????? ???? ????? ??????? ??????.
??? ?????? ??????? ?????? ?? ????? ??? ???????? ????? ??? ????? ????? ??? Microsoft. ?? ???? ????? ????? ??? Microsoft ???? ????????? ???????:
  • ????? ??????? ??? ?? ??? ??? ????????? ?????? ??????? ??????? ?????
  • ????? ?????? ???? ???? ???? ??? ????? ?????????
?????? ??? ?????? ??????? ??? ????????? ?????? ????? SQLDiag ?? ????? ???? ???? ????? ??????? SQL. ?? ???? ???? ??????? ????? ??? ?????? ??? ?????????.

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

??????? ??????? ??????? ???? ????? ??????? ???? ????????? ??? ????????? ?????? ??? ???????.

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

?? ??? ??????????? ??? ??????
???????? ????????? ???? ????? ?????? ???? ????? ?? ??????? ??? ????????? ??????? ???????. ??? ???? ??????? ??? ??? ????????? ????? "???? ?????? = ???? 5" ? "??? (??????< 5)"="" check="" constraint="" exists,="" the="" query="" optimizer="" knows="" that="" no="" rows="" will="">

???? ???? ????????? ????? ?????? ?? ???????? ??? ??????? ???? ????? ???????. ??? ???? ??????? ???? ??????? "???? ????? ??? ??????" ?? ???? true ?? false ???????? ??? ???? ????? ??????? ??????? ??? ??? ??? ?????? ?? ?????? ??????? ?? ??? ??????. ???? ???? "??????? ???????" ???? ?????? ??????? ???????? ?????? ????? ???????. ??????? ???? ????????? ??????? ??? ?????? ?? ?????? ?? ????? ????????. ??? ????????? ?? ????? ?????? ?????? ??? ??????? ????????.
????????????? ??? ??????? ???????? ??????? ???? ????? ???? ????? ?????? ??????? ????? ?????? ???????????. ??? ??? ????? ???? ???????? ???? ??????? ???? ????????? ????? ????? ??????? ?? ?????? ?????? ??????? ???????? ????? ???????. ??????? ????? ?????? ???????? ??????? ???????? ?????. ?????? ??????? ??????? ???????? ?????? ?? ????? ????? ???? ?????. ????? ??? ?? ???? ???? ??????? ??????? ???????? ???? ?????? ??? ??? ????????? ??????.
??? ?????? (??? ?????? ??????)???? ????????? ?????? ?????? ???????? ?????? ????? ???????? ??????? true ?? false. ??? ???? ??????? ??????? ???????? ???????? ???? ???????? ??? ?????? ???? ??? ??????? ?????? ???? ??????? ???????. ??? ??????? ?? ?????? ?? ?????? ???? ?? ????? ????? ???????/???????. ??? ??????? ??? ?????? ????? ????? ????? ????? ??? ????? ??? ??????? ???? ???? ?????? ????? ????? ??? ????.
?????? ????? ???????????? ?? ???? ?????? ?? ?????? ????? ???????? ??? ????? ??????. ????? AUTO_CREATE_STATISTICS ? AUTO_UPDATE_STATISTICS ???? ???????? ??? ?? ??? ??? ???? ????? ???? ????????? ???????? ????? ?? ????? ?????????? ?????. ????? ????? ???????? ???????? ???? ????? ??? ????? ??? ?????? ????????? ??????? ??? ????? ??????? ??????? ??? ???? ?????????. ????? ???????? ???????? ???? ?? ???? ??? ????? ??????? ???????? ????? ???? ??? ???????? ?? ??? ????? ???????? ?? ????? ???? ?? ????? ??????. ????? DATE_CORRELATION_OPTIMIZATION ???? ??????? ???? ????? ?? ?????????? ??? ???????. ???? ??? ??????? ??? ????? ?????? ?????? ????????.

??????

?? ??? ??????????? ??? ??????
????? ?????? ???? ?????ANSI_NULLS ????? ???? ??? ?? ??? ??? "NULL = NULL" ????? ??????? ??? true. ?? ????? ????? ??????? ???????? ????? ?????? ???????? ??? ??????? ??????. ???????? ??? ???? ?? ????? ??????? ?????. ??? ???? ??????? "?????? = NULL" ????? ??????? ???? ????? ???????? ??? ???????. ??? ???? "?????? IS NULL" ????? ??????? ?????? ???? ???????.
????? ???????????? ???? ?????? ????? ???????? ??? ?????? ????? ??????? ???????? ??? SQL Server. ??? ???? ??????? ??? ??? ??? ???????? ???? ?? ????? ??????? ??????? ???? ????????? ???? ??? ?????? ????? ???????? ??? ?????. ??? ???? ??? ??? ??? ???????? ???? ????? ?? ????? ??????? ??????? ??????? ?????? ?????? ?? ?? ???????. ????? SQL Server ???? ??????? ?????? ??? ??? ?????? ????? ???? ?? ???? ???? ?? ????? ????? ?? ???????? ????? "MAXDOP" ?? ???? ???? ?? ??????? ???? ???????.
???????? ????? (SKU) ?????? ???? SQL??? ????? ??? ??????? ??? ??? ??????? ????? ?? SQL Server 2005 ?? SQL Server 2008. ??? ???? ??????? ????? ??????? ????? ??? ????? ???????? ??? ???? ?? SQL Server 2005 Enterprise Edition. ????? ?????? ?????? ????? ??? ???? ????? ??? SQL Server 2000 Standard Edition ? SQL Server Enterprise 2005 Edition.

???????

???? ???????: 914288 - ????? ??? ??????: 11/????? ???????/1434 - ??????: 5.0
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbexpertiseinter kbexpertiseadvanced kbsql2005engine kbhowto kbinfo kbmt KB914288 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????914288

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

 

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