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

Archives: November 2012

Tip: OVER and PARTITION BY

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, 3,694 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, 579 reads

Posted in SQL Awesomesauce on 20 November 2012