Tuesday, October 23, 2007

SQL Server 2005 Hidden Gems

I just came across an article on MSDN that lists ten great features of SQL Server 2005 you most likely not know of.

The article shows you (among others):
  • how easily you can enable login/logout auditing
  • boosting performance through PCC
  • setting the DEFAULT_SCHEMA for a user so SQL Server no longer checks [USERNAME/SCHEMA].Objectname
  • Using Dynamic Management Views (DMV's) to find the top queries on your database

1 comment:

  1. Another cool feature of 2005
    maybe old hat to most, may have existed in 2000 - i do not know.
    But you can paste data from Excel into a table by opening a properly formatted table and going select *, right click, paste....