Skip to content

Instantly share code, notes, and snippets.

View nate-robo's full-sized avatar

Nathan Robinson nate-robo

  • NYC
View GitHub Profile
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
@nate-robo
nate-robo / vim_commands
Created December 4, 2018 16:23
Debug VIM performance - see what processes + execution speed during vim actions
:profile start profile.log
:profile func *
:profile file *
" At this point do slow actions
:profile pause
:noautocmd qall!
" Open profile.log and inspect results