Pipe Through less

I found an interesting command today while working on some MySQL databases for my company. I was getting annoyed at the spaghetti code that would from out of the table when I used the commandline.

SELECT * FROM TABLE;

I would try to use this view my tables. I would have to limit my rows to keep the spaghetti to a minimum. I finally gave up and googled around until I found this command.

pager less -SFX
Read More

Speeding up SQL Transactional Jobs

Yesterday, I was working on SQL code that would truncate the table, pull the newest data of completed jobs by a department with an Action_Date (just the time the job was completed) of GetDate() - 366 (so one year back from the current date) and then inserts that into the empty table. This took about half an hour to run, which was acceptable on the daily AM job schedule.

Read More