Questions tagged [sql-server-2014]

SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.

Filter by
Sorted by
Tagged with
0
votes
2answers
44 views

Getting Error 10054 after renaming the server

When I open SQL Server I have error 10054. Recently I changed the server name and I probably have this problem since. How can I solve it?
2
votes
2answers
24 views

Force update statements to take page locks in the same order?

I have two update statements on the same table that take page locks in different orders. This leads to deadlocks. Process A owns an update lock on page 1, and requests an update lock on page 2. ...
0
votes
0answers
21 views

Adding article to transactional replication causing blocking - schema mod lock

We have a transaction replication initialized from backup on a highly transactional OLTP database. When we add new articles(either from SSMS or using T-SQL) it causes massive blocking as the adding ...
0
votes
1answer
28 views

Retrieve by inserting ORDER of Merged table in SQL Server

I have a 3 tables such as "BASE_Customer", "BASE_Invoice" and "BASE_Payment" the below structure, Query: CREATE TABLE BASE_Customer ( CustomerId INT IDENTITY(1,1), CustomerName VARCHAR(45) ...
2
votes
1answer
3k 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 to ...
0
votes
0answers
36 views

How to Retrieve the order and Credit Debit and Balance from many tables

Tables are INVOICE, PAYMENT, RETURN_INVOICE, RETURN_PAYMENT, etc in my database, i want to retrieve data CREDIT, DEBIT AND BALANCE customer wise and order should be DATE wise and table insertion order,...
1
vote
1answer
40 views

why would a simple query have poor performance on MS SQL Server 2014 or 2014SP3 when on other versions it performs well?

I am running the following query on MS SQL Server 2014 (and also on 2014SP3) SET NOCOUNT ON CREATE TABLE #GUIDs( PartyNames_GUID UNIQUEIDENTIFIER NULL, Party_GUID UNIQUEIDENTIFIER NULL, ...
3
votes
1answer
179 views

sp_primary_keys_rowset is consuming a lot of CPU

I manage a database server that supports a C#/VB.NET application and we've had a lot of CPU usage problems. I am using the following dmv query from Glenn Berry at SQLSkills: SELECT TOP(50) DB_NAME(t....
2
votes
1answer
73 views

sp_Blitzcache doesn't return as many results as sys.dm_exec_query_stats for a given query

I am trying to find plans for a particular set of queries (those that update MyTable) using sp_blitzcache: EXEC sp_Blitzcache @SlowlySearchPlansFor = 'UPDATE [My Table]' this returns 3 results, ...
0
votes
1answer
105 views

Grant User permission to view XE results via sys.fn_xe_file_target_read_file

I need to grant a user (MyDomain\JohnSmith) permission to view one particular XE session results using sys.fn_xe_file_target_read_file I thought the best way to do this would be to encapsulate the ...
1
vote
1answer
35 views

How to Retrieve Credit Debit and Balance From More Than One Table in SQL Server

I have more than 1 table such as INVOICE, PAYMENT, RETURN_INVOICE, RETURN_PAYMENT, etc. i want to retrieve data CREDIT, DEBIT AND BALANCE each customer wise below are tables and insert query ...
1
vote
1answer
600 views

SQL Server hangs on index rebuild, works well after SQL service restart

We have a SQL Server 2014 enterprise cluster. Server 1 and Server 2. SQL Server is limited to 64GB of memory. We are using Ola Hallengren scripts for index rebuilding and optimizations once per week ...
1
vote
2answers
44 views

Measuring the need of Capacity or scaling SQL server

This would be more of General approach question rather than too technical: I have one of my application reach out to me wandering if we need to scale up SQL server in terms of CPU memory disk or CPU ...
4
votes
1answer
72 views

How to calculate required ressources from a baseline and what should be measured at all?

I have to deal with the following situatiuon: Currently we have 1 cluster with 5 nodes running 10 instances (SQL Server 2008 Enterprise edition), and 1 cluster with 2 nodes running 5 instances (SQL ...
1
vote
1answer
72 views

SQL Server 2014 AOAG Issue

Have a current AOAG setup with 1 database. Trying to add a 2nd database. It's in FULL recovery mode and I performed a FULL backup. When I try to add the database, it says I need a FULL backup and ...
0
votes
1answer
50 views

Sql Server 2014 update path advice

I recently inherited a SQL Server 2014 installation and I'd like to install updates. The virtual machine runs Windows Server 2016 standard. The server has about 50+ databases with 400Gb of data. I'm a ...
0
votes
1answer
73 views

Multiple databases in production

We have 3 level hierarchy in our business model. Entities at level 3 contains huge data (like dailyfacts tables). In our current DB architecture, we have one single database & all level 1 ...
3
votes
2answers
200 views

Replace a sequential set of numbers with special character

I have a varchar(200) column that contains entries such as, ABC123124_A12312 ABC123_A1212 ABC123124_B12312 AC123124_AD12312 A12312_123 etc.. I want to replace a sequence of numbers with a single * ...
0
votes
1answer
411 views

Reduce pre-allocated disk space

We have a reporting SQL (2014 R2 Enterprise) system with a Reporting and Staging DB on it. The reporting DB is pre-provisioned at 4 TB across 8 data files. Currently it contains just shy of 1 TB of ...
0
votes
1answer
81 views

Is it possible for a node to host multiple cluster in relation to Always On AG

In my example, I have 3 database servers with their own DR servers, own availability group, own clusters. Is it possible to setup another server which can be part of the 3 clusters and be a secondary ...
2
votes
1answer
1k views

SQLCMD -L Returns Bizarre Response Instead of Server List

I have a server with three installed SQL Server 2014 instances with Service Pack 1 (build number is 12.0.4213.0) installed. When I run SQLCMD -L on the server I am getting the bizarre response below. ...
0
votes
0answers
43 views

Quick question on Scalar UDF's

I am trying to browse online but can not get enough info on how to measure performance of scalar UDF's in SQL server 2014. Newer version yes i do see from plans we can get the same and newer dmv's ...
0
votes
1answer
81 views

Availability Groups Service Account has over 25000 sessions open

I am running Availability Groups on SQL Server 2014 with one database in the group. Today, the server was responding very slowly and when I got on the server I found that the Availability Groups ...
0
votes
0answers
16 views

SSIS code page / unicode conversion issue

We have a process that loads flat files into a staging table. The table has varchar(2000) columns, and the SSIS package is using code page 1252. We've noticed that some unicode characters are being ...
0
votes
0answers
48 views

Update stats as default or with a sample value

I have been reading many blogs on this and cannot come to a conclusion on update stats for VLDB;s On SQL server 2012Sp4 and 2014Sp2 we have databases over 15 TB with 4-5 tables covering most of the ...
2
votes
1answer
91 views

Snapshot Folder Location for Replication with Clustered Instance

I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box. Regarding the ...
1
vote
1answer
44 views

Replication fails with “Transaction log for database is full due to LOG_BACKUP”

Replication is failing with the subject error. The log_reuse_wait_desc states LOG_BACKUP. I have performed both database and log backups. After changing the recovery mode to single, performing ...
0
votes
1answer
323 views

SQL log directory has too much dump file

My SQL Server 2014 is automatically creating SQL dump file. It is generating automatically to take all the spaces and hangs over the database. Error: 8310, Severity: 16, State: 1. Cannot create (...
0
votes
2answers
109 views

Upgrade BI server to 2014 and stay on 2008r2 with the database engine server

We would be happy to upgrade our SQL Server environments to 2014, but we have a tight budget for next year. Our BI server (SQL Server 2008 Standard Edition, that is used only for BI purposes) is ...
0
votes
0answers
40 views

Range X-X lock on table with primary key value

I have a table with a primary key and clustered index. I am updating the table as below, update MyTable1 set SomeColumns = @SomeColums where MyPkColumn=@MyPkColumn I have another ...
0
votes
1answer
195 views

LogShipping replicated database

We use transaction replication to replicate our production database to another server(server 1) for reporting purpose. For a standby copy, we also logship the main database to another server (server 2)...
1
vote
2answers
57 views

Most efficient way to identify records with any number of key columns

I work with large third party data-sets. Long experience has taught me that it is a really good idea to give incoming lines of data a surrogate ID as soon as it enters my system so I can track it ...
1
vote
2answers
84 views

Unable to retrieve query plan of running query because of blocking

I am trying to troubleshoot a long running query in a stored procedure that around once every month randomly runs for ever and never finishes. Probably some plan caching issue. But the problem is ...
0
votes
1answer
82 views

Measuring Availability Group synchronization lag - Clarifications

Can I get some help on below As I have started and learning about the Measuring of Availability Group synchronization lag between replicas inclusive of BCP , I want to understand and learn that does ...
0
votes
1answer
57 views

How to fill/insert fake data into a MS Sql Server

I'm trying to test out some configuration settings for an MS Sql Server FILEGROUP and to do this I wish to fill my FILEGROUPdisk up so it will start populating the 2nd FILEGROUP. I've just created a ...
15
votes
3answers
2k views

Why is my EXISTS query doing an index scan instead of an index seek?

I am working on optimizing some queries. For the query below, SET STATISTICS IO ON; DECLARE @OrderStartDate DATETIME2 = '27 feb 2016'; DECLARE @OrderEndDate DATETIME2 = '28 feb 2016'; SELECT o....
0
votes
1answer
83 views

Figuring out if SQL Server database needs to be defragmented

I am tasked with looking at if a database in SQL Server 2014 needs to be defragmented. I ran DBCC SHOWCONTIG but am having trouble interpreting the results. use databasename; GO DBCC SHOWCONTIG ('...
0
votes
3answers
58 views

Table with image data base64 per row causes deadlocks/block

We have a table, CREATE TABLE [dbo].[MyTable]( [MasterKey] [uniqueidentifier] NOT NULL, [DetailKey] [varchar](100) NULL, [JSON] [nvarchar](max) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [...
4
votes
3answers
3k views

How to format documentation in MS_Description extendedproperties?

I'm using a 'MS_Description' extended property to document parameters in a stored procedure. This parameter's documentation requires more structure than just plain text. That is I would like to ...
0
votes
1answer
31 views

Recreate ##MS_SSISServerCleanupJobLogin## user as [##MS_SSISServerCleanupJobUser##

During an install of SQL Server 2014 Service Pack 3 we received the following error: Error: 15151, Severity: 16, State: 1. Cannot find the user '##MS_SSISServerCleanupJobUser##', because it does not ...
0
votes
2answers
53 views

Transaction Log Backup Affecting Applications Performance

We have a database around terabytes of data. We are taking FULL backup every week, differential backup daily and transaction log backup after every hour. Sometimes this transaction log backup takes ...
2
votes
1answer
44 views

What are the main principles of SQL Server AGs depending on WSFC?

We have WSFC with 4 nodes + a file share witness. Only nodes 1-3 have SQL server on it with Availability Groups (AGs), and node 4 is shut down gracefully. Node 1 has the primary AAG server. Now,...
0
votes
0answers
17 views

Full text sql server strange results

I have 2 documents let's say A ( word document) and b ( pdf version ) stored as blob and full text search enabled. I have 2 words which are present in both documents. Searching for the first word ...
2
votes
1answer
98 views

Replication recommendation [closed]

I am asked to investigate viability to use SQL Server replication technology for one of our upcoming project. In this project, basically there will be one central server located at corporate HQ (say ...
3
votes
1answer
809 views

File share witness vs 3rd Node for WSFC + AG with only 2 nodes?

I am migrating from Mirroring to AGs on SQL Server 2014 / Windows 2012 R2. I will have a 2 node cluster. I need this cluster to be online at all times for a production environment. I am reading ...
0
votes
0answers
21 views

Conflict Viewer in merge replication

i created merge replication on sql server 2014 Enterprise edition and i saw some conflicts in conflict table but when i opne conflict viewer it showing below Error before this it is working fine and ...
0
votes
1answer
77 views

Unable to get actual execution plan for SQL Server 2014 SP3

I was reading this blog post https://techcommunity.microsoft.com/t5/sql-server/using-xevents-to-capture-an-actual-execution-plan/ba-p/392136 and based on same created extended event CREATE EVENT ...
0
votes
0answers
14 views

One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error [duplicate]

We have a production server error causing replication agent got failed and subscription became inactive. When I tried to restart synchronizing process, it is getting failed. Should I delete/drop the ...
-1
votes
1answer
18 views

SQL server license has expired and I am not able to log into the server now [duplicate]

I need to take backup but I am not able to login due to expired license
0
votes
0answers
17 views

Does SSRS report user needs database level permission?

I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...

1
2 3 4 5
50