Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.

learn more…| top users | synonyms (1)

2
votes
2answers
42 views

How do I create a filtered index on a table type in SQL Server?

CREATE TYPE [dbo].[MyTableType] AS TABLE(Id INT NULL INDEX ix UNIQUE WHERE Id IS NOT NULL /*Unique ignoring nulls*/, Sort INT NOT NULL, [Name] NVARCHAR(MAX) NULL )What's the new way ...
1
vote
1answer
25 views

SQL Server 2016 Parse JSON into Table

I am trying to take a JSON output from an API into a SQL Server Table using the JSON Parsing in SQL Server 2016. However, I'm having a very hard time getting it to work. I've exhausted all my ...
-4
votes
2answers
25 views

Rounding of Decimal values

Is there any function in sql which rounds of the value to nearest whole number. For example, If value is 12.56 then it should be 13.If value is 12.34 then it should be 12. I tried with Ceiling ...
0
votes
0answers
18 views

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-...
-2
votes
1answer
18 views

Best way to move XML data from a SQL Server 2016 DB to Cosmos DB

Have a SQL Server 2016 table which contains ~10 GB of data. I have to migrate the XML data stored within that table in a XML column to Cosmos DB. It's a one time job and post migration such data ...
0
votes
1answer
22 views

Remove repeating interval/history duplication

It's a bit a challenge to put the proper Title to that question, so I'll try to explain the problem. We have Oracle --> SQL Server replication using JCC. The way it works, that it reads the ...
0
votes
1answer
26 views

Searching for a row based on the grouping of rows

Preface, I am not sure the question even make sense.Problem StatementI have a table that looks like this:+----------------+-----------+| ProductGroupID | ProductID |+----------------+----------...
-1
votes
1answer
16 views

On single server TFS systems should I set the SQL databases' recovery model to Simple or leave it on Full?

I recently had to go through every database on a SharePoint server and change the recovery model to simple because the logging was eating up disk space.I don't have any apparent disk space problems ...
0
votes
1answer
14 views

Calling an SSRS Mobile Report in ASp.net web application

I have an application and I would like the default screen to be an SQL Mobile Report that I have built. I can see the report when I navigate to it and it looks fine but when I try to open it in an ...
0
votes
0answers
11 views

Parameterized Queries for Always Encrypted with SSDT

SSMS v17 brought support for Parameterized Queries allowing you to INSERT and UPDATE data in Always Encrypted columns in SSMS. Does anybody know if there's something similar in SSDT?Thanks
0
votes
1answer
44 views

Sentence Select with replace

I have a table with two columns, POLIZA and TEXTO_LIMPIO.In the TEXTO_LIMPIO column is a large string and I want to replace some characters.I was doing it this way:SELECT REPLACE(TEXTO_LIMPIO,' '...
0
votes
1answer
18 views

Is SQL Server 2016 Standard Edition SP1 support switch partition?

Is SQL Server 2016 Standard Edition SP1 support switch partition? We have developed a data archiving process using switch partition mechanism in SQL Server Enterprise Edition.We want to use the ...
0
votes
0answers
22 views

SQL Server 2016 - Insert data into encrypted column with SSDT

We have two SSDT projects in our solution, 1 for the main database and another which can be published to insert test data for dev purposes.In the test data project, I'm trying to insert data into an ...
0
votes
0answers
12 views

Could not find object 'sp_MSrepl_startup' or you do not have permission

I am trying to configure distribution for replication setup in SQL Server 2016 on execution of below script. Also I got the same error when I tried from SSMS wizards for configuration.use master...
0
votes
0answers
11 views

Migrating EF Database First to SQL Server 2016

I'm working on a project (.NET Framework v4.7.1) with two Database First Entity Framework models (EF 6.2.0) that connect to two different SQL Server 2008 databases. I'm upgrading SQL Server to 2016 ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,