Skip to content

Instantly share code, notes, and snippets.


Matt Dickinson mdickin

View GitHub Profile
mdickin / gist:f4f6744774e650bf4c3aae2d313bd71a
Last active Dec 16, 2019
Finding and clearing SQL execution plans
View gist:f4f6744774e650bf4c3aae2d313bd71a
SELECT cp.plan_handle, cp.objtype, cp.usecounts,
DB_NAME(st.dbid) AS [DatabaseName], st.text, cp.refcounts--, qp.query_plan
FROM sys.dm_exec_cached_plans AS cp
CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st
CROSS APPLY sys.dm_exec_query_plan(plan_handle) qp
where objtype = 'Prepared' and
cp.usecounts > 4 and
st.text LIKE N'%some text in the query you want to search for%' OPTION (RECOMPILE);
-- For SQL Server
View gist:9693fb9d59725b20f199c935c124b89a
These are placed in the appropriate json file
"Vue Component": {
"prefix": "vuec",
"body": [
"import Vue from 'vue'",
"import { Component, Prop, Watch } from 'vue-property-decorator';",
" components: {",
mdickin / git aliases
Last active Feb 27, 2019
Helpful aliases in git
View git aliases
//git config --global alias.<alias> <git-command>
//Remove a remote branch
delr = push -d origin
//Create a new branch
newb = "!git branch $1 && git checkout $1 && git push -u origin $1 #"
//Delete local and remote branch
delb = "!git push -d origin $1 && git branch -d $1 #"
//Refresh "latest" branch from server without having to change working branches
mdickin / FiddlerWeb.config
Created Oct 27, 2016
Modify ASP.NET proxy to run through Fiddler
View FiddlerWeb.config
<defaultProxy enabled="true">
<proxy proxyaddress="" bypassonlocal="False"/>