Game Day Planning

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737403

  More actions

  November 22, 2017 at 10:23 pm

  #75777

  Comments posted to this topic are about the item Game Day Planning

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72691

  More actions

  November 22, 2017 at 10:24 pm

  #1969314

  Interesting question, thanks Steve
  Learned something new

  ____________________________________________
  Space, the final frontier? not any more...
  All limits henceforth are self-imposed.
  “libera tute vulgaris ex”

• HappyGeek

  SSCoach

  Points: 18729

  More actions

  November 22, 2017 at 11:53 pm

  #1969316

  Cheers Steve another R lesson, thank you; less of a guess on this one!

  ...

• SQL Surfer '66

  SSCertifiable

  Points: 5161

  More actions

  November 23, 2017 at 12:50 am

  #1969319

  Very useful. Now I don't have to keep track of the time offset.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737403

  More actions

  November 24, 2017 at 10:51 am

  #1969414

  Just beware of performance with AT TIME ZONE. You want to treat this more like a function and be careful of where it's used.

• SQL Surfer '66

  SSCertifiable

  Points: 5161

  More actions

  November 27, 2017 at 3:59 am

  #1969484

  Steve Jones - SSC Editor - Friday, November 24, 2017 10:51 AM

  Just beware of performance with AT TIME ZONE. You want to treat this more like a function and be careful of where it's used.

  Thanks. Brent Ozar also refers to SQLSoldier's blog about this in his weekly newsletter.

• Sean Lange

  SSC Guru

  Points: 286601

  More actions

  November 27, 2017 at 7:21 am

  #1969522

  Central America Standard Time got me confused on this one. I didn't realize there are two names for the same time zone. Central America Standard Time Zone and Central Time Zone.

  Great question about a feature I have not (and still can't at work) utilize.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/