SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
2 answers
Why does sys.dm_db_log_space_usage.used_log_space_in_bytes keep increasing with Simple recovery model
I have a simple database with essentially only one active table, though it is a large one. It is for app analytics. A bunch of records are inserted every few seconds. It is searched a few times every day. That is all of its use. Its recovery model is…
SQL Server Database Engine
asked 2026-08-24T09:51:18.3466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 0%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hong
1,526
Reputation points
commented 2026-08-28T21:32:55.1733333+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server 2022 MDS not showing data on portal after update
Hi After installing an updates on SQL Server 2022 i have problem with MDS. When i go to website and open a model I do not see data in it. Data are avaiable in views and by Excel addin. Is this some bug or I could have broke sth? Daniel
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2026-08-28T09:36:30.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 0%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Stawik
0
Reputation points
answered 2026-08-28T12:58:35.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
1,080
Reputation points
3 answers
Access issue due to sa account
Hi, To issue Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. I can logon on SSMS using the same sa account. I am using Sql server 14.0.1000. Any reason?
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,805 questions
asked 2026-08-21T09:24:27.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 97%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jonathan
320
Reputation points
commented 2026-08-28T12:45:46.32+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server Reporting Services 2022 Licensing
Hi, We want to install SSRS on a separate server to our SQL Clusters and not have SQL installed directly on the host server. Is there a way to get a license key specifically for SSRS?
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,176 questions
asked 2026-08-28T12:02:43.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 41%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Stephen Manson
0
Reputation points
answered 2026-08-28T12:32:05.0533333+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
Performance regression from SQL Server 2022 to 2025
We have the following scenario we could reproduce on a single/same Windows Server 2019: Microsoft SQL Server 2025 (RTM-CU8) (KB5104822) - 17.0.4075.5 (X64) - Enterprise Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64>…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-25T13:33:21.3933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Patrick Simons2
15
Reputation points
edited the question 2026-08-27T14:49:46.0966667+00:00
Patrick Simons2
15
Reputation points
1 answer
How to limit refresh data while refreshing in PowerBI
I want to limit the data refresh while refreshing in On premises PowerBI I have this visual for each dashboard that on which data time it was last refreshed, so now when I want to refresh again, I want to refresh the data only after the mentioned date…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,378 questions
asked 2026-08-27T11:21:50.9333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Syed Uzair
0
Reputation points
answered 2026-08-27T12:16:00.87+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Changing account password in active directory - SQL accounts
I might need to change the password of an account in active directory. I have several instances of SQL express running various programs, SharePoint being one of them. How can I verify which accounts those SQL instances depend on and if it is on that…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2026-08-25T17:08:23.1033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 7.000000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Susan Dodds
421
Reputation points
accepted 2026-08-26T21:11:24.5233333+00:00
Susan Dodds
421
Reputation points
1 answer
One of the answers was accepted by the question author.
I am trying to create a database and getting a 262 error.
I am on the admin account of my personal computer, and my instructor in the course I'm taking told me to right click the SSMS 22 icon and run it as an admin, so I did that first, and I'm still getting the same error. It seems to me that I don't have…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2026-08-26T17:18:59.79+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Krista Bland
25
Reputation points
commented 2026-08-26T18:47:04.66+00:00
Krista Bland
25
Reputation points
1 answer
Partition elimination on SQL Server 2025 running on Azure VM querying files in Storage Account
I'm trying to get partition elimination to work when using OPENROWSET on SQL Server 2025 running on an Azure VM and querying files in an Storage Account with Hierarchical namespace enabled. I have no more ideas how to get it to work. My starting point…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
290 questions
asked 2026-08-23T14:42:19.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jerry Rausk
20
Reputation points
answered 2026-08-26T18:40:28.5533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 19%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHQ%3C/text%3E%3C/svg%3E)
Hugo Queiroz
81
Reputation points Microsoft Employee
1 answer
SQL Server 2022 reports a unique index violation for a non-unique index
Under SQL Server 2022, an intermittent 2601 error occurs during a scheduled data load. SQL Server reports a duplicate key violation on a non-unique index, while referring to the index as a unique index. Another anomaly is that the duplicate key reported…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-25T06:30:09.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZN%3C/text%3E%3C/svg%3E)
Zalán Kovalcsik
0
Reputation points
commented 2026-08-26T17:42:49.3033333+00:00
Deepesh Dhake
1,080
Reputation points
1 answer
Failed to install Microsoft Sql server latest version.
I have bought a laptop named ASUS gaming TUF A15. I am trying to install SQL server latest version but failed every time. I contacted ASUS for this. They said this is a third-party application. they are not responsible for this. You need to connect…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-26T12:37:14.7466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ranjan Majumder
0
Reputation points
commented 2026-08-26T16:57:23.2633333+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
Help needed: SQL Server 2014 fails to start with error "Stack Overflow Dump not possible"
ERRORLOG.logHi! An instance of MS SQL Server 2014, which is installed on Windows 11, started failing during startup. The only error message I can see is "Stack Overflow Dump not possible". Any ideas, what's the matter here and how to solve…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2025-09-19T06:46:09.94+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 55.00000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Michael Antes
5
Reputation points
commented 2026-08-26T16:38:12.37+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
How to fix Error 262 in Microsoft SQL Server?
TITLE: Microsoft SQL Server Management Studio Create failed for Database 'deneme'. (Microsoft.SqlServer.Smo) For help, click:…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2023-09-18T10:30:01.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 48%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
Şevval Çakır
0
Reputation points
commented 2026-08-26T16:30:59.8066667+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
1 answer
SQl Services not starting after installing CU3 on SQL 2025
I have installed SQL Pacth on Failover cluster instance for SQL 2025. After installing , SQL Services are not coming up. Error Error message - Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql'…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-26T09:31:21.2866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 19%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Abhishek Gaddam
0
Reputation points
commented 2026-08-26T14:13:39.2066667+00:00
Abhishek Gaddam
0
Reputation points
4 answers
One of the answers was accepted by the question author.
filepath() and filename() causes syntax error in SQL Server 2025 and external table
We are currently running in SQL Server 2022 and use external tables on top of parquet files in a storage account. All the external table definitions looks something like this CREATE EXTERNAL TABLE [my_external_data] ( [column_a] [varchar](20)…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
290 questions
asked 2026-08-21T11:26:39.3133333+00:00
Jerry Rausk
20
Reputation points
commented 2026-08-26T07:49:01.45+00:00
Jerry Rausk
20
Reputation points
7 answers
One of the answers was accepted by the question author.
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,805 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2024-04-19T14:09:09.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
60
Reputation points
commented 2026-08-26T04:29:46.2533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 7.000000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nkrumah Richards
0
Reputation points
1 answer
New CE ignores statistics for LIKE predicates on varchar columns with UTF-8 collations — fixed 9% guess (partially fixed in CE 170, `%x%` still affected, no backport)
SUMMARY For varchar columns using any UTF-8 collation (collation name ending in _UTF8), the modern cardinality estimator (CE model 120 to 160) never consults the histogram or string statistics for LIKE predicates. Every "LIKE 'prefix%'" and…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-21T14:07:13.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hubert
0
Reputation points
commented 2026-08-25T21:14:05.1566667+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Version 2022 Expired
Hi team, My free lab kit has expired therefore I am unable to launch SCCM console because it is unable to connect to database. I tried clean reisntallation of the lab but it shows expired. Can you please guide me how I can upgrade my SQL from Evaluation…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2026-08-24T11:00:00.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 39%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Syed Mehdi
0
Reputation points
commented 2026-08-24T21:02:38.6933333+00:00
Syed Mehdi
0
Reputation points
2 answers
How to prevent auto-update of SQL Server 2025 Engine?
Hi. I am convinced of a JSON bug introduced somewhere between CU4 and CU6. I want to reinstall my instances so I can troubleshoot and then post the bug if it exists. I have repeatedly uninstalled my SQL Server 2025 instances. I have reinstalled 3 RTM…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-20T16:21:39.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeff Foushee
96
Reputation points
edited an answer 2026-08-24T02:54:33.0366667+00:00
Deepesh Dhake
1,080
Reputation points
2 answers
SQL ISNT RESPONDING
I USE SSMS SO IN SQL THE PREVIOUS QUERIES GET EXECUTED ALSO THE NEW ONES TOO . BUT WHEN I MODIFY THE PREVIOUS QUERIES THE RESULT REMAINS THE OLD SAME .THEN AFTER THE FEW TIME PERIOD THE SAME PROBLEM HAPPENS TO THE NEW QUERIES THAT I EXECUTED. EVEN AFTER…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,801 questions
asked 2026-08-22T12:24:23.3733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Maninder Karjee
0
Reputation points
answered 2026-08-23T04:06:16.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 52%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERE%3C/text%3E%3C/svg%3E)
Rukshan edirisinghe
85
Reputation points