This file contains hidden or 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 * | |
| from ( | |
| select NULL as FieldStatus | |
| union all | |
| select 1 as FieldStatus | |
| union all | |
| select 20 as FieldStatus | |
| union all | |
| select NULL as FieldStatus |
This file contains hidden or 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 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 |
This file contains hidden or 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 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 | |
This file contains hidden or 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 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 | |
This file contains hidden or 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 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 |
This file contains hidden or 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 | |
| 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 | |
This file contains hidden or 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 * from sys.dm_exec_requests | |
This file contains hidden or 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
| kill 77 --replace the number with your spid | |
This file contains hidden or 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
| /** | |
| * | |
| * @Author Parixit | |
| * @Date 18 July 2016 | |
| * @use handler test | |
| * @handler handlers.company | |
| * UDFLibraryFile "" | |
| */ |
This file contains hidden or 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
| /** | |
| * | |
| * @Author Parixit | |
| * @Date 18 July 2016 | |
| * @use handler test | |
| * @handler handlers.company | |
| * UDFLibraryFile "" | |
| */ |