Stuff of za day: 07/01/2009

2009-07-29

Listing the most costly queries in SQL Server

SELECT TOP 20 SUBSTRING(qt.text, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1) AS [Query],
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.min_logical_reads, qs.max_logical_reads,
qs.total_elapsed_time, qs.last_elapsed_time,
qs.min_elapsed_time, qs.max_elapsed_time,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
WHERE qt.encrypted=0
ORDER BY qs.total_logical_reads DESC

2009-07-27

Ride The Sky - New Protection

Posted by Vencel Biro at 15:51

Power metal of the day

2009-07-23

Dio, Judas Priest, Wasp, Iron Maiden, Quiet Riot... - Stars

Posted by Vencel Biro at 12:50

My mind is blown. Listen to those solos... Wow

2009-07-15

Updated my homepage: sitemap page, rounded corners

Posted by Vencel Biro at 13:06

I added a new page to my homepage: SiteMap. I know my website does not really have much content but I found an awesome looking sitemap template and I had to play around with it.

Besides the additional page I applied some corner rounding and shadow to the main page and the footer.

Unfortunately the awesomeness can only be witnessed if you are using Firefox 3.5 or Safari.

If you don't like it let me know! We can work something out.