Unanswered Questions
13,763 questions with no upvoted or accepted answers
18
votes
0answers
421 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
420 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
0answers
610 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 ...
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 ...
9
votes
0answers
136 views
Incorrect process utilization from System health extended events?
I have been recently working on understanding the data or metrics being stored in system health extended events event file.
We are trying to implement the data collection of performance metrics using ...
9
votes
1answer
692 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
0answers
366 views
UPDATE STATISTICS options fail in Amazon RDS SQL Server
In Amazon RDS SQL Server (any version/edition), create a temp table and update statistics on it. This works fine:
IF OBJECT_ID('tempdb..#t') IS NOT NULL
DROP TABLE #t;
GO
CREATE TABLE #t (id INT ...
8
votes
0answers
202 views
Do I need a “downtime” to update a stored procedure? (Due to “definition changed” error)
I always thought that updating a stored procedure was something I could do while users were actively using the system.
But I am currently testing out an update to a stored procedure and while a long ...
8
votes
0answers
146 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 ...
8
votes
0answers
467 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
21k 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 ---
...
7
votes
0answers
63 views
What are the practical impacts of the sys.dm_exec_query_stats warning in the documentation?
The documentation for sys.dm_exec_query_stats states the following:
An initial query of sys.dm_exec_query_stats might produce inaccurate
results if there is a workload currently executing on the ...
7
votes
2answers
122 views
Increase Max Memory setting on a SQL Server Production
I have a production box with 5 instances on.
Version: SQL Server 2014 SP3 Enterprise.
I discovered that even though the machine has ~400GB memory assigned, the combined MAX MEMORY settings on all 5 ...
7
votes
0answers
99 views
SQL Server 2016 & 2017 Force Plan failing with reason 8695
I'm trying to force a plan using query store but it keeps failing with reason 8695 according to data in SYS.QUERY_STORE_PLAN the last_force_failure_reason_desc is 'General_Failure'.
Does anyone know ...
7
votes
0answers
98 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 ...
