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
8
votes
2 answers

Microsoft.SqlServer.ManagedDTS.dll SQL Server 2016 location

I installed SQL Server 2016 Dev with all items and options (included Client SDK). But Microsoft.SqlServer.ManagedDTS.dll is missing. Where can I find the dll to reference this dll in a VB project?
Tom McDonald
  • 1,532
  • 2
  • 18
  • 37
8
votes
3 answers

SQL Server JSON_Modify, How to Update all?

i am trying update all columns with a value with Json_Modify: DECLARE @JSON NVARCHAR(MAX) SET @JSON = N'{ "A":1, "TMP": [ {"A":"VALUE1", "B": "VALUE2", "C": 1}, {"A":"VALUE3", "B": "VALUE4", "C": 2}, {"A":"VALUE5", "B": "VALUE6",…
mdelphi
  • 83
  • 1
  • 1
  • 5
8
votes
2 answers

How to update a specific item of an array in json object

I'm manipulating a JSON column in a SQL Azure table/database, the JSON object is formed like this: { "statusId": "5A5BC717-F33A-42A5-8E48-99531C30EC87", "creationDateTime": "", "assignations": [ { "userId":…
Anon Dev
  • 1,361
  • 3
  • 14
  • 29
8
votes
4 answers

Where does one place the Always Encrypted Certificate on an IIS 7.5 web server?

We have a SQL Server 2016 database that employs Always Encrypted. Our recently published ASP.net web site attempts to pull data from this database, and when it does we get this error: Error: Failed to decrypt column 'EnSSd'. Failed to decrypt a…
RoastBeast
  • 1,059
  • 2
  • 22
  • 38
8
votes
1 answer

SSDT crashes when loading SSIS packages or new project

With the release of SSDT 2016 (GA), I've loaded SQL Server 2016 GA Developer Edition, the new SSMS 2016 stand-alone build, and even Visual Studio 2015 Update 2 (Professional edition) and Visual Studio still crashes anytime I attempt to open an SSIS…
Elsimer
  • 1,878
  • 3
  • 18
  • 33
8
votes
4 answers

How to determine if sql table is Temporal?

With SQL Server 2016 supporting Temporal Tables I wonder if there is a way to determine if a table is currently temporal? Something like select * from sys.objects where object_id('dbo.MyTable', 'u') = parent_object_id and type_desc =…
Mathew Ruberg
  • 427
  • 4
  • 15
8
votes
2 answers

how to detect sql server timeout from .NET application without using catch Exception

In my current application, i am performing an update by invoking T-SQL Update command. The problem is when the same record is locked by other users at that time. At .NET application, the application will wait until SQL Server timeout, then it will…
hadi teo
  • 936
  • 6
  • 11
7
votes
2 answers

SQL Server extract first array element from JSON

I have json stored in one of the columns in SQL Server and I need to modify it to remove the square brackets from it. The format is as below. Can't seem to find a good way of doing it. [ { "Message":"Info: this is some message here.", "Active":true…
huzk
  • 171
  • 1
  • 6
7
votes
3 answers

Can in-memory tables be added to a database diagram

I have a SQL Server 2016 database with in-memory tables. I'd like to use the database diagram feature to create a graphic to match. Running SSMS 18.3.1. When I start a new diagram, the in-memory tables are not shown in the drop down. Is there…
user1443098
  • 6,487
  • 5
  • 38
  • 67
7
votes
1 answer

How to link Report Server Subscription SQL Agent Job name to the name of the report it is running

On my Report Server database all my users' Report Subscriptions are saved as SQL Agent Jobs, as is normal. If I connect to the Report Server DB and list out the SQL Agent jobs I see a huge list of jobs named as random strings of characters,…
Geoff Griswald
  • 937
  • 12
  • 24
7
votes
1 answer

how to Convert Table to Json Arrays?

I'm using Sql Server 2016 and I want to convert a table to json. I have a simple Table : CREATE TABLE [dbo].[TableTmp]( [Color] [nvarchar](50) NULL, [Type] [nvarchar](50) NULL, [Number] [nvarchar](50) NULL ) ON [PRIMARY] GO INSERT…
galgil
  • 217
  • 1
  • 3
  • 10
7
votes
3 answers

JSON text is not properly formatted. Unexpected character 'N' is found at position 0

I am new to JSON in SQL. I am getting the error "JSON text is not properly formatted. Unexpected character 'N' is found at position 0." while executing the below - DECLARE @json1 NVARCHAR(4000) set @json1 =…
user9057272
  • 367
  • 2
  • 5
  • 17
7
votes
3 answers

Max() Over Partition By with date conditions

How do I get the following result in yellow? I want to find the maximum score over the previous year (excluding the current date) and partition by Name1 and Parent1 I've tried the following which is not giving the desired result, it just returns…
user3904868
7
votes
1 answer

T-SQL Combine rows in continuation

I have a table that looks like the following. What I want is the the rows in continuation of each other to be grouped together - for each "ID". The column IsContinued marks if the next row should be combined with the current row My data looks like…
Tiawy
  • 175
  • 5
  • 11
7
votes
1 answer

SQL Merge duplicate records to one row

I have a SQL Server 2016 database with a couple thousand records in. The records are displayed currently like so; And i would like to have this outcome; I will then export the data to Excel. Essentially there are multiple contact details for one…
Lloyd
  • 75
  • 5
1 2 3
…
99 100