Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Eirikur Eiriksson

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.  Read more...
By Eirikur Eiriksson 2014/04/17 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 4,338 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2014/03/24 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,648 reads
   Items 1 to 2 of 2