#title Database Engine [[TableOfContents]] * [SQL Server 2014 요약] ==== SQL Server T-SQL 분석과 데이터베이스 엔진 ==== * [SQL Server IO Block Size Reference Table] * [단일 액세스 분석] * [연결 액세스 분석] * [DataType] * [Index Seek] * [Clustered Index Seek] * [Scan] * [선택도와 실행계획의 분리] * [클러스터링 팩터] * [Magic Density] * [컬럼의 변형] * [NULL의 사용] * [결합 인덱스의 사용] * [2개 이상의 인덱스 사용] * [병렬처리의 기본] * [부분범위처리] * [최대값과 최소값의 처리] * [커서를 언제 사용해야 할까] * [Windowing Functiion의 이해] * [집합 연산] * [Ordered] * [Spool] * [Loop Join] * [Merge Join] * [Hash Join] * [Star Join] * [Outer Join] * [Sub Query] * [Cross Join] * [Function을 이용한 연결] * [계층구조와 순환관계] * [Union] * [Cross/Outer Apply] * [Pivot] * [SQL Server의 최적화 프로세스] * [Hard Parsing과 Soft Parsing] * [미리 읽기] * [View] * [XML] * [JSON] * [CLR] * [Partitioning] * [DBCC ShowContig 해석] * [Delete와 Update의 내부동작] * [Storage Engine] * [Row Constructors] * [MERGE] * [Table Value Parameters] * [Grouping Set] * [Force Seek] * [OPTIMIZE FOR Query Hint Option Include UNKNOWN Variable Value] * [INSERT… EXECUTE Statements Can Execute Against Linked Servers] * [CONVERT Function] * [Lock Escalation Option] * [New Data Type - 날짜관련] * [Compound Assignment Operators] * [Hierarchyid Data Type] * [Transparent Data Encryption] * [Query Plan Freezing] * [Data Collection] * [Data Compression] * [Backup Compression] * [File Stream Access] * [Minimally Logged] * [Filtered Indexes and Statistics] * [Sparse Columns and Column Sets] * [RTE와 SQL Server(Change Data Capture & Tracking)] * [Resource Governor] * [Parallelism Enhancements in SQL Server 2008] * [Filtered Statistics] * [Partition] * [Where절의 실행순서] * [Columnstore Indexes] * [Metadata Discovery] * [SQL Server 2011 New Built-in Functions] * [Built-in Functions] * [SQL Server Analysis Function] * [FileTable] * [Sequence] * [With result sets] * [Offset and fetch] * [Throw in error handling] * [통계 자동업데이트] * [attachment:DatabaseEngine/Inside_the_SQL_Server_Query_Optimizer.zip Inside the SQL Server Query Optimizer][http://www.red-gate.com/products/sql-development/sql-prompt/entrypage/sql-query-optimizer-ebook?utm_source=dbw&utm_medium=email&utm_content=queryoptimizer1-20111106&utm_campaign=sqlprompt 링크] * [attachment:DatabaseEngine/SQL_Server_Query_Optimizer_Cost_Formulas.ppt SQL Server Query Optimizer Cost Formulas] * [http://social.technet.microsoft.com/wiki/contents/articles/4136.aspx New Spatial Features in SQL Server Code-Named Denali] attachment:DatabaseEngine/sql2012_new_spatial.docx * [AlwaysOn] * [시스템 카탈로그] * [COUNT(DISTINCT) 성능] * [Output절의 사용] * [http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-how-are-allocation-unit-ids-calculated/?utm_source=feedly Inside the Storage Engine: How are allocation unit IDs calculated?] ==== 참고자료 ==== * [https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/05/02/database-scoped-configuration/ Database Scoped Configuration] * [http://msdn.microsoft.com/ko-kr/library/jj200106(SQL.15).aspx SQL Server 2012 SP1 릴리스 정보] * [https://code.google.com/p/accord/ The Accord.NET Framework] --> machine learning, artificial intelligence, pattern recognition and statistics in your applications ... * [http://feedproxy.google.com/~r/PaulSRandal/~3/IGG0rATLZNg/ Tracking page splits using the transaction log] * [http://blogs.msdn.com/b/psssql/archive/2012/12/20/how-it-works-cmemthread-and-debugging-them.aspx How It Works: CMemThread and Debugging Them] * [http://blogs.msdn.com/b/sqlosteam/archive/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012.aspx Memory Manager Configuration changes in SQL Server 2012] * [http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-1.aspx Query Optimizer Deep Dive - Part 1] * [http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx Query Optimizer Deep Dive - Part 2] * [http://sqlblog.com/blogs/paul_white/archive/2012/04/29/query-optimizer-deep-dive-part-3.aspx Query Optimizer Deep Dive - Part 3] * [http://sqlblog.com/blogs/paul_white/archive/2012/05/01/query-optimizer-deep-dive-part-4.aspx Query Optimizer Deep Dive - Part 4] * [http://blogs.msdn.com/b/psssql/archive/2012/04/06/sql-server-2012-rml-xevent-viewer-and-distributed-replay.aspx SQL Server 2012: RML, XEvent Viewer and Distributed Replay] * [http://blogs.msdn.com/b/psssql/archive/2012/03/08/sql-server-2012-true-black-box-recorder.aspx SQL Server 2012 - True Black Box Recorder] * [http://msdn.microsoft.com/ko-kr/library/ms345522.aspx SQL Server 시스템 카탈로그 쿼리에 대한 질문과 대답] * [http://channel9.msdn.com/posts/SQL-Server-AlwaysOn SQL Server AlwaysOn Video] * [http://www.sqler.com/bColumn/431381 동시성 제어(Concurrency Control)와 행버전(Row Versioning)] * [http://www.mssqltips.com/tip.asp?tip=2428 SQL Server Denali Contained Database Feature] * [http://msftdbprodsamples.codeplex.com/releases/view/55330 Adventure Works for SQL Server Denali CTP3] * [http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/10/sql-server-code-name-denali-ctp3-product-guide-is-here.aspx SQL Server Code Name “Denali” CTP3 Product Guide is Here!] * [http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=106391 sql server 2011 sample database] * [http://beyondrelational.com/whatisnew/sqlserver/denali/ What is New in SQL Server Denali (SQL11)] * [http://technet.microsoft.com/en-us/library/bb418432(SQL.10).aspx TechNet SQL Server Code-Named 'Denali'] * [http://sqlblog.com/blogs/aaron_bertrand/archive/2011/08/09/sql-server-v-next-denali-ctp3-t-sql-enhancements-format.aspx CTP3 T-SQL Enhancements : FORMAT() ] * [http://sqlserver-training.com/sql-server-denali-new-features/- SQL Server Denali New Features] * [http://blogs.msdn.com/b/sqlrem/archive/2011/01/04/t-sql-intellisense-enhancements-in-ssms-denali.aspx T-SQL IntelliSense enhancements in SSMS –Denali] * [http://sqlserver-training.com/sql-server-denali-integration-services-ssis-enhancement-video-tutorials/- SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials] * [http://blogs.msdn.com/b/sqlrem/archive/2011/01/04/sql-server-code-named-denali-t-sql-debugger-enhancements-in-ctp1.aspx SQL Server Code-Named “Denali” - T-SQL Debugger Enhancements] * [New Features in SQL Server 2011] * [New T-SQL Features in SQL Server 2011] * [attachment:DatabaseEngine/columnstore_vertipaq.pdf Columnstore Indexes for Fast Data Warehouse Query Processing in SQL Server 11.0] * [attachment:DatabaseEngine/SQL_Denali_HADR_Step-by-Step__가이드.pdf SQL Code Name DENALI의 HADR 설치 및 구성 가이드] * [http://msdn.microsoft.com/en-us/library/ms130214(v=sql.110).aspx SQL Server 2011 - Books Online] * [http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9&displaylang=en Download SQL Server 2011 - Code Names Denali] * [http://msftdbprodsamples.codeplex.com/releases/view/55330 Adventureworks Sample Database for SQL Server 2011] * [http://www.mssqltips.com/tip.asp?tip=2337&home High Availability Options for SQL Server 2008] * [http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx Free ebook:Introducing Microsoft SQL Server 2008 R2] * [http://msdn.microsoft.com/en-us/library/bb418438(SQL.10).aspx Microsoft SQL Server White Papers] * [attachment:MicrosoftSQLServer/향상된_기능의_MSSQL_Server_2005_T-SQL.pdf SQL Server 2005 T-SQL] * [attachment:MicrosoftSQLServer/Spatial_DataType.zip Spatial DataType(이재웅)] * [http://blogs.msdn.com/sqlserverfaq/archive/2010/05/13/inf-new-sql-server-features-in-sql-server-2008-r2-part-2.aspx New SQL Server features in SQL Server 2008 R2 – Part 2] * [http://blogs.msdn.com/sqlserverfaq/archive/2010/05/13/inf-new-sql-server-features-in-sql-server-2008-r2-part-1.aspx New SQL Server features in SQL Server 2008 R2 – Part 1] * [http://www.microsoft.com/sqlserver/tour/ko/default.aspx SQL Server 2008 R2 디지털 투어] * [attachment:DatabaseEngine/SQL2008_vs_Oracle11g.docx SQL2008 vs Oracle11g (MS관점)] * [attachment:DatabaseEngine/693883ebook.pdf Free ebook: Introducing Microsoft SQL Server 2008 R2] * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1507514,00.html Getting started with Master Data Services in SQL Server 2008 R2] * [http://www.databasejournal.com/features/mssql/article.php/3870061/article.htm MERGE Your DML Statements in SQL Server 2008] * [http://www.mssqltips.com/tip.asp?tip=1965 SQL Server Geography Data Type] * [http://www.sql-server-performance.com/articles/dba/master_data_services_mds_overview_p1.aspx An overview of Master Data Services - MDS in SQL Server 2008 R2] * [SQL Server 2008 R2] * [http://www.sql-server-performance.com/articles/dba/upgarde_2005_packages_2008_i_p1.aspx Upgrade SSIS 2005 Packages to SSIS 2008] * [attachment:Migrating__Replication_from_SQL_Server_2000_32bit_to_SQL_Server_2008_64bit_without_re-init..doc Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization] * [http://blogs.msdn.com/psssql/archive/2010/02/23/how-it-works-sql-server-2008-numa-and-foreign-pages.aspx SQL Server 2008 NUMA and Foreign Pages] * [http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d SQL Server 2008 R2 Update for Developers Training Kit] * [http://www.microsoft.com/downloads/details.aspx?FamilyID=E9C68E1B-1E0E-4299-B498-6AB3CA72A6D7&displayLang=en SQL Server 2008 Developer Training Kit] * [http://blogs.msdn.com/sqlserverstorageengine/archive/2010/02/03/performance-improvement-by-orders-of-magnitude-when-merging-partitions-in-sql-server-2008r2.aspx Performance improvement by orders of magnitude when merging partitions in SQL Server 2008 R2] * [http://dotnetslackers.com/articles/sql/Creating-a-linked-Postgres-Server-on-SQL-Server-2008.aspx Creating a linked Postgres Server on SQL Server 2008] * [http://www.databasejournal.com/features/mssql/article.php/3857466/Top-10-Features-of-SQL-2008-R2.htm Top 10 Features of SQL 2008 R2] * [attachment:MicrosoftSQLServer/Brads_Sure_Guide_To_SQL_Server_2008.pdf Brads Sure Guide To SQL Server 2008] * [http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en SQL Server 2008 Upgrade Technical Reference Guide] attachment:SQL2008UpgradeTechnicalReferenceGuide.docx * [http://www.microsoft.com/downloads/details.aspx?FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7&DisplayLang=en SQL Server 2008 Developer Training Kit] * [attachment:MicrosoftSQLServer/PartTableAndIndexStrat.docx Partitioned Table and Index Strategies Using SQL Server 2008] * [http://www.databasejournal.com/features/mssql/article.php/3828571/article.htm Cloud Computing with Microsoft Azure SDS] * [http://www.developer.com/db/article.php/3839056/Using-new-location-aware-data-types-in-SQL-Server-2008.htm Using new location-aware data types in SQL Server 2008] * [http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=1e674d0f-560f-4d36-b0c4-07c7adc5e740 Tracking expensive queries with extended events in SQL 2008] * [http://www.connectionstrings.com/sql-server-2008 Connection strings for SQL Server 2008] * [http://www.sqlservercentral.com/articles/Clustering/68967/ Pre Check List for 64 BIT SQL Server 2008 Cluster Installation] * [SQL Server 2008 T-SQL] * [SQL Server 2005 T-SQL] * [attachment:DatabaseEngine/MSSQL_Server_DBSizer.xls SQL Server 2000 DB Sizer] * [attachment:MicrosoftSQLServer/November_2006_64-bit_SQL_Server.pdf 64-bit Solutions on SQL Server 2005] * [attachment:MicrosoftSQLServer/instpubs.sql pubs 데이터베이스] * [attachment:MicrosoftSQLServer/instnwnd.sql northwind 데이터베이스] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/67946/ spatial data types] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/65539/ SQL Server 2008 T-SQL Enhancements Part - I (Intellisense)] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/67550/ SQL Server 2008 T-SQL Enhancements Part - II (UDTs and TVPs)] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/67787/ SQL Server 2008 T-SQL Enhancements Part - III (HierarchyID and Large UDTs)] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/67945/ SQL Server 2008 T-SQL Enhancements Part - IV (Filestream)] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/67946/ SQL Server 2008 T-SQL Enhancements Part - V (Spatial)] ==== Architecture ==== attachment:DatabaseEngine/MS-SQL_Architecture.jpg