We welcome back Richard Campbell as guest speaker. This time Richard will be speaking on SQL Server querying techniques. Details below. Please register by sending an email to event@vicdotnet.org with the subject heading of "May 5 Event"
When: Date/Time: Thursday May 5, 2005 from 7-9pm
Location: University of Victoria, Cornett Building, Room A120
Take your querying to the next level! This session gets away from the fundamentals of SQL queries and into the hard stuff. See an expert in SQL Server compare and contrast querying techniques between SQL Server 2000 and SQL Server 2005. This session has a series of real world examples to show how creative SQL queries can generate solutions in record time. Some techniques you'll learn include how to do crosstab queries that take seconds to execute instead of hours, exploiting sub-queries and taking advantage of self-joining. Along the way, get some insight into how SQL servers work, as well as how SQL Server 2005 is going to make advanced querying even easier.
Added by jonathan.aquino@gmail.com on May 1, 2005