x

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 '09 at 03:13 PM in Default

Index8 gravatar image

Index8
71 1 1 1

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

8 answers: sort newest

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:

http://tomlarock.com/?s=policy+based+management

I also cover PBM in my blog/talks/presentations

http://sqlchicken.com/category/policy-based-management/

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

http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

more ▼

answered Oct 09 '09 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 '09 at 05:38 PM Index8
(comments are locked)
10|1200 characters needed characters left

I did a post recently on features in SQL 2008 that you can take advantage of without having to change your applications. It's at http://msmvps.com/blogs/robfarley/archive/2009/12/18/high-roi-items-for-sql-server-2008.aspx

more ▼

answered Dec 23 '09 at 10:29 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

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

I think some of the best features in SQL2008 is Date datatype (no more conversions to strip the time), Data compression (requires less IO operations) and filtered indexes.

I activated PAGE compression in one of our databases and reduced the size from about 1 Tb to 400Gb and increased the performance due to less IO. Data compression uses more CPU, but we are using a server with 4 quad processors and 64Gb memory. :)

With filtered indexes i can create more covering indexes with increased read performance with only slight write overhead. Covering indexes reduces Key lookups.

more ▼

answered Oct 19 '09 at 07:20 AM

Håkan Winther gravatar image

Håkan Winther
15.5k 33 37 48

Very interesting comment about compressing pages for performance. It goes against intuition and is something I will be paying attention to. Thanks for that little tip!
Dec 10 '09 at 04:23 PM Mark Allison
(comments are locked)
10|1200 characters needed characters left

My company has found that the most useful new function is spatial data. We deal with location information all the time, and being able to query directly against the data is a huge advantage.

more ▼

answered Oct 14 '09 at 08:40 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 19 21 74

I wondered who was using the spatial data types! :-)
Dec 10 '09 at 04:21 PM Mark Allison
We are using the hierarchy type as well. It's just convenient though, not changing parts of the business like spatial data.
Dec 10 '09 at 05:26 PM Grant Fritchey ♦♦
(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 '09 at 06:14 PM

TimothyAWiseman gravatar image

TimothyAWiseman
15.5k 19 22 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1936
x1816
x4

asked: Oct 09 '09 at 03:13 PM

Seen: 4257 times

Last Updated: Oct 15 '09 at 05:21 AM