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

learn more… | top users | synonyms

0
votes
0answers
6 views

Why are some of my migrated tables showing “The given key was not present in the dictionary” in WebMatrix's interface?

I'm having an issue while using the SQL Server Migration tool to convert Access accdbs into SQL Server 2014 Express. I am converting the tables using SQL Server Migration Tool and I have a connection ...
6
votes
2answers
379 views

Why is SQL Server 2014 consuming so much RAM with no active data stored?

I'm running SQL Server 2014 on my laptop along with a ton of other installed applications, from Visual Studio to video games. This is obviously not a production server, but for development and ...
-3
votes
0answers
27 views

Create database in SQL Server 2014 [on hold]

I have installed SQL Server 2014 on my laptop and I have not created new databases in SQL Server 2014 yet. Before creating a database, should I first create a private key and a certificate? If so, ...
0
votes
0answers
13 views

SSMS SQL Server 2014 - Selecting BackupSets for a Restore takes a long time

I'm having an issue with SSMS SQL Server 2014 (before and after SP1). When I go and select 'restore database' from the server and select a database, it just sits there and spin and spins. More than ...
0
votes
3answers
29 views

Merge replication throws PRIMARY KEY violation during the initialization of Subscriber

I am using SQL Server 2014 SP1 to set up merge replication on Windows 2008. The databases (Publisher & Subscriber) are restored from the production back up of SQL Server 2005 publisher database. ...
7
votes
3answers
508 views

Use 'default value' in table when NULL

I am building a config table and want one row to be the default value. For the example, I have a list table of all my databases and a msg table of my return values. In the msg table, I have one row ...
2
votes
3answers
64 views

Excessive amount of data received from server

We are having a problem with slow queries on a certain table. We tried some things with indexes but that didn't make any difference. Then we discovered that the amount of data being transferred was ...
4
votes
1answer
51 views

Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version

Tonight we upgraded our SQL Server 2012 (SP2+CU6) cluster with SQL Server 2014 Service Pack 1. On that cluster nodes, we have Native mode Reporting Services scale-out configuration. After in-place ...
0
votes
0answers
36 views

Problems with GO keyword [duplicate]

I have a query: DECLARE @str NVARCHAR(max) SET @str = 'SET QUOTED_IDENTIFIER ON' + CHAR(13)+ CHAR(10) + 'GO' + CHAR(13) + CHAR(10) + 'Select 1 from MyTable' PRINT @str EXEC (@str) It returns an ...
2
votes
0answers
26 views

Oracle 12c connection to SQL Server 2014

I have installed Oracle 12c on Centos 7 and I wanted to connect SQL Server 2014 using freeTDS so I installed: FreeTds. unixODBC. then configured odbc on the linux so when I run isql dsn username ...
1
vote
2answers
23 views

Multi server single database access [closed]

We have a database server (8 core + 32gb ram + 2tb hdd + gigabit network). SQL Server 2014 Enterprise Edition processor lic. We also have a web server (4 core + 16gb ram, 2tb hdd + gigabit network). ...
0
votes
1answer
48 views

Load data to datawarehouse via CDC [closed]

As I have surfed in net for moving data to warehouse I found some of the efficient techniques such as: CDC Trigger, DataTime stamp Partitioining. Among which I found the CDC as a better way we can ...
9
votes
3answers
291 views

Backup internals - What happens when a backup job is running - in terms of locking and performance overhead in SQL Server?

For MySQL I know the database is backed up table by table in SQL Statements, this results in locking and if you update columns while backing up you might end up in integrity problems. To my ...
5
votes
0answers
36 views

Error in partition switching in Sql Server 2014 when migrating a database from Sql Server 2005

I am migrating an old database from SQL Server 2005 to SQL Server 2014. This database has a partitioned table; a scheduled job periodically moves old data from the "online" table to the the historical ...
0
votes
0answers
19 views

Synchronization of DB

I have 2 databases and I need to synchronize data between them. I need to delete all the data from DB1 and then insert data to DB1 from DB2. What solution will you suggest drop all the foreign ...
3
votes
1answer
32 views

Should I use ReFS for a new SQL Server

We are in the process of building a new production Windows Server 2012 R2 server to run SQL 2014 Enterprise. There is a bit of advice on the internet that suggests for Server 2012 and SQL 2012 I ...
6
votes
2answers
77 views

Why does a Columnstore index build often wait on SLEEP_TASK?

I'm building a Columnstore index right now. The output from sp_whoisactive: This is a dev machine. Nothing else is running. The server has 8GB of memory available to it. The CPU is nearly idle. The ...
8
votes
0answers
85 views

SQL Server 2014 schema changes in 24/7 multi user environment

We have SQL Server 2014 Enterprise installed to run a database which should be available 24/7. Our database is huge enough (200gb +). Also we have a lot of services that hits our database every minute ...
2
votes
1answer
61 views

Update Cube data

We are using OLAP in our Project. We are facing a scenario where we need to update the cube with real time data on daily basis. I need some suggestions about an optimal way for updating the data in ...
0
votes
1answer
29 views

Post installation of SSIS for existing SQL Server instance with different build versions

I would like to install SSIS into existing SQL Server 2014 Fail-over cluster instance with latest cumulative update 7 which was applied. I know how to do it but I want to know if consistency of ...
2
votes
0answers
47 views

Where can I get error messages from SQL Server Auditing?

Where can I get information about the audit process failing to start? I'm setting up auditing on my MS SQL 2014 server. I've created an AUDIT and an associated AUDIT SPECIFICATION, but when I try ...
2
votes
0answers
27 views

What impact does UseMicrosoftUpdate have on the UpdateSource option when installing SQL Server 2014?

The ConfigurationFile.ini generated for SQL Server 2014 contains a new parameter that I cannot find documented anywhere - UseMicrosoftUpdate. What impact does this parameter have on the ...
1
vote
1answer
22 views

SQL Server pivot filter underlying tables by aliases specified in view

I have table structure as follows: CREATE TABLE [dbo].[Test] ( [ID] [int] IDENTITY(1, 1) NOT NULL , [ProductID] [int] NOT NULL , [CountryID] [int] NOT NULL , CONSTRAINT [PK_Test] PRIMARY ...
3
votes
1answer
45 views

Column Store Index over an clustered index (created when primary key is declared) - SQL Server

When a clustered index is created, the table itself becomes the index structure sorted by the index key. Imagine now that we have 5 columns in a table XPTO (a,b,c,d,e) and "a" is the primary key and ...
3
votes
1answer
26 views

Partially contained databases and Windows Logins - best practices?

In versions of SQL Server prior to 2012, in order for anyone to log in to a database using Windows credentials, you first had to create a server-level login, them map that login to a user for each ...
5
votes
2answers
283 views

Scripting the copy of SQL Server production database to test environment

We are introducing continuous integration on our project and we decided to automate the refresh of our test database instance with fresh production data. I'm currently looking for the best way to go ...
4
votes
1answer
77 views

Query Plans Change Performance Worse in SQL Server 2014

We recently upgraded our server from SQL Server 2008R2 to SQL Server 2014. We have a query that ran fine in 2008R2 but now in 2014 runs incredibly much slower and has a bad execution plan. I've done ...
0
votes
1answer
22 views

Querying XML with Unicode data

I'm trying to select attribute value from XML column using XPath with a parameter that can be a Unicode string. Could you please tell me how to make these two examples work? create table #test ( ...
0
votes
0answers
15 views

SQL Server Replication: Central Subscriber : Loading data in the same table

I have configured a Transactional Replication from Oracle (11g) to SQL Server 2014. I have many clients with the same database and we want to have a Multi-Publisher and only one Subscriber. The ...
1
vote
1answer
64 views

Intellisense is not working since upgrade to SQL Server 2014

We recently upgraded our production server to SQL Server 2014. This server hosts ~2200 databases. When I connect to it as sa with SQL Server Management Studio 2014 and I type queries, Intellisense ...
-2
votes
2answers
57 views

Deny database access to all users but sa/admin [closed]

How can I deny the access to a database for all the users except for the sa BY CODE? I know how to do it by using the interface in management studio, but I need to have it on the script.
-1
votes
1answer
68 views

Using different aggregate functions in a pivot

I have a table of data collected in the time as shown below. I would pivot them using different aggregate functions: average for C1 and sum for the others. How could I achieve it ? DECLARE @T AS ...
3
votes
1answer
74 views

Foreign keys become untrusted after bulk insert

In a SQL 2014 edition server (12.0.2430.0 - no SP1 yet) with a database in 2012 compatibility mode (working on getting it switched to 2014...) I have a handful of foreign key objects which are ...
0
votes
0answers
18 views

Loading subscription slow in SSRS

I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it ...
1
vote
1answer
134 views

Trigger Performance - 1 or 2 Triggers?

I have a question about triggers performance. CREATE TABLE [dbo].[_test]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Date] [DATETIME] NULL, [DateYearID] [INT] NULL, [DateQuarterID] [INT] NULL, [Date1] ...
0
votes
0answers
8 views

After merge replication setup, tables at subscriber not getting any data from publisher

I have created a merge replication setup through Replication Wizard. After sync, it is observed that the subscriber DB gets created with the exact tables in publisher as intended, but on the ...
1
vote
2answers
18 views

Error 3201 Operating system error 5(Access is denied.) Creating backup on network drive

Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\nst-shantanug\c$\Dummy Db Backup\dummydb.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 ...
3
votes
1answer
36 views

sql server 2014 unable to connect with Microsoft account or sa

I am running sql standard 2008 r2 on my box. and its been working great. I just installed sql server 2014 on my machine as a second instance. The service is running fine, but when I try to log into ...
0
votes
2answers
60 views

Encryption in SQL Server 2012/2014

We are hosting sharepoint DBs with AlwaysOn AGs and FCI. My boss asked me what the options for encryption are on the content database, it's backup files and at the column level? I have read about ...
5
votes
1answer
69 views

Warning for missing statistics in execution plan

I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. But if ...
2
votes
2answers
35 views

'sp_releaseschemalock' causing me a blocking issue?

why 'sp_releaseschemalock' causing me a blocking issue? what proccess that must execute sp_releaseschemalock or what function of sp_releaseschemalock? I have searched various forums or blogs about ...
2
votes
1answer
52 views

How to archive a whole database?

I have a database that is not going to be used anymore but that needs to be kept around for a long time. I'd like to remove it from the production system. My goal is to save storage space when ...
2
votes
1answer
69 views

Several Foreign Key and Cascade Delete SQL Server

In SQL Server 2014, I'm trying to add CASCADE DELETING (I want to set field to null actually, but is the same ) on 3 FK. If I add a Cascade Delete in one relationship, it works fine. If I add more ...
3
votes
1answer
97 views

MS SQL Server 2014 has vulnerabilities

I have some vulnerabilities in my MS SQL Server 2014: List of RC4 cipher suites supported by the remote server : High Strength Ciphers (>= 112-bit key) TLSv1 RC4-MD5 ...
0
votes
1answer
35 views

Replication Configuration

I had a SQL Server 2008 Express edition as a Default instance and I am having SQL Server 2012 Evolution and SQL Server 2014 Evolution are my named instances. When I was trying to configure ...
0
votes
0answers
16 views

How to Customized the Where Statement based on UDT

Goal: Display customized data based on customized where statement from UDT. The UDT is a parameter inside of a stored procedure. Problem: A parameter from a stored procedure is @communication ...
2
votes
2answers
63 views

migrate db's - best way to mirror or replicate a full database

I would like to mirror/replicate my databases to the cloud. The cloud is setup using VPN to my actual machine. I am a bit confused by the options I have and would like to get some light into it. My ...
1
vote
1answer
43 views

Migration from SQL Server 2012 Ent to SQL Server 2014 STD

We recently migrated from a traditional hosting environment with a back end of SQL Server 2012 ENT to an Azure VM running SQL Server 2014 STD. We did all the cool stuff with BPEs on SSD, etc. The ...
0
votes
1answer
33 views

backup to NAS using sqlcmd

I've been searching for possible duplicates before asking but can't find anything. The closest was Backup SQL Server To Nas but not exactly my case. We have a brand new Synology NAS configured, due ...
1
vote
2answers
43 views

Restore a newer filegroup backup

So this is my set up. In our data warehouse we have mostly tables that are filled with data from a ETL-process. We do not take backup of these tables since we have an option to do a full reset using ...