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

Archives: August 2011

T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()

A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. These new functions are FIRST_VALUE() and LAST_VALUE().

I’ll use the same setup… Read more

6 comments, 2,127 reads

Posted in SQL Server Notes from the Field on 30 August 2011

Autogrow bug – fixed with Denali

Recently I ran into a bug related to autogrow of the log file. Because this was the second time I encounted this particular bug, I decided to blog about it.

The symptoms of the problem was the one specific database took a very long time to be brought online after… Read more

9 comments, 745 reads

Posted in SQL Server Notes from the Field on 23 August 2011

T-SQL Enhancements: OVER clause

With SQL Server Denali there has been made some improvements to the OVER clause, which I wasn’t even aware of until today. I was playing around with a few af the new analytical functions, and suddenly struggled to get the results I was expecting. After some investigation, I found the… Read more

3 comments, 672 reads

Posted in SQL Server Notes from the Field on 16 August 2011

Server Side Paging with new OFFSET feature in SQL Server Denali

Ever since I was a web developer back in the days, server side paging has been an issues. Back then we returned all the rows from the database and did the paging on the client (webserver). Looking back, that is probably not the best and most efficient way to do… Read more

1 comments, 910 reads

Posted in SQL Server Notes from the Field on 9 August 2011

LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3

Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or maybe even worse you are doing multiple self joins. This is where you will start smiling, let’s have a look at an exampel.

I’ll start by creating some demo data: Read more

1 comments, 788 reads

Posted in SQL Server Notes from the Field on 2 August 2011