Questions tagged [sql-server-2017]
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
1,045 questions
7
votes
1
answer
649
views
How to release unused space? [duplicate]
I have a large table which has a ton of unused space. I updated the table recently and NULLed out a varbinary (max) column that we didn't need. This has created a lot of unused space:
EXEC ...
- 2,041
0
votes
1
answer
122
views
Changing column type from Decimal (16,2) to Decimal (32,2) on table size 500million rows
Hi folks I have a database part of an AG,I need to change the column type from Decimal (16,2) to Decimal (32,2). Does anyone know the best way I could do that above without bloating the log?
My ...
- 137
0
votes
0
answers
83
views
Strange UpdateUptimeRegKey access denied behaviour
So recently I'm having every 1 minute an alert for this:
UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
This may be a super bold question but I couldn't find anything ...
- 7,550
0
votes
2
answers
242
views
Grouping and arranging data using FOR JSON PATH and INCLUDE_NULL_VALUES
I'm having an issue with my T-SQL script. I am thinking about and working on how to produce the expected output from it.
Here's my T-SQL script:
DECLARE @user_id VARCHAR(50) = 'UGUID-2025-01-27-14-09-...
- 205
1
vote
1
answer
226
views
Multiple UPDATE and INSERT statements using BEGIN TRAN with customized COMMIT TRAN and ROLLBACK TRAN
First things first, since I am using SET XACT_ABORT ON. If an exception happens in any of the INSERT or UPDATE statements within the transaction block, then it should terminate and roll back the ...
- 205
1
vote
0
answers
56
views
Huge ReportServerTempDB
Running SSRS on SQL 2017 (fully patched) with all services on a dedicated SQL Server. The ReportServerTempDB is hundreds of gigabytes, while the ReportServer database is only a few gigabytes. All the ...
- 11
1
vote
0
answers
119
views
SQL Server: "cannot bulk load" error during delete
I am having a very interesting error using SQL Server 2022 and 2017. I am currently implementing my jurisdiction's data retention policies, which means doing a lot of deletes. I have run into a ...
- 113
-1
votes
1
answer
84
views
SQL Server does not reduce the size of MDF and LDF files even though the file shrink process has been carried out
I am a SQL Server 2017 user, I deleted a table that had too many records, but after the delete process, the size of the MDF and LDF files did not decrease, but increased. I have shrunk the file but ...
3
votes
1
answer
271
views
Query runs faster with new plan but same old statistics
OK, this sounds like the standard My query was faster yesterday question. I hope it's not.
I have a query that usually runs within seconds (e.g. like 4 secs). Last night, it ran for 12 hours before we ...
- 352
0
votes
1
answer
44
views
Applying SQL updates within a specific AAG configuration
We have recently added AAG to our production servers, for DR purposes. We have approximately 60 FCI clustered instances (SQL 2017) hosting ~5000 client databases. This is all hosted in our own ...
3
votes
1
answer
468
views
SQL Server Error Log and Failed Logins
We recently disabled a SQL account on one of our production servers at the request of the application owner, account no longer used apparently.
Since disabling we have seen login failures in the SQL ...
- 501
0
votes
0
answers
42
views
SQL Server 2017 - Instance not applicable for update (CU31 GDR Build 14.0.3485.1) [duplicate]
I have a 2017 SQL Server, and I have tried applying the latest update to the instance (CU31 GDR, 14.0.3485.1) However, when running the update wizard, it shows that the instance is greyed out and &...
4
votes
1
answer
337
views
Does enabling FILESTREAM for file I/O access improve performance and manageability in handling file data?
I am trying my best to craft my question as straightforward and clear as possible. So I will start by quoting this answer thread saying that,
If you want to read and write FILESTREAM data from ...
- 205
0
votes
0
answers
38
views
DB stuck on synchronized/recovery pending + ALT DB SET ONLINE
Im curious to understand this scenario if there was a better plan.
Index maintenance caused the log to grow, filling the disk and causing a db to go into SYNCHRONIZED/RECOVERY PENDING.
we ran ALTER ...
- 7,550
1
vote
1
answer
79
views
Interleaved Execution not happening in SQL 2017 DB
We have a SQL Server 2017 database that was imported from a 2008 instance long ago. The compatibility level is set to 140 (confirmed by the execution plans), but no multi-statement TVFs are ever ...
