Thursday, November 29, 2012
When do you stop for UX in SCRUM?
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
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;