SQL Server 2008 R2 ???????? ????? 2 ? SQL Server 2008 ???? ?????? SP1 ???????? ????? 7 ? SQL Server 2005 ???? ?????? SP3 ???????? ????? 9 ????? ????? ???? 4136 ???? ???????? ?????? ????? "?????? ??? ?????"

?????? ????????? ?????? ?????????
???? ???????: 980653 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft ????????? Microsoft SQL Server 2008 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

?????

Microsoft SQL Server 2008 R2 ???????? ????? 2? SQL Server 2008 Service Pack 1 (SP1) ?????? ???????? ???????? 7 ? Microsoft SQL Server 2005 Service Pack 3 (SP3) ?????? ???????? ???????? 9 ????? ????? ???? 4136? ???? ???? ???????? ?????? ?? ????? "?????? ??? ?????". ???? ?????? ??? ???? ?? ????????? ??? ?????? ??? ????? ?? ????? ??? ??????? ?? ???:http://blogs.msdn.com/b/queryoptteam/archive/2006/03/31/565991.aspx.????? ???? ??????? 4136 ????? ?????? ??? ?????? ??? ??????? ?????? ????? "??? ????? FOR ?????" ??? ??????? ???? ???? ?????.

??????????? ???? ??? ??????? ??????? ?? ???? ???? ?????? ??? ????? ??? ?? ???? ????? ??????? ??????.
  • ?? ????? ??????? ???????? "?????? (@ p = <value>)" ????????? ???????.</value>
  • ????????? ?????? ????? ????????? "option(recompile)".
  • ????????? ?? ??? ?? ????? ???? ?????? ?????? "? recompile".

??????? ????

SQL Server 2005

?? ????? ??? ?????? ???? ??? ?? ??????? ???????? 9 ? SQL Server 2005 Service Pack 3. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
980176???? ??????? ???????? 9 ? SQL Server 2005 Service Pack 3
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
960598???? SQL Server 2005 ???? ?? ??????? ??? ????? SQL Server 2005 Service Pack 3
Microsoft SQL Server 2005 ????????? ??????? ??? ????? ??? ????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2005 Service Pack 3 ?????? SQL Server 2005 Service Pack 3. ???? ???????? ??? ????? ?? ????????? ???????? ?? ???? ???? SQL Server ?? ???? ???? ? SQL Server ???????.

SQL Server 2008

?? ????? ??? ?????? ???? ?? 7 ??????? ???????? ????? ?????? Service Pack 1 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
979065???? ??????? ???????? 7 ? SQL Server 2008 Service Pack 1
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 1
Microsoft SQL Server 2008 ????????? ??????? ??? ????? ??? ????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 Service Pack 1 ??? ????? SQL Server 2008 Service Pack 1. ???? ???????? ??? ????? ?? ????????? ???????? ?? ???? ???? SQL Server ?? ???? ???? ? SQL Server ???????.

SQL Server 2008 R2

?? ????? ??? ?????? ???? ?? 2 ??????? ???????? ? R2 2008 ???? SQL. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? R2 2008 ???? SQL? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2072493???? ??????? ???????? 2 R2 2008 ???? SQL
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? R2 2008 ???? SQL ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
981356???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? R2 2008 ???? SQL

?????

?????? ??? ???? ?? ????????? ??? ????? "?????? ??? ?????"? ???? ???? ?????? "??????? ? recompilations ??????? ???" ????? ????? Microsoft TechNet ??? ??? ??????:
??????? ??????? ?????? recompilation ???? ??????? ?????? ???????? ?? SQL Server 2005
?????? ??? ????????? ??? "????? ????? ??????" ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897????? ????? ?????? ????? ?? ?????? SQL Server ?????? ????????? ??????? ??????? ???? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ?????? ??????? ??????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499???? ????? ????? ???? ??????? ????? Microsoft SQL Server


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

???????

???? ???????: 980653 - ????? ??? ??????: 06/???/1432 - ??????: 3.0
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Service Pack 3
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Workgroup
????? ??????: 
kbexpertiseadvanced kbsurveynew kbqfe kbfix kbmt KB980653 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????980653

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

 

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