180 likes | 213 Views
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].
E N D
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]
SQL server Myths Simon Sabin
Non Clustered index create index IX_HR_Person_surname on HR.Person(surname) select forename, surname, dob from HR.Person order by surname
Challenge 1 • Write the TSQL to get a string of a date in the format “YYYY mon dd” i.e. 2007 April 04
Challenge 2 • Write the TSQL to get a date from a string in the format “YYYY mon dd” i.e. 2007 April 04
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
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
Reference • Blogs • http://sqlblogcasts.com/blogs/simons • http://sqlblogcasts.com/blogs/tonyrogerson • Contact Me • Simon@onarc.com • Feedback – Complete the forms
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!!