540 questions
3 answers
SQL Server 2025 executing request with in SQL connexion is very slow
Hello, I installed SQL 2025 on a new VM to test the installation of my application, which currently runs on SQL 2022. I’m facing an issue with SQL 2025 (fresh installation on a new machine with a new DB): the queries are extremely slow when I use a SQL…
SQL Server Database Engine
![](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(310.4, 57.00000000000001%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
1 answer
Alternative manner to implement an hierarchy without using recursive CTEs
Hi, I'm searching an alternative manner to implement an hierarchy in T-SQL without using recursive CTEs. Actually, a MS Fabric warehouse doesn't support a such useful feature and I need to use recursive CTEs in some scenarios. Any suggests to me, please?…
SQL Server | SQL Server Transact-SQL
255 questions
![](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(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
SQL Server Agent not starting after installing KB5071544
My SQL Server Agent service does not start after a reboot of the server to complete installation of KB5071544. Event logg shows ID 7000, stating timeout occured. I tried increasing the tme out to 5 mins but no change. I am running SQL server 2019…
SQL Server | Other
14,623 questions
asked 2025-12-11T19:18:14.1566667+00:00
Abraham Libu Varghese
0
Reputation points
commented 2025-12-16T04:06:09.2766667+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(172.8, 28.000000000000004%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Abraham Varghese
0
Reputation points
2 answers
SQL Server Express 2025 installation issue on hp omnibook 7
I have got new HP Omnibook 7 flip ultra 7. I am trying to install sql server express 2025 but every time it failed. The exit code is -2061893606 (Error description: Wait on the Database engine recovery handle. Check sql server error log for potential…
SQL Server Database Engine
540 questions
asked 2025-12-16T00:07:22.9033333+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(185.6, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Amanullah Dar
0
Reputation points
answered 2025-12-16T00:16:59.19+00:00
Amanullah Dar
0
Reputation points
3 answers
Can we downgrade MS SQL SERVER 2022 STD to MS SQL SERVER 2012 R2 STD?
If I purchase a license for SQL Server 2022 Standard Edition but need to downgrade to SQL Server 2012 Standard Edition because my current application only supports the 2012 version, what steps should I take? Specifically, could you please advise on where…
SQL Server | Other
14,623 questions
asked 2025-12-15T07:36:48.44+00:00
Wuttinun Phusawang
0
Reputation points
answered 2025-12-15T22:28:10.7266667+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
2 answers
What are some database design best practices or strategies for dealing with instrument time series data from a SCADA system?
I am interested in learning some of the best practices for database design for dealing with the copious amount of data which can come from a SCADA system for lab/research machinery where several instruments could be logged at a high frequency. I have…
SQL Server | Other
14,623 questions
asked 2025-12-15T15:57:43.48+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(198.4, 85%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Stephen Young
0
Reputation points
answered 2025-12-15T22:21:32.84+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
5 answers
Error installing SQL Server: Exit code(Decimal):-2061893606 Error description: Wait on the database Engine recoveryhandle failed SQL installation failed
Hello, I have been having issues installing the sql server The error log I got is pasted below Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: …
SQL Server | Other
14,623 questions
asked 2023-01-31T09:39:28.58+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(25.6, 97%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOD%3C/text%3E%3C/svg%3E)
Olusoji Daniel
55
Reputation points
answered 2025-12-15T22:07:56.6466667+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(112.00000000000001, 6%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Valery Astakhov
0
Reputation points
1 answer
Is it possible to use Entra id authentication in SSMS 22 new migration tool?
I'm attempting to migrate an on-premise server to azure using the new built-in migration tool in SSMS 22. I'm only able to use Entra ID to authenticate into the Azure server, and when attempting to connect to the target server I don't see any option…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
587 questions
asked 2025-12-09T14:53:39.7333333+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(0, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Schmitt, Victor
0
Reputation points
commented 2025-12-15T22:01:26.31+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Descrepancy between SalesLT.SalesOrderDetail and SalesLT.SalesOrderHeader?
I deployed a new AdventureWorks LT. When I query: select * from SalesLT.SalesOrderDetail where salesorderID = 71774 there's 2 rows: SalesOrderDetailID's 110562 and 110563. They both have a linetotal of 356.898000 so when I query: select sum(LineTotal)…
SQL Server | SQL Server Transact-SQL
255 questions
asked 2025-12-10T14:31:19.0566667+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(60.8, 5%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jasper Versteegh
0
Reputation points
commented 2025-12-15T14:27:30.7633333+00:00
Jasper Versteegh
0
Reputation points
2 answers
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few…
SQL Server Database Engine
540 questions
asked 2025-12-12T12:06:09.9233333+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(41.6, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
20
Reputation points
commented 2025-12-15T11:25:15.75+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server licensing with SA for Distributed Availability Group
I need help in understanding how many licenses I need specific to Distributed Availability Group solution below with Software Assurance benefits and purchased licenses. Region A: 3 Replicas with 2 read-write and 1 HA replica Region B: 3 Replicas with 2…
SQL Server | Other
14,623 questions
asked 2025-12-11T19:27:28.0333333+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, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
VYAGHRESWARUDU KOTTURI
0
Reputation points
commented 2025-12-15T11:24:25.58+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
Select most recent data per record from multiple tables
I am trying to get the latest data for a record from multiple tables. The issue I am running into is that the data on each table could have been modified at different times and each table may contain multiple rows per record. I am currently using row…
SQL Server | SQL Server Transact-SQL
255 questions
asked 2025-12-10T15:59:27.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(265.6, 6%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H
0
Reputation points
commented 2025-12-15T11:19:54.4133333+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
SSMS 20.2 Import Wizard Throwing Error at Server End
I was trying to use the import wizard in SSMS and found that the destination servers was throwing the above error. The error that the server administrator has sent me is: "The EXECUTE permission was denied on the object…
SQL Server | Other
14,623 questions
asked 2025-12-10T14:34:02.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(144, 11%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Richard Williams
15
Reputation points
commented 2025-12-15T11:18:51.62+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
Why is run now not showing for SSRS subscriptions
I don't have the option to run now on my subscriptions.
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,121 questions
asked 2025-12-08T18:43:32.6466667+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(32, 40%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Rhonda Norrid
0
Reputation points
commented 2025-12-15T11:13:13.91+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
What happens to my account when the Volume Licensing Service Center (VLSC) is replaced by the Microsoft M365 Admin Center?
ボリューム ライセンス サービス センター(VLSC) からMicrosoft M365 管理センターに変わったため、SQLサーバ2008R2や、2019のボリュームライセンスがダウンロードできない。 弊社のアカウントが現在Microsoft M365と紐づいているが、過去のボリューム ライセンス サービス センター(VLSC) とは結び付いていない。
SQL Server Database Engine
540 questions
asked 2025-12-05T04:57:21.5133333+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(243.2, 94%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
しんどう
0
Reputation points
commented 2025-12-15T11:11:02.11+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
1 answer
SQL 2022 SSIS with ACE 12 32bit error unexpected Termination
Hi We had a set of SSIS package on SQL 2016 writing the output to Excel with different tabs. In the old server we have ACE 2010 version 14 32bit. We had to upgrade our servers to Windows 2022 SQL 2022 we installed ACE 16 32bit but when running the SSIS…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
asked 2025-09-14T08:49:48.7566667+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(102.4, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Katayoun Sarab
0
Reputation points
commented 2025-12-15T11:08:30.58+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Developer
SQL Server Developer Editionについて教えてください。 ライセンスの数量、有償、無償範囲、 Enterprise EditionとDeveloper Edition違い、 Developer Editionの5年稼働における注意点、AWS EC2で利用の注意点、 サポートの違い また、以下の構成でSQLライセンスを購入予定ですが 何か留意点はございますか？ 本番用：32 vCPUのEC2 → SQL Server Enterprise Edition…
SQL Server Database Engine
540 questions
asked 2025-12-15T05:30:07.8033333+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(214.4, 90%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
吉田明伸
0
Reputation points
answered 2025-12-15T10:51:52.8866667+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
1 answer
Timeline for Release of NEXT GEN Feature for Managed Service in Azure
What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,665 questions
Azure Managed Applications
Azure Managed Applications
An Azure service that enables managed service providers, independent software vendors, and enterprise IT teams to deliver turnkey solutions through the Azure Marketplace or service catalog.
200 questions
SQL Server | Other
14,623 questions
asked 2025-01-07T15:40:00.9233333+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2025-12-15T08:42:04.68+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, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sten Lomme
0
Reputation points
3 answers
SQL Server 2022 vs 2019 Query Performance gap
I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…
SQL Server Database Engine
540 questions
asked 2025-08-13T13:50:03.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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alex Kipritsis
1
Reputation point
commented 2025-12-15T07:02:15.7066667+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(32, 59%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
vinay kumar eshwara
0
Reputation points
1 answer
Unable to open script task in VS 2019 SSIS
HI Team , I am unable to edit script task in SSIS for Visual studio 2019. I have tried the following steps re-install VS Re-install SSIS extension Repair SSIS extension another recommendation was given to repair Visual studio Tools for…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
587 questions
asked 2025-12-15T05:00:15.13+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(240, 56.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kumarjit Chakraborty
0
Reputation points
answered 2025-12-15T05:01:24.5466667+00:00
Q&A Assist