All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
3 views

pg_ctl hangs over ssh

I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am ...
0
votes
0answers
4 views

What it is better to choose for installation of postgresql - debian or ubuntu? On base big loading

I have a big base postgre sql on Windows the server. 200 GB, are a lot of different requests. I plan migration this base to Ubuntu. What distribution you recommend to use? Ununtu 18.04 or Debian 9/10?...
0
votes
0answers
9 views

Mysql removing null value rows from column

I want to remove null values only from column and not a table because I find suggestions to remove from values from table.
1
vote
1answer
13 views

Does AE certificate include both master and encryption keys together?

After setting up Always Encrypted, I can see a certificate in my Current User when selecting select * from sys.column_master_keys under the key_path I see this location, but there is no location ...
0
votes
0answers
5 views

Aggregation vs Ternary relationship - When to use?

I am reading a book about database systems and in the chapter covering database design using ER, the author aims to explain when to use aggregation versus ternary relationship. In short, each Project ...
0
votes
0answers
11 views

Indexes for combined time and location data

I have a multi-TB table with geolocation data for a certain item id and timestamp. It is partitioned by time with a partition for every month (~500GB), and clustered (including the partitions) on the ...
0
votes
1answer
24 views

Get value from one field, and paste it in to a new column

I'm relatively new to Microsoft Access, and just a beginner with SQL programming. I have a table in MS Access. It is an import from a .txt file. In the first column There is a String with a Number or ...
0
votes
0answers
8 views

Facing permission error while trying to execute a stored procedure published through CLR

I've created a stored procedure using SQL CLR c# stored procedure in Visual Studio 2017 and I've published it in MSSQL Server. Now I can see my stored procedure, but I face this error when I want to ...
0
votes
2answers
12 views

Get matching part from conditional pattern

I'm having a table like this: |id|key |value | ------------------------ | 0|name |Homer | | 1|surname|Simpson | | 2|town |Springfield| I'm running this query: SELECT * FROM ...
0
votes
0answers
10 views

Search for partial and full matches in two tables

I have two tables users and products: 1) users: id | username | ... | ---------------------- 1 | name1cat | ... | 2 | cat | ... | 3 | name4 | ... | 4 | test | ... | 2) ...
-1
votes
1answer
34 views

Expand range of values in SQL

I have a table named "codes" where some of the entries will be as shown below. Code Description ----------------------------- 123[10-50]% ABC 433[10-500]% PQR I have to ...
0
votes
0answers
12 views

How to make related functions and procedures into one unit in mysql

I want to make related procedures and functions into single unit like packages in sql and access from that like PackageName. Function() in mysql Is it possible in MySQL if so explain with simple ...
0
votes
0answers
10 views

Oracle Materialized View - Is it Safe to Use Only ROWID as Record Identifier?

this is a question related to Oracle 12c. I'm currently trying to create MVs as data sources for Golden Gate replication. We need fast refresh because We have to replicate 60,000 rows + at one time ...
0
votes
0answers
18 views

How to verify the restored MS SQL DB from Backup matches with the source?

Once you restore the backup, how do you verify that the source and destination are in sync (schema, datatypes, number of records etc)? assuming that the source has not change. Appreciate your insights....
0
votes
0answers
11 views

Nested Sum if statement with DateDiff

Problem: Need to account for delays in review process. The field "EC2WL" is when an employee submitted a case to the Work Leader for review and the field "WL1stReview" is when the Work Leader first ...
0
votes
1answer
42 views

Run a stored procedure only the last 3 days in a month

How can I run a stored procedure only the last 3 days of a month using a T-SQL script?
1
vote
1answer
8 views

Connection pooling - NodeJS or Database products?

Consider the mysql package. The description covers connection pooling thus, Rather than creating and managing connections one-by-one, this module also provides built-in connection pooling using ...
0
votes
1answer
19 views

is “create schema” the same way of saying “create database”?

I'm a beginner in DBMS, sorry if my question sounds dumb. I often see some textbooks says: create a schema . does it that mean "create a database"? But isn't that a schema is also a skeleton of a ...
-1
votes
0answers
18 views

Would a database hosting service benefit from compressing its consumer's data?

Not sure if this is the stack to ask the question but here it goes. Assuming I'm entering a partnership with a database hosting service which charges me on one criteria: how much space my data takes ...
0
votes
0answers
12 views

ProxySQL and MySQL cluster

This article describes the set-up of MySQL cluster with one cluster node, two data nodes and one MySQL server. This article describes the configuration of ProxySQL where, MySQL servers are added into ...
1
vote
1answer
18 views

What's the problem with PostgreSQL temporary files?

I'm studying PostgreSQL architecture and in almost every book or blog post I read people say that we have to track any increasing of temp_files numbers and find the best work_mem size to avoid new ...
0
votes
1answer
13 views

Multi Master replication vs Single-Master performance

I'm trying to wrap my head around a hypothetical scenario. Imagine we have a very write-heavy distributed database and sharding is not an option. I wonder if / how is multi-leader replication (...
0
votes
1answer
15 views

three tables relation order is correct but values are false

i have those tables table1 | id | name | | 1 | axe | | 2 | bow | | 3 | car | | 4 | dart | table2 table3 | t1_id | ...
0
votes
1answer
25 views

Database from EXTREMELY disorganized Excel Sheet

First of all, I would like to say that I am familiar with Databases but all of my knowledge has come from undergraduate coursework, and am by no means an expert. I have been tasked with creating a ...
1
vote
2answers
15 views

MySQL5.7 Find_In_Set alternative

I have a table that contains User information from different countries. Information like - Name, Country, LastLoginDate, IsUpdated, Certification. This table has 1.5 million rows. Now to filter this, ...
0
votes
1answer
41 views

how to retrieve MAX ID from inner join SQL Query?

I am working on a search stored procedure which, the outcome of the procedure retrieving search rows in increments of 60. The values that this stored procedure is receiving is the search value, ...
-1
votes
0answers
12 views

Preferred database management system to compare datasets for analytics [on hold]

Preferred database management system to compare data-sets for data analytics purposes. Please provide some insights for the heads up. Some of the application serving areas are as follows: for ...
1
vote
0answers
27 views

Different Master Tables and same Child tables

I am working on Student Life Cycle management system which is in designing Stage. Now I am creating the database structure. My requirement is follows, Every year student face three term test and I ...
0
votes
1answer
48 views

SQL Server Agent Job - Unable to open Step output file. The step succeeded

I have seen many posts with "Unable to open Step output file.", but can't find any references where the step succeeded. I have my output file location set to: $(ESCAPE_SQUOTE(SQLLOGDIR))\$(...
0
votes
0answers
4 views

How Do Multiple Innodb Buffer Pool Work in Mysql 5.7

Assume that I am using the default settings in Mysql 5.7 which has 8 buffer pools and each is allocated 1GB. Then assume that there are 3 tables, each table are 2GB each. Also, assume this is a test ...
0
votes
0answers
21 views

How do I use the .ibd/.frm files to recover an InnoDB table that went missing when MySQL crashed during OPTIMIZE TABLE?

I have seen How to Recover an InnoDB table whose files were moved around but I am not sure if it's relevant, since MySQL renamed the files and there was no tablename.frm afterwards. I ran OPTIMIZE ...
0
votes
0answers
23 views

Convert Excel function to PostgreSQL [on hold]

I am looking to convert this Excel function to PostgreSQL. =INDEX(position!A:A,MATCH(species!C2,position!D:D,-1)) The function uses two tables. It looks up the for same values between the D column ...
1
vote
0answers
43 views

Availability groups multiple instance, multiple listeners

In my work environment, I have two database machines: DB01 DB02 Each database machine has three SQL Server instances: MSSQLSERVER FBG Central I've managed to set up availability groups with SQL ...
0
votes
1answer
32 views

How can I disable the @ symbol in SQL scripts for sqlplus?

In Oracle's sqlplus tool, when the script contains an @ symbol, it loads an SQL script with that name and executes it. I'm inserting a VARCHAR value which contains some CSS code, so when it encounters ...
0
votes
0answers
7 views

OS agnostic connection to MySQL database via Matlab [migrated]

I am trying to setup a database via MySQL and connect to that database using some Matlab code. I notice that there are multiple documentation pages for using Matlab to setup a connection to a MySQL ...
2
votes
3answers
226 views

How do I query for system views in a SQL Server database?

I have some queries that run against Query Store, the view sys.query_store_wait_stats is not in SQL Server 2016, but it is in SQL Server 2017. I want my queries to work in SQL Server 2016 and SQL ...
0
votes
0answers
15 views

Q: [SQL] How can I return records from a variable date range for multiple objects using one query?

Specification: I have a set of accounts. Using a single query, I wish to create a report containing the most recent 12 months of records for each individual account in the set (e.g. if A1 last billed ...
0
votes
1answer
50 views

Mssql query problem. Column '' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

There is a problem I have experienced in mssql. ( but I don't have this problem in mysql. ) They know two different engines. but I could not find a solution. Do you think I can fix this error? My ...
0
votes
0answers
16 views

Azure VM Security

With the move to Azure Cloud things are moving fast! I have a question based on Azure VM with a shared SQL Server containing multiple instances. For example if a Azure VM has 5 instances on there ...
1
vote
1answer
49 views

Inserting few millions of rows: Does indexing happens along with the insert operation

I am inserting 50 million records to an existing table with a primary key , and a non clustered key. My question is whether indexing of those will existing indexes will happen along with the insert ...
0
votes
1answer
10 views

What's best practices for changing a user's email in an application?

I'm working on a crud for an email application, and I'd like the ability to change "everything". Right now, however, it matches the JSON string to the Database based on the email address. Problem: ...
1
vote
1answer
22 views

Master Key vs Password Certificate Encryption in SQL Server

We can encrypt certificates in SQL both by the database master key, and the other option is by password. I want to know the advantages and disadvantages of DMK encryption. Does password usage make the ...
1
vote
1answer
21 views

How to restore a postgres database created via an older version of postgres?

I have a file db.backup, that I would like to restore to PostgreSQL version 11. When I tried to install via Azure Data Studio I got an error: Restore: pg_restore: [archiver] unsupported version (1....
1
vote
0answers
9 views

Postgres Service Not start using via HomeBrew

I have to install homebrew in my macOS then after I tried to install Postgres on my mac using the homebrew. but when I checked my Postgres status is it not running. /usr/local/Cellar/postgresql/11.4/...
2
votes
2answers
56 views

Backup a single table

I need to Truncate a table in Sql server which containing around 250GB data but before truncating i need to take backup of this,it may to csv file or other mode. What is best way to do it.
1
vote
0answers
17 views

Unconnected tables for predefined options in MySQL DB [on hold]

Is it okay to live some tables not connected to anything? I have a table with a set of discounts for deals. For each deal, discounts can be summed up, so I don't see the point in connecting the "...
-2
votes
2answers
27 views

Create a new calculated column by subtracting two values from a single column [on hold]

I have following data. (screenshot posted below) I wanted the result in a new column like this (screenshot posted below). The formula should be S-H value (it will be jumbled up across the dataset, ...
2
votes
1answer
60 views

How to check if backups are reliable?

I generally have to restore databases to different servers after important data imports or other important and delicate database operations. I need to be sure that my backups up to that point in time ...
-1
votes
2answers
36 views

Importing CSV file into a PostgreSQL table

I am using Python with pandas to import a CSV file into a table in Postgres import pandas as pd import psycopg2 from sqlalchemy import create_engine df = pd.read_csv('products.csv', sep=';', ...
0
votes
0answers
8 views

MySQL 5.7 - How to choose the value of innodb_online_alter_log_max_size

I've been attempting to Drop a column on a table for a few days now, but each time, it runs for a while before failing with: [Note] Aborted connection 26 to db: 'dbname' user: 'username' host: '1.2.3....

15 30 50 per page