• Adam Thurgar

SSMS installation options


Whilst installing SSMS 17.6 recently I needed to find out how to do a silent install.

The following image shows you the available options.

Most of these are self explanatory, but you may want them as part of any automated build process.

Example: /install /quiet /norestart


11 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t