Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yonabout
Posting Yak Master
112 Posts |
 Posted - 2008-07-04 : 05:39:24
|
| Hi, Firstly, apologies if this is the wrong forum.My company is currently running SQL Server 2000. Its coming up to budget planning time, and I want to upgrade to 2008.I can think of plenty of justifications from my point of view (I run a development team) with the enhancements to T-SQL, reporting and data mining, but what will really swing the vote will be any enhancements to db administration, an area which I don't know much about. The IT team responsible for budget are also the team who administer databases, so I'm much more likely to get what I want if I can show that its in their best interests as well.So with that in mind, what are the top 3 reasons for a db admin to upgrade from SQL server 2000?Cheers,Yonabout |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-04 : 14:33:50
|
| 1)Dynamic Management Views2)Online Reindexing3)Database MirroringNote these are just specific to our organisationJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 18:23:23
|
| 1. Microsoft will stop supporting sql2k soon.2. backup with compression.3. resource governor. |
|
|
|
yonabout
Posting Yak Master
112 Posts |
Posted - 2008-07-07 : 06:08:20
|
| Cool.Thanks for that - I'll add them to my list.Cheers,Yonabout |
|
|
|
|
|
|
top 3 Reasons to upgrade?