536 questions
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
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-12T13:27:56.99+00:00
Alex Kipritsis
1
Reputation point
1 answer
Link https://go.microsoft.com/fwlink/?linkid=2216019 changed installer?
Hi, For years whe have used a script to download and install SQL 2022 EXPRESS. The link we used to download the SQL 2022 installer is https://go.microsoft.com/fwlink/?linkid=2216019 But recently the link suddenly points to a SQL 2025 Express…
SQL Server | Other
14,620 questions
asked 2025-12-12T12:56:07.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(259.20000000000005, 84%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jens Schumacher
0
Reputation points
answered 2025-12-12T12:56:15.3066667+00:00
Q&A Assist
1 answer
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
536 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-12T12:44:50.3233333+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
Trouble configuring SQL Server Always On
I have created an AD setup. Joined two sql vms(primary and secondary) into that AD. I have then installed failover clustering on both the sql nodes, and created a cluster. Then I have enabled SQL Server Always On Availability Groups. Next, while…
SQL Server Database Engine
536 questions
asked 2025-12-08T13:21:50.4033333+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(230.39999999999998, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sree Harshita Maddala
0
Reputation points
edited an answer 2025-12-12T11:52:44.1266667+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(284.8, 66%, 37%)' 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)
Shruti Dhruv
405
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-12T11:51:01.2333333+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
where can I download report builder for mac or linux (arm 64)
I am looking for installation binary or the like. Even an APT or Cask command.
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-11T17:04:32.9733333+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(188.79999999999998, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Eric Rosenblum
0
Reputation points
answered 2025-12-12T11:49:48.0966667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
Can I install SQL 2008R2 on server with TLS1.2 or higher enabled
Hello, I have a requirement to upgrade SQL 2000 databases. I am thinking to install SQL 2008R2 , restore SQL 2000 backup file on SQL 2008R2, upgrade database ( provided it goes through). If successful, i will upgrade it further to SQL 2016 or SQL 2019,…
SQL Server Database Engine
536 questions
asked 2025-12-02T16:24:47.6533333+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(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mudit Gupta
81
Reputation points
commented 2025-12-12T11:48:37.1533333+00:00
Lakshmi Narayana Garikapati
650
Reputation points Microsoft External Staff
Moderator
2 answers
Issue with SSRS Reports Portal after migration from 2016 to 2022
We have recently migrated from SSRS 2016 to SSRS 2022. The installation of SSRS 2022 has been done. ReportServer is working fine but Reports portal is throwing error "Exception: System.Web.HttpException (0x80004005): Unable to validate data."…
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-09T21:36:46.1466667+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, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
MANDAL Suryani
0
Reputation points
answered 2025-12-12T11:43:26.5733333+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
1 answer
begin stack dump error no sql server 2012
Tenho um micro com Windows Server 2008 R2 enterprise com o SQL Server 2012. Este vem apresentando falha. No Event Viewer aparece esta mensagem: The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 8 time(s). No log do SQL, no…
SQL Server Database Engine
536 questions
asked 2025-12-03T10:51:55.7+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(233.6, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rodrigo de Oliveira Gomes - PrestServ
0
Reputation points
commented 2025-12-12T11:10:27+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
1 answer
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise: a) Why this is being reported so frequently? b) Does it indicate the limit is being hit? c) If b is true, how can I increase…
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-04T13:43:34.7033333+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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
231
Reputation points
edited a comment 2025-12-12T11:05:42.6566667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
4 answers
SQL Configuration step issue in Ubuntu Instance
While configuring SQL Server for the first time on Ubuntu_22.04-x86_64-SQL_2022_Standard-2025.08.28, I encountered an error that occurs frequently. I need to retry the setup 2–3 times before it works properly. Any Solution to fix this part? ++ bash -c…
SQL Server Database Engine
536 questions
asked 2025-12-04T05:16:29.8166667+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(12.8, 23%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Pratik Narottam Panchal
0
Reputation points
commented 2025-12-12T10:50:38.8866667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
Is there a changelog/release notes for MS Report Builder?
Is there a changelog/release notes for MS Report Builder? Note: This is not Power BI Report Builder. I couldn't find a separate forum for MS Report Builder, but knew that the product was associated with SSRS. FYI, the download link for the product I…
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-05T20:53:51.71+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(284.8, 77%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NK
1
Reputation point
commented 2025-12-12T10:48:01.2166667+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
2 answers
Wait on the Database Engine recovery handle failed
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: 2025-12-07 16:55:50 End time: 2025-12-07 16:59:41 Requested action: …
SQL Server Database Engine
536 questions
asked 2025-12-07T11:39:56.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, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZP%3C/text%3E%3C/svg%3E)
Zapadiya, Prahlad
0
Reputation points
commented 2025-12-12T10:45:53.7+00:00
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
3 answers
Internal error: An unexpected error occurred (file 'mdmodelmd.cpp', line 2669, function 'MDModelMD::DecodeRelAttr').
Hello, When I execute the following MDX query, I get this error: Internal error: An unexpected error occurred (file 'mdmodelmd.cpp', line 2669, function 'MDModelMD::DecodeRelAttr'). What does this error mean and how can I avoid this? The…
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,365 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(73.60000000000001, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
![](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(124.80000000000001, 23%, 22%)' 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)
1 answer
Error execute a SSIS Packed with SQL Agent
Hello, we have a very strange problem when executing an SSIS package with the SQL Agent. The package has the following tasks for an Excel file: 1. Check file in the source path. 2. Copy file to the destination path. 3. Open file in the destination…
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-07-31T11:15:48.86+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(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wolfgang
0
Reputation points
commented 2025-12-12T08:19:56.43+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(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
5 answers
SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered
Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…
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-06-24T18:20:55.04+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, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ryan
16
Reputation points
commented 2025-12-12T08:16:07.9+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 2022 CU18 Crashing with EXCEPTION_ACCESS_VIOLATION
SQL Server 2022 CU18 is experiencing crashes approximately 1-2 times a month since installation. The error log shows the following message: 2025-03-18 08:20:04.77 spid70 SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005…
SQL Server Database Engine
536 questions
asked 2025-03-18T23:00:19.1266667+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-12T07:48:11.58+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
3 answers
Joins vs Functions and Performance
It is axiomatic that joining to another table from your primary table to retrieve data, using primary keys, provides better performance than using a function. At least that's what I know from the last time I cared about it years ago. It's time to care…
SQL Server | SQL Server Transact-SQL
254 questions
asked 2025-07-03T19:12:57.03+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, 97%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Don Thompson
0
Reputation points
commented 2025-12-12T07:45:50.4966667+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
Microsoft Entra ID not working in SQL Server VSCode
Whenever I try to use my Microsoft Entra ID on the SQL Server extension in VSCode, I click 'Sign in', which takes me to the authentication page in my browser where I sign in. I get the page that says I am signed in and can close the browser, but the…
SQL Server Database Engine
536 questions
asked 2025-07-11T17:39:09.76+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(160, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Carlos Casellas Garza
5
Reputation points
commented 2025-12-12T07:43:51.5133333+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
1 answer
How to delete subscriptions in PowerBI RS
Hello, I have a user which has lot of subscription in PowerBI Report server. I want to delete all the subscriptions associate with this user. Please let me know how can i do it? Thanks
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-07-15T06:59:58.66+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(12.8, 21%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bilal H. Bhatt
136
Reputation points
commented 2025-12-12T07:41:13.88+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator