Useful Unix Commands

1. Count number of lines on all the files in the current folder

wc -l *

2. Count the number of files on the current directory :

ls | wc -l

3. Print all the line containing word/s in a file
grep -iw "search words" arc.log

4. Thread dumping for a process
 jcmd 8308 JFR.start duration=100s filename=tempo.jfr

Simple hack to Update System Properties and Environment variables on Window !

If you don't have a permission to edit the System variable on your local window machine, the following hack might work

Click Window and  type "SystemPropertiesAdvanced"  on Search programs and file search text option. Then, once you see the SystemPropertiesAdvanced shortcut, right click it and open it as an administrator.  You might be able to edit it now.

MySql Query to turn ON Query statistics I/O

SET STATISTICS IO ON
SET STATISTICS TIME ON
SELECT er.ReportID, er.ReportName, er.ReportNumber
FROM dbo.EmployeeReports er
WHERE er.ReportNumber LIKE '%33%'
SET STATISTICS IO OFF
SET STATISTICS TIME OFF