Skip to content

Instantly share code, notes, and snippets.

-- http://msdn.microsoft.com/ko-kr/library/ms189741.aspx
SELECT TOP 20 query_stats.query_hash AS "Query Hash",
SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count)/1000 AS "Avg CPU Time",
MIN(query_stats.statement_text) AS "Statement Text"
FROM
(SELECT QS.*,
SUBSTRING(ST.text, (QS.statement_start_offset/2) + 1,
((CASE statement_end_offset
WHEN -1 THEN DATALENGTH(ST.text)
@revirth
revirth / jqGrid.AvoidPageNumber.js
Last active August 29, 2015 13:56
[JS.jqGrid] avoid insert greater number than total page's
//
// jquery.jqGrid.src.js
//
//
// setPager = function (pgid, tp){
// ...................
// ............
// .....
$('input.ui-pg-input',"#"+pgcnt).keypress( function(e) {
// http://goo.gl/UWuR3W
IEnumerable<string> numbers = Enumerable.Range(1, 100).Select(x = > x.ToString("D3"));
foreach(var n in numbers)
Console.WriteLine(n);
//
// 001
// 002
@revirth
revirth / CopyUntrackedFiles.bat
Last active December 11, 2015 08:58
Copy Untracked Files
@echo off
cd %1
git ls-files -m &gt; %2.txt
echo 'done' %2.txt