DELETE FROM VPX_EVENT WHERE EVENT_ID IN
             (SELECT TOP 100000 EVENT_ID FROM VPX_EVENT
              WHERE 
              EVENT_TYPE='vim.event.UserLoginSessionEvent'
              )
GO