21,049 questions with SQL Server-related tags

Sort by: Updated
1 answer

SQL Server is not being Install in Laptop

Hi, I have purchased a new asus laptop on 12th Nov, I am trying to get install mssql server in my personal laptop. But I am not able to install it in my laptop. Please help me regarding this.

SQL Server Database Engine
asked 2025-11-14T13:18:58.21+00:00
Shailendra Chauhan 0 Reputation points
commented 2025-11-14T23:10:20.85+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
2 answers

Over 300gb of space for the Microsoft SQL Server folder

Hi everyone, I'm currently using SQL as part of my College studies, but, after a few weeks of using, I realized my Hard Disk was running a little low. So, I checked the Storage Sense, and turns out that Microsoft SQL Server is eating over 300gb of space!…

SQL Server | Other
asked 2022-04-03T13:18:30.637+00:00
Benedict Osvaldo 1 Reputation point
commented 2025-11-14T23:05:09.7866667+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
2 answers

When I try to install sql server express 2019 it shows the system can not find specified path

I have tried to install SQL server express 2019 for many times, but It shows the system can not find specified path. I donwload from official site And uninstall all the previous sql server, but still shows this problem

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-11-12T18:31:12.8633333+00:00
Abu Saleah 0 Reputation points
answered 2025-11-14T22:44:48.9033333+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
1 answer

I just cant find a fix to this error.

I tried to fix this using different methods but none of it worked https://learn.microsoft.com/en-us/answers/questions/2337222/unable-to-install-sql-server-exit-code-(decimal)-2 …

SQL Server Database Engine
asked 2025-11-12T15:12:24.24+00:00
Ometh Dasanayake 0 Reputation points
commented 2025-11-14T22:35:27.7533333+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
1 answer

LocalDB log file missing after idle

I have a SQL Server 2019 Developer Edition database backed up to a .bak file and restored into LocalDB. The restore succeeds, and the database works fine until LocalDB auto-shuts down. When it restarts, I get: "The logical database file…

SQL Server | Other
asked 2025-11-10T19:08:21.2533333+00:00
TryCatchThis 0 Reputation points
commented 2025-11-14T22:24:28.11+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
1 answer

Cannot connect to SQL Server - username issue

Trying to connect to SQL Server and getting "Login failed for user '<username>'. (Microsoft SQL Server, Error: 18456). My other colleagues are using the same credentials to log in with success. Don't know what else to do.

SQL Server Database Engine
asked 2025-08-26T15:19:50.46+00:00
Hugo Mendonca 0 Reputation points
commented 2025-11-14T12:10:04.1+00:00
Vinay Kumar Eshwara 5 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000 this error how to solve

how to install sql error without error in wndows 11 os version 24H2

SQL Server Database Engine
asked 2025-08-16T11:01:32.76+00:00
sneha k 0 Reputation points
commented 2025-11-14T12:08:58.5233333+00:00
Vinay Kumar Eshwara 5 Reputation points Microsoft External Staff Moderator
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
Alex Kipritsis 1 Reputation point
commented 2025-11-14T12:08:02.8466667+00:00
Vinay Kumar Eshwara 5 Reputation points Microsoft External Staff Moderator
0 answers

Did VMWare Tools break msdb?

Had a VMWare Tools upgrade from 12.5.1.52451 to 12.5.3.52671. The SQL servers were not rebooted after the upgrade was pushed. Weeks later after the SQL servers were rebooted, many of the instances came back up with msdb in a recovery pending state. We…

SQL Server Database Engine
asked 2025-08-21T20:33:52.62+00:00
bukkybu 386 Reputation points
commented 2025-11-14T12:06:30.8933333+00:00
Vinay Kumar Eshwara 5 Reputation points Microsoft External Staff Moderator
4 answers

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##

The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…

SQL Server Database Engine
asked 2025-08-05T14:53:19.4333333+00:00
anna@tec 0 Reputation points
commented 2025-11-14T11:51:50.1233333+00:00
anna@tec 0 Reputation points
2 answers One of the answers was accepted by the question author.

Can we uninstall Microsoft odbc driver 12 from a server running sharepoint server 2016 ?

Can we uninstall Microsoft odbc driver 12 from a server running sharepoint server 2016 ? We think this is only there for the sharepoint installation. ODBC driver 17 is also present.

SQL Server Database Engine
asked 2025-11-13T12:04:16.64+00:00
Greg Booth 1,396 Reputation points
accepted 2025-11-14T08:45:39.7966667+00:00
Greg Booth 1,396 Reputation points
3 answers

How to find Missing non clustered Indexes

Is there way to find Missing non clustered Indexes on Particular Database? Thank you

SQL Server | SQL Server Transact-SQL
asked 2025-08-12T15:50:01.7033333+00:00
Jinal Contractor 121 Reputation points
commented 2025-11-14T08:07:56.22+00:00
Singam shetty Sri ganesh 80 Reputation points Microsoft External Staff Moderator
2 answers

Why cannot the Maintenance Plan be deleted

Version:2008r2 Language:Chinese Error Text:LoadFromSQLServer方法遇到了OLE DB错误代码0x80004005 (通讯链接失败)。发出的SQL语句已失败。 I tried searching, but couldn't find any content that was exactly the same as my situation. If you need me to provide additional information to…

SQL Server | Other
asked 2024-01-31T09:09:18.4833333+00:00
博雄 胡 705 Reputation points
answered 2025-11-14T07:57:13.4333333+00:00
博雄 胡 705 Reputation points
1 answer

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Hello everyone, I am currently preparing for the DP-900: Microsoft Azure Data Fundamentals exam and would like to get an expert's clarification on a specific question. The question is as follows: Which T-SQL statement or clause should be used to…

SQL Server | SQL Server Transact-SQL
asked 2025-08-19T14:21:02.75+00:00
Anabella Noemi Santillan 0 Reputation points
commented 2025-11-14T07:11:00.8566667+00:00
Thumu Sai Pranay 0 Reputation points Microsoft External Staff Moderator
1 answer

My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?

My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?

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,105 questions
asked 2025-08-04T15:08:51.5733333+00:00
D H 0 Reputation points
commented 2025-11-14T06:53:42.7033333+00:00
Thumu Sai Pranay 0 Reputation points Microsoft External Staff Moderator
2 answers

Unable to add a machinename to SQL > Security > Login

We have successfully added machine names to the SQL Server running on an Azure VM, and they are functioning perfectly. However, when attempting to add a particular server, we receive a message indicating that it is already added. When we try to list it,…

SQL Server | Other
asked 2025-11-13T19:59:35.02+00:00
Payne, Scott 41 Reputation points
edited an answer 2025-11-14T06:32:29.3066667+00:00
Akhil Gajavelly 720 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server 2022 Express Edition Install Error

During installation, I received the error below. I downloaded this from the link in the Microsoft Learn Introduction to Transact-SQL module. How do I get this resolved?

SQL Server | Other
asked 2025-11-13T16:51:39.8233333+00:00
Ian Rodriguez 0 Reputation points
commented 2025-11-14T03:55:21.9+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator
3 answers

Lastest Report Viewer Runtime

What is the latest version of the Report Viewer runtime?

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,105 questions
asked 2025-11-13T03:35:15.4866667+00:00
Rizal 0 Reputation points
commented 2025-11-14T02:22:24.7366667+00:00
Rizal 0 Reputation points
1 answer

How to clear the restoring status on a sql database resulting from a cancelled restore process

A database restore was accidentally started to the incorrect database within Microsoft SQL Server Management Studio. There was an option to cancel the restore, so that was selected. The restore stopped but not the database is not accessible because it…

SQL Server Database Engine
asked 2025-11-14T00:19:38.64+00:00
DiannaS 0 Reputation points
commented 2025-11-14T01:33:47.26+00:00
DiannaS 0 Reputation points
2 answers One of the answers was accepted by the question author.

what could be the advantage and disadvantage of disabling lock escalation for some tables in sql server .

One of our application vendor provided suggestion to disable lock escalation for some tables in database to fix performance issues. From DBA end we suggested not to disable but they strongly recommended to disable. Can I have expertise advice what could…

SQL Server Database Engine
asked 2025-11-13T09:52:05.2166667+00:00
Seelan, Sathiya 100 Reputation points
answered 2025-11-13T16:46:05.54+00:00
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator