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

Archives: August 2011

Presenting at Curacao SQL UG

On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group. This will be my second time presenting to these great folks, and I’m really looking forward for this return visit.

The topic is Banish RBAR!, and the abstract for… Read more

0 comments, 670 reads

Posted in A Discussion of SQL Server-Related Topics on 31 August 2011

Running totals in “Denali” CTP3

One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause. One of the things that I’m particular excited about is the addition of the ROWS/RANGE clause support. And one of the reasons that I’m excited about this is that this… Read more

0 comments, 285 reads

Posted in A Discussion of SQL Server-Related Topics on 23 August 2011

ORDER BY Clause with clustered index

One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index on a table, that you can run a SELECT statement without an ORDER BY clause from that table and the results will be in the order of the clustered index… Read more

0 comments, 747 reads

Posted in A Discussion of SQL Server-Related Topics on 20 August 2011