Questions tagged [sql-server-2014]
SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.
2,753 questions
1
vote
1
answer
68
views
SQL Server 2014 Audit
I'm configuring SQL Server Audit to log all INSERT, UPDATE, DELETE, and SELECT operations. I've tested and recorded everything I need (time, action, server principal, server instance, database name, ...
1
vote
2
answers
130
views
How to improve a delete operation that is running in batched?
I have a delete based on a simple select. I could tune it to delete in batches and it's way faster then a normal delete.
DECLARE
@StartDate DATETIME = '05/01/2024',
@EndDate DATETIME = '05/31/2024'...
- 7,548
1
vote
1
answer
62
views
Multiple SQL Server installed
I have noticed there are two SQL Servers installed on the same box, which are 2014 and 2019; however, when I log into SSMS and type select @@version, it is showing 2014, and the instance name is ...
- 1,117
0
votes
2
answers
181
views
Datetime2 in SQL 2014 Vs SQL 2022
Behaviour of column type 'DateTime2' between SQL 2014 and SQL 2022.
This was found when our application's calculation for datetime difference of columns being type DateTime2 went wrong.
Tried to find ...
- 81
0
votes
1
answer
73
views
Sessions killed when AG group connection terminated
We had a strange incident last night on our SQL Server 2014 AG group. We have a two-node group setup in asynchronous mode. The clock on the secondary was off by about 30 seconds and adjusted itself ...
- 117
2
votes
1
answer
131
views
Users with role still able to INSERT despite not having a right to do so
I have a following requirement:
There is a AAD group called testgroup. Members of this group should have write access to table dbo2.Sales and read access to every table in dbo schema, and they shouldn'...
- 121
0
votes
2
answers
103
views
Is FILEPROPERTY only used for database_files dmv?
I'm trying to mix some queries I created in the past, and some that I stole over the network to give me mount points size and free space together with database size and free space of the files.
Only ...
- 7,548
0
votes
0
answers
48
views
Whats needed to be changed if I'm moving SSRS DBs from a prod env to a test one?
I’m a bit confused on how I move the reporting database (and the temp one) from prod to test.
I know after moving DBs I need to export its encryption key, but I would like to not cause any report to ...
- 7,548
2
votes
1
answer
136
views
SQL Express CPU limitation ignored
I have a SQL Express 2014 running on a VM with 12 cores
SQL Express limitations state that it should be limited to either 4 cores or 1 socket, but when I run this query:
select count(1) "Nb ...
- 3,287
1
vote
1
answer
212
views
SP getting recompiled with "Statistics changed" reason even after disabling auto_stats for all tables involved
I was troubleshooting a performance issue and I need an SP to stop getting recompiled because of auto update stats.
I don't want to disable Auto stats update on the entire database so I thought I ...
- 1,750
0
votes
1
answer
169
views
SQL Server Failover Cluster Data Loss on failover
Currently running several databases on an Active/Passive SQL Server 2014 Failover Cluster on Windows Server 2012 R2. Recently there was an event that caused the active server to failover. The failover ...
0
votes
1
answer
107
views
Working with window patching for many SQL server with AOAG
We have hundreds of servers and 99% of them have AOAG strategy. Patching takes HOURS since we need to patch secondaries (Windows patch) , wait to complete, manually fail over to the other node, Patch ...
- 7,548
0
votes
0
answers
74
views
Always on availability group removing nodes
We have a SQL 2014 enterprise with 4 node availability group database with 2 Synchronous commit , 1 read only Asynchronous for reporting and 1 DR asynchronous.
Due to space shortage we need to remove ...
- 1,117
0
votes
1
answer
115
views
Does it make sense to schedule agent to create multiple #temp tables in parallel?
So I have this idea of scheduling sql server agent to create some #temptables in parallel before mass updating my large table (roughly 30Gb) to save some time. Currently, it took about 2 hours for the ...
- 13
0
votes
3
answers
195
views
Active-Active Availability Group configuration
Lets say we have two node AlwaysON availability group setup and each node has an availability group as primary.
EG -
Cluster Nodes - Node1, Node2
Availability Group AG1 is Primary on Node 1 and ...
- 1,750