?????????????????????DBA????к???????????????λ??????DBA??DBA???????????Щ??????????????????????DBA??????????DBA?????????ЩDBA??????????????????????????л??????С????????????SQLServer DBA????????????????????￡???????????DBA?????????Щ??????

????1??char??varchar??nvarchar?????????????????????????xml??????????????????????Щ?????????Ч???????洢????????T-SQL?????????????????

????2????DB????Щ??????????????費(fèi)??????????????????????????????????master????

????3??????Щ??????????TempDB?????TempDB???????????????????????δ????

????4??Index????Щ?????????????????????????????????????????????SQL?????????????????????????????Щ???????????β??????????????????????????????????????μ?飬????????T-SQL?и?????????????????????????????????????????????????

????5???????????????????????????????????????????????????????????????????????

????6??Job???????????????Щ???????????????е????????????Щ??????????λ?????T-SQL????IO??Time???????

????7????????????????????????????????????е?????????????????????????????????У??????????????????????????????????δ???????????????

????8????????????????????????????????????????

????9???????????????CTE?????????????????????????????λ??????????????????ξ?????????

????10??SQLServer????Щ????????????????????????????Щ?????????????а汾??????????????

????11????????θ??????????θ?????????????????????????ν??д??????Profile?????????????????????????Щ?????

????12??Windows??????????????SQLServer?????????????????????????μ?SQL????????????????????????????????????????????????ú??????????????????????????????????????????????δ????

????13?????????????????????????????????????????????????

????14????α??????????????????????????????????????????????????????????????????????????ν???????Identity???????

????15??CheckPoint??LazyWriter????DDL Trigger ?? DML Trigger???????????????

????16??Mirroring ??Logshipping ?????????ó?????SQLServer??Mirroring??Oracle?????????????????????????????

????17??Mirroring??????裬Mirroring??????????Mirroring ??????????????????????Mirroring????????????????????????

????18. Replication???ú???ó???;Replication?????????;PUSH??PULL???????;??Replication?????????????;???????????????????????????????????Replication??????????????????????????Щ??;

????19. Replication??????????truncate?????;Replication Identity????δ????????δ?????δ?????????????????δ?????????????????????????????????δ?????????????????δ???;??????????????е??????????????????????????????????????????????????????δ????

????20. SSB(Service Broker)??ó???????δ???????????Щ???????????????????????????????????????????????;?????????Щ??????;

????21. ????????????????????Щ??????????(CDC(Change Data Capture)??CT(Change Tracking)??Trigger??)???????????;

????22. SQL??????裬??????ж?SQL???????????????λ??????ν????Щ????;

????23. ??????????鰈?裬??δ??????????????;

????24. ??ο????????????????;????????????????????????????????????????????????????????????????????????;

????25. ???????????????????????Щ???(????SQLServer??Windows)????????????????????ù???Щ??????;

????26. ???????????;???????????????(??10??????????)????????DB??????????????DB?????′???????????????????ο??????;

????27. ????Cluster ??????裬?????????IP????????Щ???????????Щ?????????Raid??????????????λ???;SQLServerCluster??Mysql Cluster ?? Oracle RAC???????;

????28. ??????????????????????????洢????????????????????????????????????????????????????(????????????????????);

????29. ??????????????????????????????????????????????????δ????;?????У??????????????????????????δ???;

????30. ?????????????????DBA?????????????(?????????????????滮???????????????DBA????);????????????????????????