Newest Questions
105,298 questions
0
votes
1
answer
28
views
Difference in SSIS command line
I run a nightly job that compares SQL Agent jobs between AG nodes. On some of the jobs that run SSIS packages, there is a slight difference in the command line tab. The jobs run ok on both nodes but ...
- 53
1
vote
0
answers
85
views
SQL Server Express Master database corrupted tables
I'm helping out someone where it looks like their previous developer stored some data tables in the Master database in SQL Server Express 2014. I don't know if it was to see if one could get around ...
ulysses1904
0
votes
1
answer
52
views
Unable to Delete Database - Chunks Stuck in "Recovering" State
I'm encountering an issue where I cannot properly delete a database because some chunks are in "recovering" state.
Environment:
DolphinDB Version: 3.00.2.4, Single mode
OS: Centos 7.7
What ...
- 3
0
votes
1
answer
59
views
Why does READ COMMITTED allow Phantom Reads in PostgreSQL?
When writing SQL queries against a large PostgreSQL database, I am seeing phantom reads despite setting the transaction isolation level to READ COMMITTED. Can you provide a concrete example of a multi-...
- 13
2
votes
1
answer
378
views
Do canary tables make sense for Availability Groups?
For all HA or DR solutions in SQL Server, I have heard that it is smart to have a table with a timestamp column in each database and to have an Agent Job run every minute to update that timestamp with ...
- 1,362
0
votes
1
answer
25
views
change ownership of output file when run as postgres user or redirect?
I am making a query as user postgres via my current user, xyz. I am returning the results of this query as JSON. I want to save this (huge) JSON into a file owned by my current user xyz. And I do not ...
- 103
0
votes
2
answers
58
views
PLSQL query to return the trackingcodes only if all its cashout_trackingcodes belong exclusively to that trackingcode
I have a table with below structure:
create table TEST_REFUND_CASHOUT
(
f_gdate DATE,
trackingcode VARCHAR2(4000),
cashout_trackingcode VARCHAR2(4000),
cashout_date ...
- 1,502
0
votes
0
answers
20
views
How to draw labeled precedence graph to test for view serializability?
Time | T11 | T12 | T13
--------------------------------------------
t1 | r(x) | |
t2 | | w(x) |
t3 | w(x) | |
t4 | | ...
- 101
0
votes
0
answers
38
views
Kitchen Sink Pagination - How to avoid recompiles or bad estimates when materializing intermediate result sets (temp table vs table variable vs CTE)?
I have a high-traffic SQL Server stored procedure that runs thousands of times per hour. The procedure loads a filtered set of “projects” for a user, identifies the “active task” for each project, ...
- 821
-1
votes
1
answer
50
views
Access denied for user to a database?
A user I'm supporting is getting an error. The user has grants to various tables in mydb, but when they try to access them, they get the error:
Access denied for user 'myuser'@'myhost' to database '...
- 147
0
votes
0
answers
25
views
Designing scalable sensor data storage: wide table vs single table per sensor in DolphinDB
I'm designing a system to store large volumes of sensor data (10,000+ sensors) and evaluating different schema approaches in DolphinDB.
Current Context:
Data Volume: 10,000+ sensors, continuous time-...
- 1
-2
votes
1
answer
31
views
Why am I getting a syntax error running the same code via openrecordset vs. direct connection to remote server
I've got two queries i need to run via remote server connection. They run fine if I run them by connect to the remote server FIRST, but if i use the openrecordset to run it from the command line, and ...
0
votes
0
answers
33
views
SQL Server replication is in "Performance critical" status persistently
I have multiple publication in the sql server with
SQL Server version: 2017
Transactional REplication
Distributor and Publisher are in the same server
Subscriber is on the different server
Also:
9 ...
- 111
1
vote
1
answer
36
views
Granting Monitoring privileges to a user in PostgreSQL
I am creating a new user and granting them the pg_read_all_stats privilege so they can monitor all pg_stat_* views. However, when I monitor pg_stat_activity through this user, other users' operations ...
0
votes
0
answers
17
views
Setting up Cassandra with PEMBasedSslContextFactory results in configuration error
I followed the guide for setting up client to server encryption with the PEMBasedSslContextFactory for Cassandra at https://cassandra.apache.org/doc/stable/cassandra/managing/operating/security.html#...
- 101