| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 19:13:57 GMT
content-type: text/html; charset=utf-8
cf-ray: 9645bcd99ce08839-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=8932bd42-2b2b-4be9-8af8-87f608d162da; expires=Fri, 24 Jul 2026 19:13:56 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 68d4e231-aae1-4d26-bc9a-cb5f298fb658
x-worker-origin-response-time: 487000000
x-dns-prefetch-control: off
set-cookie: prov=8932bd42-2b2b-4be9-8af8-87f608d162da; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=XvaqQDQiWmlum9BuYj_1osFbwAkmynmRzi28_ZZXzps-1753384437-1.0.1.1-6A26wX4Rj1q7aHZJn.ma.ZHtjdcvdX6QeJp9_SGShOtX0PuFU6.9PZukwXf0_0St8.7T.yJvMiHdXDQN.8YFx3u6Fk63WH5f7NQzUVYlh1Y; path=/; expires=Thu, 24-Jul-25 19:43:57 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=BOJ_SJxx0vyd95F_OWkyWcGAiJZkotMoerjD1PVf5k0-1753384437228-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql-server-2019' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [sql-server-2019]
SQL Server 2019 (major build version 15.00.xxxx). Please also tag sql-server.
1,141 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
51
views
SQL Server Shrinkfile Stops at 76% Due to LOB and System Data—Is Partial Shrink Possible?
Problem:
I am working on a SQL Server 2019 database where I deleted a large amount of user data (~500 GB).
After deletion, I attempted to shrink the data file using:
DBCC SHRINKFILE (N'web_Data', ...
5
votes
1
answer
155
views
Will unchanged database extents result in identical SQL backup bits on disk? What about with backup compression enabled?
(I'm trying to predict long-term SQL backup storage needs and if/where to enable compression, on a storage appliance with de-duplication. I know the best answer is "test both and see", which ...
0
votes
0
answers
19
views
Understanding commit_time in dm_tran_commit_table: Insert Time, Timezone, and Latency Concerns
I am currently working with SQL Server and exploring transaction management, specifically the dm_tran_commit_table view. I have a couple of questions regarding the commit_time and change tracking. ...
2
votes
1
answer
75
views
How do I maintain a specific cadence in a bi-weekly SQL Agent job schedule?
I have a SQL Agent job I need to run every two weeks on specific Saturdays (6/14, 6/28, 7/12, 7/26...). The job failed on 6/28 and when I query sysjobschedules it indicates the next scheduled run date ...
1
vote
1
answer
156
views
How can I execute Openrowset in the named instance I am currently in?
I am running this openrowset query about jobs on my current server and I see that the result set is not correct.
I was expecting a bunch of jobs but I only get one.
when I run the following piece of ...
0
votes
1
answer
34
views
XE:query_trace_column_values
according to this acticle: https://www.sqlshack.com/query-trace-column-values/
try to setup XE session which captures query_trace_column_values but it's does not work anymore on
Microsoft SQL Server ...
2
votes
1
answer
60
views
What can one do when the distribution cleanup job is unable to cleanup the transactions in the distribution database?
some of the tables inside my distribution database are very intensely populated as you can see:
this was caused by adding a few large tables to the publication a couple of days ago
the cleaning job ...
3
votes
1
answer
75
views
Find jobs stopped prior to completion by Shutdown Sequence
I am looking to report on jobs that were running when the instance is rebooted so that I can investigate and requeue. I have tested this scenario and sometimes I can identify them in msdb.dbo....
0
votes
0
answers
36
views
Extended Events - Login Event - Using Packet_Size to Filter SQL Server Logins
I want to create an Extended Events Session to track SQL Server Logins.
The value for packet_size is 4096 for all of the SQL Server successful logins that the Login Extended Event has recorded.
Is a ...
2
votes
3
answers
107
views
Changing SQL Server Database Owner to SA Broke Application Login – Why Did It Happen and How Can We Prevent It?
We're in the process of aligning with SQL Server security best practices and recently initiated a project to change database ownership from individual domain logins to the SA account across our ...
0
votes
2
answers
51
views
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019. This is a basic availability group running in a cluster-less installation.
In the dashboard I see this:
This ...
2
votes
0
answers
105
views
The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped
I'm trying to drop a security group from the Users in my SSISDB database. I'm getting the error message 'The database principal has granted or denied permissions to catalog objects in the database and ...
6
votes
3
answers
656
views
Unexplained MSSQL default date formatting
I have a problem with T-SQL that is out of my control.
Their T-SQL is failing to work with a date that was cast to VARCHAR(10). They are expecting to get the default yyyy-mm-dd (the documented default ...
1
vote
1
answer
56
views
Transaction log file for in-memory database doesn't shrink
I am using SQL Server 2019 Enterprise Edition.
We have an in-memory database used for session state data with one table stored in memory, schema only durability, simple recovery, differential backups ...
4
votes
1
answer
118
views
Odd behavior of SQL Server LIKE statement when using VARCHAR and NVARCHAR pattern
(Using SQL Server 2019 CU 31)
Why does only the CASE expression against @nvarchar_dash_after_ranges return 'LIKE' in this query? Note that the same comparison against a VARCHAR expression returns '...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 954
availability-groups × 78
execution-plan × 40
restore × 39
t-sql × 39
backup × 36
query-performance × 33
ssms × 32
clustering × 30
performance × 30
sql-server-2016 × 30
memory × 26
tempdb × 26
permissions × 23
sql-server-agent × 22
replication × 21
sql-server-2017 × 21
ssis × 21
azure-sql-database × 17
linked-server × 17
linux × 17
migration × 17
stored-procedures × 16
transaction-log × 16
encryption × 15
more related tags
Hot Network Questions
- Which domain (time or frequency) does filtering actually occur in real-life?
- Lilypond to MusicXML
- Finding the value of collector resistor
- How Fill Date Series Without Formatting Using Keyboard Only
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- I am looking for a French mathematician who contributed to complex analysis
- counting number of integer solutions
- Is it okay to email researchers if I’m just a high school student?
- Macro Definition Outside Current Group
- Why is the Schrödinger wave equation totally different from the classical wave equation?
- Using a MCU and PCB to actuate a 24V solenoid
- Axioms of quantum mechanics - intuitive explanation
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- How much of a really big a spaceship could a nuke take out?
- Where did the name of Windows XP come from? Was it connected to the Cairo project?
- How do I implement this desired Excel data transformation?
- How to model This Twisted Torus?
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- Semiclassical electron dynamics and Pauli exclusion principle
- Why is this endgame winning for Black?
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- MATCH issue across multiple tabs - floating point, INDIRECT
- Why is Shunt Voltage Reference (LM4040DBZ-3) Not outputting a stable 3V supply