SQL Server Performance

ADVANCED T-SQL PROGRAMMING IN SQL 2000&2005

Discussion in 'SQL Server 2005 General DBA Questions' started by satya, Jun 28, 2004.

  1. satya Moderator

    For UK:
    Itzik Ben Gan, SQL Server MVP
    Tue, July 6th 2004,
    Reading
    £199 (ex VAT), discounts are available

    More information and full agenda:http://www.sqlserverfaq.com?eid=43

    The Advanced T-SQL Seminar covers advanced querying techniques and T-SQL enhancements in SQL Server 2000 and SQL Server 2005. You will be introduced with many different techniques to solve common problems that you face daily as a T-SQL programmer.

    The following is a detailed list of the topics that will be covered in this seminar:

    Querying Multiple Tables
    Joins
    Types of Joins
    Self Joins
    Non-equi Joins
    Multi-Table Joins
    Semi Joins
    Subqueries
    Plain
    Correlated
    Misbehaving Subqueries
    Derived Tables
    Missing Values
    Analytical Ranking Functions
    Purpose and Examples
    Determinism
    Partitioning
    Yukon and Pre-Yukon Set-Based Solutions
    Performance Comparisons
    CTEs and Recursive Queries
    Non-Recursive CTEs
    Purpose and Uses
    Syntax
    Recursive CTEs
    Purpose and Uses of Recursive CTEs
    Elements of a Recursive CTE
    Usage Scenarios
    Single-Parent Hierarchies (Trees)
    Multi-Parent Hierarchies (Graphs)
    Advanced Issues with Recursive CTEs
    Cycles
    Sorting
    Aggregating Data
    Running Aggregations
    Cumulative
    Sliding
    Custom Aggregations
    Histograms
    Identifying Groups
    PIVOT/UNPIVOT
    PIVOT/UNPIVOT Described
    Pivoting Attributes – Open Schema
    Groups with Collective Member Criteria (Relational Division)
    String Concatenation
    Aggregating Data
    UNPIVOT
    Other DML Enhancements
    TOP Enhancements
    Comparing TOP Support in SQL Server 2005 and in Earlier Versions
    TOP Syntax
    Using an Expression as an Argument for TOP
    Using the TOP option with Modifications
    CROSS/OUTER APPLY
    CROSS APPLY
    OUTER APPLY
    Table UDFs in Subqueries
    DML with Results
    Purpose and Syntax of New OUTPUT Clause
    DELETE Example
    UPDATE Example


    SQL SERVER 2005 (YUKON) DBA ENHANCEMENTS

    Itzik Ben Gan, SQL Server MVP
    Wed, July 7th 2004,
    Reading
    £199 (ex VAT), discounts are available

    More information and full agenda:http://www.sqlserverfaq.com?eid=44

    SQL Server 2005 introduces an arsenal of new features and enhancements for the DBA in charge of database implementation. This seminar will cover some of the important DBA related enhancements. The focus will be both on database implementation enhancements related to schema and development, and also enhancements related to database maintenance, performance and high availability.


    The following is a detailed list of the topics that will be covered in this seminar:

    Database Implementation (Schema, Development)
    Partitioning
    Partitioning in SQL Server 2000
    Motivation
    Implementation
    Limitations
    Partitioning in SQL Server 2005
    Motivation
    Advantages
    Steps in Implementing Partitioning Tables/Indexes
    Index Alignment
    Adding/Removing Partitions
    Querying
    Collocated Joins
    Datatypes and Data Integrity
    MAX Option for Variable Length Data Types
    XML Data Type
    BULK Rowset Provider
    Referential Integrity Enhancements
    Trigger Enhancements
    DDL Triggers
    DDL and System Event Notifications
    Snapshot Isolation
    Exception Handling
    Exception Handling prior to SQL Server 2005
    Exception Handling in SQL Server 2005
    TRY/CATCH
    New Functions
    Trapping Errors in Transactions
    Database Maintenance, Performance and HA
    Database Mirroring
    Database Mirroring – Described
    Roles
    Synchronous Database Mirroring
    Asynchronous Database Mirroring
    Auto Failover
    Implementing Database Mirroring
    Monitoring
    Database Snapshots
    Database Snapshots, Described
    Uses of Database Snapshots
    Creating a Snapshot
    Reverting Database to a Snapshot
    Files and Filegroups Enhancements
    Instant File Initialization
    Offline Files/Filegroups
    Moving Files
    ATTACH_REBUILD_LOG
    Moving data from a clustered index to a filegroup or partition scheme (DROP INDEX)
    Backup & Restore
    Online Restores
    Early Restore Access
    Single Page Restore
    Backup and Restore Media Checks
    Backup and Restore Error Reporting
    Mirrored Backup Media
    Index Enhancements
    Online Index Operations
    INCLUDE Non-Key Columns
    Other Index Enhancements
    Tools
    SQL Computer Manager
    SQL Server Management Studio
    DTS Wizards and UI Enhancements
    Profiler Enhancements
    Database Tuning Advisor (DTA)
    SQLCMD
    Dedicated Administrative Connection



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  2. SQL_Guess New Member

    *sighs* ... and we'll never see this in Africa... I doubt that I'll get the beancounters to stretch to sending me to the UK for 2 days worth of courses ...

    *sniff sniff*

    Enjoy, those who are lucky enough to attend

    Panic, Chaos, Disorder ... my work here is done --unknown
  3. satya Moderator

    Unfortunately I'm unable to attend this seminar due to project deadlines and I do feel few times that the geographical region of US gets more lead as you can see many of them will be in US only.

    Other than this I always depend upon the web resources or lately depend upon the transcript.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. SQL_Guess New Member

    Here's hoping a transcript might find it's way here, then <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Panic, Chaos, Disorder ... my work here is done --unknown

Share This Page