[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)
鏤