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.