Skip to content

Instantly share code, notes, and snippets.

View geekkoder.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Geek Koder</title>
* @description Geek Code Decoder (originally written Extension for Firefox )
* @author Bhasker V Kode
* @date hacked up in the early hours of Feb 23,2007 .
JamesKhoury / umbraco db cleanup.sql
Created Sep 20, 2016 — forked from dampee/umbraco db cleanup.sql
Umbraco Database cleanup. After pulling in an umbraco database from production, you don't need all history or log.
View umbraco db cleanup.sql
-- dump logs
truncate table umbracolog
-- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance
DECLARE @createdDate Datetime = DATEADD(m, -1, getdate())
versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
contentNodeId IN (SELECT DISTINCT nodeID FROM cmsDocument)