| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:27:50 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b2c939ccff473-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=98928caa-f3c8-4422-9148-60933be20d75; expires=Thu, 23 Jul 2026 12:27:49 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: 43466049-5578-4c34-9239-4f75c15a1d13
x-worker-origin-response-time: 448000000
x-dns-prefetch-control: off
set-cookie: prov=98928caa-f3c8-4422-9148-60933be20d75; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=lLhdEedaFWhxfd0hW1iOTlErEFcoI1z3fNauMerbyKQ-1753273670-1.0.1.1-FFon5O78buoVgT5rmiWdTnZENTJN.dbO3Cghw.cMc3m_6ZsNQq_g74aYg0lj_JGhaDIN6pux_mmRCSk9rWBqy3fRek6vRDFyRQrsUpOY83A; path=/; expires=Wed, 23-Jul-25 12:57:50 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=vAgw_LZma9J3tF8CN2JlD9de0MB9l2M2_aq6khHpbEI-1753273670153-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,960 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
18
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
19
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
22
views
Database design in healthcare - 21 CFR Part 11
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 ...
1
vote
1
answer
47
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
52
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
35
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
26
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
36
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
24
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
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
1
answer
42
views
SQL 2022 Parsing error for restore Master Key
I am trying to setup a secondary SQL server for log shipping. The primary server is encrypted as it should be.
On the secondary I am trying to run the restore master key command, but I keep getting ...
0
votes
0
answers
34
views
SSIS Lookup with query failing is not giving an error
The query I use to load the LOOKUP cache does a type conversion
SELECT CAST(key_as_varchar_column AS INT) AS key_as_int FROM table
That works fine unless the source system GUI really allows text in ...
- 233
- 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 × 879
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
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Why does internal energy end up higher in an irreversible adiabatic process, even though the work done is less?
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- Distance Between Subspaces
- What is that "T" in the pattern string of the date-command?
- Error when sending an email with attached PDF using Google Script
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Repository with SQLite in Python
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- A soviet sci-fi novel (novelette?) with frogs?
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- Fit text on TWO pages by varying font size automatically
- Which domain (time or frequency) does filtering actually occur in real-life?
- Will a restless MCU survive long enough?
- How can I grow kelp or seaweed at home in a small container?
- How to 'scale' a square list?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- bootstrapping for variance estimation takes too long
- Which PowerShell commands are automatically scrubbed from Get-History?
- Axioms of quantum mechanics - intuitive explanation
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?