MSSQL编程：向RAID5停战！

一个语句分成两个event(实际上不止，其他可以忽略)，一个table_mapevent和一个Rows_log_event。Table_mapevent是一样的，主要看Rows_log_event。
BaarfLinks

WhyshouldInotuseRAID5?－ArtS.Kagel

IsRAID5ReallyaBargain?－CaryMillsap

BAARF的开篇语

BAARFwasinventedbyJamesMorleonWednesdaythe4thofJune,2003,intheGrangehoteloutsideBirminghamwhilehavingabeerortwowithMogensNørgaard.
Onthefollowingday-Thursdaythe5thofJune,whichhappenstobetheDanishnationalholidaycelebratingourconstitution-theBattleAgaistAnyRaidFiveinitiativewasannouncedjointlybyJamesandMogensinfrontoftheUKOracleUserGroupUNIXSpecialInterestGroupmeetingattheGrangehotel.
Bothannouncerswerecarefultosportthe“EnoughisEnough”look(includingarmsfoldedacrossthechest)whiledeliveringthemessagetoabout80delegates.
It’simportanttonote,thatRAID-3,-4,and-5areallincludedintheinitiative,sotheFinBAARFbothstandsforFive,Four,and…err…Free.
ThereasonforBAARFisthatwe’vehadit.EnoughisEnough.For15yearsalotoftheworld’sbestdatabaseexpertshavebeenarguingbackandforthwithpeople(vendorsandothers)abouttheprosandconsofRAID-3,-4and-5.
CaryMillsaphaswrittenexcellentarticlesonRAIDtechnologiesthatshouldhavestoppedtheuse-andpointlessdiscussionsmanyyearsago.Manyothershavewrittensplendidarticlesaboutitaswell.Many.
JamesMorleandothershavewrittenbookswheretheydiscussedtheuselessnessofRAID-Fstuff.
Ithasbeenthesamearguments,thesamemistakes,thesamemisunderstandingsthathaveguidedthediscussionsforallthoseyears.
ThesamefrustrationsfrompeoplethatknewRAID-Fisnotagoodchoice.
ThelawsofNaturearestillsolidlyinplaceandarenotgoingtobechangedbyRAID-Fvendorsanytimesoon.
Sowe’vedecidedtostoparguinganddebatingwithpeopleaboutit.Wewilllowerourbloodpressurepermanentlybyrefusingtohaveanymoreargumentsaboutit.
We’redone.It’sdone.Everythinghasbeensaid.It’stimeforaction–andmakingupyourmind.
YoucanjoinBAARF.Ornot.You’reeitherin.Ornot.
WewillofcourseformtheBAARFParty,andwe’llarrangevariousBAARFPartyConventionswherewe’llproudlydisplayourlogo,whichsays“I’mNOTtalkinganymoreaboutRAID-5.Joinus.Ornot.”–orsomethingtothateffect.
WewillcollecttheusualhorrorstoriesaboutRAID-Fstuffandcustomersbeingcheatedfirst,andsurprisedlater.
TheBAARFpartywillhaveitsownequivalentoftheIraqiInformationMinistertodeliverkeynotesattheirconventions.
Butnomorediscussions.
Birmingham,6thofJune,2003-06-06
JamesMorle&MogensNørgaardphp本地模拟的prepare底层就是mysql_real_escape_string，所以必须得用mysql_set_character_set去设置mysql->charset，否则就存在字符集问题。

是否碎片会引发效率问题？这都是需要进一步探讨的东西。varbinary(max)代替image也让SQLServer的字段类型更加简洁统一。

呵呵，这就是偶想说的

相信各位对数据库和怎么样学习数据库都有一些经验和看法，也会有人走了一些弯路总结出自己的经验来，希望大家能把各自的看法和经验拿出来分享，给别人一份帮助，给自己一份快乐

SQL语言是学习所有数据库产品的基础，无论你是做数据库管理还是做数据库开发都是这样。不过具体学习的侧重点要看你将来做哪一块，如果是做数据库管理（DBA），侧重点应该放在SQLServer的系统管理上.

每天坚持做不一样的是，认真做笔录，定时复习。一个月你就可以有一定的收获。当然如果你想在sql方面有一定的造诣，你少不了需要看很多很多的书籍了。

Mirror可以算是SQLServer的Dataguard了。但是能不能被大伙用起来就不知道了。

微软对CLR作了大篇幅的宣传，这是因为数据库产品终于融入.net体系中。最开始我们也是狂喜，感觉对象数据库的一些概念可以实现了。

不过话说回来了，绝大多数的性能优化准则与对sqlserver存储的结构理解息息相关