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
1 vote
1 answer
43 views

Transactional Replication row data inconsistency

I am seeing data inconsistency in row count Transactional Replication. Subscriber is having 20 rows extra. The agent profile is used continue on data consistency error. The replication is working fine....
Raja_mssqlDBA's user avatar
0 votes
0 answers
28 views

Reinitialize Transactional replication which is 5 months behind

I have given new server recently and found one of of the publication - subscription is out of sync and Distributer agent stopped as well. After checking with the team, looks like they wanted this and ...
Raja_mssqlDBA's user avatar
0 votes
0 answers
16 views

Move Replication snapshot folder and Distribution database from C to another drive

I am planning to move Replication snapshot folder and Distribution database from C to another drive. Following is what I read blog post. My setup - Both Distributor and publisher are in same server. ...
Raja_mssqlDBA's user avatar
0 votes
0 answers
17 views

Transactional replication initialize from database snapshot spare file?

I would like to know, is it possible to initialize transactional replication from database snapshot spare file for existing replication which is inactive and expired default more than 72 hours. I have ...
Raja_mssqlDBA's user avatar
0 votes
1 answer
49 views

Joining SQL 2016 to a one-node cluster that has SQL 2014 installed

I have currently 1-node (it's a lab) Windows 2012R2 cluster with SQL server 2014 installed (patched to the last patch based on sqlserverupdates.com). The goal is to upgrade the cluster to something ...
Sranda's user avatar
  • 347
0 votes
1 answer
37 views

Why do I need to create endpoints after configuring a aoag?

So recently on new servers we are building, after creating the aoag and add servers, they don't go in sync, and I need to manually run this: CREATE ENDPOINT Hadr_endpoint STATE=STARTED AS TCP(...
Racer SQL's user avatar
  • 7,374
0 votes
0 answers
51 views

Performance issue on same identical database with same execution plan

Need some help advise on one of the issues that we have bee working on. For one of our SQL databases (SQL2014) we use database mirroring ( i know its old but we are working on migration) and there is ...
Newbie-DBA's user avatar
0 votes
0 answers
49 views

SQL Server unexplained network traffic gaps in traced events

This appears to have started happening a week, maybe two weeks ago. Essentially, we cannot figure out whether it is the server or the client that is periodically pausing between SQL statements. In the ...
孔夫子's user avatar
  • 4,310
0 votes
0 answers
35 views

SQL Server SSIS Data Flow Task: How to enable transactions between two machines while bypassing DTC, if one machine does not have DTC support?

A bit of a conundrum here; I'm trying to survey what are my best to worst-case options. For a given SSIS package, I have a Data Flow Task which connects via OLE DB for both the Source and Destination ...
user3621633's user avatar
0 votes
1 answer
177 views

No catalog entry found for partition ID in database 7

I would like some help to fix the database problem. I went to restore a database and I couldn't, so I executed DBCC CHECKDB (N'DATABASE_NAME') and the following result is displayed: CHECKDB found 0 ...
Chris Samaritano's user avatar
0 votes
0 answers
28 views

Session locking nonstop other sessions

so Suddenly we have a NULL session locking everything else. the rows goes on if the server are left for some minutes running. DBCC INPUTBUFFER returns "No Event". sp_who2 says background,...
Racer SQL's user avatar
  • 7,374
2 votes
1 answer
163 views

Cursor loop all users all databases

so I'm messing around tyring to code a cursor to loop through all users and drop them for all databases. this is the code that obviously doesn't work, because i'm cracking my head on the logic to grab ...
Racer SQL's user avatar
  • 7,374
2 votes
1 answer
259 views

Adding a leading zero to single digits in a comma separated string of numbers

I have a table with two columns. ID and VALUE. The VALUE column contains a combination of a string of numbers from 1 to 45. EG :- ID VALUE T123 1,6,7,9,17,22,43 T456 2,3,5,7,8,13,28,32,41 T789 ...
UK1539's user avatar
  • 25
0 votes
1 answer
37 views

How to Schedule Run query hourly

I have MSSQL Server Express 2014 Edition. Is it possible to schedule a query to be run by hourly? As I want it to clean up the audit trail records. Please kindly assist me.
Nadh's user avatar
  • 1
3 votes
2 answers
291 views

Merge join asks for seemingly unnecessary sort before joining

I use one table to update another table. Both the tables have a clustered index where the first 4 columns are the same type of data. CREATE UNIQUE CLUSTERED INDEX [...
KHP's user avatar
  • 65
0 votes
0 answers
146 views

SQL Database not working after OS upgrade

Let me begin by saying I’m a noob with anything SQL. So I was tasked to upgrade the OS on a VM running Server 2012 R2 with SQL Server 2014 Services running on it. Mainly, there is an internal website ...
Lin's user avatar
  • 1
0 votes
0 answers
41 views

Lost SQL 2014 installation media and needing to install on new server

We have an on-site installation of SQL 2014 that we want to move to a new server. We are no longer engaged with the company that did the original installation. We can not find any media/installation ...
Joseph St. John's user avatar
0 votes
0 answers
248 views

Issues deploying SSRS related to permissions

I'm tryingto deploy a package (from a Visual studio 2017 ) and I'm receiving this error: TITLE: SQL Server Integration Services A .NET Framework error occurred during execution of user-defined ...
Racer SQL's user avatar
  • 7,374
3 votes
1 answer
172 views

Trace database query

I need an advice. I would need to trace one particular procedure in SQL Server. It happens to me that one procedure ends up with a timeout and I need to find out which select, insert or update this ...
Jan Kůst's user avatar
0 votes
0 answers
115 views

Linked server query occasionally returns results slowly

I have an unfortunate situation where I need to pull a next-number from a table from both a local and a linked server. To do so, I've created a stored procedure to return the result. When I execute ...
Dave.Gugg's user avatar
  • 294
1 vote
0 answers
122 views

SSRS 2014 Report parts and Subreports redirects to http: instead of https:

I am looking to find a solution for the SSRS 2014 server redirects to http url instead of https for all the subreports and other report parts like subscription , security , datasources etc .  What I ...
divyasridhar's user avatar
0 votes
0 answers
63 views

Cannot run a Linked server to a AASA instance using any ther login that it's not a windows acc

I created a process to run some validations on a SSAS instance from my SQL Server instance. It works great with my windows account, but using Local accounts (user/pass) I got the famous error: Cannot ...
Racer SQL's user avatar
  • 7,374
2 votes
2 answers
602 views

Security Considerations/Risks/Best Practices for Enabling CLR Integration (Assemblies) for SSIS Catalog

The major pre-requisite in utilizing SSIS Catalog is enabling CLR Integration. The instance in question is running SQL Server 2014. I'm looking for feedback and resources I can mine which specifically ...
user3621633's user avatar
10 votes
1 answer
1k views

SELECT Statement with , * in column list is faster than same statement without *

Situation When querying a database with a SELECT statement with a defined set of columns, the results are received in around 21 seconds. If there is an additional asterisk (, *) at the end of the list ...
John K. N.'s user avatar
  • 17.4k
0 votes
1 answer
63 views

Are SQL Server 2014 Security Updates Cumulative

I know this question may have already been partially answered. My questions are as follows. Are SQL Server Security Updates cumulative ? On https://sqlserverupdates.com/sql-server-2014-updates/ ...
steve's user avatar
  • 47
0 votes
1 answer
169 views

How does SQL Server know not to execute Anchor element in Recursion CTE for 2nd Iteration / 1st Recursion?

I've been reading up on the inner workings of CTE Recursion and I'm still not quite sure how SQL Server is implementing the Anchor element in their source code and how SQL Server Query Execution ...
user3621633's user avatar
3 votes
1 answer
123 views

Improving query response speed when joining a non-spatial table with a spatial table on a non-spatial column

I have a table of frequently updating events that affect certain geometries. The geometry areas are fixed, but there may be an event affecting multiple areas at once, so there's a many-to-many ...
wxdan's user avatar
  • 33
4 votes
2 answers
1k views

Is SQL Server able to use internal parallelism for an update statement?

I am struggling to find the best way to migrate some "varchar" columns to "nvarchar". One of the options i am using is to add new nvarchar column(s) then update the values from the ...
Edward Hayrabedian's user avatar
1 vote
1 answer
546 views

Enforce password policy after creating a login

Lets say I created an SQL login with a password that does not adhere to the AD password policy without checking "Enforce password policy" option. After creation, I go back and check the box....
DMDM's user avatar
  • 1,738
2 votes
1 answer
72 views

Forwarding SQL Server Error Logs to Another Server

I wasn't sure where to post this question. If this is not the right place, kindly point me in the right direction. We have SQL Server 2012 and 2014 on-prem. My intention was to forward the error logs ...
Nina G's user avatar
  • 123
0 votes
0 answers
101 views

Is there a built-in field or other way to put the rdl date/time stamp on a SSRS report template?

I've put the built-in fields for the report server and the report name at the bottom of my reports. I want to also put the date/time stamp of the report's .RDL file on it so we can see if the report ...
Tim Johnson's user avatar
0 votes
0 answers
299 views

SQL Server Install/Uninstall Freezes

I'm running Windows Server 2019 Standard. All Windows updates have been installed. Chckdsk, sfc, and dism have been run and found no problems. Server has been restarted. I'm trying to uninstall some ...
socaljoker's user avatar
0 votes
2 answers
227 views

"last time index was used" showing many columns. "not used indexes" showing one column, with 0 reads

So I got this query to check unused indexes: SELECT OBJECT_NAME(s.object_id) AS 'Table Name', i.name AS 'Index Name', i.index_id, user_updates AS 'Total Writes', ...
Racer SQL's user avatar
  • 7,374
2 votes
1 answer
647 views

How best to resolve excessive Transaction Log size

I understand excessive Transaction Log growth is a very common issue, and has been asked and answered many times. (Why Does the Transaction Log Keep Growing or Run Out of Space?) I also know the exact ...
Dave Harding's user avatar
1 vote
1 answer
73 views

Can't drop and recreate FK in SQL

I have a DBCC check that will always fail with the following error: Msg 8992, Level 16, State 1, Line 2 Check Catalog Msg 3853, State 1: Attribute (referenced_object_id=517752334,key_index_id=1) of ...
Dominic Legendre's user avatar
0 votes
0 answers
92 views

SERVER_OPERATION_ENCRYPTION_LEVEL missing from SSISDB catalog_properties

I'm using MSSQL 2014 (build 12.0.6439.10, named instance) with SSIS 12.0 and trying to execute a package that I've successfully imported into the SSISDB catalog, but when I attempt to run it via a SQL ...
RollingDBA's user avatar
0 votes
0 answers
238 views

SQL Server FILESTREAM Object Garbage Collection in a Always On Availability Group

We have a production SQL Server 2014 running on FILESTREAM with Always On Availability Group. It has been about 4 years since the servers go live. Recently, we encounter a hard disk space issue on the ...
L.C. Tan's user avatar
0 votes
1 answer
32 views

How to model/query this data problem? Is this a timeseries issue?

We have a large amount of data in a MS-SQL2014 (v12) server. We need to determine if a product was for sale in some time period. For example, was this inventory for sale in the month of July 2022? (...
Pure.Krome's user avatar
6 votes
2 answers
385 views

SQL Server generating sporadic Memory Dumps

We're running a 2014 SQL Server. For the past couple of years, the server generates memory dumps with no rhyme or reason, every 2-7 days, locking up most processes, and forcing us to restart the SQL ...
Depth of Field's user avatar
0 votes
2 answers
86 views

How to limit which NUMA nodes are used by SQL Server / SSRS?

I have SSRS and SQL Server running on same physical server (2 NUMA nodes). How do you configure SQL Server and SSRS to use separate NUMA nodes? I just didn't want SQL Data Engine to potentially ...
user2368632's user avatar
  • 1,087
0 votes
1 answer
93 views

Dynamic Quorum behaviour with a witness

I was going through this article and trying to understand the behaviour described in the article. Summary - It is not a common scenario to see cluster nodes go offline until the last node and the FSW ...
DMDM's user avatar
  • 1,738
3 votes
0 answers
73 views

Estimates badly wrong on empty string, but not specific value - SQL 2014 or earlier

Update: I went down the rabbit hole and came out understanding that this is a bug in 2014. It can be replicated on SQL Server 2019 in compatibility level 120 (2014) but if you flick the compatibility ...
The Forge's user avatar
3 votes
2 answers
792 views

What ports to open for sql server behind secure domain firewall

We are trying to solve connectivity issues for one of the app trying to pull data from very secured sql server behind firewall. I am not that expertise in security but need help on how to proceed in ...
Newbie-DBA's user avatar
0 votes
1 answer
65 views

Dell Server Raid 1 drive quick replacement with 2 exact copies

Apologies if I am posting this to the wrong place. We are unfortunately having to handle our own server administration in-house and no one here is an expert at servers in any way! (we are web app ...
CapnElectric's user avatar
6 votes
3 answers
623 views

How to write script to kill MS Office database locks in MSSQL

I've recently inherited a MSSQL database as our DBA has moved on to greener pastures. I'm not a DBA and have limited to moderate SQL knowledge but have had to absorb some of his duties and have an ...
user2631683's user avatar
0 votes
1 answer
97 views

Restore from Azure Storage DB to sqlserver 2014

I am trying to restore the Database from Azure Storage to Sql server 2014 but getting the error "TITLE: Microsoft SQL Server Management Studio An exception occurred while executing a Transact-SQL ...
Saira's user avatar
  • 101
2 votes
2 answers
186 views

Is it possible to query total CPU load on system that is hosting SQL Server 2014+ Express?

I can get the available memory by querying the [master].[sys].[dm_os_sys_memory] view, but I haven't found anything similar for getting info about the CPU load. I only find info about querying CPU ...
Martin Riddar's user avatar
0 votes
1 answer
71 views

storing sensor historical binary data for last 720 reads (SQL Server) [closed]

I need to store binary data - online status (1,0 or NULL) of about 100k sensors. Data are refreshed every 1 hour and I need to store historical data for 30 days, which gives me 720 records per sensor. ...
user13189993's user avatar
0 votes
0 answers
94 views

Select MIN on Primary Key Field Using Sub-Optimal Index / Plan

I have a stored procedure that takes in a list (table variable) of IDs, and then it performs some queries to analyze the contents of the list and take the appropriate actions. One of the queries ...
mathewb's user avatar
  • 1,134
2 votes
0 answers
155 views

SQL Server 2014 SP3 Backup to URL error

We have a database on a SQL Server 2014 (SP3 12.0.6433.1) and I'm trying to take a backup to Azure Blob Storage. I have followed this document (https://learn.microsoft.com/en-us/previous-versions/sql/...
AzNerd's user avatar
  • 21

1
2 3 4 5
55