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
1 answer
18 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 ...
user avatar
  • 101
2 votes
2 answers
43 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 ...
user avatar
0 votes
1 answer
36 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. ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
  • 1,074
2 votes
0 answers
38 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://docs.microsoft.com/en-us/previous-versions/sql/...
user avatar
  • 21
2 votes
0 answers
40 views

How to change data type of PK for very min to no maintenance while performing this action

We had issue on our prod server for one of the tables approx 500 M rows and one of the column int has maxed out its length limit. So probable suggestion from dev team was to change data type of that ...
user avatar
5 votes
2 answers
332 views

Records greater than epoch timestamp using only LIKE operator

I have the following query so far and unfortunately, I cannot use regexp or greater than operators, I can only use the LIKE keyword. The whole column is in a json string, I can't use json_value or ...
user avatar
0 votes
1 answer
67 views

nslookup returning secondary IP of a listener (different subnet)

I'm pretty confused about this issue. We noticed that we sometimes receive some errors from the app servers causing timeouts. after a lot of digging, we discovered that sometimes when using a listener ...
user avatar
  • 7,156
0 votes
1 answer
32 views

SQL Server Upgrade + BPE

One of the SQL instance has BPE( buffer pool extension) enabled. Would this have an impact ( or any issues ) if instance is upgraded from SQL 2014 to SQL 2019. I went through the MS docs and does not ...
user avatar
2 votes
1 answer
86 views

DBCC CHECKDB getting terminated abnormally

We have a SQL Server 2014 set up on Always on AG with one primary node and 2 secondary nodes. On the primary node, DBCC CHECKDB for one of the databases is scheduled on SQL agent job. This job was ...
user avatar
  • 31
0 votes
1 answer
26 views

Help Understanding huge discrepancy in LDF file growth on AAG between primary and secondary

I currently have a SQL Server 2014 instance with a very basic AAG setup. There are 2 nodes in the AG. The Log drive on the primary has 90% free space, and the log drive on the secondary has 5% free ...
user avatar
  • 388
0 votes
0 answers
71 views

How to Force Drop a Database that is in Emergency Mode and corrupt?

In SQL Server 2014. We have a database that is in Emergency mode and is corrupt beyond repair. We need to get rid of it and reclaim the space. But we're having trouble as the database isn't even ...
user avatar
  • 143
0 votes
0 answers
32 views

Backup Maintenance Plan Overhead Longer than Actual Backups

I created a maintenance plan to perform transaction log backups on a single database. The plan is scheduled as a job that runs every fifteen minutes. The plan has two steps: clean up log backup files ...
user avatar
  • 1,074
0 votes
0 answers
44 views

How can i store execution plans for certain stored procs

Unfortunately we cannot use query store as we are on SQL 2014 and need to find a way to store execution plans of certain stored procedures. I saw XE like sp statement completed but unfortunately it ...
user avatar
0 votes
1 answer
45 views

In Always on AG How can we setup jobs with a failover

In SQL Server 2019, We have primary and secondary replicas. if primary goes down then secondary will become the primary server, In such case how to handle the SQL jobs. Please help me to get it ...
user avatar
0 votes
0 answers
10 views

faster way to create AOAG with cloned disks

We have some projets going on to move databases from one server to another. for example we have 3 servers. We cloned the data/log files from the production server (AWS) and moved into the 2 other ...
user avatar
  • 7,156
-2 votes
1 answer
48 views

What other options do we have for Having?

I deleted my old question to be more precise on what I need. we have a big query containing lots of smaller queries. This query runs really fine, until it reaches to the "having max" clause: ...
user avatar
  • 7,156
3 votes
1 answer
564 views

Is there a way to Delete inserted data, or vice versa?

I'm trying to get Data inserted and then Deleted in the same query. I'm trying to delete it in chunks to not cause LOG issues: DECLARE @BatchSize INT SET @BatchSize = 100000 WHILE @BatchSize <> ...
user avatar
  • 7,156
1 vote
1 answer
54 views

Why automatic failover does not occur when I turn off SQL Service in SQL Server Failover Cluster Instance?

I faced unusual behavior associated with automatic failover so that automatic failover does not work in the case of turning off SQL Server service. It seems that clustered disks are still remaining ...
user avatar
  • 1,183
0 votes
1 answer
158 views

Free node memory and low PLE

We run a SQL Server 2014 standard edition on a 94 GB RAM server with 82 GB RAM dedicated to SQL. I know PLE is not the answer to all and we should not focus on it too much. But if you look at the ...
user avatar
  • 1
-1 votes
1 answer
54 views

SQL Server 2014sp2 / SQL Server 2014 sp3 CU4 Primary Key Violation on Primary Key constraint on insert

Prod Env: SQL Server 2014 sp2 Test Env: SQL Server 2014 sp3 CU4 Prod and Test matches up. Recently updated Test Env to sp3 cu4. Since updating proc_a (within a SQL job) fails due the below error. ...
user avatar
  • 11
3 votes
2 answers
352 views

Is there a way to add INCLUDE for a UNIQUE NONCLUSTERED index?

we have a table with 4 columns ( example ): create TABLE [dbo].[myTable] ( [Id] BIGINT NOT NULL, [Id2] SMALLINT NOT NULL, [Id3] SMALLINT NOT NULL, [IdUnique] ...
user avatar
  • 7,156
0 votes
0 answers
52 views

Very imbalanced memory usage across NUMA nodes

Our SQL Server 2014 Standard edition uses 82 / 94 GB RAM on our server and we have 2 NUMA nodes configured. When I check the LPE for both nodes, instance 1 has an very high value, 90000+ and steadily ...
user avatar
  • 1
-1 votes
1 answer
32 views

How to get partnumber that have at least have one source type Website and at least one stockid equal 1 Based on PartNumber?

I work on sql server 2017 i face issue i can't get partnumber that have at least source type website and at least have stockid equal 1 per partnumber so with another meaning i need to get part numers ...
user avatar
3 votes
2 answers
132 views

Estimating the best restore time from saved backups in SQL Server

I am looking for guidance and any advice on how to estimate the restore time for SQL Server databases once copied locally to the server. This is just to layout a strategy what will happen if in future ...
user avatar
1 vote
1 answer
28 views

Log shipping report to show average daily volume?

Is there a SQL log shipping report (or query) that I can run to see what my average daily log shipping volume is in terms of gigabytes of log data shipped (by DB or in total)?
user avatar
2 votes
0 answers
74 views

Why is my SQL instance suddenly increasing i/o

I have the following query: WITH CTE AS ( -- Acknowledged: false SELECT TOP 5 dbo.AlertDetail.AlertDetailID, dbo.AlertDetail.AlertDateTime, dbo.Vehicule.Name, ...
user avatar
6 votes
1 answer
349 views

Why is statistics update slower on a clustered columnstore than on a rowstore?

I've moved several large tables (each with >10^9 rows and a couple of dozens columns) from clustered rowstore to clustered columnstore indexes on a SQL Server 2014 instance and noticed that ...
user avatar
0 votes
0 answers
53 views

SQL Server 2014 consuming more memory than max server memory setting

For the past month, I have noticed our SQL Production server has been consuming more memory than we allocated for it. This is the current structure: Total OS Ram: 31Gb SQL Server currently using ...
user avatar
0 votes
2 answers
184 views

Which TLS version is database mail using?

How can we find out which TLS version our database mail is using for sending e-mails? We have issues with database mail (mails are sometimes not sent, even after 10 repeats), and it seems that TLS 1.1 ...
user avatar
  • 245
-1 votes
1 answer
40 views

how to display category name for c and x from table category without using self join?

I work in sql server 2014 I need to get categories c and x without using self join. But, I don't know how to do that. My data sample create table #category ( categoryc int, categoryx int ) ...
user avatar
2 votes
1 answer
173 views

Error 9002 - State 4, Class 17: SQL Server reports full transaction log

I have the problem when running an external program that accesses a SQL Server 2014 database. I get the following error message. The transaction log for the 'TService' database is full. The ...
user avatar
0 votes
1 answer
35 views

Tracing Remote Sql Execution

Recently in our database server we have found that there are some queries executed by unknown client/user/application. We have found out the query client_name is the name of the same server (means ...
user avatar
0 votes
0 answers
109 views

Maxdop setting in SQL Server 2014 during index rebuild offline and online

We are having issues performing index, table and stats maintenance in one of our databases. There are over 200 indexes, some of them on tables having more than 1b rows. We can't bring application down(...
user avatar
0 votes
1 answer
99 views

Find what queries are reports using on SSRS

EDIT: It seems they're using "semanticQuery" and this is why I cant see usefull information? We will be decommissioning one of our functions, and we noticed that some reports are still ...
user avatar
  • 7,156
0 votes
1 answer
79 views

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

I'm using the function DATABASEPROPERTYEX to check the Recovery property of databases, but the result is wrong for the database AdventureWorks (later I noticed the same strange behavior for ...
user avatar
  • 4,589
3 votes
2 answers
331 views

Identify all queries that target a given table?

Is there a good way to identify all queries that target a given table (extended events, procedure cache, etc)?
user avatar
0 votes
0 answers
36 views

How to get first row group by partid and compliance typeid and document type?

I work on SQL server 2014 I face issue I can't get only one row based on part id and compliance type id and document type . so if have part id as 3581935 and compliance type id 1 and document type Web ...
user avatar
0 votes
0 answers
85 views

Trace id 2 stopped because disk space, but I can't find this trace

I received the famous alert: Trace ID '2' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the problem. But running both ...
user avatar
  • 7,156
0 votes
0 answers
55 views

SQL miss transfer some data to another table under transaction

I have query which transfer data from one database to another. Query is controlled by Maintenance plan and it's executed each 10 sec. SQL server isolation level is read committed. Over query we are ...
user avatar
  • 1
0 votes
2 answers
66 views

Creating an if then clause in SQL

I'm fairly new to SQL and I am am used to writing formulas in Crystal Reports. I want to recreate the following formula from Crystal Reports into an SQL statement to create a column: if (not isnull ({...
user avatar
0 votes
1 answer
53 views

Does AOAG needs a Windows failover cluster?

I'm reading some windows docs about AOAG and I got confused: Always On availability groups, the high availability and disaster recovery solution introduced in SQL Server 2012 (11.x), requires Windows ...
user avatar
  • 7,156
0 votes
1 answer
90 views

SQL Server 2014 mirroring Backup

Is it necessary to stop working on the database when preparing the mirroring process? If I take an old backup of the main database and restore it, will all the new data be transferred when running ...
user avatar
-3 votes
3 answers
157 views

Slowly running a query that always runs fast

I have two tables that 99% of operation on it is simple select. Rarely we have insert/delete and updates. There is a inner join on these tables and execution plan of the query is index seek. 99% of ...
user avatar
  • 439
0 votes
1 answer
80 views

Getting database-level audit logs without database audit specification

I have server level auditing on SQL Server 2014. Why am I receiving database-level audit events (such as SELECT, INSERT, UPDATE, DELETE, etc.), even though there are no database audit specifications? ...
user avatar
  • 13
2 votes
3 answers
356 views

SQL Full DB Backup performance on different Hardware

I wrote a fairly simple script that creates in a periodic interval a backup of our DBs, switching automatically into differential in case a full backup already exists. This runs great on my system. A ...
user avatar
2 votes
2 answers
488 views

Are SQL Security Updates Cumulative? Are the vulnerabilities corrected with one Security Update also covered by the next Security Update?

I recently patched SQL Servers that had SP3 and CU4 with the latest available Security Update. After CU4 there are 2 Security Updates available, one from 2020/02/11 and the other one from 2021/01/12. ...
user avatar
0 votes
1 answer
244 views

DBCC CHECKDB job failed on SQL Server 2014

We have a DBCC CHECKDB job that runs weekly on Saturdays. This job was created thorugh Maintenance Plan wizard. Typical duration for this job is 1.5 hours. This past weekend the job failed with the ...
user avatar
2 votes
1 answer
660 views

How can I change the RSA key length from 1024 to 2048?

SQL Server Environment: OS version: Windows 2012 R2 Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64) Instance type: Named instance When I am attempting to connect from a Docker ...
user avatar
  • 12.3k
4 votes
2 answers
6k views

Database mail trying to send 2 times and then failing

Our database mail was running for 3 years without problems, but since one week, we are often (but not always) getting this error: The mail could not be sent to the recipients because of the mail ...
user avatar
  • 245

1
2 3 4 5
55