| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 13:08:52 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b68ae6b8725e0-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=171ed549-acb2-4cc4-88b6-ea44802e8dbf; expires=Thu, 23 Jul 2026 13:08:52 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-frame-options: SAMEORIGIN
x-request-guid: 9814669f-6b42-4fdc-b2e5-3a5cc636b9fd
x-worker-origin-response-time: 946000000
x-dns-prefetch-control: off
set-cookie: prov=171ed549-acb2-4cc4-88b6-ea44802e8dbf; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=idYUWtcgiW9NbORojOuGIia7OWzkl9n2KSn4NG1euTo-1753276132-1.0.1.1-NtlcKf6SyaZOjPKqdgjimtCqVtAzRaO48AgMa2Y1exrmMyVkmWXw8xcgt_zzqEOxA2hZY4Gw5WnMP6KaFXBsP1EYlsfnRVetdPi3KyvKSzs; path=/; expires=Wed, 23-Jul-25 13:38:52 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=NpxDPjWzonBP_oHefDan15Y4VBCIusdErBER8fbcvy4-1753276132549-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
50
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', ...
4
votes
1
answer
154
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
153
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
74
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
49
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
652
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
116
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
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- Is there a way to move the cursor specifically to the beginning of the visually selected region (not just toggle like `o`)?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- When is XLOOKUP() faster than VLOOKUP()?
- How much power does the Fed chair have over interest rates?
- How can I automatically replace curly braces { and } in LaTeX macro arguments—e.g., in math formulas—for label generation?
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Create a custom filter in WordPress extensions page
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- Can you identify this shell case from Flanders?
- Etymology of the word skulduggery?
- A soviet sci-fi novel (novelette?) with frogs?
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- How should a typical reward curve look like while training a RL model
- a stray не in this sentence?
- Mother in Law has overstayed her schengen visitor visa by 9 days. She is applying for the same visa this year, what should we take care of?
- Make a Mulenère encryption program
- Manga/manhwa where protagonist is the only one summoned to a different other world
- When you view a historical event with an incorrect modern lens
- 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?
- Book/book series including siblings (possibly twins; boy and girl) fighting various creatures from the 2010's
- I wonder whether there exists a book of "Formal power series" and "Formal infinite products"?