All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

Automatic Failover At Always On High Avability Group SQL SERVER

after i read on documentation https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15 i ...
-1
votes
1answer
48 views

Can OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY cause to create totally different execution plan and also cause query to run slow?

We have a SELECT query which is taking time (around 90 secs) to execute. It has OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY in it. When we remove OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY, it completes in 4-5 ...
1
vote
1answer
28 views

MySQL CASE WHEN is not working as expected with user-defined variables?

i need help please with the following query. I am pulling zip codes (plz) along with user id (uid) from DB and ORDER them by zip (plz) and uid. Also I use a user-defined variable @prev to check if ...
0
votes
0answers
28 views

What is mysql version?

I have installed msyql and mariadb. When checking for the versions, everything I see is the version of mariadb. How can I know the version of mysql itself? mysql -V mysql Ver 15.1 Distrib 10.3.23-...
1
vote
1answer
18 views

mariabackup crashing, help

Hi I'm using mariabackup on one of my MariaDB 10.5.4 nodes from my Galera Cluster and whenever I run it i get this from my output logs: [00] 2020-08-05 11:26:40 Connecting to MySQL server host: ...
0
votes
0answers
14 views

Convert MySQL table date/datetime column to int (unix_timestamp) with existing records

I have tables with existing data, that use date? and datetime` fields, that I want to convert to unix timestamp values (ints). For some of the tables, creating a view that calls unix_timestamp() on ...
0
votes
1answer
27 views

How to query an Extended Events target file on a SQL Azure Managed Instance by using T-SQL?

I'm setting up an Extended Events trace in a Managed Instance (NOT Azure SQL DB) for the first time. These are the steps I've carefully followed: Created a Master key on my Database. Created a ...
2
votes
1answer
48 views

Database schema design implementation feedback

I'm having difficulty on designing a database schema design with the right relationships. I'm currently trying to design a database system where a question can be answer via a live_stream. The ...
0
votes
0answers
16 views

Do Sql Server backups contain transacitons during backup? [duplicate]

I have a database that automatically takes full backup weekly, differential backup daily, and transaction log backup every 5 minutes. The full backup takes about half an hour so its runtime often ...
0
votes
1answer
24 views

Login with readonly to all databases [duplicate]

The built in SA login on a server has full access too all databases. Is there a way to have a login, that has read-only access to all databases, current and future databases? So like sa, but with ...
0
votes
1answer
30 views

Why is ALTER faster than UPDATE (for full table rewrites)?

Let's create a garbage table.. CREATE TABLE foo AS SELECT x::text FROM generate_series(1,20e6) AS t(x); Time: 14077.654 ms (00:14.078) Now, let's look at boring UPDATE, UPDATE foo SET x = 'foo'; ...
1
vote
1answer
39 views

Why does MySQL think I'm using SRID 1?

I can run the query on my local machine no problem (Server version: 10.4.6-MariaDB), but when I run it on my remote one (Server version: 8.0.17 MySQL) it poops out this error message: ERROR 3548 (...
0
votes
0answers
8 views

Sum data from one table and divide it by count of rows in joined table

I'm using postgresql. I need to sum data from one table (timeWorked from log table, summed by taskId) and then divide it by the amount of rows in the joined table (task_worker). Also join another ...
0
votes
1answer
23 views

Remote PostgreSQL DB with local buffer … how could it look like

I have a sensor which is generating a data vector let's say every second (adjustable to up to 100 vectors per second) at a remote location. The location got 4G modem to send the data. Due to power ...
0
votes
1answer
15 views

Java application not using Transparent Application failover in Oracle database

I have a customer that have a RAC environment (2 nodes, database version is 11gR2). Clusterware version: [grid@server2 ~]$ crsctl query crs releaseversion Oracle High Availability Services release ...
4
votes
1answer
27 views

Problem with enabling System Audit (Firebird's Trace and Audit Services)

I would like to enable System Audit on my Firebird 2.5.9.27139 (x64) database (Windows 10), to inspect all queries performed on it. I've already read some docs about what the configuration file should ...
1
vote
1answer
18 views

Administrator can't view tables (“server refused to connect”)

I'm quite experienced with MSSQL and MySQL/MariaDB, but I'm a newbie re PostgreSQL. I got everything to work, except for the odd detail that the admin user which I set up during installation can't &...
0
votes
1answer
15 views

Why is this (postgres) composite gin(scalar, scalar, array gin__int_ops) index not using the array criteria?

I have a table create table r_prot_search( openprot_release_id integer, annotation_group_sig text, dataset_ids integer[] ); With a composite index: create index my_index on r_prot_search ...
1
vote
2answers
32 views

What is best for a primary key? Bigint of 20 numbers or varchar / varbinary of 15 characters? [duplicate]

I have already seen some posts making comparisons of varchar with numeric fields, but most only compare with equal values ​​and do not talk about performance in primary keys. I have a user ...
-1
votes
1answer
17 views

getting last entry with ORDER BY with inner join not working [closed]

I just realized that this statement is no longer getting the last entry from attributes. I was working before I believe I had added the inner join. But adding this inner join I no longer get the ...
0
votes
2answers
24 views

I need to do periodic commits in my purge function

I wrote a purge function that runs in Postgres 9.6. The function goes through all of the tables in our application starting from the bottom most child table and ending with the top most parent table ...
0
votes
0answers
7 views

System for managing matches and teams

I would like to create a system for managing matches and teams in an amateur championship. I had thought about this type of relationship. By default ONEtoONE has been set. Can anyone tell me if the ...
0
votes
0answers
19 views

Makefile:34: /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk: No such file or directory

While installing pg_repack, I'm getting the error below: pgxn install pg_repack INFO: best version: pg_repack 1.4.5 INFO: saving /tmp/tmp1s5fkkn9/pg_repack-1.4.5.zip INFO: unpacking: /tmp/...
0
votes
1answer
25 views

Programmatic way to rewrite a query with the view definitions as sub query?

Wondering if anyone has found or knows of a way to programmatically re-write a query to use the view definition as a subquery? For example, let's say I have a view: CREATE VIEW View1 AS select * from ...
0
votes
1answer
17 views

Why is a table showing up twice in pg_class?

I am attempting to run a PostgreSQL statement to query approximate table size count estimate using the following statement: SELECT reltuples as approximate_row_count FROM pg_class WHERE relname = '...
2
votes
0answers
59 views

CHECKDB with default settings and parallelism involved

This would be my follow-up question because I am trying to understand the CHECKDB behaviors While running CHECKDB without any MAXDOP specified on below 2 servers:- Server with 10 Vcores, MAXDOP at ...
-1
votes
1answer
46 views

Oracle index analyze stats - managed by whom?

Some questions about managing indexes. We saw in some cases where indexes weren't analyzed in weeks, even though data was inserted and queried from them - using conditions that use these indexes. The ...
1
vote
0answers
7 views

~/.my.cnf settings for a custom .mysql_history file

In my development environment I have a lot of databases, and I run the same query a lot of times. Long time ago I saw a post how to have a separated mysql_history per database. That allowed me to ...
0
votes
1answer
13 views

MySQL: how to use audit_log plugin to audit user modification

I am trying to audit any user modification action (create user/alter user/drop user/rename user) on a MySQL Enterprise server 5.7.24. I have installed the audit_log plugin following the document, and ...
0
votes
0answers
14 views

SSRS: Make tables start from the top of the new page

I am trying to create a report with multiple tables. The report will be exported to Excel though. I want to have 2 tables in one page so I "Add a page break after" to every second tables. ...
0
votes
1answer
45 views

why do i have that unnatural process on my server

i have an abnormal process on my RedHat server i tried to kill it but it appears again and because of that process i can't start my fusion middleware any ideas please when I execute the command TOP ...
0
votes
1answer
9 views

POWA analyzer displays error 500 after logging in

I tried to install POWA web analyzer. I can see the login page but after login there is a 500 error message. This is the error at the server: ProgrammingError: (psycopg2.errors.InsufficientPrivilege) ...
0
votes
0answers
36 views

modelling bill split app schema

I've been trying to model an efficient schema for a bill split app, the requirements are as follows: There can be groups in which there can be multiple participants, and conversations consisting of ...
0
votes
1answer
27 views

Do I need GRANT for INSERT to table If has EXECUTION GRANT for procedure?

I have five domain users and five roles in my database. GRANT EXECUTE adds to the appropriate roles. Roles are included in other roles, i.e. at most we have one role that has grants for two procedures,...
0
votes
1answer
34 views

SQL Server 2016: Table can't grow while 313 MB is still available in the database

Yesterday, the below error was reported: Could not allocated space for object 'dbo.X'.'Y' in database 'Z' because the 'PRIMARY' filegroup is full After deletion of some records from the table by an ...
0
votes
0answers
34 views

Use of tempdb for bulk upsert operation

We are using SSIS for ETL purpose. There is a shortcoming in SSIS as it doesn't provide any in built component which will bulk upsert the destination. The alternative to it to use Staging tables which ...
0
votes
1answer
35 views

SSMS IntelliSense not working with sa user

In SSMS (versions 17 and 18), IntelliSense is not working with the sa user, but it is working with another user. If I connect to a SQL database with the sa user and create a query window, IntelliSense ...
0
votes
0answers
15 views

Oracle(12+) + Kerberos = Protocol Violation

we have an various oracle database installations and a few Kerberos KDC servers application uses JDBC driver latest 8 version and it works perfect with 11.2 version but when I try to connect to a bit ...
1
vote
1answer
30 views

Oracle multiple databases only able to access one database

I am new to oracle. I've installed oracle 12c(required to be this specific version) in my windows pc with no problem. I created one database named LOCAL using Database Configuration Assistant. Then i ...
0
votes
0answers
18 views

Trigger having issues on partioned table execution - Postgres - 11

Postgres - Trigger having issues on partitioned table execution I am using postgres 11 version I am trying to execute a trigger on partitioned table with customized function and trigger function, that ...
0
votes
0answers
36 views

Select Changed Rows in MySQL and Postgres without Timestamp column

I have the following scenario: I have 2 source systems, one running Postgres, the other running MySQL. An ETL process (using Azure DataFactory and Azure Integration runtimes) runs the Extract for a ...
-2
votes
1answer
29 views

Would this kind of table structure be wasteful and stupid, or superior to my current way of doing it?

I currently have this table structure: CREATE TABLE people ( id bigserial, timestamp timestamptz DEFAULT now() NOT NULL, PRIMARY KEY (id) ); ...
-2
votes
0answers
31 views

how to sum sales after MAX purchasing date in SQL

Select "Item No_", MAX(case when ("Entry Type" IN (0,4)) and ("Quantity" >0) then "Posting Date" else 0 end) as "PUR DATE", MAX(case when "...
2
votes
1answer
25 views

Why did adding a self-referential foreign key freeze the table?

I'm running PostgreSQL 11.5. I have a simple table of registers. create table register( id serial primary key, name text not null ); This table is small (~6000 rows), relatively heavy read (100s ...
0
votes
0answers
5 views

Redshift using back slashes in a like statement causing it to fail

So i am attempting to filter a query on a file path field with a like statement using the below '%text\Text\text%' this returns no results '%text_Text_Text%' this returns the expected results To ...
0
votes
0answers
27 views

Putting data into a 3nf database: do you normalize before or after data input?

If i want to end up with a 3NF database, I see 2 options: Generate an excel sheet of denormalized data all in one big ugly table, insert, then sort the data from the external table into my normalized ...
1
vote
2answers
35 views

High autovacuum CPU/IO usage from database with more than 10k append-only tables

In my system I have more than 10k tables that are very similar, I only do insert operations in these tables and delete old data via a cron schedule one time per day. These insertions come each minute, ...
2
votes
4answers
58 views

How can I dump the schema of a SQL server database on Linux?

UPDATE: My goal is to get a set of SQL commands that can b executed and would recreate the database that I made including all the resources such as tables, indexes, trigger functions, privilege grants ...
2
votes
0answers
31 views

MySQL router on server with tomcat memory leak

Memory is slowly used by mysql router. I am running mysql router version 8.0.20 (I found there was a memory leak on mysql router 2.1.2 but mysql router 8.x is newer) I have a 3 node single-primary ...
0
votes
1answer
31 views

How to install Oracle's sqlplus on a Mac? [closed]

I need steps how to install Oracle's sqlplus on a Mac.

15 30 50 per page
1
3 4
5
6 7
1702