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

Guest Columnist: Eirikur Eiriksson

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Bringing them back from the dead

When trying to find the causes for why the SQL Server service doesn’t start, one of the best places to start is the SQL Server Error log, but there is a problem!  Read more...
By Eirikur Eiriksson 2018/09/10 | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |   Briefcase | 1,054 reads

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,743 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 2016/04/22 (first published: 2014/03/24) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 13,933 reads
   Items 1 to 3 of 3