Statistics on memory optimized tables

• N_Muller

  SSCarpal Tunnel

  Points: 4037

  More actions

  January 10, 2019 at 4:01 pm

  #373472

  I am creating the following statistics on a memory-optimized table:

  CREATE STATISTICS STATS_MyMemOptTable ON MyMemOptTable ( ID ) WITH FULLSCAN, NORECOMPUTE

  
  When I run this in SSMS it works just fine. However, when I try adding it to Visual Studio it gives me error "SQL71569: Invalid syntax for a memory optimized object."

  I need to create this stats in VS so it can be maintained through TFS.  What am I doing wrong?

• Mike01

  SSChampion

  Points: 11413

  More actions

  January 15, 2019 at 10:51 am

  #2018964

  just a stupid guess, but what sql version do you have the VSTS Project set to?

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• N_Muller

  SSCarpal Tunnel

  Points: 4037

  More actions

  January 15, 2019 at 10:56 am

  #2018966

  VS 2015.  But I tried on VS 2017 and still didn't work.