December 28, 2010 at 7:00 am
Hi
I'm currently setting up a workstation for SQL Server development.
Initially I planned to use SQL server Express, but i got a great deal on SQl Server 2008 Developer edt. and now I consider using this since as I understand this is identical to Enterprise edt.
Are there any overhead of using developer edt. over Express edt. on a high end workstation?
/Andy.l
December 28, 2010 at 8:17 am
Only as you implement more and more functionality, Reporting Services, Analysis Services, otherwise, by and large, running the SQL Server service is about the same. However, we have hundreds of laptops and desktops all running the developers version of SQL Server locally. It's the best way to do development, you won't have major pain unless you're doing really crazy stuff with it as part of your development process.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
December 28, 2010 at 12:24 pm
The only thing to be mindful of, is if your target production environment is not Enterprise Edition to not use features and functionality that is only in Enterprise Edition (since Dev edition has enterprise features).
Seems logical but I have seen folks been bitten by it before.
December 28, 2010 at 12:33 pm
Henry Treftz (12/28/2010)
The only thing to be mindful of, is if your target production environment is not Enterprise Edition to not use features and functionality that is only in Enterprise Edition (since Dev edition has enterprise features).Seems logical but I have seen folks been bitten by it before.
True.
Hopefully there's a test or staging environment between your dev platform and production so that you validate what was done in dev prior to a release to production.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply