JT Lee revirth

revirth / Top 20 queries.sql

Last active August 29, 2015 14:06

	-- 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 / 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) {

revirth / Enumerable.Range.Test

Last active August 29, 2015 13:56

	// 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 / CopyUntrackedFiles.bat

Last active December 11, 2015 08:58

Copy Untracked Files