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;