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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Lastest Report Viewer Runtime
What is the latest version of the Report Viewer runtime?
SQL Server Reporting Services
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
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