SQL Spark

  if Select SQL take lots of time, try below options Inner HASH JOIN Query hint - Option (recompile) – running more than 20 minutes, cancelled query Cross Apply/Outer Apply (Optimize the query to use cross apply/outer apply instead of subquery)  – completed in 4 min Use Temp table with index Create update statement to replace sub query Query hint - FORCE_LEGACY_CARDINALITY_ESTIMATION Use this hint in select statement option (use hint('FORCE_LEGACY_CARDINALITY_ESTIMATION'))  SELECT * FROM Schema.Table WHERE Condition = 'Value' OPTION (USE HINT ('FORCE_DEFAULT_CARDINALITY_ESTIMATION'));

select max(local_tcp_port) from sys.dm_exec_connections where net_transport ='TCP' USE master GO xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc'  GO

SELECT er.session_id, er.status, er.command, db_name(er.database_id) [Database], st.text  FROM sys.dm_exec_requests er  CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) st  WHERE er.session_id > 50 and session_id <> @@SPID    SELECT        r.cpu_time CPUTIME_Miliseconds,        r.cpu_time * 0.001 CPUTIME_Seconds,        r.total_elapsed_time * 0.001 TotalElapsedTime_Seconds,        r.session_id        ,st.TEXT AS batch_text        ,SUBSTRING(st.TEXT, statement_start_offset / 2 + 1, (                      (                            CASE                                    WHEN r.statement_end_offset = - 1       ...