| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> wei ruan xu yao gai jin SQL Server de liu da gong neng
 

wei ruan xu yao gai jin SQL Server de liu da gong neng

2008-08-15 05:14:00 编辑來源:互联网 评论
 
本文为【微软需要改进SQL Server的六大功能】的拼音翻译版
  hen chang shi jian yi lai , wo yi zhi zai shi yong Microsoft SQL Server。 zui kai shi , wo shi yong de shi SQL 4.2, zhe shi Sybase SQL Server 4.9 de yi ge yi zhi ban ben , yun xing zai Windows for Workgroups 3.11 xi tong shang , zhe dou shi hen jiu yi qian de shi qing le 。 cong na yi hou , wei ruan de SQL chan pin yi jing zou guo le man chang de dao lu , er jin nian nian di , wei ruan you jiang tui chu xin ban ben de SQL 10.0, ye jiu shi bei ye jie chao de fei fei yang yang de SQL Server 2008。 jing guo zhe me duo nian de bu duan wan shan ,SQL chan pin ken ding jie jin wan mei le , shi bu shi ? er shi shi bing fei ru ci 。 xia mian wo jiu xiang xi jie shao yi xia wo xi wang wei ruan neng gou gai jin de SQL 6 da gong neng , dan yuan neng gou zai SQL Server 2008 kan dao zhe xie bian hua 。
  1.SSMS zi dong shua xin
  zai lao ban de qi ye guan li qi zhong , yi jian ling ren gan dao hen tao yan de shi qing shi dang ni chuang jian yi ge xin de dui xiang shi , bi ru yi ge shu ju ku huo yi ge biao , nin xu yao shou dong shua xin dui xiang zi yuan guan li qi (Object Explorer), zhe yang cai neng kan dao xin chuang jian de dui xiang 。 zhe zhong xian xiang reng ran cun zai yu SQL Server Management Studio zhong , ji shi ta zai 2005 nian bei che di chong xie le , zhe jian shi qing hen nao ren , yin wei ni bi xu shou dong shua xin bao han xin dui xiang de na ge wen jian jia 。 jin jin dan ji “F5” shi bu hui jie jue wen ti de 。SSMS zai hou tai wan cheng le na me duo gong zuo , na me , wei shen me bu ba zhe yi gong neng jiao gei SSMS lai wan cheng ne ?
  2. fu zai ping heng de shu ju ku jing xiang
  dang SQL Server 2005 xuan bu ju bei shu ju ku jing xiang (Database Mirroring) gong neng shi , wei ruan cheng nuo gei wo men yi ge shu ju bao hu he fu zai ping heng de jie jue fang an , bu xu yao qun ji jiu neng shi xian tou ming de gu zhang he ke hu duan chong ding xiang 。SQL Server 2008 shi xian le ji hu suo you zhe xie gong neng , chu le fu zai ping heng 。 zai gu zhang fa sheng zhi qian , jing xiang shu ju ku bu de bu chu yu “Restoring” huo “No Recovery” mo shi xia , zhe shi de jing xiang shu ju ku bu neng yong yu fu zai ping heng cha xun 。 de que , ni ke yi dui jing xiang shu ju ku pai kuai zhao (snapshot), dan shi , zhe zhi shi yi ge ji yu shi jian dian de kuai zhao , bing bu neng fan yang zui xin de shu ju ku geng xin 。 wo ren wei zhe shi you she ji que xian zao cheng de 。 zai xiu zheng zhe yi que xian zhi qian , wo bu de bu shi yong dian dui dian fu zhi (Peer-to-Peer Replication) huo ri zhi chuan song (Log Shipping) jin xing fu zai ping heng 。
  3. SSMS nei zhi ri zhi guan li qi (Log Explore)
  tong chang , kai fa shang dui dai shi wu ri zhi (Transaction Log) de tong yong lu xian shi , ba ta yi mou zhong nei bu huo si you ge shi chu cun , yong hu wu fa cha kan huo shou dong xiu gai 。 ru guo ni xiang yao cha kan cun chu zai Transaction Log zhong de shi wu ji lu , huo zhe you xuan ze xing chong xin zhi xing mou xie shi wu er bu rao luan qi ta shi wu de hua , chu ni xu yao shi yong yi ge di san fang de gong ju , bi ru Lumigent de Log Explorer。 wei ruan ying gai jiang zhe zhong ji shu nei zhi dao SSMS zhong 。 wei ruan zhi jin mei you shou gou gai ji shu , zhe ling wo gan dao hen qi guai 。 wo cai xiang ken ding shi yin wei Lumigent yao jia tai gao le 。 ye xu yao bi shou gou ya hu de jia ge yao bian yi yi xie 。
  4. ReportBuilder RDL ying gai geng wei jing que , yi bian neng wei BIDS ti gong geng hao de fu wu
  ReportBuilder zhen de hen ku , ta neng gou rang ni shi yong bao gao mo xing fei chang xun su di chuang jian qiang da de bao gao 。 ni shen zhi ke yi rang ni de yong hu zi ji chuang jian zhuan an bao gao 。 huo zhe ba ta fang zai ni de kou dai li , yi bian neng zai ni yu yue ti yu duan lian de kong xian jian xi kuai su di kai fa bao gao --- xiang xiang yi xia , zhe hui gei ni de yong hu liu xia duo me shen ke de yin xiang a ( kai wan xiao !)。ReportBuilder de shen qi zhi chu jiu zai yu ta neng sheng cheng RDL( bao gao ding yi yu yan ),RDL shi Report Services zhong suo you bao gao de XML yuan ge shi 。 zhe yi wei zhe ni ke yi zai Business Intelligence Development Studio (BIDS) zhong , yong bao biao she ji qi (Report Designer) da kai nei zhi yu ReportBuilder zhong de bao gao , cong er jin xing jin yi bu de xiu gai he you hua 。 chu le BIDS shu ju ji de ding yi bu shi hen zheng que , xu yao jin xing yi xie ren gong gan yu lai jiu zheng zhe xie cuo wu 。 bu guo , wei ruan ruo yao xiu gai zhe yi gong neng ying gai bu hui hua fei tai duo shi jian 。
  5. wan zheng bei fen (Full Backup) ying gai jie duan shi wu ri zhi
  zi cong SQL Server chan pin wen shi yi lai , wan zheng de shu ju ku bei fen (Full Database Backup) shi bu jie duan shi wu ri zhi de 。 zhe yi wei zhe zai quan mian xiu fu mo xing (Full Recovery Model) xia , shi wu ri zhi hui ji xu wu xian zeng chang , chu fei ni jing chang dan du yun xing jin xing shi wu ri zhi bei fen (Transaction Log Backups)。 jian yu Microsoft Exchange Full Backup shi jie duan shi wu ji lu de , suo yi wo men wei shen me zai SQL Server shang ye zhe me zuo ne ? dui yu na xie ting shuo wei ruan zheng zai ba SQL Server tui jin dao “ zi wo tiao zheng ” mo shi de xin yong hu lai shuo , zhe jiang shi hen you bang zhu de 。
  6.“ kai yuan ” de bao gao guan li qi
  nei zhi zai ASP.NET 2005 zhong de bao gao guan li qi (Report Manager) shi yi ge xiang dang ben chong de Web ying yong 。 bu guo xian zai , ta zai ben di .NET dai ma zhong bei chong xie le , suo yi wo men bu bi shi yong IIS or ASP.NET。 zhe jian zhi hao ji le 。 dan shi , ba yuan dai ma gei wo men , na me wo men zi ji jiu neng gou you hua zhe ge qian duan ying yong , zhe shi bu shi tai jie jin kai yuan le ? huo xu wo men cheng zhi wei gong xiang yuan dai ma (Shared Source) geng wei zhun que 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
   hen chang shi jian yi lai , wo yi zhi zai shi yong Microsoft SQL Server。 zui kai shi , wo shi yong de shi SQL 4.2, zhe shi Sybase SQL Server 4.9 de yi ge yi zhi ban ben , yun xing zai Windows for Workgroups 3.11 xi tong shang , zhe dou shi hen jiu yi qian de shi qing le 。 cong na yi hou , wei ruan de SQL chan pin yi jing zou guo le man chang de dao lu , er jin nian nian di , wei ruan you jiang tui chu xin ban ben de SQL 10.0, ye jiu shi bei ye jie chao de fei fei yang yang de SQL Server 2008。 jing guo zhe me duo nian de bu duan wan shan ,SQL chan pin ken ding jie jin wan mei le , shi bu shi ? er shi shi bing fei ru ci 。 xia mian wo jiu xiang xi jie shao yi xia wo xi wang wei ruan neng gou gai jin de SQL 6 da gong neng , dan yuan neng gou zai SQL Server 2008 kan dao zhe xie bian hua 。   1.SSMS zi dong shua xin    zai lao ban de qi ye guan li qi zhong , yi jian ling ren gan dao hen tao yan de shi qing shi dang ni chuang jian yi ge xin de dui xiang shi , bi ru yi ge shu ju ku huo yi ge biao , nin xu yao shou dong shua xin dui xiang zi yuan guan li qi (Object Explorer), zhe yang cai neng kan dao xin chuang jian de dui xiang 。 zhe zhong xian xiang reng ran cun zai yu SQL Server Management Studio zhong , ji shi ta zai 2005 nian bei che di chong xie le , zhe jian shi qing hen nao ren , yin wei ni bi xu shou dong shua xin bao han xin dui xiang de na ge wen jian jia 。 jin jin dan ji “F5” shi bu hui jie jue wen ti de 。SSMS zai hou tai wan cheng le na me duo gong zuo , na me , wei shen me bu ba zhe yi gong neng jiao gei SSMS lai wan cheng ne ?   2. fu zai ping heng de shu ju ku jing xiang    dang SQL Server 2005 xuan bu ju bei shu ju ku jing xiang (Database Mirroring) gong neng shi , wei ruan cheng nuo gei wo men yi ge shu ju bao hu he fu zai ping heng de jie jue fang an , bu xu yao qun ji jiu neng shi xian tou ming de gu zhang he ke hu duan chong ding xiang 。SQL Server 2008 shi xian le ji hu suo you zhe xie gong neng , chu le fu zai ping heng 。 zai gu zhang fa sheng zhi qian , jing xiang shu ju ku bu de bu chu yu “Restoring” huo “No Recovery” mo shi xia , zhe shi de jing xiang shu ju ku bu neng yong yu fu zai ping heng cha xun 。 de que , ni ke yi dui jing xiang shu ju ku pai kuai zhao (snapshot), dan shi , zhe zhi shi yi ge ji yu shi jian dian de kuai zhao , bing bu neng fan yang zui xin de shu ju ku geng xin 。 wo ren wei zhe shi you she ji que xian zao cheng de 。 zai xiu zheng zhe yi que xian zhi qian , wo bu de bu shi yong dian dui dian fu zhi (Peer-to-Peer Replication) huo ri zhi chuan song (Log Shipping) jin xing fu zai ping heng 。   3. SSMS nei zhi ri zhi guan li qi (Log Explore)    tong chang , kai fa shang dui dai shi wu ri zhi (Transaction Log) de tong yong lu xian shi , ba ta yi mou zhong nei bu huo si you ge shi chu cun , yong hu wu fa cha kan huo shou dong xiu gai 。 ru guo ni xiang yao cha kan cun chu zai Transaction Log zhong de shi wu ji lu , huo zhe you xuan ze xing chong xin zhi xing mou xie shi wu er bu rao luan qi ta shi wu de hua , chu ni xu yao shi yong yi ge di san fang de gong ju , bi ru Lumigent de Log Explorer。 wei ruan ying gai jiang zhe zhong ji shu nei zhi dao SSMS zhong 。 wei ruan zhi jin mei you shou gou gai ji shu , zhe ling wo gan dao hen qi guai 。 wo cai xiang ken ding shi yin wei Lumigent yao jia tai gao le 。 ye xu yao bi shou gou ya hu de jia ge yao bian yi yi xie 。   4. ReportBuilder RDL ying gai geng wei jing que , yi bian neng wei BIDS ti gong geng hao de fu wu   ReportBuilder zhen de hen ku , ta neng gou rang ni shi yong bao gao mo xing fei chang xun su di chuang jian qiang da de bao gao 。 ni shen zhi ke yi rang ni de yong hu zi ji chuang jian zhuan an bao gao 。 huo zhe ba ta fang zai ni de kou dai li , yi bian neng zai ni yu yue ti yu duan lian de kong xian jian xi kuai su di kai fa bao gao --- xiang xiang yi xia , zhe hui gei ni de yong hu liu xia duo me shen ke de yin xiang a ( kai wan xiao !)。ReportBuilder de shen qi zhi chu jiu zai yu ta neng sheng cheng RDL( bao gao ding yi yu yan ),RDL shi Report Services zhong suo you bao gao de XML yuan ge shi 。 zhe yi wei zhe ni ke yi zai Business Intelligence Development Studio (BIDS) zhong , yong bao biao she ji qi (Report Designer) da kai nei zhi yu ReportBuilder zhong de bao gao , cong er jin xing jin yi bu de xiu gai he you hua 。 chu le BIDS shu ju ji de ding yi bu shi hen zheng que , xu yao jin xing yi xie ren gong gan yu lai jiu zheng zhe xie cuo wu 。 bu guo , wei ruan ruo yao xiu gai zhe yi gong neng ying gai bu hui hua fei tai duo shi jian 。   5. wan zheng bei fen (Full Backup) ying gai jie duan shi wu ri zhi    zi cong SQL Server chan pin wen shi yi lai , wan zheng de shu ju ku bei fen (Full Database Backup) shi bu jie duan shi wu ri zhi de 。 zhe yi wei zhe zai quan mian xiu fu mo xing (Full Recovery Model) xia , shi wu ri zhi hui ji xu wu xian zeng chang , chu fei ni jing chang dan du yun xing jin xing shi wu ri zhi bei fen (Transaction Log Backups)。 jian yu Microsoft Exchange Full Backup shi jie duan shi wu ji lu de , suo yi wo men wei shen me zai SQL Server shang ye zhe me zuo ne ? dui yu na xie ting shuo wei ruan zheng zai ba SQL Server tui jin dao “ zi wo tiao zheng ” mo shi de xin yong hu lai shuo , zhe jiang shi hen you bang zhu de 。   6.“ kai yuan ” de bao gao guan li qi    nei zhi zai ASP.NET 2005 zhong de bao gao guan li qi (Report Manager) shi yi ge xiang dang ben chong de Web ying yong 。 bu guo xian zai , ta zai ben di .NET dai ma zhong bei chong xie le , suo yi wo men bu bi shi yong IIS or ASP.NET。 zhe jian zhi hao ji le 。 dan shi , ba yuan dai ma gei wo men , na me wo men zi ji jiu neng gou you hua zhe ge qian duan ying yong , zhe shi bu shi tai jie jin kai yuan le ? huo xu wo men cheng zhi wei gong xiang yuan dai ma (Shared Source) geng wei zhun que 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
时尚性感的燕子(3)
时尚性感的燕子(2)
纯美的女生生活写真(14)
纯美的女生生活写真(13)
来自束河[]
恰巧-巧家~~
高尔夫
行摄匆匆天子山
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有