Fastest way to merge MOV files by using ffmpeg

There was full of sunshine over the week. I wanted to keep some of the video in my dash camera to celebrate summer. The weather was nicely recorded, but it was all saved in separate MOV files for 1 min each. I wanted to combine them into a single file for sharing over YouTube.

Obviously there were bunch of software of doing this, but many of them take too much time for processing. (My CPU fan worked damn hard to cool off). I didn't need to re-encode the files.
There must be some smarter way.

I turned out using ffmpeg. It gave exactly what I needed. The merge of 6 files (6 mins) only took about 1 - 2 mins. This was amazing fast compare with using other software. Thanks ffmpeg!

1. Install ffmpeg (it is free)
2. Copy all the mov files into a new blank folder
3. Create a text file (files.txt) with all the files to be merged in order with the format like this
   
   file 'file1.mov'
   file 'file2.mov'
   file 'file3.mov'
   file 'file4.mov'
   file 'file5.mov'
   file 'file6.mov'
4. Run this command in the folder
   ffmpeg -safe 0 -f concat -i files.txt -vcodec copy -acodec copy merged.MOV
5. The output file merged.mov is ready.

Here is the batch script to do the whole thing nice and easy

@echo off

del merged.mov

del files.txt

for %%i In (*.mov) DO echo file '%%i' >>files.txt

ffmpeg -safe 0 -f concat -i files.txt -vcodec copy merged.MOV

What a lovely day!

Rainbow 6 Siege - Cold Zero - 100% Health Finish

Rainbow 6 Siege - Tubular Assault - 100% Health Finish

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

Engine part names

https://i.pinimg.com/originals/61/3f/69/613f6997b566882fca77970717899380.jpg

How to find text in entire workbook

Your eyes are not built for searching text in a boring excel file.

To protect your eyes, you have to know what the computer can do for you.

Make good use of the "find and replace" can save your eyes from bleeding.