Month May 2016

Convert float string to int c#

Converting a string to a integer seems to be trivial. But there could be endless of formats and styles on the string so it’s not always that easy that it’s seems. If you have a string like “629.00” and want…

View current sql queries on MSSQL database

To view current sql queries running on sql database you can use this sql script to get current query and elapsed time. SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext I have only…