![[-]](/moniwiki/imgs/plugin/arrup.png "[-]")
![[+]](/moniwiki/imgs/plugin/arrdown.png "[+]")
[edit]
1 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
- 통계 자동업데이트
Inside the SQL Server Query Optimizer![[http]](/moniwiki/imgs/http.png)
링크
- SQL Server Query Optimizer Cost Formulas
- New Spatial Features in SQL Server Code-Named Denali sql2012_new_spatial.docx
- AlwaysOn
- 시스템 카탈로그
- COUNT(DISTINCT) 성능
- Output절의 사용
- Inside the Storage Engine: How are allocation unit IDs calculated?
[edit]
2 참고자료 #
![[https]](/moniwiki/imgs/https.png)
Database Scoped Configuration
- SQL Server 2012 SP1 릴리스 정보
- The Accord.NET Framework --> machine learning, artificial intelligence, pattern recognition and statistics in your applications ...
- Tracking page splits using the transaction log
- How It Works: CMemThread and Debugging Them
- Memory Manager Configuration changes in SQL Server 2012
- Query Optimizer Deep Dive - Part 1
- Query Optimizer Deep Dive - Part 2
- Query Optimizer Deep Dive - Part 3
- Query Optimizer Deep Dive - Part 4
- SQL Server 2012: RML, XEvent Viewer and Distributed Replay
- SQL Server 2012 - True Black Box Recorder
- SQL Server 시스템 카탈로그 쿼리에 대한 질문과 대답
- SQL Server AlwaysOn Video
- 동시성 제어(Concurrency Control)와 행버전(Row Versioning)
- SQL Server Denali Contained Database Feature
- Adventure Works for SQL Server Denali CTP3
- SQL Server Code Name “Denali” CTP3 Product Guide is Here!
- sql server 2011 sample database
- What is New in SQL Server Denali (SQL11)
- TechNet SQL Server Code-Named 'Denali'
- CTP3 T-SQL Enhancements : FORMAT()
- SQL Server Denali New Features
- T-SQL IntelliSense enhancements in SSMS –Denali
- SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials
- SQL Server Code-Named “Denali” - T-SQL Debugger Enhancements
- New Features in SQL Server 2011
- New T-SQL Features in SQL Server 2011
- Columnstore Indexes for Fast Data Warehouse Query Processing in SQL Server 11.0
- SQL Code Name DENALI의 HADR 설치 및 구성 가이드
- SQL Server 2011 - Books Online
- Download SQL Server 2011 - Code Names Denali
- Adventureworks Sample Database for SQL Server 2011
- High Availability Options for SQL Server 2008
- Free ebook:Introducing Microsoft SQL Server 2008 R2
- Microsoft SQL Server White Papers
- SQL Server 2005 T-SQL
- Spatial DataType(이재웅)
- New SQL Server features in SQL Server 2008 R2 – Part 2
- New SQL Server features in SQL Server 2008 R2 – Part 1
- SQL Server 2008 R2 디지털 투어
- SQL2008 vs Oracle11g (MS관점)
- Free ebook: Introducing Microsoft SQL Server 2008 R2
- Getting started with Master Data Services in SQL Server 2008 R2
- MERGE Your DML Statements in SQL Server 2008
- SQL Server Geography Data Type
- An overview of Master Data Services - MDS in SQL Server 2008 R2
- SQL Server 2008 R2
- Upgrade SSIS 2005 Packages to SSIS 2008
- Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization
- SQL Server 2008 NUMA and Foreign Pages
- SQL Server 2008 R2 Update for Developers Training Kit
- SQL Server 2008 Developer Training Kit
- Performance improvement by orders of magnitude when merging partitions in SQL Server 2008 R2
- Creating a linked Postgres Server on SQL Server 2008
- Top 10 Features of SQL 2008 R2
- Brads Sure Guide To SQL Server 2008
- SQL Server 2008 Upgrade Technical Reference Guide Upload new Attachment "SQL2008UpgradeTechnicalReferenceGuide.docx"
- SQL Server 2008 Developer Training Kit
- Partitioned Table and Index Strategies Using SQL Server 2008
- Cloud Computing with Microsoft Azure SDS
- Using new location-aware data types in SQL Server 2008
- Tracking expensive queries with extended events in SQL 2008
- Connection strings for SQL Server 2008
- Pre Check List for 64 BIT SQL Server 2008 Cluster Installation
- SQL Server 2008 T-SQL
- SQL Server 2005 T-SQL
- SQL Server 2000 DB Sizer
- 64-bit Solutions on SQL Server 2005
- pubs 데이터베이스
- northwind 데이터베이스
- spatial data types
- SQL Server 2008 T-SQL Enhancements Part - I (Intellisense)
- SQL Server 2008 T-SQL Enhancements Part - II (UDTs and TVPs)
- SQL Server 2008 T-SQL Enhancements Part - III (HierarchyID and Large UDTs)
- SQL Server 2008 T-SQL Enhancements Part - IV (Filestream)
- SQL Server 2008 T-SQL Enhancements Part - V (Spatial)
