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

learn more… | top users | synonyms

0
votes
1answer
27 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
22 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
0answers
22 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
7 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
35 views

Processors: E5-4620 v2 vs E5-2620 v3 [on hold]

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 ...
0
votes
0answers
24 views

Why do I need to reset user mapping always after restarting PC?

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 restarting my PC the mapping again cleared for the user and I need to set ...
5
votes
1answer
205 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
15 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
23 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 ...
3
votes
1answer
89 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
46 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
43 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
40 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
38 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 ...
0
votes
1answer
43 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
32 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 ...
0
votes
0answers
100 views

Insert into multiple tables using a single stored procedure [closed]

I have four tables, in all the four tables I have similar columns. I want to make an entry into each table using a single stored procedure. I have created a user defined table type: CREATE TYPE ...
1
vote
0answers
34 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
168 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 ...
1
vote
1answer
67 views

Where has STATMAN gone in SQL Server 2014?

So we've recently upgraded our environment to SQL Server 2014 (Enterprise on CU5) and are having some problems diagnosing performance issues, compounded by the problem that we no longer seem to be ...
1
vote
1answer
33 views

MS SQL Server CPU load goes up dramatically when turning on 2014 features by setting compatibility level

I'm running some Microsoft SQL Server 2014 load testing on a decently spec'ed machine. I'm certainly not an expert on the SQL Server tuning specifics, but with the bits an pieces I've gathered from ...
0
votes
1answer
28 views

When does a port get assigned if SQL Server is set to TCP Dynamic Ports

I'm trying to determine when a dynamic port is assigned to SQL Server. If the TCP/IP Properties have the TCP Dynamic Ports enabled, does that port get assigned at the time the Server is installed or ...
3
votes
1answer
76 views

Will dropping text column on SQL Server 2014 lock the table?

I have been tasked to drop a text column from a production SQL Server 2014 table. The table contains 61,683,821 records. Question: will dropping the column lock the table (or cause similar ...
1
vote
1answer
46 views

Can I import a specific vssettings file when launching SSMS?

In the interest of disambiguating between when I am connecting to non-production and production, I utilize vssettings for a specific theme in Management Studio (fire-and-brimstone style when in prod, ...
1
vote
1answer
37 views

Store extended properties and apply to another copy of the database

I'm using SQL Doc to document a development copy of a database. SQL Doc uses extended properties to store user entered values. At some point, I would like to copy those extended properties to the ...
2
votes
1answer
57 views

Transaction with multiple SQLCMD calls in a batch file

Is there a good way to do something like the following? SQLCMD -S %SERVER% -E -Q "BEGIN TRANSACTION" FOR %%f in (script1 script2 script3) do ( SET CURRENT_SCRIPT=%%f SQLCMD -S Localhost -E -b ...
1
vote
0answers
61 views

The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT'

I have a question about XTP_CHECKPOint. I'm using SQL Server 2014. I have a database that is in SIMPLE recovery model mode. It is also being replicated. There are no open transactions. I've run DBCC ...
7
votes
1answer
136 views

High PAGELATCH_* and WRITELOG waits. Are they related?

We are seeing very high PAGELATCH_EX and PAGELATCH_SH wait types along with high WRITELOG waits. I've diagnosed the query causing the PAGELATCH waits and can eliminate them by reducing the insertion ...
0
votes
1answer
58 views

Is it possible to install SQL Server 2014 Enterprise on Windows 7?

I'm planning to install SQL Server 2014 Enterprise Edition on a 64bit HP workstation. I read the SW and HW requirements on: https://msdn.microsoft.com/en-us/library/ms143506.aspx And according to it, ...
0
votes
0answers
50 views

SQL Server 2014 Management Studio cannot design table

I am attempting to design a table via the right click menu on the table After I choose design I immediately get this error Object reference not set to an instance of an object (SQLEditors) ...
2
votes
1answer
16 views

A workaround for restoring HeirarchyId in SQL server 2014

After installing VS 2015 CTP 4, HierarchyID stopped working in SQL Server 2014. This is the bug listed here. I am looking for a workaround. To that end, I have tried reinstalling everything ...
0
votes
1answer
43 views

SQL Server Express 2014 Installation directory

I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked to select the installation folder of SQL Server. ...
0
votes
0answers
11 views

SQL Server 2014, Volumes in Resource Governor

I'm looking at Resource Governor on 2014 and how it relates to volumes. I can see where to set up MAX|MIN IOPS PER VOLUME on a resource pool. That's not keyed by volume, however ...
1
vote
2answers
323 views

Installing SQL Server 2014 Express fails with error “ Could not find the Database Engine startup handle.”

Let me start by saying I am not a DBA, and I actually don't have alot of database admin experience. I'm just a guy trying to run SQL Server on my local machine to build some simple .NET applications ...
3
votes
2answers
89 views

What perfmon counters should I use to get the fastest restore possible on an idle system?

I have a development VM running Windows 2012-R2 and Sql Server 2014. I have one disk from a SAN holding the OS and SQL. My backup file is stored locally on the disk. I want to restore database as ...
2
votes
0answers
46 views

Database corrupt after restore and upgrade on another instance

Just wondering, if someone faced the same issue. We have got a SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) and there is a process of backup on MSSQL Server 2008 R2 and restore on ...
0
votes
0answers
102 views

Unable to start a nested transaction for OLE DB provider “SQLNCLI11” for linked server

I have two linked servers and want to create a store procedure that simply SELECT data from one table from the first server and INSERT the data in other table from the second server. The procedure ...
1
vote
1answer
81 views

Table size is not changed after new column is added

I am trying to check how the table size is going to be increased after adding new column with default values. I use the following default values: NULL, ''(empty string) and some text(some random ...
0
votes
0answers
48 views

SSMS IntelliSense doesn't work on particular database

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center, so far I found one database (database A) doesn't have IntelliSense working, e.g. typing: SELECT ...
-2
votes
1answer
44 views

Sql server sqllogship.exe…full docs?

Are the internals and all the logic of sqllogship documented? Eg so i can manage it directly, without the wizard? Or replace it with my own tool? I find this syntax (which is real, from a live SQL ...
1
vote
1answer
59 views

SQL Server: Understanding log ship utility: sqllogship.exe

This is my first time using the stock SQL log shipping setup. The copy operation is failing. I think I see the issue. I need to change the unc: '\\Win-2ooc0jplr5k\sql\logbackup\', Backup ...
0
votes
1answer
53 views

SQL Server Import/Export: cannot copy geo columns

I'm trying to copy data from a SQL Server 2014 Express database to a SQL Server 2008R2 Express database. Compatibility level for the 2008R2 Express database is set to 100. As soon as I hit Next in ...
2
votes
1answer
731 views

SQL Server service account Windows privileges and rights

My question is, if you create a new domain user account for each of the SQL Server processes, what permissions should be set for each account? Or does the SQL configuration manager actually take care ...
4
votes
0answers
114 views

SQL Server Management Studio 2014 Backup - Set Property Devices Error

I recently upgraded my local SQL Server to Version 2014, which also installed the SSMS 2014. When using SQL Server Management Studio 2014 to create a backup (both local and remote, Server Versions ...
4
votes
1answer
96 views

On Prem SQL Server: Log shipping via Azure Blob Storage: Possible?

This is about on premise, regular SQL Server 2014, Standard edition. This is NOT about SQL Azure. The only part of Azure in this conversation is Azure Blog Storage, as a transport for some bits (SQL ...
2
votes
1answer
102 views

CAST SUBSTRING to NUMERIC SSIS

I have a fixed width text file that I am bringing in through SSIS. As part of the input into SQL Server I am grabbing a string of characters and trying to CAST them as numeric in a derived column. The ...
1
vote
2answers
64 views

Query cache size in SQL Server 2014

Is there a way to define/set/increase the query cache size in SQL Server 2014 similar to what MySQL has http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html
1
vote
0answers
48 views

Setting up a new db-server with same name and ip. Backup/restore or detach/attach

I'm planning to set up a new Win 2012 server, with SQL server 2014 standard. This server is going to replace our current server, Win 2008R2, with SQL server 2008R2. The name and ip is going to be the ...
0
votes
2answers
142 views

SQL Server 2014 Latest CU / Service Pack

Where can you find the latest SQL Server 2014 Cumulative Update (CU) and/or Service Pack? Note: I added this question and answered my own question to make this easier to find for others in the ...