Home › Forums › General discussion › What are the advantages of SQL Server 12, 14 and with TOOLS & ADVANCED SERVICES
Tagged: 32 bit, 64 bit, Advanced Services, SQL Server 2012 Express, SQL Server 2014 Express, SQL Server 2016 Express, Tools, Windows 7
- AuthorPosts
What are the advantages, disadvantages, issues and best Tabble practices with using any of the following for SQL SERVER 2012, or 2014, Express or 2016 when Express for it arrives?
I would presume to use 64 bit on my 64 Win 7 systems, but want to clarify and ask about tools and services.
SQL Server 20XX LocalDB Express 32bit
SQL Server 20XX LocalDB Express 64 Bit
SQL Server 20XX Express 32 Bit
SQL Server 20XX Express 64 Bit
SQL Server 20XX Express with Tools 32 Bit
SQL Server 20XX Express with Tools 64 Bit
SQL Server 20XX Management Studio Express 32 Bit
SQL Server 20XX Management Studio Express 64 Bit
SQL Server 20XX Express with Advanced Services 32 Bit
SQL Server 20XX Express with Advanced Services 64 BitThanks,
GregI’ve used SQL Server since version 7, but, still, please regard this ‘answer’ as slightly-educated guess (;
all should work OK (v.2008 is fine) – assuming the bugs are worked out (don’t install on the first day it comes out) I usually use the most recent version.
Management Studio gives you a UI to investigate/export/backup the database (I also use MS Access)
My logic: SQL server is used in many high-end implementations world-wide – the incremental upgrades are often useful, particularly from the Management Studio standpoint, and more and more bugs are killed (unfortunately some get added, too)
I use, presently, 64bit 2014 Express with Management Studio – what MS Downloads calls
( ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe )I make sure to use all 64bit MS products on this machine, because there are incompatibilities with mixing Office versions, in some cases, and I value having MS Access on this machine, which allows me to manipulate SQL Server databases in a familiar Office UI type environment.
Irregular updates to SQL Server are sent out on Windows Update. It is likely that sometime after SQLSvr 2016 comes out, 2014 will get some updates rolled out.
Personally, I will stick with 2014 in this TABBLES environment for another year, probably.hope that helps
OK – maybe it works now?
I’ve used SQL Server since version 7, but, still, please regard this ‘answer’ as slightly-educated guess (;
all should work OK (v.2008 is fine) – assuming the bugs are worked out (don’t install on the first day it comes out) I usually use the most recent version.
Management Studio gives you a UI to investigate/export/backup the database (I also use MS Access)
My logic: SQL server is used in many high-end implementations world-wide – the incremental upgrades are often useful, particularly from the Management Studio standpoint, and more and more bugs are killed (unfortunately some get added, too)
I use, presently, 64bit 2014 Express with Management Studio – what MS Downloads calls
( ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe )I make sure to use all 64bit MS products on this machine, because there are incompatibilities with mixing Office versions, in some cases, and I value having MS Access on this machine, which allows me to manipulate SQL Server databases in a familiar Office UI type environment.
Irregular updates to SQL Server are sent out on Windows Update. It is likely that sometime after SQLSvr 2016 comes out, 2014 will get some updates rolled out.
Personally, I will stick with 2014 in this TABBLES environment for another year, probably.hope that helps
- AuthorPosts
- You must be logged in to reply to this topic.