Newest Questions
105,257 questions
1
vote
1
answer
31
views
Semantic search database installed but not functional
I am trying to get Semantic Search feature running in my SQL Server 2019 by doing the following:
SELECT
SERVERPROPERTY('IsFullTextInstalled');
1 (this means it is installed)
SELECT
...
- 11
0
votes
0
answers
4
views
Event Monitor ACTIVITY tables not created when EM not enabled
Created the event, enabled it, validated that it's active, but no tables appeared.
Do I first have to call WLM_SET_CONN_ENV before the CAPTURESQLDLMEDCASALL tables are created, or am I ...
- 694
0
votes
0
answers
31
views
Optimise "Virtual Keys" in PostgreSQL Views
I am integrating data display software that expects tables for a dynamic use case, and have opted to produce views for the display software to consume. Essentially, the data display issues queries of ...
- 143
0
votes
1
answer
24
views
Enabled always statement level trigger on logical replication target does not seem to fire
Overview
I have the following setup using Azure PostgreSQL flexible server v17:
a main database containing a certain table included in the table list for a logical replication publication
a replica ...
- 1,191
0
votes
1
answer
8
views
Negative lookahead in table-matching pattern for psql or pg_dump
I'm trying to do a schema-only pg_dump of my database, however with data from one or two specific tables included. This means I can't use the --schema-only or --data-only options of pg_dump, and I can'...
- 604
0
votes
1
answer
23
views
MariaDB --skip-grant-tables --skip-networking appears to remain despite removal from cnf files
AlmaLinux 9.6
We have recently been having some big issues with a Plesk update from MariaDB 10.5 to mariaDB 10.11.14 .
This now seems to be resolved (I reinstalled the MariaDB and the data from a dump)...
- 269
0
votes
1
answer
24
views
impdp failing in AWS RDS - seems RDS internal package (RDS_SYS_TRIGGER_UTIL) is missing or invalid?
In my job we have 3 Oracle database servers, hosted in AWS RDS - one for development, one for testing and one for production.
We have a years-old bash script that uses expdp and impdp to export ...
- 101
0
votes
0
answers
25
views
MongoDB compound index usage to avoid in-memory sorting
This question on MongoDB compound index:
Below is a sample document in a given collection test.
{ a : 5, b : 3, c: 2, d : 1 }
Given a compound index { a: 1, b:1, c:1, d:1}, Which of the below query ...
- 1,019
0
votes
2
answers
29
views
How to resolve "phantom" tables in the tablespace?
We run a Plesk server, for our sins. We yesterday did an update from MariaDB 10.5.17 to 10.11.14
SYSTEM:
AlmaLinux 9.6
Plesk Obisidan 18.0.73
An issue that has been identified with this is that ...
- 269
-5
votes
1
answer
193
views
The query times out when executed through the application
I have a query that, when executed in SQL Server Management Studio takes only 2 seconds to run, but when I execute it through the application, it takes 1 minute and times out. I increased the timeout ...
- 41
0
votes
2
answers
98
views
SSMS Noob Error: The query references an object that is not supported in distributed processing mode
I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is to do a recursive joins on 4 different views but to start with I tried something basic and received the following ...
0
votes
1
answer
21
views
Two sequences associated with one identity column
One of my clients has a database in which a single identity column
(called id in that table) has two sequences associated with it(!)
Both sequences display
Sequence for identity column: <schema>....
- 9,520
0
votes
0
answers
17
views
Exporting a whole iSeries database to reinject it in PostgreSQL
I am trying to recover a client's data hosted on an iSeries server. It is very probably a DB2. There are 2000+ tables to transfer.
I have access with jdbc and tried with DBeaver (which gives the best ...
- 197
0
votes
2
answers
98
views
SQL Server 2019 (v15) : tempdb related files eat up about 80 GB on C disk, how to make it small and free up some space in C
On Windows Server 2016 and with SQL Server 2019 (v15.0), the tempdb file size is huge at about 80GB and it is divided into many files such as:
tempdb.mdf,
tempdb_mssql_2.ndf
tempdb_mssql_3.ndf
...
...
- 111
1
vote
1
answer
183
views
Log file AutoGrow Cancelled/timed out
WE have our Autogrowth on our Database set to the following:
ROWs Data - Size 25000MB - Autogrowth by 10%, Unlimited
Log - Size 345789 - Autogrowth by 10%, Limited to 2097152MB
Database is throwing ...
- 143