Brokerage fee comparison at a glance - Hong Kong

			Trading Value and brokage fee in HKD
Broker	Minimum	Rate	5,000	10,000	100,000
Bank of China (Gold Star)	100	0.200%	100.00	100.00	200.00
Bank of East Asia Supreme Gold	80	0.250%	80.00	80.00	250.00
Bright Smart	50	0.067%	50.00	50.00	66.80
China Construction Bank	0	0.180%	9.00	18.00	180.00
Citigold	100	0.200%	100.00	100.00	200.00
DBS Treasures	0	0.250%	12.50	25.00	250.00
Fubon Bank	80	0.250%	80.00	80.00	250.00
Hang Seng Bank	100	0.250%	100.00	100.00	250.00
HSBC	100	0.250%	100.00	100.00	250.00
Interactive Brokers	18	0.080%	18.00	18.00	80.00
SHK direct	88	0.138%	88.00	88.00	138.00
Standard Chartered Bank	0	0.200%	10.00	20.00	200.00

Winner			China Construction Bank	China Construction Bank & Interactive Brokers	Bright Smart
Fee			9.00	18.00	66.80

Additional cost

– SFC Transaction Levy 0.0027% of the transaction amount

– Stock Exchange Trading Fee 0.005% of the transaction amount

- Stamp Duty 0.1% of the transaction amount

Date: 1/27/2018

Live document: https://docs.google.com/spreadsheets/d/e/2PACX-1vRgaNDCI4tByBYyxVM7CZzSv0psCb2ZXRF-umj_mgPX0rAD_jnzy-7CXfMl2MpAPw1T6_cw--rwFyNC/pubhtml?gid=0&single=true

Listing all tables in a database and their row counts and sizes

CREATE TABLE #RowCountsAndSizes (TableName NVARCHAR(128),rows CHAR(11),     
       reserved VARCHAR(18),data VARCHAR(18),index_size VARCHAR(18),
       unused VARCHAR(18))

EXEC       sp_MSForEachTable 'INSERT INTO #RowCountsAndSizes EXEC sp_spaceused ''?'' '

SELECT     TableName,CONVERT(bigint,rows) AS NumberOfRows,
           CONVERT(bigint,left(reserved,len(reserved)-3)) AS SizeinKB
FROM       #RowCountsAndSizes
ORDER BY   NumberOfRows DESC,SizeinKB DESC,TableName

DROP TABLE #RowCountsAndSizes

Source: https://www.sqlmatters.com/Articles/Listing%20all%20tables%20in%20a%20database%20and%20their%20row%20counts%20and%20sizes.aspx