281 questions
3 answers
Alternative to UNION
I have a UNION Query that is combining information from a History Table and the current Master Table. We are talking about a few million rows here. The problem is the amount of [tempdb] space it is allocating and using for the UNION. So we thought if we…
SQL Server | SQL Server Transact-SQL
![](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, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
3 answers
unable to install SQL server setup exist code (decimal): 2068052413 error description. Fatal error during installation
Hi guys, i encountered the above error message and will need your help. I opened the error description link and it opens up xbox page.. Got confused! As i have read the error description but i don't understand it The error log summary text folder is…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,786 questions
asked 2026-04-06T13:41:58.38+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(252.8, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOK%3C/text%3E%3C/svg%3E)
Olumide Kuforiji
0
Reputation points
commented 2026-04-23T13:59:55.5266667+00:00
Olumide Kuforiji
0
Reputation points
1 answer
Filters (slicers) in Power BI
Hi, currently I am a bit lost in slicers topic - I have a star schema with single direction relationships from dimensions to fact table, the slicers are created from the dimension tables, but currently I am able to create a combination in slicers which…
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,371 questions
asked 2026-04-23T10:12:47.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(70.4, 13%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Michaela Jakubikova
0
Reputation points
commented 2026-04-23T12:12:53.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(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
1,300
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Express 2025 - database size limit
Hi, I’ve installed SQL Server Express 2025 on a Windows Server 2019 Standard machine. I created a new instance and restored a database that was previously running on SQL Server Express 2019. The database size is currently close to 10 GB, and I only have…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-04-23T11:54:27.3833333+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, 49%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mateusz Wantoch-Rekowski
0
Reputation points
answered 2026-04-23T11:54:41.98+00:00
Q&A Assist
1 answer
SQL Server Developer Edition – Request for Formal Clarification on Usage Restrictions and Boundaries
We are requesting formal clarification at an organisational level regarding the licensing limitations and permitted use of SQL Server Developer Edition, to support corporate governance and audit compliance. To ensure correct interpretation and consistent…
SQL Server | Other
14,729 questions
asked 2026-04-23T10:59:24.18+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(211.20000000000002, 11%, 30%)' 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)
Mohammad Sultan: H&F
0
Reputation points
answered 2026-04-23T10:59:54.51+00:00
Q&A Assist
1 answer
SQL Server Developer Edition – Corporate Licensing Clarification on Permitted and Restricted Use
We are seeking formal clarification at an organisational level regarding the licensing terms of SQL Server Developer Edition, to ensure our enterprise use complies fully with Microsoft licensing requirements. Please provide an authoritative statement…
SQL Server | Other
14,729 questions
asked 2026-04-23T10:35:54.19+00:00
Mohammad Sultan: H&F
0
Reputation points
commented 2026-04-23T10:47:04.89+00:00
Mohammad Sultan: H&F
0
Reputation points
1 answer
SQL Server 2025 Standard Key not working for Power BI Report Server
I am attempting to convert my evaluation edition of Power BI Report Server to a fully activated. I have read in both of the articles linked below that the exact same key used to activate SQL Server 2025 Standard (17.x) is what you should use to activate…
SQL Server | Other
14,729 questions
asked 2026-01-30T15:38:53.39+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, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kyle Minard
0
Reputation points
commented 2026-04-23T09:17:46.16+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(134.4, 49%, 23%)' 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)
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
2 answers
SQL server generating different query_id for same query_text_id after mirroring failover
I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-01-30T13:50:19.4766667+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(134.4, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
udhayan d
181
Reputation points
commented 2026-04-23T09:15:01.8266667+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
1 answer
Microsoft ACE.OLEDB.12.0 is not registered while import excel file
Microsoft ACE.OLEDB.12.0 is not registered -
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-01-27T08:59:23.8633333+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(92.8, 15%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENE%3C/text%3E%3C/svg%3E)
Noseda, Enzo
0
Reputation points
commented 2026-04-23T09:12:01.8133333+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
1 answer
Can not install SQL server
I tried to install QL server on my new laptop and seems it's not working at all. Herewith the summary: Summary_TUFA1420250817_20260114_071102.txt I installed using SQL2019-SSEI-Expr, even I tried uninstalled all and tried using SQL2022-SSEI-Expr but…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-01-26T15:01:06.8466667+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, 57.99999999999999%, 31%)' 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)
Santos
0
Reputation points
commented 2026-04-23T09:04:15.5566667+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
3 answers
SSMA for Db2 cannot connect to Db2 running on AIX.
SSMA for Db2 cannot connect to Db2 running on AIX. connection string is: Provider=DB2OLEDB;Password=[password];Persist Security Info=True;User ID=[UserId];Initial Catalog=[DB Name];Data Source=[DB Name];Authentication=Server_Encrypt_Pwd;Network…
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.
605 questions
asked 2025-11-20T02:22:21.9466667+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(268.8, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Ikuo Takekawa/竹川 育夫
0
Reputation points
commented 2026-04-23T05:51:59.81+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
2 answers
Where to find Standard Runtime SQL 2025 (version 17)
Where to find Standard Runtime SQL 2025 (version 17) that is used by Microsoft Dynamics GP?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-02-22T22:20:02.2566667+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, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cindy Mikeworth
21
Reputation points
recommended 2026-04-23T05:45:12.7433333+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, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL server management studio 22
Hello, I need help. I am totally new to SQL. I have downloaded SQL server management studio 22. When I try to upload excel files into my database i click: Database -> Tasks -> Import Data HOWEVER, Import Data I can not click on. When I try to…
SQL Server | Other
14,729 questions
asked 2026-02-20T08:39:13.67+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(262.40000000000003, 61%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Melisa
0
Reputation points
recommended 2026-04-23T05:44:47.63+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
2 answers
Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer
Hello, I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro. I installed: Database Engine Services (Default instance: MSSQLSERVER) Integration Services (added later via “Add features to existing…
SQL Server | Other
14,729 questions
asked 2026-02-22T20:30:09.4333333+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(236.8, 57.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sabyasachi Paul
0
Reputation points
recommended 2026-04-23T05:45:01.8933333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
can you use ssrs integrated mode in sharepoint subscription edition
can you use ssrs integrated mode in sharepoint subscription edition
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,155 questions
asked 2026-04-06T20:40:18.06+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, 47%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Reeves, Jim
0
Reputation points
commented 2026-04-23T05:05:16.4633333+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
2 answers
SSRS 2016 (V13.0.6470.1) Error: Failure sending mail: An internal error occurred on the report server.
Receiving issue with SSRS e-mail subscriptions. Can send e-mails via the shared mailbox using PowerShell on same server successfully. Issue is only when trying to send via SSRS 2016. It started occurring 2 days ago and was working prior. Makes me think…
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,155 questions
asked 2026-04-13T21:38:01.45+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(310.4, 60%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Brian
1
Reputation point
commented 2026-04-23T05:13:56.07+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Restore procedure on a database when replication is enabled
Hi, I have a database in production for an application. Sometimes sometimes requires restores. Replication is enabled on the server as there is an ELT tool replicating the data to a data warehouse. There are 2 databases which are the Publishers but there…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-04-14T04:46:13.4833333+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, 62%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mohammed Misselmany
20
Reputation points
answered 2026-04-23T05:22:22.3866667+00:00
Mohammed Misselmany
20
Reputation points
2 answers
SQL Server Always on AG group failing to failover to secondary
We are experiencing SQL Server Availability Group failover issues. The same problem is occurring across multiple Availability Groups on the same server. We identified that the ODBC drivers were uninstalled and have since reinstalled the drivers and…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-04-14T10:43:25.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(294.40000000000003, 48%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Narasimha Gopavarapu
0
Reputation points
commented 2026-04-23T05:29:49.9133333+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
1 answer
Deux codes d'activation de Ms MSQL Svr runtime 2022 lot ESD ne fonctionnent plus
Bonjour, Nous avions commandé deux licences SQL serveur 2019 Std Runtime 2022 lot EDS OEI 5 clt avec les cartons et tous les numéros de série encore disponibles, mais les serveurs sur lesquels ces licences ont été activées sont depuis quelques jours…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
692 questions
asked 2026-04-14T16:11:53.8566667+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(192, 65%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENT%3C/text%3E%3C/svg%3E)
Nawal TAHIRI
0
Reputation points
commented 2026-04-23T05:10:47.09+00:00
Akhil Gajavelly
1,810
Reputation points Microsoft External Staff
Moderator
1 answer
Setup issue on Sql express 2017
Hi, Do I need to create the instance before the setup can continue, for the issue below?
SQL Server | Other
14,729 questions
asked 2026-04-23T05:41:14.9166667+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(236.8, 43%, 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)
Scott Huang
3,366
Reputation points
answered 2026-04-23T05:41:27.0466667+00:00
Q&A Assist