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

Visual Studio 2015 SSIS - Custom SSIS component not picked up in SSIS toolbox

I'm having a problem adding a custom SSIS component to SSIS in Visual Studio 2015. My system is: Windows 8.1 64 bit Visual Studio Community 2015 Version 14.0.24720.00 Update 1 Microsoft SQL Server Integration Services Designer Version…
mattp
  • 131
  • 1
  • 5
10
votes
2 answers

Data profiling Task - custom Profile Request

Is there any option to create a custom Profile Request for SSIS Data Profiling Task? At the moment there are 5 standard profile requests under SSIS Data Profiling task: Column Null Ratio Profile Request Column Statistics Profile Request Column…
Barsham
  • 749
  • 8
  • 30
10
votes
3 answers

How to read field name with space in Json using OPENJSON in SQL Server 2016

How can I read value from json file in that field name contains space using OPENJSON in Sql Server 2016. See the below code: DECLARE @json NVARCHAR(MAX) SET @json = N'{ "full name" : "Jayesh Tank"}'; SELECT * FROM OPENJSON(@json) WITH ( [name]…
Jayesh Tank
  • 129
  • 1
  • 8
10
votes
4 answers

SSRS Error - "Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate

I'm new to SSRS and I'm not sure if it will do what I would like to do. I'm getting the following error in SSRS: "The Value expression for the text box 'Textbox17' refers to the field 'DayCnt'. Report item expressions can only refer to fields…
JM1
  • 1,595
  • 5
  • 19
  • 41
10
votes
1 answer

Why SQL returns an Array instead of an Object?

I'm using SQL SERVER 2016 JSON result, but I don't know why it converts everything to array, e.g. if I execute the following query it returns an array instead of an object: SELECT 1 AS One,2 AS Two,3 AS Three FOR JSON PATH The result…
Saman Gholami
  • 3,416
  • 7
  • 30
  • 71
10
votes
4 answers

How can I add a check constraint for JSON in Entity Framework?

Adding a JSON CHECK CONSTRAINTfor a table field with ALTER TABLE [dbo].[Data] ADD CONSTRAINT [JsonData must be formatted as JSON] CHECK (IsJson([JsonData]) > 0) works fine, but I want to make it work for Code First. I have tried the…
PianoSong
  • 340
  • 4
  • 18
10
votes
1 answer

Deploy of a report with SSDT 2016 generates error

I use VS2015 with SQL Server Data Tools; I have some Reporting Services (RDL) reports. I want to deploy them to a Reporting Server with SQL Server 2014 installed. In my report project I set the TargetServerVersion to "SQL Server 2008R2, 2012 or…
Catwiesl
  • 146
  • 7
9
votes
2 answers

Does DATETIME type include timezone information?

I want to use UTC timestamps exclusively in an MSSQL database. When writing the current timestamp I can use system methods like GETDATEUTC and we have agreed with suppliers that timestamps sent from external sources will also be provided as implicit…
Mr. Boy
  • 60,845
  • 93
  • 320
  • 589
9
votes
2 answers

SSAS Measure Group EstimatedSize EstimatedRows

The properties panel in SSDS for a Measure Group has two properties I'd like to learn more about: EstimatedRows and EstimatedSize. There seems to be little documentation on either of these. I did find that I can run the Aggregation Design Wizard and…
Mike Smith - MCT
  • 1,166
  • 1
  • 9
  • 15
9
votes
1 answer

Do Clustered Columnstore Indexes Affect SSAS Query End User Performance

Do Clustered Columnstore Indexes affect SSAS Performance querying for the end-user, and how could to fix this? Read an article below here how Sort order affects SSAS query customer user performance. Is there any way to resolve this issue? Would…
user11156893
9
votes
1 answer

Query complex JSON in SQL Server - filter array of objects

I'm having problems meshing together the JSON functions in Msft Sql Server. I have a table that stores complex JSON structures and need to pull out a subset of an array of objects. As an example, I made a simple script that creates a table and…
Matthew Allen
  • 538
  • 2
  • 7
  • 14
9
votes
2 answers

Sql Server 2016: Enable TLS 1.2 for SQL Server Connection

I've SQL server 2016 running on windows 2012 R2 and I applied the patch for TLSv1.2 support and rebooted the VM, https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server I do see TLS 1.2 being enabled using IISCrypto…
OTUser
  • 3,788
  • 19
  • 69
  • 127
9
votes
3 answers

SQL Server 2016 select where in json array

I have a table [JsonTable], and the column [JsonData] save the json string, JsonData like: { "Names": ["John", "Joe", "Sam"] } How can I inner join this table like: SELECT* FROM [TestTable] AS T INNER JOIN [JsonTable] AS J ON T.[Name] IN…
Max
  • 4,439
  • 2
  • 18
  • 32
9
votes
4 answers

How to remove Always Encrypted from a column in SQL Server 2016

How can I remove the encryption property from a column in SQL Server 2016? I've enabled this feature using the Always Encrypted wizard in SQL Server Management Studio 2016, but I would like to remove the encryption from some columns I've added…
Bas de Raad
  • 556
  • 1
  • 6
  • 15
9
votes
3 answers

How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?

I have a table that has system versioning (temporal table), but I can not see a design environment visually. I do it because I can see the SYSTEM_VERSIONING clause has been used. I would like to have temporarily Stop and then enable it. Who can…
Aiyoub A.
  • 5,261
  • 8
  • 25
  • 38
1 2 3
…
99 100