Unanswered Questions
13,897 questions with no upvoted or accepted answers
18
votes
0answers
395 views
9i streams capture doesn't evaluate rules
I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
13
votes
1answer
295 views
Why is PostgreSQL choosing the more expensive join order?
PostgreSQL using defaults, plus
default_statistics_target=1000
random_page_cost=1.5
Version
PostgreSQL 10.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 6.4.0) 6.4.0, 64-bit
I've vacuumed and ...
11
votes
1answer
7k views
Use LDAP for name look up with Oracle Instant Client
Partly as a result of having problems with conflicting versions or bitness with the full installation of Oracle client, my development team (of which I'm a member) has been moving towards using Oracle ...
10
votes
0answers
513 views
Splitting Snapshot files with MaxBCPThreads for Transactional Replication
I've just set up a publication, and I'm attempting to get the snapshot to apply faster. So far the Distribution Agent is respecting the MaxBCPThreads settings, but the Snapshot Agent is not. I'm ...
9
votes
1answer
198 views
Optimizing a 'latest' query in Postgres on 20M rows
My table looks as follows:
Column | Type |
-----------------------+-------------------+
id | integer |
source_id | integer ...
9
votes
1answer
601 views
HADR high worker thread usage
Why would an availability group's number of worker threads in an HADR pool increase well beyond minimum usage of "typically, there are 3–10 shared threads" per replica?
In one case we've observed ...
8
votes
1answer
165 views
Database Design for Forecasting Review
I am trying to learn more about Relational Databases and I figured there is no better way to learn then to actually do something. I decided to make a personal attempt to look at Personal Budget ...
8
votes
0answers
380 views
Why does RDS PostgreSQL always recover on restart?
I am running an RDS instance of PostgreSQL 9.6.3: select version(); returns PostgreSQL 9.6.3 on x86_64-pc-linux-gnu [...].
I have found that after issuing a stop from the RDS console followed by a ...
8
votes
1answer
20k views
Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
If I do CAST(1 AS SIGNED INTEGER) I always end up getting a BIGINT returned, for example:
$ mysql -u root -p --column-type-info
Enter password:
--- Copyright and help message snipped for brevity ---
...
8
votes
4answers
5k views
What is the meaning of “select * from relational(owner.table)”?
We recently got some errors in our alert log of the form
301598: Tue Jul 16 03:58:29 2013
301599: ORA-01555 caused by SQL statement below
301600: SELECT * FROM RELATIONAL(<owner>.<table>)...
7
votes
0answers
58 views
What cases benefit from the Reduce, Replicate, and Redistribute join hints?
The From Clause Documentation starting with SQL Server 2008 briefly mention 3 join hints and their basic mechanisms:
Reduce
Replicate
Redistribute
However there does not seem to be much information ...
7
votes
0answers
106 views
Statistics disappearing/empty randomly throughout the day
I've got a SQL Server 2017 (CU9) database that is exhibiting some performance related issues that I believe have to do with the index statistics. While troubleshooting I discovered that the ...
7
votes
1answer
235 views
Blocking caused by Query Store. Unable to clear or disable
I recently updated our 2016 SQL Server to SP2 and the most recent CU (KB4458621) released in August 2018. Just in the last day or so, I noticed that I have some blocking going on. I can't kill the ...
7
votes
3answers
350 views
Foreign Key with a Constant
Let's say I have a table A, that has two columns: one is an ID for ThingA, and one is an ID for ThingB. The primary key is (ThingA, ThingB).
Next, I have a second table, but this time it's restricted ...
7
votes
1answer
2k views
Query External LDAP Server from SQL Server
I have done extensive research on querying LDAP Server but so far has not been able to work around. Therefore, asking experts help
Background: I have a client whose LDAP Server is OnPremise (though ...
