In SQL Server Management Studio, when using the Memory Optimization Advisor at some screen resolutions, the checkboxes for selecting the primary key do not appear. The row height where the columns are…

After applying CU4, every connection to a database engine instance returns an error complaining that a type cannot be loaded from the above DLL. The file list for CU4 shows an updated version of that …

Databases can only be dropped when not in use. BOL suggests setting the database to single user with rollback immediate prior to dropping the database. The problem with this, is that it is performed i…

I've now seen this scenario at a number of client sites and it's already caused quite a bit of data loss.
It is a common operation for users to want to create a copy of their production databases for …