All Questions

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 ...

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 ...

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 ...

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-...

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: ...

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 ...

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 ...

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 ...

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 ...

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 ...

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'; ...

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 (...

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 ...

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 ...

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 ...

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 ...

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 &...

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 ...

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 ...

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 ...

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 ...

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 ...

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/...

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 ...

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 = '...

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 ...

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 ...

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 ...

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 ...

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. ...

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 ...

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) ...

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 ...

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,...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

I currently have this table structure: CREATE TABLE people ( id bigserial, timestamp timestamptz DEFAULT now() NOT NULL, PRIMARY KEY (id) ); ...

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 "...

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 ...

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 ...

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 ...

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, ...

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 ...

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 ...

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