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

String_agg in sql server 2016

Here is my code in sql server 2016 insert into @entdef_queries(entitydefid,squery) select A.entitydefid , ( select String_agg(cols,ioperator) from …
shane
  • 127
  • 1
  • 1
  • 6
12
votes
3 answers

Increment column for streaks

How do I get the following result highlighted in yellow? Essentially I want a calculated field which increments by 1 when VeganOption = 1 and is zero when VeganOption = 0 I have tried using the following query but using partition continues to…
user3904868
12
votes
13 answers

SSIS Error: VS_NEEDSNEWMETADATA

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2). While updating one of the ETLs and trying to run on the new server I…
Jonathan Porter
  • 1,365
  • 7
  • 34
  • 62
12
votes
5 answers

Column encryption in ASP MVC app with SQL Server 2016 using .net Core / EF Core

I am trying to use the "Always Encrypted" feature in SQL Server 2016 to encrypt some columns. I used this post as a guide to set the columns as encrypted in SSDT. That part goes fine, it's when I attempt to query the data from the application that I…
Brian
  • 2,318
  • 3
  • 19
  • 20
12
votes
3 answers

SQL Server 2016 Cannot add system versioning to relationship table

The SQL Server 2016 system versioning is cool. I am using the free Developer version. Thanks MS! I am unable to figure out if it will give me versioning of many to many relationships. I have a User object that has a collection of Roles and vice…
user2893547
  • 135
  • 1
  • 9
12
votes
3 answers

What is the best way to query deleted records with SQL Server 2016 temporal tables?

I'm looking at SQL Server 2016 temporal tables and can't find any efficient way to query for all historical records that are now deleted. I prefer not to soft-delete or moving to a 'deleted items table', as I feel with temporal tables it is…
Le-roy Staines
  • 2,037
  • 2
  • 22
  • 40
11
votes
2 answers

Power BI Slow with SSAS Multidimensional Cube

We are implementing Power BI with SSAS Cube Direct Query. For some reason, SSAS Power BI is extremely slow performance, however using SSDT SSAS Application or Power View or Excel is Much faster. I read that Power BI converts SSAS Multidimensional…
user11156893
11
votes
10 answers

Find matching records based on dynamic columns

I have a list of pets: And I need to find a correct owner for each of the pet from Owner table In order to correctly match each pet to an owner I need to use a special matching table that looks like this: So, for pet with PetID=2 I need to…
user194076
  • 8,787
  • 23
  • 94
  • 154
11
votes
1 answer

Database name 'tempdb' ignored, referencing object in tempdb

Instead of checking temporary table existence like this: IF OBJECT_ID('tempdb..#table') IS NOT NULL BEGIN; DROP TABLE #table; END; I am using the new DROP IF EXISTS technique: DROP TABLE IF EXISTS tempdb..#table; It is working perfectly, but…
gotqn
  • 42,737
  • 46
  • 157
  • 243
11
votes
3 answers

Why is columnstore index not being used

I have a non-clustered columnstore index on all columns a 40m record non-memory optimized table on SQL Server 2016 Enterprise Edition. A query forcing the use of the columnstore index will perform significantly faster but the optimizer continues to…
Rory
  • 959
  • 10
  • 22
11
votes
3 answers

Avoid schema mismatch in System-Versioned tables

Looking for a workaround for: Error: SQL71609: System-versioned current and history tables do not have matching schemes. Mismatched column: 'XXXX'. When trying to use SQL 2016 System-Versioned (Temporal) tables in SSDT for Visual Studio 2015. I've…
Andrew Barnett
  • 5,066
  • 1
  • 22
  • 25
11
votes
1 answer

Is it possible to change the user account of the localdb instance in SQL Server?

Is it possible to change the user account of the localdb instance in SQL Server? We changed our domain and it is using my old domain account so I can no longer login anymore. Also, I don't believe that you can login with SQL auth, so the sa account…
bkorzynski
  • 541
  • 1
  • 5
  • 15
11
votes
2 answers

Why we require temporal table in SQL Server 2016 as we have CDC or CT?

What advantages do Temporal Tables have over Change Data Capture or Change Tracking in SQL Server?
Kannan Kandasamy
  • 13,405
  • 3
  • 25
  • 38
11
votes
5 answers

SQL won't connect after deploying

I recently deployed my website on IIS (LocalDB). But whenever I try to run the website, the SQL fails to connect. I've been through hundreds of posts/articles now but I am unable to resolve it. Error A network-related or instance-specific error…
Pirate X
  • 3,023
  • 5
  • 33
  • 60
11
votes
1 answer

Cannot import SQL Azure bacpac to 2016 CTP

I'm very familiar with the process of exporting from Azure SQL V12 down to my dev box and then importing to my local sql (2014) instance. I'm spinning up a new Win10 box and have installed the SQL 2016 CTP. I'm connecting to that same Azure…
justSteve
  • 5,444
  • 19
  • 72
  • 137
1 2 3
…
99 100