My experience at upgrading my HP Pavilion 9500 from Vista Ultimate x64 to Windows 7 Ultimate x64 was the worst I have read about so far. To help anyone who had my issues I documented all my fixes and posted some comments on the net for those who had same issues.
Paul Randal gives an excellent explanation of why not to shrink data files if you don't have to. http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx You can turn a <1% fragmented index to 99% fragmented index with one shrink operation.
His recommendation, if you have the extra space, is to shrink by moving data to new filegroups:
Since the Red-Gate software sponsored award website doesn't post much information about us, I thought I would post my application letter so you get a better feel for what I do at work. Thanks for voting - click Vote Now image on this site: http://www.exceptionaldba.com/vote.htm
My company uses SCOM 2007 and recently upgraded to R2, which provides a whole host of new features like linux support and Service Level Dashboards. Walter Eikenboom has some great SCOM related posts and one on this feature.
If you read the release notes, SharePoint MUST be a local install, can't do remote yet.
The terminal services team blog has a great post on upcoming Windows 7 and Windows 2008 R2 multi-monitor remote RDP sessions, including comparison to the Vista span mode. Cool things to come in next version!
The SQLCAT team blog has a great tip on deleting rows efficiently to help preventing blocking and minimize log file growth http://sqlcat.com/msdnmirror/archive/2009/05/20/fast-ordered-delete.aspx.
Louis Davidson (Dr. SQL) has a great book on the subject, but he also posted a great shorter version on simple-talk. Always a good reminder for us all...http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/
Lookup tables or Entiry-Attribute-Value (EAV) tables are often used in SQL programming. Joe as always gives some great advice on how to properly design these kind of tables. http://www.simple-talk.com/sql/t-sql-programming/avoiding-the-eav-of-destruction/ His use of a view to prevent SQL engine from intent locking is a great idea that is new to me, I will have to remember that one.