Home Forums General discussion What are the advantages of SQL Server 12, 14 and with TOOLS & ADVANCED SERVICES

Viewing 4 reply threads
  • Author
    Posts
    • Avatar photoGreg
      Member
      Post count: 2

      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 Bit

      Thanks,
      Greg

    • Avatar photoGreg
      Member
      Post count: 2

      Meaning in part… which of these versions is the best for use with Tabbles, and why.

    • xkat
      Participant
      Post count: 44

      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

    • xkat
      Participant
      Post count: 44

      i tried to answer this question, but TABBLES forum timed out, and then gives an error – ‘you already posted this answer’. or some such ?!?!? when it obviously is NOT POSTED.
      i’ll try again later

    • xkat
      Participant
      Post count: 44

      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

Viewing 4 reply threads
  • You must be logged in to reply to this topic.