Skip to content

Instantly share code, notes, and snippets.

View SteGriff's full-sized avatar
🎣

Stephen Griffiths SteGriff

🎣
52 followers · 137 following
View GitHub Profile
@SteGriff
SteGriff / move-commits.sh
Created October 8, 2021 13:08
Git move commits to another branch
# == Check how many commits to move ==
git log
# == Move commits to a new branch ==
# Creates the branch at current HEAD but doesn't check it out:
git branch new-branch
# Resets master/main/current back x commits
git reset --keep HEAD~2
@SteGriff
SteGriff / toSentenceCase.js
Created August 26, 2021 13:09
JS String toSentenceCase
String.prototype.toSentenceCase = function(){ return this.slice(0,1).toUpperCase() + this.slice(1) }
@SteGriff
SteGriff / predict-indexes.sql
Created June 10, 2021 13:48
Predict useful SQL indexes
SELECT
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
dm_migs.last_user_seek AS Last_User_Seek,
object_name(dm_mid.object_id,dm_mid.database_id) AS [TableName],
'CREATE INDEX [IX_' + object_name(dm_mid.object_id,dm_mid.database_id) + '_'
+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.equality_columns,''),', ','_'),'[',''),']','') +
CASE
WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns IS NOT NULL THEN '_'
ELSE ''
@SteGriff
SteGriff / visualise-running-query-plans.sql
Created June 10, 2021 13:48
Visualise execution plans of running queries
-- QUERY TO GET RUNNING PLAN HANDLES
SELECT d.name, t.text,PLAN_HANDLE, r.total_elapsed_time/1000 RunningSeconds
FROM sys.dm_exec_requests r
JOIN sys.databases d on d.database_id = r.database_id
CROSS APPLY sys.dm_exec_sql_text(sql_handle) t
ORDER BY 4 DESC
-- VISUALISE A PLAN HANDLE
@SteGriff
SteGriff / running-queries.sql
Last active June 10, 2021 13:53
Running SQL queries
SELECT
d.name,
t.text,
r.total_elapsed_time/1000 as [Time],
r.blocking_session_id,
SUBSTRING(t.text,r.statement_start_offset/2 +1,
(CASE WHEN r.statement_end_offset = -1
THEN LEN(CONVERT(NVARCHAR(MAX), t.text)) * 2
ELSE r.statement_end_offset END -
r.statement_start_offset)/2)
@SteGriff
SteGriff / sql-connections.sql
Created June 7, 2021 09:24
SQL connections
SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame
@SteGriff
SteGriff / loader.htm
Created May 12, 2021 14:07
Pirijan's Earth Spinner
<html>
<head>
<style>
@keyframes slideMoon{0%{left:-40%}
to{left:145%}
}
@keyframes slideEarth{0%{left:-60%}
to{left:145%}
}
@SteGriff
SteGriff / fix-ng-on-init.ts
Last active January 28, 2021 19:15
Angular FormControls suck
ngOnInit(): void {
// Form field subscribes to self
// In FormGroup
this.anotherForm.controls.scoops.valueChanges.subscribe(value => {
this.anotherForm.controls.scoops.setValue(value, { onlySelf: true, emitEvent: false, emitModelToViewChange: true });
}, error => { }, () => { });
// Standalone FormControl
this.flavour.valueChanges.subscribe(value => {
@SteGriff
SteGriff / skippingIterator.js
Created October 27, 2020 15:07
Generate a sequence which skips numbers and doesn't repeat, like an offset sawtooth wave. Or odd numbers up to n, followed by even numbers up to n.
const skippingIterator = (x, skip, limit) =>
{
return 1 + ((skip * x) % limit) + (Math.floor((skip * x)/limit));
}
const limit = 36;
for (let i = 0; i < limit; i++)
{
console.log(i, skippingIterator(i, 3, limit));
}
@SteGriff
SteGriff / kanji.json
Created October 16, 2020 17:21
JSON of KANJIDIC Kanji
This file has been truncated, but you can view the full file.
[{"kanji":"亜","kun_readings":["぀.ぐ"],"on_readings":["γ‚’"],"name_readings":["γ‚„","぀ぎ","぀ぐ"],"jlpt":1,"unicode":"4e9c","heisig_en":"Asia"},{"kanji":"ε”–","kun_readings":["γŠγ—"],"on_readings":["γ‚’","γ‚’γ‚―"],"name_readings":[],"jlpt":null,"unicode":"5516","heisig_en":"babble"},{"kanji":"娃","kun_readings":["う぀く.しい"],"on_readings":["γ‚’","γ‚’γ‚€","γƒ―"],"name_readings":["い"],"jlpt":null,"unicode":"5a03","heisig_en":"fair"},{"kanji":"阿","kun_readings":["γŠγ‚‚γ­.γ‚‹","くま"],"on_readings":["γ‚’","γ‚ͺ"],"name_readings":["γ»γ¨γ‚Š","γ‚γš","あわ","γŠγ‹","きた","γͺ"],"jlpt":1,"unicode":"963f","heisig_en":"Africa"},{"kanji":"ε“€","kun_readings":["あわ.γ‚Œ","あわ.γ‚Œγ‚€","かγͺ.しい"],"on_readings":["γ‚’γ‚€"],"name_readings":[],"jlpt":1,"unicode":"54c0","heisig_en":"pathetic"},{"kanji":"ζ„›","kun_readings":["いと.しい","かγͺ.しい","め.でる","お.しむ","まγͺ"],"on_readings":["γ‚’γ‚€"],"name_readings":["あ","あし","え","かγͺ","γͺγ‚‹","めぐ","めぐみ","γ‚ˆγ—","けか"],"jlpt":2,"unicode":"611b","heisig_en":"love"},{"kanji":"挨","kun_readings":["ひら.く"],"on_readings":["γ‚’γ‚€"],"name_readings":[],"jlpt":null,"unicode":"6328","heisig_en":"s