Kill Linux processes

We have an old messy thirdparty application at work that uses Oracle. Sometimes the application tends to lock the Oracle system and use a LOT of threads, leaving the system pretty much unresponsive. To be able to kill all 1000+ Oracle-plus processes i created a small script that kills all processes.

Shrink transactionlogs

To shrink the MS-SQL transactionlogs for emergency storage needs we can use the following syntax.

Use at your own risk.

Tablecopy with T-SQL

Today i found myself in a situation where i needed to copy some data from one table on a MS-SQL server to another. I found the following T-SQL syntax to be very helpfull.

Use at your own risk.