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
4
votes
1 answer

Returning a json object in select - causes slow down

In the stored procedure, I'm using CTE table to return a data set as JSON. As the amount of data increased, I have noticed that one particular part of the stored procedure is causing the slowdown after running the execution plan. There're 4 tables…
smr5
  • 2,593
  • 6
  • 39
  • 66
4
votes
2 answers

TSQL: Parsing strings with various characters

I have a table with a file name column where various vendors named files differently. So there is a filename with a last, first, middle name in the file with various characters separating the name. Some have a comma + space, comma with no space,…
JM1
  • 1,595
  • 5
  • 19
  • 41
4
votes
2 answers

SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine with Visual Studio. When I deploy to the SSIS Catalog, I receive the below error: Execute SQL Task: Error: Failed to acquire connection.…
Michael
  • 2,507
  • 8
  • 35
  • 71
4
votes
4 answers

SSIS Script Component not working when deployed. Complains about ComponentVersionMismatchError

A package with a Script Component that runs fine on SSDT (Visual Studio 2017) does not run when deployed to SQL Server 2016. It throws a ComponentVersionMismatchException. So, other packages work fine. This one has a data flow with a Script…
user2712166
  • 81
  • 1
  • 5
4
votes
2 answers

Query optimization from from query execution plan

I have not found any suitable way to show query plan other than image, so i added image. in image i got the execution plan and i want to reduce fullouter join cost , if any one suggest me the way of reducing cost it would be great for better query…
Zaynul Abadin Tuhin
  • 31,407
  • 5
  • 33
  • 63
4
votes
3 answers

SSIS - package works in VS, fails with "Failed to compiled scripts contained in the package". There are no script objects in the package

VS2017, Deploy to SS2016. Package runs without any errors from VS. Project deployment to a server that previously had package deployments only - we're moving to project deployment, and DBAs said to use that. Getting many errors like: Get Error…
RBerman
  • 374
  • 4
  • 9
4
votes
1 answer

Using cross apply to query nested arrays in json

I have what is probably a relatively easy query but I cannot get my head around how to query nested json arrays. I have a SQL 2016 DB with a json field which contains a json string with multiple child arrays. Attached is an image of the json…
SilverE
  • 51
  • 1
  • 5
4
votes
4 answers

JSON - How to append an array to an array in sql

I have a json field in a table that contains an array like this:- [ { "ID": 11111, "Name": "apple", }, { "ID": 22222, "Name": "orange", }, { "ID": 333333, "Name": "banana", } ] I would like to…
dan0001
  • 153
  • 1
  • 9
4
votes
3 answers

Split the string using String_Split() in SQL Server 2016

I need to use STRING_SPLIT in my stage table and import the results into another table. Stage table: DECLARE @stage TABLE(ID INT, Code VARCHAR(500)) INSERT INTO @stage SELECT 1, '123_Potato_Orange_Fish' UNION ALL SELECT 2,…
SQL006
  • 439
  • 6
  • 21
4
votes
2 answers

How to refresh table data when in edit mode in latest versions of SQL Server Management Studio?

In SQL Server Management Studio, it is possible to open a table and see its contents, this is done by: right clicking on the table choosing Edit first N rows (where N is a parameter that defaults to 200) In SQL Server 2008 R2 there was a button (I…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
4
votes
3 answers

Error when inserting into temporal table using Entity Framework Core 2.1

I'm getting the below error when trying to insert into a temporal table using Entity Framework Core 2.1. Cannot insert an explicit value into a GENERATED ALWAYS column in table 'db_test.dbo.Department'. Use INSERT with a column list to exclude the…
VPP
  • 731
  • 1
  • 9
  • 34
4
votes
2 answers

Entry and Exit points on times series chart data

Is the following actually possible in SQL? I have some time-series data and I want to extract some entry and exit points based on prices. Desired output: Example Data: SQL Data: CREATE TABLE Control ([PKey] int, [TimeStamp] datetime, [Name]…
user3904868
4
votes
1 answer

Get data as rows from array inside JSON column

I have a table which the 'Preference' column stores JSON strings. a) I would like to get the type from companytype as rows. In my attempt on sqlfiddle I get the five rows but no data in them. SELECT z.[Type] FROM FinPreferences p CROSS APPLY…
alwaysVBNET
  • 3,150
  • 8
  • 32
  • 65
4
votes
3 answers

Why does MS-SQL-Server (all versions) cast 1.0/12.0 as numeric(8,6)?

I'm trying to explain a 101.10 difference in value. 303'300'000/12 is about 25'275'000. However, according to MS-SQL, it's 25'274'898.90. Consider this (dumbed down) SQL-statement: SELECT 303300000.00/12.0 AS a ,1.0/12.0*303300000.00 AS…
Stefan Steiger
  • 78,642
  • 66
  • 377
  • 442
4
votes
2 answers

How to query data when columns are encrypted in SQL Server 2016

I've been trying to find solution in this problem. I encrypted my columns from my database in SQL Server 2016 . In order to read the data I already set the parameters "Column Encryption Setting=Enabled"; I know I don't have problem in my certificate…
April
  • 141
  • 2
  • 2
  • 8
1 2 3
…
99 100