New answers tagged sql-server
0
votes
MSSQL database slow when move database on other disk
Please try to update statistics and defrag existing indexes on the database you moved. Use Ola Hallengren scripts which you can download from here.
EXECUTE dbo.IndexOptimize
@Databases = '...
- 361
0
votes
How to solve the intermittent failed execution of SSIS package in debug mode
thank you all for your support.
I was able to solve all my problems.
here are the actions performed:
updated tools used: sql server 2019 CU23, Microsoft Visual Studio Community 2022 Version 17.8.1, ...
0
votes
How to solve the intermittent failed execution of SSIS package in debug mode
Are you using the old Attunity Oracle Connector? That connector was deprecated in SQL Server 2019 and replaced by the Microsoft Connector for Oracle. You can install the new connector from here. You ...
- 361
0
votes
System.EnterpriseServices Error when trying to connect Excel or PowerBI to a SQL Server
Had the same problem. Ended up adding a User DSN that connects to the SQL Server database and then connecting to the database via ODBC rather than connecting by the obvious choice "From a SQL ...
1
vote
How to Return the SQL_DB log files (.ldf) to the default Application
You can not return it to the default application because there is no default application - .log files are not supposed to be opened with anything except SQL Server. The steps to undo an assignment are ...
- 51.8k
0
votes
How to Return the SQL_DB log files (.ldf) to the default Application
There is no default application to open those files, they are binary files used by the SQL Server storage engine and are not meant to be accessed directly.
The ".log" file extension makes ...
- 70.7k
Top 50 recent answers are included