Getting Ready for R

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736063

  More actions

  September 22, 2016 at 11:26 pm

  #77438

  Comments posted to this topic are about the item Getting Ready for R

• September 22, 2016 at 11:26 pm

  This was removed by the editor as SPAM

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  September 23, 2016 at 6:13 am

  #1902759

  Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? The more versions of SQL Server running in a single environment, the better. :hehe:

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  September 23, 2016 at 7:10 am

  #1902771

  Ed Wagner (9/23/2016)

  ---

  Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? The more versions of SQL Server running in a single environment, the better. :hehe:

  LOL that sounds like my place. We have production instances with 2005, 2008, 2012 and 2014. We did finally remove the last 2000 instance a couple of years ago. :w00t:

  _______________________________________________________________

  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/

• Eric M Russell

  SSC Guru

  Points: 125560

  More actions

  September 23, 2016 at 7:41 am

  #1902776

  I think most DBAs would be more excited about RegEx integration than R. :doze:

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

• September 23, 2016 at 7:52 am

  This was removed by the editor as SPAM

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  September 23, 2016 at 9:00 am

  #1902810

  Stewart "Arturius" Campbell (9/23/2016)

  ---

  Sean Lange (9/23/2016)

  ---

  Ed Wagner (9/23/2016)

  ---

  Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? The more versions of SQL Server running in a single environment, the better. :hehe:

  LOL that sounds like my place. We have production instances with 2005, 2008, 2012 and 2014. We did finally remove the last 2000 instance a couple of years ago. :w00t:

  Sounds a lot like my previous contract.

  Their head office has only recently approved the upgrade of their databases from SQL2005 to SQL2008....:hehe:

  If they don't mind paying extra for extended support...

  Thanks for the question, Steve!

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  September 23, 2016 at 9:44 am

  #1902833

  Revenant (9/23/2016)

  ---

  Stewart "Arturius" Campbell (9/23/2016)

  ---

  Sean Lange (9/23/2016)

  ---

  Ed Wagner (9/23/2016)

  ---

  Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? The more versions of SQL Server running in a single environment, the better. :hehe:

  LOL that sounds like my place. We have production instances with 2005, 2008, 2012 and 2014. We did finally remove the last 2000 instance a couple of years ago. :w00t:

  Sounds a lot like my previous contract.

  Their head office has only recently approved the upgrade of their databases from SQL2005 to SQL2008....:hehe:

  If they don't mind paying extra for extended support...

  Thanks for the question, Steve!

  SQL Server 2005 is no longer supported - I believe it was April 2016.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  September 23, 2016 at 9:58 am

  #1902844

  Ed Wagner (9/23/2016)

  ---

  Revenant (9/23/2016)

  ---

  Stewart "Arturius" Campbell (9/23/2016)

  ---

  Sean Lange (9/23/2016)

  ---

  Ed Wagner (9/23/2016)

  ---

  Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? The more versions of SQL Server running in a single environment, the better. :hehe:

  LOL that sounds like my place. We have production instances with 2005, 2008, 2012 and 2014. We did finally remove the last 2000 instance a couple of years ago. :w00t:

  Sounds a lot like my previous contract.

  Their head office has only recently approved the upgrade of their databases from SQL2005 to SQL2008....:hehe:

  If they don't mind paying extra for extended support...

  Thanks for the question, Steve!

  SQL Server 2005 is no longer supported - I believe it was April 2016.

  I was responding to 'from SQL2005 to SQL2008' - the latter one is on extended support. So I wander why would anyone go that route. Maybe they got some special deal.

• Eric M Russell

  SSC Guru

  Points: 125560

  More actions

  September 23, 2016 at 10:35 am

  #1902856

  Revenant (9/23/2016)

  ---

  ...

  I was responding to 'from SQL2005 to SQL2008' - the latter one is on extended support. So I wander why would anyone go that route. Maybe they got some special deal.

  Executive management probably blew the dust off of a five year old server specification and purchase request.

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  September 23, 2016 at 11:32 am

  #1902877

  Revenant (9/23/2016)

  ---

  Ed Wagner (9/23/2016)

  ---

  Revenant (9/23/2016)

  ---

  Stewart "Arturius" Campbell (9/23/2016)

  ---

  Sean Lange (9/23/2016)

  ---

  Ed Wagner (9/23/2016)

  ---

  Thanks for a good question. There's actually grumblings of getting SQL 2016 here, even though we still have a SQL 2005 instance. Why not, right? The more versions of SQL Server running in a single environment, the better. :hehe:

  LOL that sounds like my place. We have production instances with 2005, 2008, 2012 and 2014. We did finally remove the last 2000 instance a couple of years ago. :w00t:

  Sounds a lot like my previous contract.

  Their head office has only recently approved the upgrade of their databases from SQL2005 to SQL2008....:hehe:

  If they don't mind paying extra for extended support...

  Thanks for the question, Steve!

  SQL Server 2005 is no longer supported - I believe it was April 2016.

  I was responding to 'from SQL2005 to SQL2008' - the latter one is on extended support. So I wander why would anyone go that route. Maybe they got some special deal.

  Touche. I don't get it either.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  September 28, 2016 at 1:52 am

  #1903560

  Easy one, thanks.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  September 28, 2016 at 1:53 am

  #1903561

  Eric M Russell (9/23/2016)

  ---

  I think most DBAs would be more excited about RegEx integration than R. :doze:

  Why? You already have CLR 😛

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP