Skip to content

Instantly share code, notes, and snippets.

View isummation's full-sized avatar

iSummation INC isummation

View GitHub Profile
@isummation
isummation / sql2.sql
Last active September 29, 2016 09:30
select *
from (
select NULL as FieldStatus
union all
select 1 as FieldStatus
union all
select 20 as FieldStatus
union all
select NULL as FieldStatus
$ git pull
remote: Counting objects: 85, done.
remote: Compressing objects: 100% (37/37), done.
remote: Total 85 (delta 63), reused 69 (delta 48)
Unpacking objects: 100% (85/85), done.
error: inflate: data stream error (unknown compression method)
fatal: failed to read object 8b0fd4094630fea108b60faa15535ffbc85d87cb: Invalid argument
> $ git status On branch vikas Your branch is based on 'origin/master',
> but the upstream is gone. (use "git branch --unset-upstream" to
> fixup) nothing to commit, working directory clean
$ git fsck --full
error: inflate: data stream error (unknown compression method)
error: unable to unpack 38fe6f16c7e8246d61150f0bc42629dbb532b5ce header
error: inflate: data stream error (unknown compression method)
fatal: loose object 38fe6f16c7e8246d61150f0bc42629dbb532b5ce (stored in .git/objects/38/fe6f16c7e8246d61150f0bc42629dbb532b5ce) is corrupt
$ git fsck --full
Checking object directories: 100% (256/256), done.
Checking objects: 100% (168543/168543), done.
error: refs/remotes/origin/staging: invalid sha1 pointer 0000000000000000000000000000000000000000
error: refs/remotes/origin/development: invalid sha1 pointer 0000000000000000000000000000000000000000
error: refs/remotes/origin/master: invalid sha1 pointer 0000000000000000000000000000000000000000
error: bad ref for refs/remotes/origin/staging
@isummation
isummation / lock.sql
Last active September 29, 2016 09:26
SELECT
OBJECT_NAME(p.OBJECT_ID) AS TableName,
dtl.resource_type,
dtl.resource_description
FROM sys.dm_tran_locks dtl
JOIN sys.partitions p ON dtl.resource_associated_entity_id = p.hobt_id
@isummation
isummation / view.sql
Last active September 29, 2016 09:26
select * from sys.dm_exec_requests
@isummation
isummation / kill.sql
Last active September 29, 2016 09:26
kill 77 --replace the number with your spid
/**
*
* @Author Parixit
* @Date 18 July 2016
* @use handler test
* @handler handlers.company
* UDFLibraryFile ""
*/
/**
*
* @Author Parixit
* @Date 18 July 2016
* @use handler test
* @handler handlers.company
* UDFLibraryFile ""
*/