|





| |
Resources:
Whitepapers/Articles:
-
T-SQL improvements in SQL Server 2012:
-
How to Use Microsoft SQL Server 2012's Window Functions, Part 1,
Part 2,
Part 3
-
Efficient T-SQL Querying using SQL Server 2012’s Window Functions @
Microsoft's Channel 9
-
SQL Server 2012 T-SQL at a Glance – OFFSET/FETCH,
OFFSET/FETCH Part 1,
Part 2 -
SQL Server 2012 T-SQL at a Glance – Sequences,
Sequences Part 1,
Part 2 -
SQL Server 2012 T-SQL at a Glance – THROW -
SQL Server 2012 T-SQL at a Glance – EXECUTE WITH RESULT SETS -
SQL Server 2012 T-SQL at a Glance - Metadata Discovery -
SQL Server 2012 T-SQL at a Glance - New and Enhanced Functions
-
Connect Items:
-
Connect Feature Request - BIGDATEADD, BIGDATEDIFF and “100 nanoseconds”
Part
-
Connect Feature
Request - Add SQL Server Engine Support for Interval Queries,
connect item,
Survey
- Connect Feature
Request - Ordered Set Functions,
connect item
- Various Resources:
-
SQL Server Columnstore Performance Tuning
-
SQL Server Columnstore Index FAQ
-
Tracing Query Performance with Extended Events
-
Temporary Tables in Stored Procedures
-
Temporary Object Caching Explained
-
Partitioned Table and Index Strategies Using SQL Server 2008
-
Changes to automatic update statistics in SQL Server – traceflag 2371
-
Arrays and Lists
in SQL Server, Other Texts by
Erland Sommarskog
-
Advanced Uses of APPLY
-
SQL Server 2012 Solutions for Median
Calculation
-
The Data
Loading Performance Guide
-
Intervals:
- Interval
Queries in SQL Server
-
Academic Paper - Managing Intervals Efficiently in Object-Relational Databases
-
Article
- A Static Relational Interval Tree
-
Article
- Advanced interval queries with the Static Relational Interval Tree
- Connect Feature
Request - Add SQL Server Engine Support for Interval Queries
-
Dynamic Search
Conditions, Other Texts by
Erland Sommarskog
Plan
Caching and Recompilation in SQL Server 2012
Plan Caching in SQL Server
2008
SQL Server
2012 Upgrade Technical Reference Guide
SQL Server
2008 Upgrade Technical Reference Guide
The SolidQ Journal
SQL
Server Pro Magazine
Itzik's
Articles in SQL Server Pro Magazine
Books:
T-SQL Books:
- Training Kit (Exam
70-461): Querying Microsoft SQL Server 2012
(MSPress, December 2012)
- Microsoft SQL
Server 2012 T-SQL Fundamentals
(MSPress, 2012)
- Microsoft
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
(MSPress, 2012)
- Microsoft SQL Server
2008: T-SQL Fundamentals (MSPress, 2008) by Itzik Ben-Gan
-
Inside Microsoft SQL Server 2008: T-SQL Querying
(MSPress, 2009) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
-
Inside
Microsoft SQL Server 2008: T-SQL Programming
(MSPress, 2009) by Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low,
Ed Katibah, Isaac Kunen
-
Inside Microsoft SQL Server 2005: T-SQL Querying
(MSPress, 2006) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
-
Inside Microsoft SQL Server 2005: T-SQL Programming
(MSPress, 2006) by Itzik Ben-Gan, Dejan Sarka, Roger Wolter
Set Theory:
Relational
Modeling:
SQL:
Blogs:
SQL Server Forums:
Downloads:
Logical Query Processing Poster
SQL
Sentry Plan Explorer
SQL Server 2012 System Views Map
Source Code for
Recent Conferences:
Atlanta Microsoft Database Forum
Back to Top
|
| |
|