Questions tagged [sql-server-2016]

SQL Server 2016 (major build version 13.00.xxxx). Please also tag sql-server.

Filter by
Sorted by
Tagged with
1
vote
1answer
1k views

Using @@ROWCOUNT in multi-operation batch to check either a failure or a success of the whole transaction

I have the following script defined with hopefully explanations in comments to explain rationale in the right context. The questions are basically: Is the following usage of @@ROWCOUNT in conjunction ...
2
votes
0answers
923 views

Anyone else had problems uninstalling SQL Server 2016 RC0?

We installed RC0 the day it was released and, for needs of space and project transitioning, needed to reclaim the space. As I couldn't find an uninstall option in the installation UI, I resorted to ...
4
votes
1answer
5k views

Trouble setting up mirroring on SQL Server 2016

I've setup a test SQL Server 2016 server. I've installed 2 instances, restored a backup on the primary. Then restored a backup on the secondary with NO RECOVERY, then restored the transactional log ...
2
votes
0answers
843 views

Unexpected Memory Pressure - RESOURCE_SEMAPHORE wait

Update I've done some further investigation into this issue and could still do with some help understanding what's going on. After restarting the instance, I monitored memory allocations over time, ...
4
votes
2answers
3k views

Msg 39011, SQL Server was unable to communicate with the LaunchPad service

We have just installed SQL Server Enterprise 2016 CTP 3.3 on a server that already had SQL 2012 Standard installed. We installed SQL2016 as a Named Instance and have been trying to get the R ...
8
votes
3answers
23k views

Data warehouse server. How do you calculate RAM/CPU specifications?

I am trying to write a spec for a data warehouse server for our planned data warehouse upgrade. As we run virtual servers on VMWare hosts we have the ability to add or remove resources as necessary. ...
3
votes
1answer
647 views

Can SQL Server 2016 validate JSON on insert?

Currently SQL Server 2016 CTP 3 and later releases support NVARCHAR(max) fields with JSON content. However since the type NVARCHAR(max) is totally free-form, there is no constraint on these fields. ...
3
votes
1answer
908 views

How do I generate the ENCRYPTED_VALUE for CREATE COLUMN ENCRYPTION KEY?

I can make a certificate in the windows certificate store for the master column key easily enough with: $cert = New-SelfSignedCertificate ` -Subject "Always Encrypted Sample Cert" ` -...
3
votes
1answer
610 views

Having hard time understanding expressions in below query plan

I was going through Temporal tables new features in SQL 2016,one of the examples was to query tables with as of clause which returned below query plan Rows Executes StmtText StmtId NodeId ...
4
votes
1answer
3k views

How to enable query store on the SSMS object browser with Sql Azure?

I am following this guide: Monitoring Performance By Using the Query Store I am using SSMS 2016 CTP3.2 and Sql Azure V12 I have enabled the query store on the database properties. I can use the ...
4
votes
2answers
410 views

Performance of a self join in a temporal table with a single day's difference between end_date and start_date

Title says it all really. A pretty standard temporal table design has a start_date and an end_date where the end_date is the day before the next record's start_date. In this case, there is an ...
11
votes
1answer
53k views

SQL Server AlwaysOn database stuck in Not Synchronizing / In Recovery mode after upgrading. Error: Cannot open database '…' version 782

While testing an upgrade from SQL Server 2014 SP1 (12.0.4422.0) to SQL Server 2016 CTP 3.2 (13.0.900.73) I was following the recommended update process and ran into an issue where the database would ...
2
votes
1answer
683 views

Why can't I alter a security policy conditionally?

I have the following rather simple statement in SQL Server Mgmt Studio 2016 CTP 3.2: if exists(select null from sys.security_policies where name = 'OrganisationSecurityPolicy') begin alter ...
28
votes
1answer
780 views

Is the eager spool operator useful for this delete from a clustered columnstore?

I'm testing deleting data from a clustered columnstore index. I noticed that there is a large eager spool operator in the execution plan: This completes with the following characteristics: 60 ...
3
votes
1answer
794 views

SSMS 2016 CTP3.1 November Preview (v13.0.800.111) bug? properties error: missing column federated_service_account

Using SSMS 2016 CTP3.1 November Preview (v13.0.800.111) on my laptop, whenever I right click any database object (the database, a table, etc.) I get the below error. TITLE: Microsoft SQL Server ...
2
votes
2answers
1k views

Where can I find a compatible version of SSMS for SQL Server 2016 CTP?

Microsoft seem to have many versions of SQL Server 2016 CTP available at a time to download, at only 2.5GB a piece, but only one version of SSMS 2016 CTP, and if your db engine is the wrong version ...
1
vote
1answer
132 views

Scalability of concurrent log restore for different databases on SQL Server

Are there any locks or resource blocking/contention (beyond IO capacity) between two sessions, which restore logs for two different databases with norecovery? Same about restore logs with recovery? ...
3
votes
2answers
755 views

SQL Server transferring results slowly in table result set, but instantly with XML

I have a query that left joins 100+ tables and returns 2,000+ columns, but only a few rows (10-20). This part is out of my control at the moment and it used to run ok with a bit fewer columns (maybe ...
4
votes
1answer
13k views

Msg 39011 SQL Server was unable to communicate with the LaunchPad service

I was playing with the new "R" scripting in SQL Server 2016 CTP 30. Finally got it working, thanks to this site. I've had a problem that I'm sure others will run into as well. All of a sudden the "...
3
votes
1answer
132 views

Where clause to filter rows for Azure Stretch Database?

Currently stretch database in SQL Server 2016 moves the entire table to Azure. However, this InfoQ article mentions an "archive row" mode for Stretch database that will allow you to filter which rows ...
5
votes
1answer
3k views

Will Temporal Tables be included in the Standard Edition of SQL Server 2016?

The new version of SQL Server 2016 wil support so called Temporal Tables. I can't find any documentation that would say whether this feature would be Enterprise-only or available in Standard edition ...
7
votes
1answer
28k views

Configuring SQL Server 2016 to allow remote connections

I have SQL Server 2016 installed on Windows Server 2016 Core. Locally, it seems to be working. I can connect using SQLCMD.exe and do some basic selects and what not. From remote, I cannot connect. ...
1
vote
1answer
3k views

Unable to get SQL Server 2016 CTP3 service to start on Windows 10

During install of MS SQL Server 2016, on a developer/DBA workstation client PC which is joined to a domain, the installation using all logon and other installer defaults, completes with failures, and ...
2
votes
1answer
388 views

Row level security in SQL Server 2016 with a normalised schema

SQL Server 2016 supports row level security, which is great. However all of the samples assume that the username is inside the table you wish to apply security to (see example below- from MSDN https://...
4
votes
2answers
2k views

How to get snapshot of changed data and store them on daily basis

I have a requirement from my client. He wants to store a snapshot of what data has changed for some given tables, mainly financial transaction tables, on daily basis. This is for audit purposes. Data ...
3
votes
1answer
1k views

Can I convert a VARCHAR field body to unquoted JSON result in SQL Server 2016 CTP 2.X?

I have downloaded and installed SQL Server 2016 Community Technology Preview 2.3, which if I understand correctly, should contain a built-in function called JSON_VALUE. (Update: CTP 2.4 has shipped ...
2
votes
0answers
4k views

SQL Server does not exist or access denied" after installing SSMS

I recently installed SQL Server Management Studio (which also installed SQL Server 2016 to my local machine), and now am unable to connect to SQL Server from applications on my machine. It will come ...
3
votes
4answers
3k views

Which version of SQL Server 2016 supports R

Microsoft buying REvolution results (amongst other things) in the integration of R in SQL Server 2016. Looking through the features supported by the SQL Server 2016 I cannot find R-Support. Does ...
17
votes
1answer
1k views

Query strategies using SQL Server 2016 system-versioned temporal tables for Slowly-Changing Dimensions

When using a system-versioned temporal table (new in SQL Server 2016), what are the query authoring and performance implications when this feature is used to handle Slowly Changing Dimensions in a ...
6
votes
1answer
681 views

Server roles in SQL Server 2016

There are 3 new server roles in SQL Server 2016: mediumrc largerc xlargerc Any idea what these are for? Google doesn't give any information about these.
1
vote
2answers
4k views

TempDB default number of files in SQL Server 2016

Noticed the docs for SQL Server 2016 CTP2 state "by default, setup adds as many tempdb files as the CPU count or 8, whichever is lower." https://msdn.microsoft.com/en-us/library/bb510411(v=sql.130)....

1
46 47 48 49
50