This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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: {", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<configuration> | |
<system.net> | |
<defaultProxy enabled="true"> | |
<proxy proxyaddress="http://127.0.0.1:8888" bypassonlocal="False"/> | |
</defaultProxy> | |
</system.net> | |
</configuration> |