It'll be good if we have a series of blog posts on how to write SQL queries effectively.
For example,not in can be replaced with left join for some scenarios to improve performance.
The above link shows one attempt to identify a metric that should be useful to DBAs ie the throughput for the restore command. I'm wondering if there is another way to get the restore_end time (as mentioned in the link the restorehistory restore_date is the restore start time). Only alternative I can think of is to read the end time from the sql server error log.
First of all congrats for sharing troubleshooting tips on issues with SQL Server and you guys are doing an amazing job to make DBA life easy. It will be useful if you guys can throw some tips on query tuning with Examples.
Kudos to you for having this blog...
The topic that is baffling :) my mind is extended events i read white papers from jonathan and i followed uhis extended event a day. But i still remained confused to use this cool feature. You guys really enlighten the normal DBA on many topics and if u can handle this topic so that a normal DBA can handle them eith ease.
Thanks in anticipation.
Please check the video on extended events: -blogs.msdn.com/.../sql-server-2008-extended-events.aspx
Please feel free to let us know if you have any questions.