SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2012, T-SQL Rss

   Items 1 to 9 of 9   

New and Basic Result-set Paging functionality in SQL 2012 Version.

Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.  Read more...
By Eli Leiba 2013/04/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 596 reads

SQL Server 2012: Time Marches On

Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.  Read more...
By Additional Articles 2013/02/13 | Category: date manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,422 reads

Sequences III

By Steve Knox 2012/05/01 | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 2,216 reads

Analytic Enhancements in SQL Server 2012 - Part II

The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.  Read more...
By Additional Articles 2012/04/25 | Source: Database Journal | Category: sql server 2012
Rating:  Rate this |   Briefcase | 3,329 reads

Sequences II

By Steve Knox 2012/04/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,670 reads

Sequences I

By Steve Knox 2012/04/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,622 reads

Sequences in SQL Server 2012

This article describes the sequence new feature used in SQL Server 2012  Read more...
By Daniel Calbimonte 2012/04/13 | Source: SQLServerCentral.com | Category: sequence
Rating: |  Discuss |   Briefcase | 8,863 reads

Changes to SQL Server 2012 Execution Plans

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.  Read more...
By Grant Fritchey 2011/12/14 | Source: SQLServerCentral.com | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 6,321 reads

Window Functions in SQL Server

With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.  Read more...
By Additional Articles 2011/11/14 | Source: SimpleTalk | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 4,177 reads
   Items 1 to 9 of 9   
create sequence (3)    
sequence objects (2)    
analysis services (ssas) (1)    
date manipulation (1)    
execution plans (1)    
lag (1)    
lead (1)    
performance tuning (1)    
sequence (1)    
sequence object (1)    
window functions (1)