Freigeben über

We would like your feedback !

  • Artikel

 

Comments

  • Anonymous
    September 29, 2010
    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.

  • Anonymous
    October 11, 2010
    stackoverflow.com/.../how-can-i-query-how-much-time-a-sql-server-database-restore-takes 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.

  • Anonymous
    October 13, 2010
    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.

  • Anonymous
    April 14, 2011
    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. Aditya.

  • Anonymous
    April 14, 2011
    Hello Aditya, 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. Kind regards Harsh Chawla