Jeff -- For the running totals functionality, I think the performance is pretty good if you use ROWS and have the correct index in place. Where I really wish they...

There are a few things, such as creating a custom window aggregate function. Itzik's book spends a lot of time talking about theoretical functionality that I don't. I also have...

Be sure to check out my new book as well!

Itzik's book on windows functions is fantastic, and I have learned a lot from him. ROWS does use an in-memory table most of the time, but not in every case....

There is no OPTIMIZE in the OVER clause. It was just a wrong answer. So, the older methods is something that people might think of because window aggregates without an...

This site has made all the difference for me. Back in 2002, I found that SSC had the answers I needed as a new DBA. I was impressed that the...

Well, whatever media you have should work. Maybe I should have just said "the media" and left RTM out.

Take a look at the links I posted. Slipstreaming is combining the service pack with the RTM media. If all goes well, you don't have to apply the service pack...

Thanks, Grant. This is confusing stuff. A few months ago I was actually able to slipstream the service pack into a Standard install with no problems.

I tried doing this twice...

I love how I always find my answer within 5 minutes of posting a question!

Here is the workaround to avoid slipstreaming: http://wadingthrough.wordpress.com/2009/09/14/problem-installing-sql-server-2008-on-windows-2008-r2/

Shoot an email to SQLH2@Microsoft.com if you don't find the answer.

I am no longer using this product, so I don't know your answer. Microsoft was pretty good about answering questions about it, so you might take a look at the...

Thanks for all the comments.

It's been a couple of months since I wrote the article, so I don't remember all the examples that I used. I know that...

With this program, it makes a difference whether the SQL Server instance is local or not because it uses the DAC to connect. This feature is disabled for remote connections...

When I try to connect to a remote instance, I get an error about using the DAC. Maybe that is part of the issue.