SQL Server 2008 Over

《SQL Server 2008 Over》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、SQLServer2008OverviewPresentedbyTarekGhazaliITTechnicalSpecialistMicrosoftSQLServerMVP,MCTSMicrosoftWebDevelopmentMCPITILV3FoundationCertified©2009TarekGhazali.Allrightsreserved.WhatisnewinSQLServer2008MorepowerfulmanagementPolicyManagementfeatureImprovedperformanceandscalabilityStoringhighvolum

2、eofdataSupportfordiversetypesofdataBettersecurityandavailabilitySecurityincreasedbydataencryptionAvailabilityincreasedbydatabasemirroringChangesfordevelopersLINQ(LanguageIntegratedQuery)LINQenablesdatabasedeveloperstoissuequeriesagainstadatabaseusinga.NET-basedprogramminglanguageinsteadofthenorm

3、alT-SQLstatements.LINQ(LanguageIntegratedQuery)(Cont.)SQLServer2008enhancesLINQbyprovidinganewLINQtoSQLproviderthatallowsdeveloperstoissueLINQcommandsdirectlyagainstSQLServertablesandcolumnsThiswillreducetheamountoftimeittakestocreatenewdataqueriesEnhancementofT-SQLStatementsMERGEstatement:Itall

4、owsthedevelopertocheckfortheexistenceofdatabeforetryingtoinsertthedata.AllowsyoutomergetwotablestogetherbasedonasetofcriteriaUsefulforsynchronizingdataGreatforconsolidatinginaDataWarehouseEnhancementofT-SQLStatements(Cont.)Nolongeritisnecessarytocreatecomplexjoinsinordertoupdatedatathatexistsand

5、toinsertdatathatdoesnotalreadyexist,allduringasinglestatement.TableValuedParameters(TVP)TVP'smakepossibletousea"table"asaparameterforaprocedureLimitations:TVP'scanonlybeREADONLYintheprocedurethatdefinethemasaparameterCanonlybeusedasaninputparameter.ApartfromthisthesamerulesapplytoTVP'sastotablev

6、ariablesforexamplenoDDLcanbeexecutedagainstaTVPandnostatisticsarekeptforTVP's.DataCompressionWorksontablesandindexesWorksonclusteredandnon-clusteredindexesCompressiontypes:PageandRowT-SQLextensionstoTableandIndexDDLDataCompression(Cont.)CREATETABLE...[WITH([,...n])]:=

7、{DATA_COMPRESSION={NONE

8、ROW

9、PAGE}[ONPARTITIONS({

10、}[,...n])]NewSPtoestimatecostsavingssp_estimate_data_compression_savingsNewDatatypesDateandTimeDatatypesDATE–adateonlytype(precision1day)T