Stack Overflow
Stack Overflow

Questions tagged [sql-server-2016]

Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.

Microsoft SQL Server 2016 v.13.0.1601.5 Ready To Manufacture (RTM), was released on June 1, 2016.

There are many editions of SQL Server 2016:

1- Entreprise Edition : Comprehensive, mission-critical in-memory performance with unparalleled security, mission critical high availability, an end-to-end enterprise business intelligence solution with mobile BI built in, in-database advanced analytics at scale, and unlimited virtualization with software assurance. Enterprise edition provides the highest scale and performance for Tier-1 workloads.

2- Standard: Find rich programming capabilities, security innovations, and fast performance for applications and data marts. Easily upgra

3- Developer: Build, test, and demonstrate applications in a non-production environment with this free, full-featured set of SQL Server 2016 SP1 Enterprise edition software.

4- Express: Deploy small databases in production environments with this free, entry-level database that’s ideal for building small, data-driven applications up to 10 GB of disk size.

5- Compact: Free, embedded database app for building ASP.NET websites and Windows desktop applications.

6- Web: Secured, cost effective, and highly scalable data platform for public web sites—available to third-party hosting service providers only.

References

3794 questions
5
votes
1 answer

SQL Server 2016 FOR JSON PATH returns string instead of array when using case statement

I'm trying to build a JSON object that contains an array, using SQL Server 2016. The source data for the array is itself JSON, so I'm using the JSON_QUERY inside a select statement, with the FOR JSON clause applied to the select…
Roland Andrag
  • 437
  • 4
  • 9
5
votes
1 answer

Connect to SQL Server Developer edition

I recently installed Microsoft SQL Server Express for a project of mine, and I was able to connect to the instance with SQL Server Management Studio and everything worked fine. Then I realized that I needed the Developer edition for importing data…
fisherman45
  • 59
  • 1
  • 3
5
votes
2 answers

Visual studio 2015 update 3 and sql server 2016 "the visual studio CRC package did not load correctly"

I just downloaded Visual studio 2015 update 3. When I open up sql server I get this error message followed by a shutdown of sql server. Visual studio 2015 update 3 and sql server 2016 The activitylog.xml ` …
Train
  • 3,420
  • 2
  • 29
  • 59
5
votes
1 answer

SSDT doesn't recognize STRING_SPLIT function in SQL Server 2016

Try to use SQL Server 2016 STRING_SPLIT function in a stored procedure. It parses correct in SSMS. But in SSDT (latest version), the function can't be resolved, so the project cannot be compiled. Anybody know how to solve this? Thanks.
user3616544
  • 1,023
  • 1
  • 9
  • 31
5
votes
1 answer

Safe solutions for INSERT OR UPDATE on SQL Server 2016

Assume a table structure of MyTable(MyTableId NVARCHAR(MAX) PRIMARY KEY, NumberOfInserts INTEGER). I often need to either update i.e. increment a counter of an existing record, or insert a new record if it doesn't exist with a value of 0 for…
WonderWorker
  • 8,539
  • 4
  • 63
  • 74
5
votes
3 answers

SQL Server 2016 _can't start mirror

After upgrading SQL Server 2014 to SQL Server 2016 (both Enterprise editions), I can't start mirror. This works normally on SQL Server 2014. After I restore (WITH NORECOVERY) mirror database with full and log backups of primary database I normally…
Cubone
  • 61
  • 1
  • 1
  • 4
5
votes
1 answer

What's causing "The specified LocalDB version is not available on this computer" error on SQL LocalDB?

I have just done a clean installation of VS2015 Update 2 on a new workstation and have set about running some of our integration tests that used SQL LocalDb. They are failing with the following SqlException: Additional information: Local Database…
Jack Ukleja
  • 13,061
  • 11
  • 72
  • 113
5
votes
4 answers

Error of SQL Server 2016 sp_execute_external_script with R integration

I am evaluating SQL Server 2016 in-database integration with R on Windows 10. I have followed the steps installed all components and scripts. Now I have following questions: Where does sp_execute_external_script reside? I can’t find it. When I run…
Frank
  • 156
  • 2
  • 6
5
votes
2 answers

R In SQL Server

I've recently downloaded the CTP for SQL Server 2016 in order to get a grasp with the integration of the R language with SQL Server. I haven't been able to find any resources/documentation on the topic as of yet. Has anyone else had any joy with…
Dataoverride
  • 103
  • 5
4
votes
3 answers

Use LAG with a specific condition on what LAG value to take?

Suppose I have a table as follows: Row Volume 1 10000 2 8000 3 0.01 4 0 5 5000 6 0 Now, if I were to use the LAG() function in SQL Server, I believe the following table will result: Row Volume …
Ethan Mark
  • 293
  • 1
  • 9
4
votes
0 answers

When using For Auto SQL to select large amounts of data in C#, the JSON data is split into multiple strings and won't parse

I am trying to retrieve some SQL data from anonymous type. Different queries may be passed into the SqlQuery option so I am trying to retrieve the data as JSON and then parse that JSON later on. The problem I run into is the data is automatically…
nightwolf555
  • 327
  • 1
  • 14
4
votes
1 answer

SQL - Json query

I have tables similar to below where it has one to many mapping DECLARE @T1 TABLE(RootId int, [Name] varchar(50)) DECLARE @T2 TABLE(Id int,RootId int, Category varchar(50)) INSERT INTO @T1 VALUES(1,'Some Name 12121'),(2,'Some Name 343434') INSERT…
user12073359
  • 289
  • 1
  • 11
4
votes
4 answers

Unable to upgrade/import a dacpac file

ORIGINAL QUESTION: Trying to upgrade a blank database created in a test VM using a .dacpac file, but get the following error message: Error SQL72014: .Net SqlClient Data Provider: Msg 15401, Level 16, State 1, Line 1 Windows NT user or group…
oshirowanen
  • 15,297
  • 82
  • 198
  • 350
4
votes
1 answer

Issue with memory optimized tables transaction commit dependencies

I'm working with SQL Server 2016, and working on large group of sprocs that are all called by one parent sproc. All the sprocs do nothing but reads to return one result set. I've confirmed all necessary objects are in cache and no physical reads are…
mituw16
  • 5,126
  • 3
  • 23
  • 48
4
votes
1 answer

Wrong object_name and definition relationship in sys.sql_modules and sys.objects

I ran the following query SELECT sm.object_id, v1.object_name, o.type, o.type_desc, sm.definition FROM sys.sql_modules sm CROSS APPLY (VALUES (OBJECT_NAME(sm.object_id))) v1 (object_name) JOIN sys.objects o ON…
Aleix
  • 431
  • 4
  • 20
1 2 3
…
99 100