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
715 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
0 answers
100 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,558
1 vote
1 answer
243 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
132 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
3 votes
1 answer
280 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
3 votes
1 answer
563 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
4 votes
1 answer
346 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
1 vote
1 answer
82 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 ...
