Thursday, November 29, 2012
When do you stop for UX in SCRUM?
Posted by
Dan Pupek
at
9:28 AM
I've been struggling with the question of integrating User Experience (UX) into our release cycle. Here is an article that suggests a pretty good solution:
Fitting Big-Picture UX Into Agile Development
Tuesday, November 27, 2012
See what your SQL Queries are costing you
Posted by
Dan Pupek
at
9:02 AM
Here is a neat script that will tell you what the most costly queries are on your SQL Server:
SELECT creation_time
,last_execution_time
,total_physical_reads
,total_logical_reads
,total_logical_writes
, execution_count
, total_worker_time
, total_elapsed_time
, total_elapsed_time / execution_count avg_elapsed_time
,CAST('' AS XML) AS statement_text
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
ORDER BY total_elapsed_time / execution_count DESC;
Subscribe to:
Comments (Atom)