This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<xsl:sort data-type="number" case-order="lower-first" select="@sortOrder" order="ascending" /> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
umbraco.library:DateGreaterThanOrEqualToday( data [@alias='ClassDate']] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* ------------------------------------------------------------------ | |
-- Title: FindMissingIndexes | |
-- Author: Brent Ozar | |
-- Date: 2009-04-01 | |
-- Modified By: Clayton Kramer <ckramer.kramer @="" gmail.com=""> | |
-- Description: This query returns indexes that SQL Server 2005 | |
-- (and higher) thinks are missing since the last restart. The | |
-- "Impact" column is relative to the time of last restart and how | |
-- bad SQL Server needs the index. 10 million+ is high. | |
-- Changes: Updated to expose full table name. This makes it easier |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select sum(reserved_page_count) * 8.0 / 1024 | |
from sys.dm_db_partition_stats | |
GO | |
SELECT sys.objects.name, sum(reserved_page_count) * 8.0 / 1024 | |
from sys.dm_db_partition_stats, sys.objects | |
where sys.dm_db_partition_stats.object_id = sys.objects.object_id | |
group by sys.objects.name | |
ORDER BY sum(reserved_page_count) DESC |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
http://www.facebook.com/sharer.php?s=100&p[title]=YOUR_TITLE&p[summary]=YOUR_SUMMARY&p[url]=YOUR_URL&p[images][0]=YOUR_IMAGE_TO_SHARE_OBJECT | |
http://twitter.com/share?url=http://yourdomain.com&text=This+is+where+your+tweets+goes…&hashtags=hash,tags,here | |
http://pinterest.com/pin/create/bookmarklet/?media=http%3A%2F%2Fyourdomain.com%2Fsomeimage.jpg&url=http%3A%2F%2Fyourdomain.com&title=Your%20Title&is_video=false&description=Some%20Description |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$(function () { | |
$('.checkall').on('click', function () { | |
$(this).closest('fieldset').find(':checkbox').prop('checked', this.checked); | |
}); | |
}); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Configuration; | |
using System.IO; | |
using BeVancouver.Web.Helpers; | |
using ServiceStack.ServiceHost; | |
using ServiceStack.ServiceInterface; | |
using ServiceStack.ServiceInterface.ServiceModel; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
dt.controlId, | |
n.UniqueId, | |
n.text, | |
dt.dbType | |
FROM dbo.umbracoNode n | |
LEFT JOIN dbo.cmsDataType dt | |
ON n.id = dt.nodeId | |
WHERE dt.nodeId IS NOT NULL | |
ORDER BY n.text |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
t.NAME AS TableName, | |
p.rows AS RowCounts, | |
(SUM(a.total_pages) * 8) / 1024 AS TotalSpaceMB, | |
(SUM(a.used_pages) * 8) / 1024 AS UsedSpaceMB, | |
((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024 AS UnusedSpaceKB | |
FROM | |
sys.tables t | |
INNER JOIN | |
sys.indexes i ON t.OBJECT_ID = i.object_id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-ExecutionPolicy unrestricted -Command "(New-Object Net.WebClient).DownloadString(\"http://...aspx\")" | |
-ExecutionPolicy unrestricted -Command "(New-Object Net.WebClient).DownloadString($d=Get-Date;$t='{0:yyyyMMddTHHmmssZ}' -f $d.AddMinutes(-2);$f='{0:yyyyMMddTHHmmssZ}' -f $d.AddMinutes(-8);$url=\"http://...aspx?from=\" + $f + \"&to=\" + $t;write-host $url)" |