Thanks Adam. I was initially just looking for any signs of life from running your sp, i.e. records>0. Sleeping SPIDs were a welcomed sight, when I finally...

Partially answering my own question, for the benefit of the next person. Edit the query, change at least the following two lines from a 0 to a 1: ...

Is there a 'Read-only' version of this script that can tell us if ANY indexes really need a defrag or reorg? I think it would be better...

Thanks for the replies.

I was just wishful thinking for an easier way to get a copy of our end-user clients database. Your reply confirmed...

Can anyone confirm whether Backup Compression is included in the new SQL 2008 Standard R2, or is it still just for Enterprise? This really should be offered...

Thanks everyone.

In addition to your great comments and hints, I found a very helpful article in one of the recent SqlServerCentral.com newsletters: http://www.sql-server-performance.com/articles/dba/migrating_databases_checklist_part1_p1.aspx ...

Thanks Alex, we already 99.99% sure the database(s) work fine under SQL 2008 since we've been testing a copy of SQL 2008 Express for awhile for basic...

Elliott W (11/18/2009)

---

I didn't see anything about the pre-work needed..

Have you run the SQL Server Upgrade Assistant against the server to see what it points out?

Are you aware of any...

You're absolutely right about the link in a previous newsletter. It was an article link in the 6/18 newsletter pointing to SearchSQLServer aka TechTarget, I thought it was the...

Maybe they only sell the most recent and the freshest 100,000 email addresses. The "About" webpage here claims 819,000 members. I signed up on Feb 2nd 2009....

I'm not slamming the community. The community here is terrific and very knowledgeable, the invaluable newsletters and forums, which is why I'm here and why I care enough to...

Well I know SQLServerCentral gave my email address to techtarget and techtargetlists. I know this because the email address I used is JohnSQLServerCentral @ [my company domain]. ...

It really is this simple:

SELECT InvoiceID FROM Invoice ORDER BY NEWID()

Could his SQL 2005 installation issue be related to the MSXML 6.0 SP2 issues that are now Hindering every new install of SQL Server 2005? Occurring since about Nov...