Skip to content

Instantly share code, notes, and snippets.

View wqweto's full-sized avatar

Vladimir Vissoultchev wqweto

View GitHub Profile
@wqweto
wqweto / CsvExtensions.cs
Created June 8, 2015 12:48
Generic CSV formatting extension that works on `IEnumerable<T>` and returns `IEnumerable<string>`
public static class CsvExtensions
{
//
// sample usage:
//
// var list = new object[] {
// new { Email = "svetlahristova0@gmail.bg", Name = "Свет.а Х,истова", UnsubscribeToken = "12\r34" },
// new { Email = "test", Name = "11\"22", UnsubscribeToken = "5\n67" },
// };
// var csv = string.Join(Environment.NewLine, list.ToCsvTable());
@wqweto
wqweto / gist:4257321
Created December 11, 2012 09:34
Fix for 'Last good DBCC CHECKDB over 2 weeks old'
/*
Sample DBCC DBInfo() With TableResults output. Notice double dbi_dbccLastKnownGood field. Fix at the bottom.
ParentObject Object Field VALUE
------------------------------- --------------------------------- ------------------------------------ ---------------------------------------------------------
DBINFO STRUCTURE: DBINFO @0x00000000420BD670 dbi_dbid 5
DBINFO STRUCTURE: DBINFO @0x00000000420BD670 dbi_status 9502720
DBINFO STRUCTURE: DBINFO @0x00000000420BD670 dbi_nextid 348222265
DBINFO STRUCTURE: DBINFO @0x00000000420BD670 dbi_dbname Dreem15_IVB
@wqweto
wqweto / gist:4730218
Created February 7, 2013 10:45
Find Column Usage in MSSQL 2008
DECLARE @TmpColumns TABLE (
TableName SYSNAME
, ColumnName SYSNAME
, object_id INT
, column_id INT
)
INSERT @TmpColumns
SELECT s.TableName, s.ColumnName, c.object_id, c.column_id
--FROM (
@wqweto
wqweto / a_find_implicit_conversions.sql
Last active December 16, 2015 03:39
Finding Implicit Column Conversions in the Plan Cache made usable
/*
Based on http://www.sqlskills.com/blogs/jonathan/finding-implicit-column-conversions-in-the-plan-cache/
Results made (mostly) usable by deduping on statements and ordering output by tables and columns
Uses sys.columns instead of INFORMATION_SCHEMA.COLUMNS for performance (nothing gained here)
*/
@wqweto
wqweto / post_cache.txt
Created August 20, 2013 19:42
SQLIO test of RAID 5 with 4 x Intel 520 SSDs on an HP SmartArray P420i controller
sqlio v1.5.SG
using system counter for latency timings, 2343896 counts per second
8 threads writing for 360 secs to file D:\testfile.dat
using 8KB random IOs
enabling multiple I/Os per thread with 8 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 36864 MB for file: D:\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
//Convert all unsafe characters in szStringIn to escape sequences
//lpszStringIn and lpszStringOut should be different strings
inline _Success_(return != FALSE) BOOL AtlEscapeUrl(
_In_z_ LPCSTR szStringIn,
_Out_writes_to_(dwMaxLength, *pdwStrLen) LPSTR szStringOut,
_Out_opt_ DWORD* pdwStrLen,
_In_ DWORD dwMaxLength,
_In_ DWORD dwFlags = 0)
{
ATLENSURE( szStringIn != NULL );
@wqweto
wqweto / bitclean.bat
Last active January 4, 2016 05:28
Dumps audio file bitrate
@echo off
for /f "tokens=1-2 delims=|" %%i in ('cscript //nologo bitrate.vbs /f:"%~1" /m:"%~2"') do (
if %%j LSS 320 echo %%i has bitrate %%j and will be deleted
)
@wqweto
wqweto / re.lua
Last active January 4, 2016 16:19
LPeg.re w/ optional built-in and external trace support (can be used w/ pegdebug.lua)
-- $Id: re.lua,v 1.44 2013/03/26 20:11:40 roberto Exp $
-- imported functions and modules
local tonumber, type, print, error = tonumber, type, print, error
local setmetatable = setmetatable
local m = require"lpeg"
-- 'm' will be used to parse expressions, and 'mm' will be used to
-- create expressions; that is, 're' runs on 'm', creating patterns
-- on 'mm'
@wqweto
wqweto / bf2.lua
Last active February 16, 2016 16:56
Brainfuck optimizing compiler in Lua
-- This transpiler generates Lua source code from input brainf**k program, then compiles and
-- executes this Lua source code. Can be used with LuaJIT for jitted brainf**k experience.
--
-- Based on https://github.com/prapin/LuaBrainFuck/blob/master/brainfuck.lua
-- Inspired by https://github.com/luapower/bf and its dynasm implementation (~5-10x faster)
-- Optimizations from https://www.nayuki.io/page/optimizing-brainfuck-compiler
--
-- Optimizations due to lpeg grammar:
-- instead of generating repeating `i = i + 1` just output `i = i + N`
-- instead of generating repeating `t[i] = t[i] + 1` just output `t[i] = t[i] + N`
@wqweto
wqweto / countdown.lua
Last active February 16, 2016 18:15
Countdown problem solution in Lua
--local strict = require"strict"
local function permutations(t)
local fn = coroutine.yield
local function permgen(t, n)
for i = 1, n do
t[n], t[i] = t[i], t[n]
if n == 1 then
fn(t)
else