FIX: ??? ??? ??????? ???? ???? ?? ????? ?????? ??? ???????? ??? ?? re-partition ?????? ???? ??? ???????? ???? ??? ??? ????? ?????? ?? SQL Server 2008

?????? ????????? ?????? ?????????
???? ???????: 974262 - ??? ???????? ???? ????? ????? ??? ???????.
Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ????? ??????? ???? ??? ????? ???? ??? ????? ?? Microsoft SQL Server 2008.
  • ??? ????? ?????? ??? ???????? ????? ??????.
  • ??? ??????? ????? ?? ??? ????.
  • ???? ???? ???????? ??????? ????? ????? ??????? ?????? ?? ?????? ????? ??????:
    • ????? ??????? FREESYSTEMCACHE('ALL') DBCC.
    • ????? ??????? ????? DDL ??? ??????.
  • ????? ??????? ?????? ????? ????? ?????? ??? ????? ??? ????.
?? ??? ?????????? ??? ????? ?????? ??? ???????? ????? ?????? ??????. ????? ????? ??????? ??????? ?????? ??? ???? ??? ???????? ?????? ??????:
SELECT OBJECT_NAME(object_id), index_id, partition_number, rows, data_compression_desc
FROM sys.partitions
WHERE object_id = object_id('<obj_id>')
ORDER BY partition_number
??????<obj_ID> ???? ???? ?????? ??????.

???????? ??? ???? ??? ??? ???????? ??? ???? ???? ????? ??? ???? ??? ???????? ????? ???? ????? ???? ????? ??? ???? ??? ???????? ????? ???? ????? ????? ???????:
msg 11406 ? ????? 16 ???? 1? ?? 12
??? ????? ALTER TABLE ?????. ????? ?????? ?????? ?? ???? ???? ??? ?????? ?????? DATA_COMPRESSION.

?????

??? ??? ???? ??????? ???? ?? ????? ?????? ??? ???????? ?? ???? ???? ????? ?????? SQL Server ?????? ?????? ????? ????? ????? ?????? ???? ??????.
?????? ??? ????? ?????? ????? ??????? ??? ???????? ??? ?????.

?? ??? ????? ????? ??????? ?????? ?? ?????? ????? ?????? ????? ??? ?????? ??????? ?????? ?? ????? ????? ?????? ???? ??????. ??? ????? "????? ??????? ?????? ?? ?????? ????? ??????" ? ??? ????? ????? ??????? ?????? ?? ?????? ????? ???? ?????? ????? ????? ????? ?????? ???? ?????? ?? ?????. ??? ?????? ????? ????? ????? ???????? ?????? ???? ?? ?????? ??? ????? ??? ????? ???? ??????? ??????? ?? ??? "???????".

????

SQL Server 2008

??? ??? ??????? ????? ??? ??? ??? ?????? ???? ????? Microsoft SQL Server 2008.

?? ????? ??????? ????? ???? ??????? ????? ?? 7 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
973601???? ??????? ???????? 7 SQL Server 2008
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008

SQL Server 2008 ?????? ????? ?????? Service Pack 1

??? ??? ??????? ????? ??? ??? ??? ?????? SQL Server 2008 ?????? ????? ?????? Service Pack 1.

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 4 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ????? ?? ????????? ??? ???? ??????? ???????? ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
973602???? ??????? ???????? 4 SQL Server 2008 ?????? ????? ?????? Service Pack 1
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? 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 ???????.

?????

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

?????

?????? ??? ???? ?? ????????? ??? ????? ????? ??? ???? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/ms190273.aspx
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????


????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server


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

???????

???? ???????: 974262 - ????? ??? ??????: 02/????/1430 - ??????: 1.1
????? ???
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
????? ??????: 
kbmt kbsurveynew kbexpertiseadvanced kbqfe kbfix KB974262 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????974262

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

 

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