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

?????? ????????? ?????? ?????????
???? ???????: 919636 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 810 (??????? ?????? SQL)
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????
???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ??????? ??? ??? ?????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ??????? ??? ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ??????? ??? ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ??????? ??? ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

??? ??? ??? ????????? ???????? ?? ??????? ?? ????? ????? ??????? ??????? ???? ????????? complied ?? ???? ??? ????? ?? SQL Server 2005 ?????? ?? Microsoft SQL Server 2000.

?? ???? ??? ??????? ??? ???? ??? ?????? ???????:
  • ?????? 1: ????? ????????? ??? ???? ?????? ??????? ????????.
  • ?????? 2: ????? ????????? ??? ?????? ????? ??? ????? ??????? nvarchar ?????? ANSI. ??? ???? ??????? ??????? ????? ?????? ??? ??????? nvarchar ??? ????? ???? ANSI.
  • ?????? 3: ????? ????????? ??? ???? ??? ???? ???? ????? ??? ???? ?????. ????? ??? ???? nvarchar ?? ???? ?????. ??? ???? ?????? ?????? ????????? ????? ??????? ANSI ?? ???????.
????? ?????? 2 ? 3 ????? ???? ?? ??????? ?? ??????? ??? ????????? ????????.

??? ???? ??????? ???? ???? ????? ??? ???? nvarchar. ??? ?????? ?? ?????? ? ?? ??? ?????? nvarchar MyCol. ??? ????? ????????? ???????? ???? ?????? ??????:
SELECT CASE MyCol
          WHEN 'Value1' THEN 'NewValue1'
          WHEN 'Value2' THEN 'NewValue2'
          ELSE MyCol
       END
FROM MyTable
?? ??? ??????? ????? "??????" ? "Value2" ? "NewValue1" ? "NewValue2" ????? ANSI. ??? ?????? ??? ?????? nvarchar MyCol ????? ?? ??????? ANSI "??????" ? "Value2". ?????? ???????? "NewValue1" ? "NewValue2" ?? ?????? ??????? ANSI ?? ?????? ??????? ????? MyCol.

????? ??? ??????? ??????? ??? ???????? ?? ???? ??? ???? pagesused ???? ?????? sys.syscacheobjects ?? ????? ??? ????? ???? sys.dm_exec_cached_plans.

???? ?? ???? ??? ????? ????? ???? ????????? complied ????? ??? ????? ??? ?????? ???? ???????? RESOURCE_SEMAPHORE_QUERY_COMPILE.

????

????? ????? ???? ????? ?? 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

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

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????. ??? ???? ??? ??? ??? ?????? ??? ??????? ??? ??? ????? ??????? ???????? ?? ????? "Workground" ??? ????? ??? ??????? ?????? ?????? ????? ????? ???????? ??? ???? ????.

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.sqlenum.dll9.0.2164.0908,06414 ????? ????12: 32x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2164.075,55214 ????? ????12: 29x 86
Msgprox.dll2005.90.2164.0197,92014 ????? ????12: 29x 86
Replprov.dll2005.90.2164.0547,61614 ????? ????12: 31x 86
Replrec.dll2005.90.2164.0782,11214 ????? ????12: 32x 86
Msmdlocal.dll9.0.2164.015,661,85614 ????? ????12: 33x 86
Sqlaccess.dll2005.90.2164.0347,93614 ????? ????12: 31x 86
Sqlservr.exe2005.90.2164.028,950,87214 ????? ????12: 33x 86
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.sqlenum.dll9.0.2164.0875,29614 ????? ????13: 12x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2164.091,42414 ????? ????12: 29x 64
Msgprox.dll2005.90.2164.0259,36014 ????? ????13: 10x 64
Replprov.dll2005.90.2164.0745,24814 ????? ????13: 12x 64
Replrec.dll2005.90.2164.01,008,41614 ????? ????13: 12x 64
Msmdlocal.dll9.0.2164.015,661,85614 ????? ????12: 33x 86
Sqlaccess.dll2005.90.2164.0355,10414 ????? ????13: 11x 86
Sqlservr.exe2005.90.2164.039,251,23214 ????? ????13: 13x 64
????? ????? SQL Server 2005 Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.sqlenum.dll9.0.2164.0875,29614 ????? ????12: 29x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2164.0163,10414 ????? ????12: 29IA-64
Msgprox.dll2005.90.2164.0542,49614 ????? ????12: 28IA-64
Msmdlocal.dll9.0.2164.048,733,98414 ????? ????12: 30IA-64
Replprov.dll2005.90.2164.01,617,18414 ????? ????12: 29IA-64
Replrec.dll2005.90.2164.02,141,47214 ????? ????12: 29IA-64
Sqlaccess.dll2005.90.2164.0349,47214 ????? ????12: 28x 86
Sqlservr.exe2005.90.2164.072,208,67214 ????? ????12: 30IA-64

???? ??????

??????? ?????? ??? ??? ??????? ?? ?????? ??? ???? "N" ???? ???? ??????? ???????? ?? ???? ???????. ????? ????? ?????? ??????? ?? ??? "???????" ???????? ???? ?????? ??????:

SELECT CASE MyCol WHEN N'Value1' THEN N'NewValue1' WHEN N'Value2' THEN N'NewValue2' ELSE MyCol END FROM MyTable

?????

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

??????? ????

????? ??? ??????? ??????? ??? ???????? ?? ???? ??? ???? pagesused ???? ?????? sys.syscacheobjects ?? ????? ??? ????? ???? sys.dm_exec_cached_plans.

????? ?? ????????? ??? ???? ?????? sys.syscacheobjects ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms187815.aspx
?????? ??? ???? ?? ????????? ??? ????? ??? ????? ???? sys.dm_exec_cached_plans ?? ?????? ???? MSDN ??????:
http://msdn.microsoft.com/en-us/library/ms187404.aspx
????? ?? ????????? ??? ???? ??????? ???????? Microsoft SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 919636 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.9
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
????? ??????: 
kbmt kbautohotfix kbsql2005engine kbhotfixserver kbexpertiseadvanced kbqfe kbfix kbpubtypekc KB919636 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????919636

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

 

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