Blog ala Vidar

SQL, AppFrame and other cool technologies

Monthly Archives: May 2009

Why convert to SQL Server 2008?

I’ve been asked by a couple of people this question. Microsoft released SP1 a couple of weeks ago, but what’s the difference between 2005 and 2008, and when is the next version coming? The next version of SQL Server is scheduled for 2011 (NB! This is a rumor!!!). That’s two years. Then SQL Server 2005 will be… 6 years old. Anyhow, here’s a list of nice features that you don’t got in 2005:

For developers:

  • New column types – Date, Time, Datetimeoffset, Datetime2
  • MERGE statement
  • Sparse Columns – Performs very good compared to large tables with many NULL-able columns
  • Spatial Data types – Geometry etc
  • Transact-SQL IntelliSense
  • Table Valued Parameters
  • Grouping sets

For DBAs:

  • Easier to maintain multiple servers
  • Transparent Data Encryption – Encrypt the physical database files without any application changes
  • Auditing
  • Resource Governor – ability to set "maximum CPU/memory usage" on heavy queries, users etc
  • Data Compression – Reduce the storage requirements of both database and backups
  • Performance Data Collection – Makes it easy to find issues and bad performing queries
  • Integrated Full Text Search
  • Policy management
  • Database Mirroring – Improved compared to 2005 with automatic page recovery of corrupted pages
  • Hot Add CPU

Keyboard shortcuts in SSMS

You can save a lot of time using simple keyboard shortcuts. Here’s a list of my favorite shortcuts in SQL Server Management Studio. NB!!! You might have to go in to Tools –> Options –> Environment –> Keyboard and press “Reset to default”.

Action Shortcut
New Query Window CTRL + N
Close window CTRL + F4
Delete all text in current tab CTRL + SHIFT + DEL
Selected text to UPPER case CTRL + SHIFT + U
Selected text to lower case CTRL + SHIFT + L
Selected text to comment CTRL + K, CTRL + C
Uncomment selected text CTRL + K, CTRL + U
Info of selected object (text) ALT + F1
Include actual execution plan CTRL + M
Switch between tabs CTRL + TAB
Object Explorer Details F7
Object Explorer F8