none
תזכורת!! יום שני הקרוב הרצאה פתוחה בחינם במייקרוסופט (כיבוד קל הובטח) RRS feed

  • דיון כללי

  • רישום ופרטים נוספים בקישור הבא (מומלץ להירשם אבל לא חובה):

    http://israel.sqlpass.org/Home.aspx?EventID=3017

    Transact-SQL: The Power of INSTEAD OF Triggers (Ronen Ariely)

    A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. For example on insert, update or other DML and DDL query's execution events. We can create DML triggers on tables to execute after or INSTEAD OF events, but a view can be referenced only by INSTEAD OF triggers. An "INSTEAD OF trigger" is executed instead of the original event, and not combining with it. In this session, we will go step by step, and we will create different triggers, discuss different cases, and mention some useful tips and tricks.

    Query Tuning Like a Pro (Michael Zilberstein)

    Your query runs fast, but from time to time it appears to be stuck, and you don't have a clue what causes it. Is it a blocking issue? Or maybe another process throttles server resources? [Query Duration] = [Execution Duration] + [Wait Duration]. This simple formula lies in a basis of a powerful methodology that enables us to find root cause of query slowness. Of course, it can be a sub-optimal execution plan. But what if execution plan is the best one you can imagine and query is still stuck from time to time? Many other reasons can slow it down, but where should we look for those reasons? By the end of this session you will be equipped with a step-by-step algorithm and a set of scripts that are capable of eliminating guesswork from troubleshooting query performance.


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]

    יום שישי 03 יולי 2015 14:32
    מנחה דיון