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:
Posts (Atom)