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

Content with tags T-SQL, SQL Server 2012 Rss

   Items 1 to 10 of 10   

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2017/05/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 710 reads

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 | 603 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,739 reads

Sequences III

By Steve Knox 2012/05/01 | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 2,226 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,592 reads

Sequences II

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

Sequences I

By Steve Knox 2012/04/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,630 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,870 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,583 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,437 reads
   Items 1 to 10 of 10   
create sequence (3)    
sequence objects (2)    
analysis services (ssas) (1)    
data warehousing (1)    
database design (1)    
date manipulation (1)    
development (1)    
execution plans (1)    
lag (1)    
lead (1)    
miscellaneous (1)    
other (1)    
performance tuning (1)    
sequence (1)    
sequence object (1)    
sql server (1)    
sql server 2016 (1)    
window functions (1)