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

Archives: November 2012


I like to repost this blog about once a  year, because you really really need to know about windowing functions. So, happy November! Here’s a quick summary of OVER and PARTITION BY (windowing functions, “new” in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to get aggregate…

Read more

0 comments, 4,609 reads

Posted in SQL Awesomesauce on 26 November 2012

Blogging for Beginners

Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the same things again and again. Of course, these were the things (a) I was told when I was an aspiring blogger, or (b) I wish I had been told as… Read more

4 comments, 970 reads

Posted in SQL Awesomesauce on 20 November 2012