For questions about SQL Server 2014 (major build version 12.0.xxxx)

learn more… | top users | synonyms

5
votes
1answer
63 views

Select all records, join with table A if join exists, table B if not

So here's my scenario: I'm working on Localization for a project of mine, and typically I would go about doing this in the C# code, however I want to do this in SQL a bit more since I am trying to ...
2
votes
0answers
49 views

Transactional Replication in SQL server 2014

We need to set up transactional replication in SQL server 2014, Enterprise edition so that: Database to be replicated from Publisher is approx. 2 TB in size. This would be used 24*6. Here we also ...
1
vote
2answers
41 views

Backup to local and MIRROR TO Azure Files returns ERROR

I have an Azure VM with SQL Server 2014, with a local drive (X:) for storing backups. Using Ola Hallengren's scripts. I added an Azure Files share and tried to do a mirror backup, but I get the ...
0
votes
0answers
27 views

Do I need a separate server for Quorum?

We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: 1 Primary Replica and another is Secondary Replica. The question is, do we need a separate server ...
0
votes
0answers
12 views

Distributed Replay DCOM issue

I have 2 SQL Servers in a Domain. Windows Firewall is disabled on both servers and there is no hardware firewall. Both servers are in the same subnet. One server, called Controller is configured as a ...
6
votes
1answer
64 views

SSMS Registered Servers with ReadOnly Application Intent

We are working on SQL Server 2014 POC testing with AlwaysOn and one of the user asked about saving the configuration of SSMS with ReadOnly Intent using the registered servers in Local server group. ...
-1
votes
1answer
43 views

Restoring a backup of a database from SQL Server 2014 into SQL Server 2012 [duplicate]

Is it possible to load a backup of SQL server 2014db into SQL server 2012? Trying to import/restore is throwing backward compatibility issues. Thanks
2
votes
1answer
34 views

stored procedures vs inline SQL in a Job step SQL SERVER 2014

I have created a job with two steps. Step 1 deletes 50000 rows from an error table older than 90 days. Step 2 creates and emails a quick report on the number of new records created in the error ...
6
votes
0answers
136 views

Crashing CLR on SQL Server 2014 (windows 2012R2)

I have this small CLR that does a RegEX function on a string in columns. When running on SQL Server 2014 (12.0.2000) on Windows Server 2012R2 the process crashes with Msg 0, Level 11, State 0, ...
5
votes
1answer
328 views

SQL Server 2014 - Reset everything

Short of reinstalling the software, is there a simple way to 'start from scratch' with a SQL instance? By that I mean: Remove all created logons, Remove all added databases, Reset system databases, ...
3
votes
0answers
65 views

What exactly can SQL Server 2014 execute in batch mode?

When a columnstore index is being used in a query SQL Server is able to use batch mode. Documentation is thin on what can run in batch mode and what can't. Please look at the following (motivating) ...
1
vote
0answers
31 views

DBCC SHRINKFILE (N'XYZ' , EMPTYFILE) using single core

Is there any way to force DBCC SHRINKFILE to use more than one core? We're running SQL Server 2014 on a hex core machine - and SHRINKFILE is using one hyper threaded core. I/O is at a small fraction ...
0
votes
0answers
24 views

Cursor Performance in New Server

I bought a new server with spec : HP ProLiant ML310e Gen8 v2 8 GB Single Memory, Intel Xeon E3-1220v3 3,1 GHz, 500 GB SATA 7.5K RPM, Windows Server 2012 R2 x64, SQL Server Standard 2014 x64, RAID 0 ...
0
votes
1answer
24 views

NC Columnstore and delete on batch

hope you can give me some pointers on this behavior I have a NC Columnstore and in the same batch I want to drop this column store and "delete" some information. But I get this error: DELETE ...
0
votes
0answers
16 views

Can't see any services listed in Configuration Manager

I am using SQL Server 2014 and am logged in my desktop as my user account with admin rights. When opening Config Mgr, I do not see any services listed whatsoever. Could this be an issue that ...
0
votes
1answer
31 views

Can I Upgrade SQL Server 2008 R2 Express to SQL Server 2014 Developer edition

I currently have SQL server 2008 R2 Express installed for my QA/Dev environment on Amazon EC2 instance. Now my database is growing beyond the 10GB limitation of Express edition, so am planning to buy ...
0
votes
0answers
19 views

SQL 2014 Database NDF file Lost - Filegroup offline

(Originally asked on StackOverflow and redirected here) I have a database that has lost one of its .ndf files and have been unable to get at the data. The ndf file in question was added last ...
0
votes
1answer
22 views

Inplace upgrade from SQL Server 2008 Standard to SQL Server 2014 evaluation

I am trying to evaluate SQL Server 2014 by using the 2014 evaluation edition to upgrade an in place SQL Server 2008 Standard sp4 instance. At the end of the process I expect to have a SQL Server ...
3
votes
1answer
70 views

SQL Server Agent maintains thousands of sleeping connections

In a recent monitoring session I noticed that one of our main MSSQL 2014 databases had an increasing number of open connections. It started with more than 1000 open connections, and now after two ...
1
vote
0answers
33 views

System.Data.SqlClient.SqlException (0x80131904): SQL Server detected a logical consistency-based I/O error: incorrect checksum

I am migrating client's database to my hosted environment, the client runs SQL Server 2008 R2, and we run SQL Server 2014. I am stuck on restoring one log file, which left below error message when I ...
0
votes
0answers
29 views

Scale-Out Query Server: SQL Server 2012/2014 Enterprise vs BI Edition

Was reviewing the Features Supported by the Editions of SQL Server (2012, 2014) and noticed what appears to be a mistake, but I'm just not certain and looking for confirmation. For 2012/2014, there ...
0
votes
1answer
37 views

Is it possible to get a list of procedures create with WITH EXECUTE?

Is it possible to get a list of stored procedures create with WITH EXECUTE in SQL Server? If so how? I tried looking at the sys.procedures table but they all have the principal set to null and I know ...
1
vote
1answer
68 views

DROP LOGIN fails on SQL Server 2014

We have a database with an owner 'dbowner'. Our install procedure drops the login for user 'dbowner' and creates it again. On any other version of SQL Server the following SQL query succeeds: USE ...
0
votes
0answers
21 views

Problem running SQL Server 2014 SSAS in an SSIS package

I have a SQL Server 2014 AlwaysOn environment setup with 3 nodes. It is a QA environment. I have a user who is trying to run an SSIS package against an SSAS cube. He can manually run the process in ...
0
votes
1answer
47 views

Is it possible to estimate the restore progress in SQL Server 2014 from pages read/written?

For context - SQL 2014 EE, we're doing tran log backups from our main production box and restoring to a R/O instance. The log is usually around 50GB. So I'm familiar with the structure of SQL Server ...
1
vote
0answers
52 views

Why does an SSIS package fail when executed from the IS Catalog?

When executed via the SQL Server Agent under the same user context, is there any reason a package would successfully run when using the file system (i.e. DTExec.exe), but fail to execute when launched ...
0
votes
0answers
21 views

Why do the databases go into the “recovery pending” state when the share permissions are changed from “everyone”?

Yesterday we had a power failure and after the power was back our financial databases on the SQL did fall into "Recovery Pending" state. After struggling a while I've remembered that a few days ago we ...
2
votes
1answer
56 views

Help understanding discrepency between sys.dm_exec_cached_plans and dm_os_memory_clerks

We've got a strange discrepancy on one of our SQL Server 2014 instances between the amount of memory being used for cached plans as per sys.dm_exec_cached_plans and the amount of memory used as per ...
2
votes
1answer
46 views

Can't connect to new instance of SQL Server

I was trying to upgrade to SQL Server 2014 from SQL Server 2012, but I kept getting a failure on one of the pre-installation checks saying that I needed to have SP1 or later installed for SQL Server ...
0
votes
0answers
18 views

Multiple Distributors in SQL Server Replication

Per this article, a Publisher can only have one remote Distributor in doing SQL Server Transactional Replication. Each Publisher can be assigned to only a single Distributor instance, but multiple ...
2
votes
0answers
39 views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
0
votes
1answer
36 views

SQL Server Full Text Search Engine is not returning consistent results

I'm working on an application that makes use of the Full Text Search Engine from SQL Server. In order to convert the user input into readable parameters for SQL, i'm using This very useful FTS query ...
1
vote
1answer
25 views

Finding the end of a Relationship chain optimally

I have a table that contains an id column, a parent column, and it's child column. So for every record, I know what record comes before it and what will come after it in a chain relationship, but from ...
1
vote
1answer
35 views

SQL Server 2014: missing replication option

This article details exact steps to set up basic database replication with SQL Server 2014. It starts with this: Right-click the Replication folder, and then click Configure Distribution. ...
2
votes
0answers
17 views

Manual Failover with AlwaysOn availability group

We are planning to upgrade our SQL 2012 to SQL 2014. We currently use a mirror for our production databases but are planning to move to availability groups. We are going to be running 2 SQL Servers on ...
0
votes
1answer
50 views

Processors: E5-4620 v2 vs E5-2620 v3 [closed]

We're debating between: R820 - E5-4620 v2 - 2.6GHz - 8 cores, 20MB Cache, 1333MHz max memory speed - max of 768GB ram - 8 core R730 - E5-2620 v3 - 2.4GHz - 6 cores, 15MB Cache, 1866MHz max memory ...
1
vote
1answer
34 views

Why do I need to reset user mapping always after restoring my DB

I have created a user using SQL Server 2014 management studio, I have mapped user to a couple of tables as db_owner. But after restoring my databases the mapping again cleared for the user and I need ...
5
votes
1answer
228 views

MAXDOP not working?

I wanted to test out MAXDOP on my computer. So I set MAXDOP to 2 for a specific query. However, when I looked at my logical processors in Task Manager as I ran the query, it looked like they were all ...
0
votes
0answers
25 views

Why is script with “ xp_cmdshell ” in comment failing with a transport level error?

When executing the following batch that is part of a large script: ... GO ----------------------------------------------------------------------------------------------- -- Removed the xp_cmdshell ...
0
votes
0answers
11 views

How to accomplish SQL Server 2012+2014 high availability [duplicate]

(Copied from here) Maybe I'm searching for the wrong thing, but I can't see how I can do this. I have two servers: Server A (has SQL Server 2012 installed) Server B (has SQL Server 2014 ...
0
votes
1answer
29 views

How to accomplish SQL Server 2012+2014 high availability

Maybe I'm searching for the wrong thing, but I can't see how I can do this. I have two servers: Server A (has SQL Server 2012 installed) Server B (has SQL Server 2014 installed) Server A provides ...
4
votes
1answer
97 views

Problem with pattern matching on unicode characters

I'm writing a piece of code that uses pattern matching on unicode characters but I'm running into an odd problem. Some characters work and some don't. DECLARE @Pattern nvarchar(50) = N'%[^a-z]%' -- ...
3
votes
0answers
47 views

Take action from extended event?

I've seen it mentioned a few times that you can configure an event session to take an action when an event fires. Does anyone have any information on how to do this? I know that you can use the ...
0
votes
1answer
55 views

Continuous replication between Oracle Database and Microsoft Azure SQL [closed]

Background info: Our core ERP has it's data on Oracle. Our own applications are Microsoft SQL based. Almost every application reads data from this Oracle database and usually there is some sort of ...
2
votes
1answer
43 views

Untraceable error importing Huge dataset with SQLCMD

I am currently doing an internship and I received a 42 gb ms sql-server import script. I tried to import the script using the ms SQLCMD tool all at once. It ran for 30 minutes and then I got the ...
2
votes
1answer
42 views

DLL Error While Creating an In-Memory Table in SQL Server 2014

While trying to create an in-memory table on a pre production box we get the following error. CREATE TABLE [stage].[MyData] ( [ID] [VARCHAR](50) COLLATE Latin1_General_100_BIN2 NOT NULL INDEX ...
1
vote
1answer
46 views

Server-wide Database Permissions in SQL Server

We have a SQL Server 2014 installation, which is accessible by a subset of our Active Directory users via Windows Authentication. Currently, when they log into the server for the first time they are ...
0
votes
1answer
37 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
1
vote
0answers
39 views

Backup terminating abnormally [closed]

Does anyone in the community know which SQL-Server 2014 CU will fix the issue of a backup terminating abnormally and causing a stack dump. This SQL-Server instance was an upgrade from 2012 to 2014 ...
5
votes
4answers
200 views

How to check if Alter view/stored proc script has run successfully

For the database deployments, I call all the db schema changes in a batch file and run them on the target database. Sometimes we have scripts for altering the views or stored procs. I'm wondering ...