I found a stored procedure already in my database (via legacy), and modified it to display remaining seconds and lapsed seconds.
SELECT percent_complete, start_time, status, command, estimated_completion_time/1000/60 As 'Minutes to Completion', total_elapsed_time/1000/60 As 'Minutes Elapsed', wait_type, last_wait_type
order by 'Minutes to Completion' desc
This is useful when you must
perform a shrink or another time consuming task. It does not give much help besides "
" and "
" for ad hoc queries though.
Software Developer (Senior)
What I get paid or have been paid to do:
Trading software and protocols (QuickFIX, Onix, etc).
Price feed development.
Trader simulation tools.
Back office, end of day reporting, NFA compliance.
Performance testing, optimization, and analysis.
Large scale data management, analysis, and visualization.
Worked with most major banks, some electronic exchanges, many data providors, and a few counter-parties:
MISO, PJM, NYISO, NEISO, CAISO, AESO, ERCOT, BOE, CME, CBOE, Eurex, ICE, Morgan Stanley, J.P. Morgan, RBS, EBS, Credit Suisse, Nomura, Barclays, Deutsche Bank, Citibank, UBS, Goldman Sachs, Bear Stearns (defunct), Triaina, Bloomberg
Experience in FX, energies, futures.