FIX: "????? ?????" ?? ????? ????? ??? ???? ?? SQL Server 2008: "?????? 1 ???? ?? ????? ??????? ????"

?????? ????????? ?????? ?????????
???? ???????: 956031 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 50003626 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? ??????? sp_estimate_data_compression_savings ??????? ??? ???? ????? ?? ????? ????? nonclustered ? ???? nonclustered ???? ?? ???? ?? Microsoft SQL Server 2008 ?? ????? ????? ????? ???????:
msg 512 ? 16 ??????? 1 ???? sp_estimate_data_compression_savings ????? 251 ??
??????? ???? ?????? ???? ???? ?? 1. ??? ??? ????? ??? ????? ???? ????????? ?????? = ?! = ? < ?? < = ? > ? > = ?? ??? ??????? ????????? ?????? ??????.
??? ????? ?? ?? ????? ????? ????? ??? ??? ????? ???????. ??? ???? ???????? ????????? ????? ?? ??? ??????? nonclustered ??? ?????.

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

????

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

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2008. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
968382????? ?????? ??? ???? ???? ???? ?? SQL Server 2008

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

?? ????? ??????? ????? ???? ??????? ????? ?? 2 ??????? ????????. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
958186???? ??????? ???????? 2 SQL Server 2008
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008

???? ??????

??????? ?????? ??? ??? ??????? ??? @ index_id ??????? ??? ????? sp_estimate_data_compression_savings ??????? ??????. ??? ????? ??????? ?????? ?? ??? ????? ?? ???? ???? ?????.

?????

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

??????? ????

??? ??????? ??????? sp_estimate_data_compression_savings ????? ?????? ????? ?????? ???????. ??????? sp_estimate_data_compression_savings ????? ????? ????? ??? ?????? ???? ????? ???????.

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

  1. ??? ????? SQL Server ????? Studio ?? ?? ?????? ??? ???? SQL Server 2008.
  2. ?? ?????? ??????? ???? ?? ?? ?????? ???????? ???????.
    CREATE DATABASE TEST
    GO
    USE Test
    GO
    
    CREATE TABLE REPRO(i int primary key nonclustered, a int)
    GO
    
    CREATE NONCLUSTERED INDEX NONCLUSTERED_REPRO ON REPRO(a)
    GO
    
    EXEC SP_ESTIMATE_DATA_COMPRESSION_SAVINGS @schema_name = 'dbo', @object_name = 'repro', @index_id = NULL, @partition_number = NULL, @data_compression = 'PAGE'
    
?????? ??? ???? ?? ????????? ??? ????? ?? ?? ??????? ? ?????? ??? ??????? ??? ??? ??????? ????? ?????? ???? ??????? ???????? ???? ????? ??? ??????? ?????? ?????? ?? ????? "????? ??????? ?? Microsoft" ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
958186???? ??????? ???????? 2 SQL Server 2008

?????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ????? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 956031 - ????? ??? ??????: 12/???? ??????/1430 - ??????: 3.0
????? ???
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt sql2008relnotedatabaseengine sql2008relnote kbbug kbqfe kbfix kbexpertiseadvanced kbprb KB956031 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????956031

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

 

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