Skip to content

Instantly share code, notes, and snippets.

View yurifedoseev's full-sized avatar

Yuri Fedoseev yurifedoseev

8 followers · 1 following
View GitHub Profile
@yurifedoseev
yurifedoseev / part2.go
Created December 6, 2023 06:04
func runPart() error {
start := time.Now()
filename := "day6//input.txt"
races, err := loadRace(filename)
if err != nil {
return err
}
waysComb := int64(1)
for _, race := range races {
waysComb *= calculus(race)
@yurifedoseev
yurifedoseev / gist:1f36ef13d9173d890fc8fe1287f45264
Created November 15, 2017 09:16
add ssh agent
# Create ~/.ssh/config с указанием хоста:
Host my_host.ru
ForwardAgent yes
ssh-add -K ~/.ssh/id_rsa
@yurifedoseev
yurifedoseev / map.scala
Created August 4, 2015 15:13
/**
* Created by Yuri on 04.08.2015.
*/
object Utils {
def mapClassToSeq(mes: AnyRef) = {
mes.getClass.getDeclaredFields.map(f => {
f.setAccessible(true)
camelToUnderscores(f.getName) -> f.get(mes)
}).toSeq
@yurifedoseev
yurifedoseev / Usage.sql
Last active August 29, 2015 14:25
Usage in sql
-- find object usage in stored procedures and functions
select * from INFORMATION_SCHEMA.ROUTINES e
where OBJECT_DEFINITION(OBJECT_ID(e.SPECIFIC_SCHEMA + '.' + e.SPECIFIC_NAME)) LIKE '%ObjectName%';
@yurifedoseev
yurifedoseev / git-delete
Created December 30, 2014 15:14
git удлаение стейдж файлов
git rm $(git ls-files --deleted)
@yurifedoseev
yurifedoseev / sites.cleanup
Last active November 20, 2018 09:20
Delete all sites from IIS express configuration
appcmd.exe list site /xml | appcmd delete site /in
@yurifedoseev
yurifedoseev / dotNetFrameworks
Created February 10, 2014 14:59
Write all installed .net frameworks. desc.
dir /b /ad /o-n %systemroot%\Microsoft.NET\Framework\v?.*
@yurifedoseev
yurifedoseev / rebuild_indexes.sql
Created December 6, 2013 07:01
rebuild all indexes
sp_MSforeachtable 'alter index all on ? reorganize'
go
@yurifedoseev
yurifedoseev / most100executed.sql
Last active February 22, 2017 06:42
100 most executed queriest
--Get Top 100 executed SP's ordered by execution count
SELECT TOP 100 qt.text AS 'SP Name', qs.execution_count AS 'Execution Count',
qs.execution_count/DATEDIFF(Second, qs.creation_time, GetDate()) AS 'Calls/Second',
qs.total_worker_time/qs.execution_count AS 'AvgWorkerTime',
qs.total_worker_time AS 'TotalWorkerTime',
qs.total_elapsed_time/qs.execution_count AS 'AvgElapsedTime',
qs.max_logical_reads, qs.max_logical_writes, qs.total_physical_reads,
DATEDIFF(Minute, qs.creation_time, GetDate()) AS 'Age in Cache'
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
@yurifedoseev
yurifedoseev / sql worst queries.sql
Last active February 22, 2017 06:42
Long long executed script
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan'),
core AS (
SELECT
eqp.query_plan AS [QueryPlan],
ecp.plan_handle [PlanHandle],
q.[Text] AS [Statement],
n.value('(@StatementOptmLevel)[1]', 'VARCHAR(25)') AS OptimizationLevel ,
ISNULL(CAST(n.value('(@StatementSubTreeCost)[1]', 'VARCHAR(128)') as float),0) AS SubTreeCost ,