Find Currently Running Query on SQL Server Below script will find out the queries running currently on your SQL server. 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

useEffect does not render properly with if statement

Taylor

In my useEffect statement if I put my sort inside of a conditional statement is does not work until useEffect is rendered again. When I move my sort outside of the if statement it renders the first time. Why is this and how do I fix this?

 useEffect(() => {
    if (sortBy.value === "PRICE_LOW") {
      console.log("in Here");
    }
      flights.sort((a, b) => b.price - a.price);
   }, [flights, sortBy]);
}