Add-Migration allocation_units angular angular6 azure Background Call build-tools core C# dell docker docker image donet ef dotnet dotnet ef @eaDir ef EntityFramework error find firewall index kill light codes linux Luci mssql msvs_version MySql network ng build node-gyp node-sass openvpn OpenWRT partitions size PK powershell Primary Key size sp_who2 sql SSH synology t-sql tables Thread ThreadPool Threads tips ubuntu Update-Database vpn windows-build-tools wpf xev xmodev

To check size used by data and indexes You can use following script

If anyone is interested in how to list columns in the main key on the mssql server then I present a quick script.

    ,OBJECT_ID(Col.Table_Name) AS [object_id]
    Col.Constraint_Name = Tab.Constraint_Name
    AND Col.Table_Name = Tab.Table_Name
    AND Constraint_Type = 'PRIMARY KEY'
    AND [Col].Table_name='<TABLENAME>'

The following example shows how to easily create an index in the MySQL database

ALTER TABLE `TableName` ADD INDEX `IndexName` (`ColumnName`):

The following script allows you to disconnect active connections to the selected ms sql database.