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

learn more… | top users | synonyms

1
vote
0answers
9 views

SQL Server 2014 AG Listener

I have built a two node SQL Server 2014 Always On cluster on the same subnet. I need to create two availability groups/listeners in the same instance for two sets of databases. Do I need two separate ...
0
votes
0answers
14 views

Getting issue while creating SQL Server Agent job

Getting error while copying SQL Server Agent job from SQL Server 2012 to SQL Server 2014. I restored databases in SQL Server 2014. But still facing below error. Msg 14234, Level 16, State 1, ...
2
votes
0answers
11 views

SQL Server 2014 vs Amazon Redshift performance

I have heard the SQL Server 2014 using clustered columnstore indexes is second only to HANA in performance. Does anyone have any metrics that compare RedShift to SQL Server 2014 for query performance ...
2
votes
1answer
18 views

SSAS and SQL Server on the same server

I have a server that is primarily used for SSAS, heavy processing, however I have SQL Server on it alongside SSAS, but I don't want sql server to hold ssas back. I have set the SQL Server MAX memory ...
5
votes
2answers
83 views

sql server max memory includes SSIS?

I have installed 2 instances of sql server plus SSIS on the following server. Note the amount of RAM is nearly 384 GB And this is the max and min memory settings that I have applied to my 2 ...
1
vote
1answer
17 views

The connection is broken and recovery is not possible - sql server error

I am having the following sql server error, while creating tempDB files. Any ideas? The connection is broken and recovery is not possible. The client driver attempted to recover the ...
2
votes
1answer
36 views

What do the HT* wait types mean? (HTREPARTITION, HTDELETE, …)

A big query is running right now. The result of a batch mode hash join that spills to disk is streamed into a temp table using select into. The query is showing wait types HTDELETE and HTREPARTITION ...
0
votes
1answer
19 views

Sql Server Licensing & Clustering for AlwaysOn

For Sql Server 2014, reading these MSDN link and Microsoft PDF file about licensing, created a couple of questions. For AlwaysOn do we need WSFC or FCI? How are WSFC and FCI different? If we only ...
1
vote
1answer
15 views

FIPS 140-2 Compliance

Just wondering if anyone has configured FIPS? Based on the information I found in the Microsoft support pages, it would seem FIPS is configured at the Windows level only and that all instances on my ...
1
vote
0answers
10 views

Domain Admin on AWS lacking user rights to edit the top 200 using the Management Studio interface

I setup an application + SQL Server on AWS. Everything works fine my SQL User can read/write to any table. Now I connected to the SQL Server using my domain admin account using windows authentication ...
3
votes
2answers
63 views

Does SQL Server prioritize select and update statements?

Assume that SQL Server received both select and update statements to the same table at the same time Do any of them get prioritized? I know that select statements are delayed until update completed. ...
0
votes
1answer
41 views

How to configure SQL Server Port on multiple instances?

I have a server called SQLDWDEV01, with 2 instances: default and UAT. To the default instance that uses port 1433, everything works fine. However, the UAT instace, which I configured according to ...
1
vote
1answer
29 views

when installing sql server 2014 SSIS, what are the meaning of “authentication level”?

After installing SSIS 2014, it is the time to deal with the permissions. when dealing with the DCOM Config (control Panel->Administrative Tools-> Component Services) You want to set up the ...
1
vote
0answers
21 views

How do I convert a datetime column from SQL Server 2014 to Oracle 11g using ogr2ogr? [on hold]

I have a table in SQL Server 2014 with two columns, one called username with data type nvarchar(50) and another datetime column called currenttime. I've got just test data in there - two rows: ...
2
votes
1answer
27 views

TDE restored DB encryption state

I've been looking into using TDE in our SQL Server 2014 environment and have a few questions. I think I have a fairly solid grasp on the numerous "how-to's" that are out there on initially ...
0
votes
1answer
27 views

Can SQL Server 2014 schema be defined using ODBC?

I am trying to use the ODBC driver for SQL Server 2014 to export data from an Autodesk Revit 2015 model to a database. However, I would like to export to a default database (e.g. db1), creating a new ...
11
votes
3answers
960 views

Is a weekly rebuild of indexes a good idea? [duplicate]

We had a SQL expert suggest rebuilding our table indexes weekly. We're currently doing this Saturday night and it causes lots of timeouts during the rebuild process. I'd like to avoid the timeouts ...
3
votes
2answers
95 views

How to install SSIS on SQL Server 2014?

I am installing SQL Server 2014, including SSIS, on a Windows Server 2012 R2 machine. From this link: https://msdn.microsoft.com/en-us/library/ms137861(v=sql.120).aspx ssis uses port 135 which should ...
3
votes
1answer
27 views

Create Linked Server to AlwaysOn Availability Group Listener

I have an alwayson availability group setup using SQL 2014 and Windows Server 2012 R2. There are 3 nodes in the group. The SQL Service is running as a Managed Service account on each node (1 MSA for ...
3
votes
1answer
25 views

Microsoft Help Viewer in ssms 2014 doesn't open local documentation

I have Visual Studio 2013 installed I have downloaded all documentation I need installed via visual studio. I can open it with the command "C:\Program Files (x86)\Microsoft Help ...
2
votes
0answers
18 views

SQL Server 2008 Replication “between retries” or “worker thread no available”

All our existing servers are in SQL 2008 and I am in the process of upgrading to SQL 2014 and as well moving SAN to different SAN storage. As part of it I have to upgrade my distributor. We got ...
0
votes
1answer
20 views

Safe delete Transaction Log in SQL Mirroring scenario

We are using SQL Server Mirroring with a witness (High Safety mode) and we see the transaction log on the Principal Server has grown around 20 GB in few weeks. I looked around on SO and google for ...
3
votes
0answers
49 views

Could you please describe how SQL Server 2014 do cardinality estimation of Join predicate?

I found the information about CE of single filter predicate, multiple filter predicated but I have not found anything about JOIN predicate.
1
vote
0answers
25 views

Mysteriously Updated Rows

Yo, heres the trigger causing the Problem USE [SalesDb] GO /****** Object: Trigger [dbo].[trgAfterUpdate] Script Date: 7/16/2015 6:34:01 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
1
vote
2answers
59 views

Restore SQL Server 2008 database onto SQL Server 2014?

I have a backup file that I need to restore daily on schedule based. But the backup file is from SQL Server 2008 and restore destination is SQL Server 2014. And also the backup file is from cross ...
0
votes
0answers
21 views

windows 2012 r2 how to test drive is 64 or 32 bits

I am following a pre-installation document for sql server 2014 on windows server 2012 r2 one of the items is about the storage, it needs to be 64 bits. Confirm Storage is Set Correctly Confirm that ...
1
vote
0answers
11 views

Extracts all characters before the 3rd occurrence of a delimiter in SQL Server 2012 [migrated]

For example the string is AL*12345*B001*1 Please help me get the result to be AL*12345*B001 (all characters before the third '*' delimiter. Below I'm using a reverse to look for the last delimiter ...
1
vote
1answer
18 views

Get new ID for inserted ID that comes from another table?

Simple question but I'm a newbie. I have existing orders table 'Orders'(table1) and it has an OrderNumber as a column and the orders are number up 156. I have a existing table called 'orders'(table ...
1
vote
0answers
11 views

Lookback Query utilizing Change Data Capture in SQL Server 2014?

I'm using SQL Server 2014 to maintain a small database and while looking for a way to keep a History of my Data I came upon the Change Data Capture Mechanism. My question now is if there is an easy ...
2
votes
1answer
53 views

Process Data cube from job on SQL server

I have an SQL Server Agent job on server(X) that has a step that is supposed to process a data cube on a remote server(Y). Whenever I run the job it fails and says that server(X) does not have ...
0
votes
1answer
38 views

Failed SQL Login - Source server same as destination cannot locate SPID SQL Server 2014

Bit of a confusing one here. We are getting repeated messages in the SQL Server error log as below for a SQL Server instance: NT AUTHORITY\SYSTEM Reason: Failed to open the explicitly specified ...
1
vote
1answer
28 views

SQL Server full text search query takes way too long to execute

I've got query snippet as follows: SELECT * FROM CONTAINSTABLE(dbo.Analysis, *, 'FORMSOF(FREETEXT, "historic year-on-year exchange rates forecast year-on-year exchange rates")'); I'm running it on ...
4
votes
0answers
67 views

The curious case of HADR_SYNC_COMMIT waits

We are noticing an interesting pattern for HADR_SYNC_COMMIT waits in our environment. We have a three replica; one primary, one sync secondary and one async secondary in a datacenter and we just added ...
1
vote
1answer
49 views

Oracle 12c Client to 10g Server (OPENQUERY)

Scenario: We currently have a SQL 2008 R2 server (with Oracle 10g Client) using OPENQUERY to return data from an Oracle 10g database. Problem: We would like to upgrade to SQL Server 2014 SP1 (with ...
2
votes
1answer
49 views

SQL Server process only using half of the memory on host

We doubled the memory on host that has a SQL Server Enterprise 2014 instance on it. After a reboot of the server we noticed that the SQL service is only using half of the memory. A little background ...
5
votes
1answer
117 views

Adding a local user account into SQL Server

I have a (developer) instance of SQL Server 2014 running in my machine. For quick background I'm on a small network like this: Workgroup: HOME Users HOME\PCA HOME\PCB HOME\PCC I'm HOME\PCA. Now ...
0
votes
1answer
49 views

Problem trying to force the use of a filtered index

I was trying to do some testing on filtered indexes yesterday and created a fairly simple situation: CREATE TABLE IndexTest ( ID INT NOT NULL IDENTITY(1,1) CONSTRAINT pk_IndexTest PRIMARY KEY, ...
0
votes
1answer
11 views

How do I figure TOTAL DURATION for specific group

I have a table with CARD # and REDEEMED DATE. I am trying to figure out the total duration (in minutes) for each CARD #. I am using Microsoft SQL Server 2014
3
votes
1answer
75 views

Service Credentials to use in AlwaysOn Availability Groups?

When using AlwaysOn Availability Groups does each SQL Instance need to use the same service credentials? We are setting up a new SQL2014 deployment and will be using AlwaysOn. If I have 2 SQL servers ...
0
votes
1answer
15 views

SSAS (Analysis Services) 2014 - Cumulative Update 1 for SP1

I just recently applied CU1 for SQL Server 2014 SP1 (http://support.microsoft.com/en-us/kb/3067839) to my development workstation and one PROD server. Analysis Services continues to report itself as ...
0
votes
0answers
29 views

Property error when linking SQL Servers

I'm running into an issue linking SQL servers. The servers I have are: Server A - SQL Server 2008 R2 Server B - SQL Server 2014 I can set B as a linked server on A with no problem, but setting up A ...
1
vote
1answer
78 views

Missing Index Not Displaying In Execution Plan

I recently installed SQL Server Management Studio 2014 (Developer Edition), and I noticed that I am no longer seeing the missing index feature. What I have done: Ran the workload through Database ...
1
vote
1answer
101 views

should we keep the log file or the data file on the fastest drive?

SSD = solid state drive We have a specific question about tempDB performance on server CRM01 (Marketing CRM server - running large queries): On CRM01, tempDB data and log files reside on the solid ...
0
votes
0answers
12 views

Cannot upgrade from SQL Server 2008 R2 SP2 standard edition to SQL Server 2014

When I run the upgrade wizard, it says "the specified edition upgrade is not supported". I have SQL Server 2008 R2 standard edition (SP2) and it has been added in the supported list on MSDN website. ...
1
vote
0answers
19 views

Why is SQL Server 2008 Installation Center installed with SQL Server 2014? [closed]

just for curiosity: Why is SQL Server 2008 Installation Center installed with SQL Server 2014? It does not seem to be of any use. It appears in the Start menue of Windows and there are also a number ...
1
vote
0answers
14 views

SQL Server Compact Provider in SQL Server 2014 for OPENROWSET

I'm unfortunately well aware from many questions asked previously that SQL Server Compact 4 can no longer be opened as an object in SQL Server 2014 Management Studio. However I can't find any ...
3
votes
1answer
36 views

Importing via sqlcmd errors out

PS C:\Users\administrator.INTERNAL\Desktop> sqlcmd -S SQLMAIN\MSSQLSERVER -i rdmdb.sql Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SQL Server Network Interfaces: Connection string is ...
4
votes
1answer
75 views

Exporting SQL Server DB from my laptop to AWS RDS

I am following this tutorial from AWS to export a SQL Server database that currently sits on my laptop to Amazon Web Services RDS. In particular I am trying the Generate and Publish script wizard ...
2
votes
1answer
49 views

What is limiting the batch requests per sec

We have a newly created azure sql server 2014 instance. The specs for the server are as follows Pretty bare bones I know. Since this is just a testing server, we have opted to set up the data files ...
0
votes
2answers
42 views

ODBC Driver tracing not capturing any logparser events

I have enabled Driver Tracing using these directions. I am running SQL Server 2014, which uses the 2012 native driver. I run the start batch file then the following LogParser command: ...