<div>
Why an accepted solution receives 100 points and assisted solution 400 points?<br />
Shouldn't be the opposite?
</div>


Why an accepted solution receives 100 points and assisted solution 400 points?
Shouldn't be the opposite?

<div>
I do appreciate the comment, Vitor. I don't say I good at distributing it right. I will take help of mods.<br />
<br />
thanks to both experts.
</div>


I do appreciate the comment, Vitor. I don't say I good at distributing it right. I will take help of mods.

thanks to both experts.

<div>
thank you again, experts.<br />
thanks to mod also for quick attention!
</div>


thank you again, experts.
thanks to mod also for quick attention!

<div>
That's more logical. Thank you.
</div>


<div>
<div class="content wysiwyg-content">
hi,<br />
below query was bringing results 4 hours ago, but now it is not bringing the same records.. can you infer why/what may cause it to fail?<br />
(I am running from master database).<br />
<br />
SELECT * <br />
FROM <br />
sys.dm_exec_connections AS Blocking <br />
JOIN <br />
sys.dm_exec_requests AS Blocked <br />
ON <br />
Blocking.session_id = Blocked.blocking_session_i<wbr />d <br />
JOIN sys.dm_os_waiting_tasks <br />
AS Waits &nbsp;<br />
ON Blocked.session_id = Waits.session_id <br />
RIGHT OUTER JOIN sys.dm_exec_sessions Sess &nbsp;<br />
ON Blocking.session_id = sess.session_id <br />
CROSS APPLY sys.dm_exec_sql_text(Block<wbr />ing.most_r<wbr />ecent_sql_<wbr />handle) AS BlockingSQL <br />
CROSS APPLY sys.dm_exec_sql_text(Block<wbr />ed.sql_han<wbr />dle) AS BlockedSQL
</div>
</div>


hi,
below query was bringing results 4 hours ago, but now it is not bringing the same records.. can you infer why/what may cause it to fail?
(I am running from master database).

SELECT * 
FROM 
sys.dm_exec_connections AS Blocking 
JOIN 
sys.dm_exec_requests AS Blocked 
ON 
Blocking.session_id = Blocked.blocking_session_id 
JOIN sys.dm_os_waiting_tasks 
AS Waits  
ON Blocked.session_id = Waits.session_id 
RIGHT OUTER JOIN sys.dm_exec_sessions Sess  
ON Blocking.session_id = sess.session_id 
CROSS APPLY sys.dm_exec_sql_text(Blocking.most_recent_sql_handle) AS BlockingSQL 
CROSS APPLY sys.dm_exec_sql_text(Blocked.sql_handle) AS BlockedSQL

seeing historical blocking and blcoked processes thru DMV

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.