dbcc Archives - Sion IT

Cannot shrink transaction log SQL 2005

If you ever come across a MS SQL 2005 transaction log that refuses to shrink, this little bit of code might help you out.

Posted on July 28, 2012 at 20:12 by simon · Permalink · Leave a comment
In: SQL · Tagged with: , ,

T-SQL Example code: useful stores procedures and snippets

Here are some useful one liners that I find very useful

Posted on July 12, 2012 at 23:41 by simon · Permalink · Leave a comment
In: SQL · Tagged with: , , , , , , , , ,

T-SQL Example code: SQL Fixes

Here are a few lines of code that have got me out of troubel in the past:

Posted on July 12, 2012 at 23:29 by simon · Permalink · Leave a comment
In: SQL · Tagged with: , ,