Tag: sql query

WordPress SQL Queries for database cleanup

With time your WordPress database may grow out of control. A couple contibuting factors are post revisions, RSS feeds fed through the dashboard. There are plugins that handle basic database optimizations, however, the command line is a quick and dirty way to handle some of these. I have always been aware of the transient RSS entries in the wp_options of…

Read More »

Commands to shrink the SQL Server transacation log

I recently encountered a database that was 4 MB in size with it’s respective transaction log at 460 MB. The transaction log is used in a recovery model to restore the database to a point in time. I wanted to reduce the size of the transaction log. More importantly, I wasn’t exactly clear as to why a transaction log of…

Read More »