January 10, 2019 at 4:01 pm
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?
January 15, 2019 at 10:51 am
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/
January 15, 2019 at 10:56 am
VS 2015. But I tried on VS 2017 and still didn't work.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy