| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 07:42:46 GMT
content-type: text/html; charset=utf-8
cf-ray: 9641c8603f966cd6-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=6acbf0c7-2272-45f4-8049-2bdfc95a013c; expires=Fri, 24 Jul 2026 07:42:46 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: e7f5267f-1be5-448e-88cd-6fe05f6ca403
x-worker-origin-response-time: 546000000
x-dns-prefetch-control: off
set-cookie: prov=6acbf0c7-2272-45f4-8049-2bdfc95a013c; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=DJhKgU1igiMSq9HHga0aheJeUG7AeekA5v1hhNIfgTE-1753342966-1.0.1.1-uanXw3TaAzAT9DJ_wkqSmuhUM8flLOyHX1z_B_8V7ezoocEAdO29vL5q2BXio2Jqn5mRQpDooD9QaPV00nHi2Lbsa9Tq5RrJRjgsEV0BbRw; path=/; expires=Thu, 24-Jul-25 08:12:46 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=lQPbH9B4Sev5NDuBszPwWOuczvlOqvRXFfd0Zh05tYE-1753342966374-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql-server' 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]
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
34,961 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
23
views
Is there any reasonable way to Purge Expired Data from a SQL Server Ledger Database
The SQL Server Ledger Database functionality looks very interesting, and I would like to recommend it for several use cases, but I am concerned that there is no option for purging historical data.
I ...
1
vote
0
answers
13
views
How can I design an experiment to show the benefits of writing while under Snapshot isolation?
We've all read the documentation for Snapshot isolation and know about Update Conflict Detection and when you should theoretically use Snapshot isolation for writes. However, I have never found anyone ...
0
votes
0
answers
28
views
SQL Server 2022 Express/Dev Not Able To Install
I'm trying to set up a new laptop - Dell 16 2-in-1 - so that I can code on it but I can't get SQL 2022 Express or Dev to actually install. I can run both of them, get all the way to the end of the ...
-2
votes
0
answers
25
views
How to fix transactional replication latency
Good Morning,
We are facing replication latency issue. I checked for blocking, long running transactions or bulk operations running. They all are good. No issues with slow storage or slow network. I ...
0
votes
0
answers
27
views
Database design in healthcare - 21 CFR Part 11 [closed]
I have a database which has organically grown in size and scope over the last few years which handles manufacturing data for medical devices in an R&D setting. For a variety of reasons we need to ...
2
votes
1
answer
58
views
What are the downsides of running a Physical Only Database Integrity Check job
I am unable to find an article yet, that is able to clearly help my understanding of the risks I run by running my Ola Hallengren DatabaseIntegrityCheck job with PHYSICALONLY parameter on our large ...
0
votes
1
answer
55
views
Could not find stored procedure 'sp_BlitzLock' [closed]
I'm running into an issue while trying to execute the stored procedure sp_BlitzLock in SQL Server 2022 Developer Edition. Here's the exact error message I'm getting:
Msg 2812, Level 16, State 62, Line ...
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', ...
0
votes
1
answer
36
views
SQL Batch execution failing for SysAdmin user
Having the strangest issue I've ever encountered. I have a batch of SQL statements to pull a chunk of data from SQL to a text file. The batch runs in our development, sandbox environments with no ...
3
votes
1
answer
28
views
Can Transact-SQL snapshot backups interface with Amazon EBS?
I have recently discovered Transact-SQL snapshot backups. They let you interact with snapshot backups, like this flowcharts explains.
It is obvious that this is compatible with a traditional SAN. I ...
-1
votes
1
answer
31
views
To track records fetched in last query [closed]
In migration project and need to fetch records in batches on table where dont have key column since it's a legacy data and need to track the records fetch to avoid duplicating .can you pls suggest the ...
0
votes
1
answer
37
views
SSISDB view returns empty unless user is ssis_admin
I have an SSISDB catalog in SQL Server (2019 EE) and created a view for reporting purposes:
CREATE VIEW [dwh].[v_folders] AS
SELECT name AS foldername
FROM ssisdb.catalog.folders;
The goal is to use ...
0
votes
1
answer
25
views
What is a "scan request" in the context of Availability Groups?
The documentation for sys.dm_hadr_database_replica_states states
1 = Synchronizing. For a primary database, indicates that the database is ready to accept a scan request from a secondary database. ...
0
votes
1
answer
43
views
ADO.NET client occasionally attempts connection to SQL Server mirror partner even when principal is online
We're running SQL Server 2016 Standard Edition with database mirroring in synchronous mode and automatic failover enabled. Our .NET applications use connection strings with Failover Partner.
...
4
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 ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server-2012 × 3286
sql-server-2008-r2 × 2630
t-sql × 2512
sql-server-2008 × 2356
sql-server-2014 × 2321
sql-server-2016 × 2238
performance × 2104
availability-groups × 1308
backup × 1232
query-performance × 1190
index × 977
sql-server-2019 × 954
ssms × 913
replication × 900
database-design × 878
sql-server-2017 × 843
sql-server-2005 × 821
restore × 770
stored-procedures × 767
execution-plan × 745
ssis × 717
permissions × 701
transaction-log × 602
security × 594
azure-sql-database × 559
more related tags
Hot Network Questions
- Which workflows more effective: worldbuilding before plotting or the other way around?
- How do mechanical gyros maintain rotational speed?
- When you view a historical event with an incorrect modern lens
- How can I delete a stubborn file on Windows Server?
- Macro Definition Outside Current Group
- How much power does the Fed chair have over interest rates?
- Axioms of quantum mechanics - intuitive explanation
- Mars colony book I read in the 80's. The name?
- Does אֵלִ֣י in psalm 22:1 say god or "my god"
- Finding the value of collector resistor
- Error on numerical integation
- Is it okay to email researchers if I’m just a high school student?
- Write two very different programs with the same characters
- Where did the name of Windows XP come from? Was it connected to the Cairo project?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- What is the consistency strength of Russell & Whitehead's ‘Principia Mathematica’?
- Can you identify this shell case from Flanders?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- tac-command is it a bug or a misinterpretation of the manual?
- Camera Controls Stopped Working
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- Using a MCU and PCB to actuate a 24V solenoid
- A soviet sci-fi novel (novelette?) with frogs?
- Do the constructible lines and circles (not merely their intersections) cover the plane?