[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