Connect Digest : 2010-02-06
Upgrading a database with read-only filegroups
Earlier today, I complained that I should be able to upgrade a database with read-only filegroups. In this case an upgrade from, say, 2000 to 2005 is blocked because the engine can't update the system schema / structure. Since I am trying to protect the data, not the system schema, I think it should be okay that the engine ignores the read-only flag during the upgrade process. The workaround is rather cumbersome : get exclusive access to the original database, mark the filegroup as read/write, backup, restore, then mark the filegroup as read-only. Blecch.
In testing this scenario against different versions of the engine, I also came across a couple of bugs in SSMS 2008 SP1 dialogs that deal with filegroups and the read-only flag:
Updating statistics during RESTORE
Steve Jones wants to see updating statistics to be an optional part of a RESTORE operation:
NULLgarity wants filegrowth settings to be inherited from model instead of defaulting to 1MB when not specified.
There is a lot to be said for sorting. The other day I requested that the "Object Explorer Details" column header choices be ordered alphabetically instead of mosaically:
And a long time ago, NULLgarity also asked for the ability to sort grid results by clicking on column headers. Ideally we would just get Excel integration into the results pane (I asked for that in #524769), but this would be a good consolation prize:
Bad error messages
And the other day, I highlighted several Connect items when I discussed some of the poor and/or vague error messages that come out of SQL Server:
As for Connect itself, you may have noticed the shiny new URL format for Connect items, e.g.:
This overcomes the severely limited URL format that existed previously:
This format was not only far too long to be practical for services like twitter, but it also drove people nuts in newsgroups or e-mail, because it would often wrap and break. Go vote for that item (either link will work!), as it is encouraging them to come up with an even shorter and more intuitive URL format that will do away with the need to use bit.ly and the like to shorten Connect item URLs.