FIX: ???? ????? ?? ???? ??? ??????? ???? ??? ????? ??????? SQL ???????? ???? ?????? ???? n ??????? ??? ???? ????? ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 924601 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 1253 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ??????? ??? ??? ?????
  • ????????? ??????? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ??????? ??????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ??????? ??? ????? ???? ??????? ??????
  • ??????? ??????? ?? ???? ????????? ???????

???????

??? ????? ??????? SQL ???????? ???? ?????? ???? n ??????? ??? ???? ????? ?? Microsoft SQL Server 2005 ?? ?????? ????? ????? ??? ??????? ????. ?? ????? ????? ??? ???? ?????? ???????? ????? ?? ????? ????? ???? ??? ?????? ???? ??????. ??? ???? ??????? ????? ??? ??????? ??? ????? ???????? ?????????:
  • ????? ??????? ????? ???? tblTest. ????????? ?? ???? ?? ???:
    SELECT top 1 * FROM tblTest WHERE OrderID = 'ABCDXYZ' ORDER BY OrderDateTime DESC
  • ?? ????? ?????? tblTest ??? ???? OrderDateTime.
  • ??? ????? ???? ?????? ???????? ??? ???? OrderDateTime.
  • ??? ????? ???? ??? ?????? ??? ???? OrderID.
?????????
  • ?? ???? ??? ????? ???? ???? ?????? ???????? ???? ??????? ORDER BY.
  • ????? ??? ????? ?????? ???????? ?? ??? ????? ??? ????? ???? ??? ??????.

?????

???? ??? ??????? ???? ?????? ????????? overestimates ????? ??????? ???? ????? ?? ???? ?????.

????

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

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

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

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

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

?????? ??? ??????? ??????? ??? ?? ???? ???? SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ?????? ??? ???? ?????????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.
????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 ? ??????? ?? ?? x 86
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.2187.0398,11231 ????? ????07: 40x 86
Microsoft.analysisservices.adomdclient.dll9.0.2187.0543,52031 ????? ????19: 41x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2187.0138,01631 ????? ????19: 38x 86
Microsoft.analysisservices.dll9.0.2187.01,215,26431 ????? ??????: ??x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2187.075,55231 ????? ????19: 37x 86
Microsoft.sqlserver.sqlenum.dll9.0.2187.0908,06431 ????? ??????: ??x 86
Msgprox.dll2005.90.2187.0197,92031 ????? ????07: 40x 86
Msmdlocal.dll9.0.2187.015,610,14431 ????? ??????: ??x 86
Msmdredir.dll9.0.2187.03,990,30431 ????? ????07: 40x 86
Replprov.dll2005.90.2187.0547,61631 ????? ????19: 41x 86
Replrec.dll2005.90.2187.0782,11231 ????? ??????: ??x 86
Sqlaccess.dll2005.90.2187.0347,93631 ????? ????07: 40x 86
Sqlagent90.exe2005.90.2187.0319,26431 ????? ??????: ??x 86
Sqlservr.exe2005.90.2187.028,961,11231 ????? ??????: ??x 86
Xpstar90.dll2005.90.2187.0292,64031 ????? ??????: ??x 86
Xpstar90.rll2005.90.2187.0152,86431 ????? ??????: ??x 86
SQL Server 2005, ????? 64-??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.2187.0522,52801 ?????? ????00: 06x 64
Microsoft.analysisservices.adomdclient.dll9.0.2187.0543,52031 ????? ????19: 41x 86
Microsoft.analysisservices.adomdclient.dll9.0.2187.0543,52001 ?????? ????00: 02x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2187.0138,01631 ????? ????19: 38x 86
Microsoft.analysisservices.dll9.0.2187.01,215,26431 ????? ??????: ??x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2187.075,55231 ????? ????19: 37x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2187.091,42401 ?????? ????00: 03x 64
Microsoft.sqlserver.sqlenum.dll9.0.2187.0875,29601 ?????? ??????: ??x 86
Msgprox.dll2005.90.2187.0259,36001 ?????? ????00: 05x 64
Msmdlocal.dll9.0.2187.015,610,14431 ????? ??????: ??x 86
Msmdredir.dll9.0.2187.03,990,30431 ????? ????07: 40x 86
Replprov.dll2005.90.2187.0745,24801 ?????? ????00: 03x 64
Replrec.dll2005.90.2187.01,008,41601 ?????? ??????: ??x 64
Sqlaccess.dll2005.90.2187.0355,10401 ?????? ????00: 06x 86
Sqlagent90.exe2005.90.2187.0390,94401 ?????? ????00: 06x 64
Sqlservr.exe2005.90.2187.039,341,85601 ?????? ????00: 03x 64
Xpstar90.dll2005.90.2187.0540,96001 ?????? ????00: 06x 64
Xpstar90.rll2005.90.2187.0153,37601 ?????? ??????: ??x 64
SQL Server 2005 ? ??????? ????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.2187.01,095,45631 ????? ????23: 02IA-64
Microsoft.analysisservices.adomdclient.dll9.0.2187.0543,52031 ????? ????19: 41x 86
Microsoft.analysisservices.adomdclient.dll9.0.2187.0543,52031 ????? ????23: 01x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2187.0138,01631 ????? ????19: 38x 86
Microsoft.analysisservices.dll9.0.2187.01,215,26431 ????? ??????: ??x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2187.075,55231 ????? ????19: 37x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2187.0163,10431 ????? ????23: 00IA-64
Microsoft.sqlserver.sqlenum.dll9.0.2187.0875,29631 ????? ????23: 02x 86
Msgprox.dll2005.90.2187.0542,49631 ????? ????23: 01IA-64
Msmdlocal.dll9.0.2187.048,587,04031 ????? ????23: 01IA-64
Msmdredir.dll9.0.2187.06,237,47231 ????? ????23: 02IA-64
Replprov.dll2005.90.2187.01,617,18431 ????? ????23: 02IA-64
Replrec.dll2005.90.2187.02,141,47231 ????? ????23: 02IA-64
Sqlaccess.dll2005.90.2187.0349,47231 ????? ????23: 01IA-64
Sqlagent90.exe2005.90.2187.01,143,58431 ????? ????23: 02IA-64
Sqlservr.exe2005.90.2187.072,216,86431 ????? ????23: 01IA-64
Xpstar90.dll2005.90.2187.0951,07231 ????? ??????: ??IA-64
Xpstar90.rll2005.90.2187.0152,35231 ????? ????23: 02IA-64

?????

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

??????? ????

????????? ?? ??? "???????" ?? ???? ??? ??????? ?????? ???? ????? ??????: ????
SELECT top 1 * FROM tblTest WHERE ORDERID = 'AE5PL-14' ORDER BY OrderDateTime DESC
|--Top(TOP EXPRESSION:((1)))
|--Nested Loops(Inner Join, OUTER REFERENCES:([PtnIds1004]) PARTITION ID:([PtnIds1004]))
|--Constant Scan(VALUES:(((32)),((31)),((30)),((29)),((28)),((27)),((26)),((25)),((24)),((23)),((22)),((21)),((20)),((19)),((18)),((17)),((16)),
((15)),((14)),((13)),((12)),((11)),((10)),((9)),((8)),((7)),((6)),((5)),((4)),((3)),((2)),((1))))
|--Clustered Index Scan(OBJECT:([part2].[dbo].[tblTest].[IX_tblTest_RT]), WHERE:([part2].[dbo].[tblTest].[OrderID]='AE5PL-14') 
ORDERED BACKWARD 
PARTITION ID:([PtnIds1004]))
????????? A ??? ?????? ???? ????? ??? ?? ???? ?? ???:
SELECT top 1 * FROM tblTest WHERE ORDERID = 'AE5PL-14' ORDER BY OrderDateTime DESC
|--Top(TOP EXPRESSION:((1)))
|--Nested Loops(Inner Join, OUTER REFERENCES:([Uniq1002], [nonpart2].[dbo].[tblTest].[OrderDateTime], [Expr1004]) WITH 
ORDERED PREFETCH)
|--Index Seek(OBJECT:([nonpart2].[dbo].[tblTest].[IX_tblTest]), SEEK:([nonpart2].[dbo].[tblTest].[OrderID]='AE5PL-14') ORDERED 
BACKWARD)
|--Clustered Index Seek(OBJECT:([nonpart2].[dbo].[tblTest].[IX_tblTest_RT]), SEEK:([nonpart2].[dbo].[tblTest].[OrderDateTime]=
[nonpart2].[dbo].[tblTest].[OrderDateTime] AND [Uniq1002]=[Uniq1002]) LOOKUP ORDERED FORWARD)

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

?????? ??? ???? ?? ????????? ??? ?????? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
923849FIX: ???? ????? ??????? ???? ???? ????? ?? SQL Server 2005 ???? ????????? ?? ?????

???????

???? ???????: 924601 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.6
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
????? ??????: 
kbmt kbautohotfix kbfix kbexpertiseadvanced kbsql2005tsql kbhotfixserver kbqfe kbpubtypekc KB924601 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????924601

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

 

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