1 / 17

Platinum

Platinum. Learn & Enjoy [Put your phone on Vibrate!]. www.sqlbits.com. Group BY: [Food and Drink at Reading Bowl, see you there!]. Gold. Feedback Forms: [Voucher for £30 book on return of Form]. Silver. Lunch Time Sessions: [Idera in Everest, Quest in Memphis, Grok in Chic 1 and 2].

lyneth
Download Presentation

Platinum

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Platinum Learn & Enjoy [Put your phone on Vibrate!] www.sqlbits.com Group BY: [Food and Drink at Reading Bowl, see you there!] Gold Feedback Forms: [Voucher for £30 book on return of Form] Silver Lunch Time Sessions: [Idera in Everest, Quest in Memphis, Grok in Chic 1 and 2] Ask The Experts[Sessions need to finish on time, take questions to the ATE area]

  2. SQL server Myths Simon Sabin

  3. Clustered Index

  4. Non Clustered index create index IX_HR_Person_surname on HR.Person(surname) select forename, surname, dob from HR.Person order by surname

  5. Challenge 1 • Write the TSQL to get a string of a date in the format “YYYY mon dd” i.e. 2007 April 04

  6. Challenge 2 • Write the TSQL to get a date from a string in the format “YYYY mon dd” i.e. 2007 April 04

  7. Challenge 3 • Write the TSQL to get a number padded to with zeros on both side of the decimal point “00.00” i.e. 1.1 becomes 01.10 and 0 into 00.00

  8. SQLCLR Tips

  9. Take Away • Just because it was true before doesn’t mean its true now, even in football • Try to understand why? • CLR is a good thing, become its friend

  10. Reference • Blogs • http://sqlblogcasts.com/blogs/simons • http://sqlblogcasts.com/blogs/tonyrogerson • Contact Me • Simon@onarc.com • Feedback – Complete the forms

  11. Platinum www.SQLBits.com[Conference Web site] www.sqlbits.com www.SQLBlogCasts.com[Becoming the premier Blogging site for SQL professionals] Gold www.SQLServerFAQ.com[UK SQL Server Community Website] Silver UK SQL Bloggers cwebbbi.spaces.live.comsqlblogcasts.com/blogs/simonssqlblogcasts.com/blogs/tonyrogerson Contact Me Simon@onarc.com Feedback Forms!!

More Related