SQL 2008 VS. SQL 2005

Have been playing with SQL 2005; Recently our Sharepoint SQL Server have been migrated to SQL server 2008. Saw some more folders/features/controls from the 2K8 MMS, didn't really get to use any new STUFF. Just using it as 2K5.

To those who have enjoyed the goodies in 2k8, wanna share some nice things you have done with 2008 that 2005 didn't have? THANKS!

more ▼

asked Oct 09, 2009 at 03:13 PM in Default

Index8 gravatar image

71 1 1 1

(comments are locked)
10|1200 characters needed characters left

8 answers: sort voted first

Arguably the most potent tool for DBA's in 2008 would be Policy Based Management. Tom LaRock did a nice 3-video walk-through with Brent Ozar which you should probably check out:


I also cover PBM in my blog/talks/presentations


My PBM fanboy-ism aside, here's the list to all the new features available in SQL 2008


more ▼

answered Oct 09, 2009 at 04:14 PM

Jorge Segarra gravatar image

Jorge Segarra
419 2

Watching videos now...Thanks, Jorge. Will go to your sqlchicken soon.
Oct 09, 2009 at 05:38 PM Index8
(comments are locked)
10|1200 characters needed characters left

Well, I've used the Date & Time datatypes, compound operators ( @i += 1 ), GROUPING SETS, MERGE, Row constructors and the enhanced Declare.

more ▼

answered Oct 09, 2009 at 07:54 PM

RBarryYoung gravatar image

782 5 5 8

(comments are locked)
10|1200 characters needed characters left

For me, the single most important enhancement is the sys.sql_expression_dependencies system view - at last a dependencies view that isn't broken.

A close second comes filtered indexes - but really SQL Server is on catch up in that arena with regard to other DBMSs.

more ▼

answered Oct 09, 2009 at 07:01 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(comments are locked)
10|1200 characters needed characters left

PBM is nice as Jorge has mentioned. From the security side, the Audit object and Transparent Data Encryption are also nice, but both require Enterprise Edition.

more ▼

answered Oct 09, 2009 at 05:52 PM

K. Brian Kelley gravatar image

K. Brian Kelley
933 2

(comments are locked)
10|1200 characters needed characters left

The enhancements to SSMS2008 over SSMS2005 are fairly significant, I especially like adding missing index information to execution plans and the addition of intellisense. The ability to query multiple servers at once is very useful in some limited situations. http://www.sqlservercentral.com/articles/Management+Studio/63536/ provides an introduction to some of the SSMS enhancements.

Also, small tweaks to TSQL such as the ability to initialize a variable when it is declared are nice in a readability sense.

more ▼

answered Oct 14, 2009 at 06:14 PM

TimothyAWiseman gravatar image

15.6k 21 23 32

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 09, 2009 at 03:13 PM

Seen: 4662 times

Last Updated: Oct 15, 2009 at 05:21 AM