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
1
vote
1 answer

Parallel execution of a stored procedure by using JMeter JDBC request and parameterization

I am able to execute simple SQL queries in Jmeter by setting up thread groups,jdbc connection config, jdbc request,csv data config and view results tree. But the problem I am struggling with is to execute a SQL Server stored proc in parallel for 'n'…
Teja
  • 13,214
  • 36
  • 93
  • 155
1
vote
1 answer

Standalone R and R - SQL give different results

I am working on a forecasting model for monthly data which I intend to use in SQL server 2016 (in-database). I created a simple TBATS model for testing: dataset <- msts(data = dataset[,3], start = c(as.numeric(dataset[1,1]), …
Kristijan Tornič
  • 19
  • 3
1
vote
1 answer

Balanced Data Distributor in BIML

Is there support for the balanced data distributor component in BIML? The documentation has this: https://varigence.com/Documentation/Language/Element/AstBalancedDataDistributorNode But when I use this element, I get the following error: Error 0 …
Mark Wojciechowicz
  • 4,287
  • 1
  • 17
  • 25
1
vote
1 answer

Adding array to array with JSON_MODIFY

DECLARE @JSON_CurrentArray NVARCHAR(MAX) = '{"Some List": [{"Name":"Item1","Id":"2"},{"Name":"Item2","Id":"3"}]}'; DECLARE @JSON_TopLevel NVARCHAR(MAX) = '{"OverAll":[{"Product Section":[]}]}'; SET @JSON_TopLevel = JSON_MODIFY(@JSON_TopLevel,…
That Data Architect Guy
  • 52
  • 6
1
vote
1 answer

Issue in R package installation in SQL Server 2016 Developer edition

I am using SQL Server 2016 Developer edition. I am trying to install "rtweet", "text2vec" R packages into SQL Server, but it shows Package ‘rtweet’ is not available (for R version 3.2.2) How can I solve this problem?
mzhasan
  • 55
  • 1
  • 6
1
vote
1 answer

Is it posible to use SQL Server Session Context with Azure elastic queries

I want to know if it's posible to share SQL Server SESSION CONTEXT variables between different Azure Sql databases using Elastic Queries. I searched in official documentation but i can't found any information about this feature is available or not.
Pablo García
  • 359
  • 3
  • 9
1
vote
3 answers

Select data from SQL Server in WPF app

Having problems with accessing what is inside my list in a wpf application of a mafia game I am creating. Basically I read from SQL Server 2016, then add it to my user collection list. Later when I use my list in a display, they all are there.…
LINQtothepast
  • 57
  • 2
  • 10
1
vote
4 answers

DATEDIFF function resulted in an overflow in SQL Server 2016

I have a table in SQL Server 2016 with the following data: id | t | memory -------+-------------------------+------------ 620255 | 2017-07-17 16:11:25.100 | 11632640 620127 | 2017-07-17 16:11:24.100 | 11632640 619999 |…
Prerak Sola
  • 9,517
  • 7
  • 36
  • 67
1
vote
3 answers

Switch Partitioning failing due to mismatch in file groups of source and destination tables

I am trying to implement switch partitioning on one of the tables and I made sure that the partition function,scheme,file groups are working fine. But I get the file group error when I run the below command. Can someone share your thoughts on…
Teja
  • 13,214
  • 36
  • 93
  • 155
1
vote
1 answer

What is bottleneck for query to perform slow in Azure

I have Azure SQL database in Standard tier, 10 DTU. How can i "predict" performance on CPU intensive queries (as that seems to be reason for slowness)? To illustrate problem will use perf_test table, that can be populated like this (script could be…
Jānis
  • 2,216
  • 1
  • 17
  • 27
1
vote
1 answer

SQL works in R studio but not in R-Serivces

This code works perfectly in R-Studio but there is no way to make it work in MS Management studio. It keeps on saying that: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myserver\LOCAL01'. That is not my user give it is a…
Leonardo Lanchas
  • 1,616
  • 1
  • 15
  • 37
1
vote
5 answers

How to swap value in SQL Server?

I want to swap the value between the row but I don't have an idea how to make it as I create a script to do it but the answer still not correct. I get the data raw in from the pdf then convert it into excel 'xls'. Please see the sample…
PAT
  • 41
  • 1
  • 6
1
vote
1 answer

How to prevent bad optimization of CROSS APPLY with Inline Table-Valued Function

I have an inline table valued function which runs a query on an OLE-DB linked server, defined as follows: CREATE FUNCTION [dbo].[fnGetResultsForTag] ( @elapsedTimeTag NVARCHAR(50) ) RETURNS TABLE AS RETURN ( SELECT tag, time,…
Hydrargyrum
  • 3,378
  • 4
  • 27
  • 41
1
vote
1 answer

How to consolidate results from multiple invocations of a stored procedure?

I have a stored procedure that is supposed to work as follows: DECLARE @TagNames AS TABLE ( tag NVARCHAR(50) NOT NULL ) -- Get list of tags INSERT INTO @TagNames SELECT tag FROM tagTable WHERE tag LIKE @tagPattern -- Create unified result set,…
Hydrargyrum
  • 3,378
  • 4
  • 27
  • 41
1
vote
3 answers

How to make a ratio between values from two queries?

I have these two queries SELECT COUNT(DISTINCT s.KliRC) Celkem ,r.Region FROM dbo.Smlouvy s JOIN CS_OZ oz ON oz.KodOZ = s.KodOZ JOIN CS_Regiony r ON r.KodRegionu = oz.KodRegionu GROUP BY r.Region --…
user5021612
1 2 3
…
99 100