Week #13 Meeting June 10-16, 2013

Discussion in 'SQL Server Study Group' started by snh, Jun 10, 2013.

  1. snh

    snh Well-Known Member
    Director

    Joined:
    Oct 6, 2008
    Messages:
    137
    Likes Received:
    0
    Monday, June 10th, 2013

    This is week number 13 of 20 weeks for the SQL Study Group.
    Last week (12) we did not meet due to schedule conflicts, and week prior (11) was problematic because I was not online in time for the meeting.

    We are still looking to meet online at the regular time. Check here for changes.
    We will start the Skype conference call session first (just audio portion), then I will announce the Mikogo session ID and link via Skype Chat.

    Notes from Week 11:

    • How wildcards work in CONTAINS vs LIKE - http://technet.microsoft.com/en-us/library/ms187787.aspx
    • When using a CASE statement to choose between two collations, the collation must be specified tagging a COLLATE statement to the tail of the SELECT clause - http://msdn.microsoft.com/en-us/library/ms179886.aspx
    • Performance tuning and dta command-line parameters - http://technet.microsoft.com/en-us/library/ms187097.aspx
    • Including WHERE clauses in CREATE INDEX statements - http://msdn.microsoft.com/en-us/library/ms188783.aspx
    • RAISERROR Usage - http://msdn.microsoft.com/en-us/library/ms177497.aspx

    ...And some other items that came up in the 10-question practice exam

    For this week, we will attempt another 10 question practice exam in study mode as a group, and review the results together.

    -snh
     

Share This Page