SQL 관련 스터디 사이트

MS-SQL의 대가 정원역 전문가에게 MS-SQL 튜닝 교육을 받았던 내용의 reference입니다.
DB에 관심있으신분은 한번식 시간날때 봐보세요


DB 전문가(정원혁)
http://blog.naver.com/wonhyukc/40004347354


성능 카운터
http://technet.microsoft.com/ko-kr/magazine/2008.08.pulse.aspx


PASS cafe
http://cafe.naver.com/sqlpass
http://www.sqlpass.org


RPC 호출 in Query Analyzer
http://www.informit.com/articles/article.aspx?p=25288&seqNum=6

DBA checklist / guidebook
http://www.microsoft.com/korea/technet/sql/tuning_guide_developer03.mspx
http://support.microsoft.com/kb/601062/ko


DB전문가
http://blog.naver.com/wonhyukc/40004347354


SQL Memory Archtecture
http://support.microsoft.com/?id=271624

eSeminar:
http://www.microsoft.com/korea/seminar/

http://support.microsoft.com/default.aspx?scid=kb;ko;kr197297
조인의 이해

능력있는 관리자
http://blog.naver.com/wonhyukc/40009502241
http://blog.naver.com/wonhyukc/40011094657

rml & read80 trace utility
http://support.microsoft.com/?kbid=887057

추천 사이트
http://www.databasejournal.com/
http://sqlservercentral.com
http://www.sql-server-performance.com


웃어보자^^
http://cafe.daum.net/iriverboy

권장할만한 책
김연홍 (모델링)
http://freelec.co.kr/shop/book_detail.asp?code=89-89345-52-9
http://www.en-core.com/

Ken Handerson's books
http://kangcom.com/common/bookinfo/bookinfo.asp?sku=200305150010
http://www.yes24.com/Goods/FTGoodsView.aspx?goodsNo=309142&CategoryNumber=001001003005009001


SQL server magazine 잡지

손호성
http://www.yes24.com/Goods/FTGoodsView.aspx?goodsNo=1396163&CategoryNumber=001001003005009001

우철웅
http://www.yes24.com/Goods/FTGoodsView.aspx?goodsNo=258430&CategoryNumber=001001003005009001

KT neoss project: SQL server world top 10
http://www.dbguide.net/know/know105001.jsp?mode=view&pg=1&idx=2578

볼랜드 포럼에서의 토론
http://www.borlandforum.com/impboard/impboard.dll?action=read&db=free&no=10092

http://www.borlandforum.com/impboard/impboard.dll?action=read&db=free&no=9625



문서화 되지 않은 dbcc
http://www.sqlmania.net/board/view.asp?boardid=7&idx=15&page=1&srchKey=&srchVal=

sql magazine: memory myths - subscribers only :(
http://www.winnetmag.com/SQLServer/Articles/ArticleID/37890/pg/2/2.html

read80trace: New trace tool
http://support.microsoft.com/default.aspx?scid=kb;en-us;887057

명령 프롬프트에서 자동 완성 기능 사용
http://support.microsoft.com/default.aspx?scid=kb;ko;kr310530


http://www.databasejournal.com/features/mssql/
http://www.dbguide.net/lib/columns/dbg_view.jsp?idx=540

저장프로시저 재컴파일 관련
Query Recompilation in SQL Server 2000
308737 - How to identify the cause of recompilation in an SPRecompile event
243586 - INF Troubleshooting Stored Procedure Recompilation
276220 - HOW TO Use KEEPFIXED PLAN to Disable Stored Procedure Recompilations

통계 관련
195565 - INF How SQL Server 7_0 and SQL Server 2000 Autostats Work
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000

관계형 엔진
Microsoft SQL Server Query Processor Internals and Architecture
Microsoft SQL Server 쿼리 프로세서 내부 및 아키텍쳐
http://msdn.microsoft.com/library/kor/default.asp?url=/library/KOR/dntaloc/html/sqlquerproc.asp


메모리 구조
http://msdn2.microsoft.com/en-us/library/aa224760(SQL.80).aspx