[dba-Tech] SQL express version question

John Colby jwcolby at gmail.com
Fri Jul 29 12:39:35 CDT 2016


Does SSMS work with Express?  I use SQL Server 2008 for everything but I 
am working on a game which I hope to use express for.  It would be nice 
to be able to use SSMS with the express version.  I assume if it does I 
will beed a later version of SSMS?


On 7/29/2016 11:38 AM, Fred Hooper wrote:
> HI Michael,
>
> I faced the same question when I started converting a single, but very
> complex application. I started with 2012, primarily because I already
> had a copy of that development version. After a bit, I did some research
> and found the two points below, which were persuasive for me:
>
>   1. 2014 brought the ability to better handle complex queries
>   2. 2016 lost the ability to control when and if updates were applied
>      (Express version only)
>
> I changed the back end to 2014 and could immediately see the speed
> differences with 2014, which I expect to remain with. I'm now about half
> done with the first stage of the conversion.
>
> Best,
> Fred
>> Zimmer, Michael <mailto:Michael.Zimmer at federalmogul.com>
>> Wednesday, July 27, 2016 12:00 PM
>> Hello All,
>>
>> Currently at my work, we use literally dozens of MS Access databases
>> that clients utilize across our LAN.
>> Now we are looking at migrating to a SQL Server. So a couple of us
>> here are beginning to dabble in SQL. Due to company policy, we have to
>> only deal with Microsoft products, so I've been looking at the
>> different flavors of SQL Server Express Edition.
>>
>> My question is what version of SQL Server Express should we be
>> learning on? 2014? Or 2016? What is the difference, if any, between
>> the versions? Any advantages/disadvantages?
>>
>> Thanks for any advice you can offer!
>>
>>
>> Kindest personal regards,
>>
>> Mike
>>
>>
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
>>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>

-- 
John W. Colby



More information about the dba-Tech mailing list