Skip to content

Instantly share code, notes, and snippets.

Avatar

Matt Dickinson mdickin

View GitHub Profile
@mdickin
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';",
"",
"@Component({",
" components: {",
@mdickin
mdickin / git aliases
Last active Feb 27, 2019
Helpful aliases in git
View git aliases
//git config --global alias.<alias> <git-command>
//C:\Users\matt.dickinson\.gitconfig
//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
mdickin / FiddlerWeb.config
Created Oct 27, 2016
Modify ASP.NET proxy to run through Fiddler
View FiddlerWeb.config
<configuration>
<system.net>
<defaultProxy enabled="true">
<proxy proxyaddress="http://127.0.0.1:8888" bypassonlocal="False"/>
</defaultProxy>
</system.net>
</configuration>