Wayne Sheffield

My blog about SQL Server

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 provides a supported, documented (in […]

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 key. Nope, this is absolutely […]

First of all, I didn’t think much about goals for 2010, and subsequently never set any, so I’m going to list the accomplishments that I’ve had in 2010: Articles: 5 articles written; 3 published; 2 submitted and are being published in Jan 2011. Events: Attended SQL Saturday #30 (Richmond, VA) on 4/10/2010 3 Question of […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close