Nathan Robinson nate-robo
nate-robo
/ vim_commands
Created
December 4, 2018 16:23
Debug VIM performance - see what processes + execution speed during vim actions
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
| :profile start profile.log | |
| :profile func * | |
| :profile file * | |
| " At this point do slow actions | |
| :profile pause | |
| :noautocmd qall! | |
| " Open profile.log and inspect results |
nate-robo
/ rej_trans.sql
Created
July 10, 2017 21:49
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
| WITH trans AS ( | |
| --trans AS ( | |
| SELECT | |
| WI_Hist_SQN | |
| , WI_ID | |
| , Revision_No | |
| , Old_Status_Num as Prior_Status_Key | |
| , LAG(Create_TS, 1) OVER (PARTITION BY WI_ID ORDER BY Create_TS ASC) AS PreviousTime | |
| , New_Status_Num AS Status_Key |