View geekkoder.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
<html xmlns="http://www.w3.org/1999/xhtml"> | |
<head> | |
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> | |
<title>Geek Koder</title> | |
<script> | |
/** | |
* @description Geek Code Decoder (originally written Extension for Firefox ) | |
* @author Bhasker V Kode | |
* @date hacked up in the early hours of Feb 23,2007 . |
View umbraco db cleanup.sql
-- dump logs | |
truncate table umbracolog | |
-- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance | |
-- http://borism.net/2008/12/16/fixing-a-large-cmspropertydata-table-in-umbraco/ | |
DECLARE @createdDate Datetime = DATEADD(m, -1, getdate()) | |
DELETE FROM cmsPropertyData WHERE | |
versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND | |
contentNodeId IN (SELECT DISTINCT nodeID FROM cmsDocument) |