FIX: SQL Server 2005 ?? overestimate ????? ?????? ?? ????? ??????? JOIN ????? ????? ??????? SQL Server 2005 ??? ????? ??? ??? ????? ????? ???????

???? ???????: 920346 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? #: 714 (??????? ?????? SQL)
????? ???: 434226 (SQLBUDT)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????
???? ??? ?????? | ????? ???????

???????

???? ??? ????????? ??????:
  • ????? ??????? Microsoft SQL Server 2005 ??? ????? ??? ??? ????? ????? ???????. ??? ???? ??????? ????????? ??? ???. 
    FROM t1 JOIN t2 ON t1.a = t2.a AND t1.b = t2.b
  • ??????? ???? ??? ????????? ?? ???? ????? ????? ??? ???????? ?????? ??????? ?? ???? ????? ???????.
  • ??? ??????? ????????? ?? ???? ????? ????? ??? ????? ????? ??????. ????? ????? ???????? ????? ???? ???? ????? ?? ?????? ???? ????? ???? ?? ??? ???? ?? ??????.
  • ??????? ???? ??? ????????? ?? ???? ????? ????? ??? ???????? ???? ????? ???? ?? ????? ??????? - ????.
?? ??? ?????????? ?? overestimate SQL Server 2005 ????? ?????? ?? ????? ??????? JOIN.

????? ??? ????? ??????? ??? ?????? ?? ???? ??? ??????? ??????? ??????? ???? JOIN ???? ??? ?????? ????????? ?????? ????? ??? ??????. ??? ?????? ?????? ????????? ????? ??? ??????, ?? ???? ???? ???? SQL Server 2005 ?????.
???? ??? ?????? | ????? ???????

????

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

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

?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

  • SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1)

    ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    913089
    (http://support.microsoft.com/kb/913089/ )
    ????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
??????? ?????? SQL Server 2005 32-??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.sqlenum9.0.2164.0908,06415 ????? ????03: 32??? ???? ???????
Ms.ss.mgdsqldumper.dll2005.90.2164.075,55215 ????? ????03: 29??? ???? ???????
Msgprox.dll2005.90.2164.0197,92015 ????? ????03: 29??? ???? ???????
Replprov.dll2005.90.2164.0547,61615 ????? ????03: 31??? ???? ???????
Replrec.dll2005.90.2164.0782,11215 ????? ????03: 32??? ???? ???????
Sbmsmdlocal.dll9.0.2164.015,661,85615 ????? ????03: 33??? ???? ???????
Sqlaccess.dll2005.90.2164.0347,93615 ????? ????03: 31??? ???? ???????
Sqlservr.exe2005.90.2164.028,950,87215 ????? ????03: 33??? ???? ???????
??????? ?????? SQL Server 2005 64-??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.sqlenum9.0.2164.0875,29615 ????? ????04: 12??? ???? ???????
Ms.ss.mgdsqldumper.dll2005.90.2164.075,55215 ????? ????03: 29??? ???? ???????
Ms.ss.mgdsqldumper.dll2005.90.2164.091,42415 ????? ????04: 10??? ???? ???????
Msgprox.dll2005.90.2164.0259,36015 ????? ????04: 10??? ???? ???????
Replprov.dll2005.90.2164.0745,24815 ????? ????04: 12??? ???? ???????
Replrec.dll2005.90.2164.01,008,41615 ????? ????04: 12??? ???? ???????
Sbmsmdlocal.dll9.0.2164.015,661,85615 ????? ????03: 33??? ???? ???????
Sqlaccess.dll2005.90.2164.0355,10415 ????? ????04: 11??? ???? ???????
Sqlservr.exe2005.90.2164.039,251,23215 ????? ????04: 13??? ???? ???????
??????? ?????? SQL Server 2005 64-?? ????????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.sqlenum9.0.2164.0875,29615 ????? ????03: 29??? ???? ???????
Ms.ss.mgdsqldumper.dll2005.90.2164.075,55215 ????? ????03: 29??? ???? ???????
Ms.ss.mgdsqldumper.dll2005.90.2164.0163,10415 ????? ????03: 29??? ???? ???????
Msgprox.dll2005.90.2164.0542,49615 ????? ??????: ????? ???? ???????
Replprov.dll2005.90.2164.01,617,18415 ????? ????03: 29??? ???? ???????
Replrec.dll2005.90.2164.02,141,47215 ????? ????03: 29??? ???? ???????
Sbmsmdlocal.dll9.0.2164.048,733,98415 ????? ????03: 30??? ???? ???????
Sqlaccess.dll2005.90.2164.0349,47215 ????? ??????: ????? ???? ???????
Sqlservr.exe2005.90.2164.072,208,67215 ????? ????03: 30??? ???? ???????
???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

??????? ????

?????? ??? ??????? ?????? ??? ????? ????? ???? 4104 ??? ????? ??? ??????? ??????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
824684
(http://support.microsoft.com/kb/824684/ )
??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
???? ??? ?????? | ????? ???????

???????

???? ???????: 920346 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.8
????? ???
  • 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 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
????? ??????: 
kbmt kbautohotfix kbbug kbfix kbtshoot kbhotfixserver kbqfe kbpubtypekc KB920346 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????920346
(http://support.microsoft.com/kb/920346/en-us/ )
???? ??? ?????? | ????? ???????

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

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