All Questions

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

After changing nls_characterset the data inside a table changes from one language to another

After the characterset is set to WE8MSWIN1252 we see that a certain table value appears in english (as it should be), but after we change characterset to al32utf8 since it is a product requirement for ...
0
votes
0answers
12 views

Scaling Users in MongoDB

Our team has been tasked with a fairly open ended request for a MongoDB with multiple users that can access and submit documents to collections for a graduate class. The team is all new to MongoDB and ...
1
vote
1answer
33 views

Need help in parallel execution of current running queries

I need some help in understanding if there is any problem here with very high utilization of CPU on my read-only server. Read-only means this server is secondary read-only configured via LS where DW ...
0
votes
0answers
13 views

How to connect to a database in SQL Sever Management Studio (SSMS) using Microsoft OLE DB Provider for SQL Server

After asking this question, I realized that the true slowness comes from SQL Server Engine, and I used tons of things and still no success. However, I created a connection.udl file on desktop and ...
0
votes
0answers
20 views

Whats the best way to implement multi tenant architecture with multiple unique identifier

What's the best way to implements multi tenancy in a single database with one schema where current user can be identified with multiple unique identifier. Each tenant can have many business ...
-5
votes
0answers
36 views

SQL database project [on hold]

1)Identify buyers who in 1990 made at least three purchases totaling at least 10,000. 2)identify the boss who directly reports the smallest number of employees.
-4
votes
0answers
20 views

Xampp Error: MySQL shutdown unexpectedly. Please help me to fix this error , i tried lot of ways but i can't able to fix [on hold]

Here My Log : 2019-09-22 10:15:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-09-22 10:15:37 0 [Note] InnoDB: Uses event mutexes 2019-09-22 10:15:37 0 [Note] InnoDB: ...
3
votes
0answers
25 views

Are there any tools that support Database query submission, review, approval and execution workflow? [on hold]

We are a very small setup in the e-commerce space. More than often there is a need to correct data manually in our MySQL database via SQL query execution. There is 1 database administrator in our ...
-1
votes
2answers
27 views

ERROR: check constraint “dates_check” is violated by some row

ALTER table myTable ADD CONSTRAINT dates_check CHECK(start_date::date < end_date::date); Gives.. ERROR: check constraint "dates_check" is violated by some row But.. select start_date, ...
0
votes
0answers
22 views

SQL Server 2017 not occupying free memory

Recently one of our read servers (SQL Server 2017 CU2 - yes, way out of date) had its Page Life Expectancy drop from an avg of 15K seconds to 250 seconds. It is one of 2 load balanced read servers ...
0
votes
0answers
9 views

UPDATE trigger leads to Deadlock

Mysql Version: 5.6 I have a trigger on a table which has a bunch of conditions. But, the trigger does some selects at the top. I am getting deadlocks on some. DELIMITER // DROP TRIGGER IF EXISTS ...
4
votes
0answers
50 views

Change transaction isolation level inside running transaction

I'm studying transaction isolation levels in SQL Server, and I'm trying to figure out how SQL Server behaves when the isolation level changes during the lifetime of the transaction. It seems that ...
0
votes
1answer
25 views

I need to remove duplicate values SQL Left Join

My SQL code: SELECT users.id, users.username, job.category, locations.location FROM users INNER JOIN job ON users.username = job.username INNER JOIN locations ON job.username = locations.username ...
0
votes
0answers
20 views

Aggregate non identical rows values [on hold]

Is there any way to aggregates sales and other columns based on dissimilar rows values. I have one column that has different rows values for example: Product name state Sales1 Sales 2 AA1 ...
0
votes
2answers
20 views

Connecting to local database on Azure VM

Using DBforge to try and connect to a local MSSQL database on an Azure Ubuntu 18 VM, I am getting this error: A network-related or instance-specific error occurred while establishing a connection to ...
3
votes
1answer
176 views

Lost Update Understanding

https://habr.com/en/company/postgrespro/blog/467437/ gives the following example of a Lost Update: For example, two transactions are going to increase the amount on the same account by ₽100 (₽ is ...
0
votes
1answer
13 views

Azure database - unable to locate in my Azure account

I have an Azure account where a developer that used to work with me has set up an MSSQL database on an Ubuntu VM. The PHP (CodeIgniter) system I am working on logs in (so database queries work ...
-1
votes
0answers
10 views

mysql pivod query print atandance report with dates coulm

i have 2 mysql table 1 is atandance data now second table is std_atandance i wont display output like I will try many tame but can not shole this pivod query ples help me
0
votes
1answer
16 views

Postgres - how to investigate a dependency before DROPing a field

I want to drop a field from a partitioned table, POSTGRES claims there are dependencies and proposes using CASCADE. How can I check that nothing important will be deleted before risking DROP with ...
-2
votes
0answers
13 views

Configuring Performance Tuning from the Server Side

Here are the details from the server RAM : 12.00 GB CPU : Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GHz (6 core(s)) OS : Ubuntu 16.04.6 LTS Here all the settings have left the default mysql> ...
0
votes
0answers
20 views

Unexpected slow queries

Using LEMP on popular cloud-service virtual server, with MyISAM tables. The problem is that sometimes once in few hours simple mysql queries (select from where) executing several seconds (5-9) ...
0
votes
0answers
27 views

SQL Server Management Studio (SSMS) is way too slow in its GUI

I know this question has been asked before here and here. But none of them could sovle my problem. I have this environment: Windows 10, build 1903 (freshly installed) Microsoft SQL Server 2016 (SP2) (...
0
votes
0answers
13 views

How to prevent users with Global Drop Privilege DROP MySQL System Databases

I have a very specific context: For security, my Infrastructure Team will only give the DBAs Team access to MySQL not full access to servers. Their MySQL Users will have almost full global ...
1
vote
1answer
30 views

How to use parent table column inside subquery JOIN condition?

I am writing a SQL Query for pulling records from multiple tables for sending the update or added new values email notifications to the user. In below SQL Query I am getting all records which are ...
1
vote
1answer
18 views

Generate hierarchical path

I have a classstructure table: create table classstructure (classstructureid number(8,0), classificationid varchar2(25), parent number(8,0)); insert into classstructure(classstructureid, ...
1
vote
1answer
55 views

Get max, min, avg value within each 1 day range in sql server

I want to select max, min, avg value within each 1 day range. My Table looks like: +-------+---------------------+ | Value | TimeStamp | +-------+---------------------+ | 31.20 | 2019-04-...
1
vote
1answer
47 views

Creating a view that calculates percentages

I have this table getting populated with top10 destination ports every ten minutes along with a "total" entry that records the total number of bytes and packets transmitted for each port for the time ...
0
votes
0answers
16 views

Permissions issue in Docker SQL Server 2017 while restoring certificate

Docker SQL Server 2017 container @latest. Using master database. The error I am facing is the following: [S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not ...
1
vote
1answer
39 views

How do I reference a row which has two foreign keys as its primary key?

I am currently trying to setup a database managing players and teams for a competition. Players are competing in teams of two but may be shuffled. As every team combination can only exist once, I ...
0
votes
0answers
28 views

How to sync SQL Server environments with databases under simple recovery mode? [on hold]

We are looking for a tool to sync production databases to development environment, the databases to be synced are under simple recovery mode (they are for data warehouse loaded nightly) and you can ...
1
vote
2answers
22 views

Generate table of all databases and schema with a single psql command

In PostgreSQL is it possible to generate a list of all databases and all schema with a single psql command? To be concrete, let me provide an example. I have two databases in a PotgreSQL database ...
2
votes
0answers
21 views

How can I quickly update cache expiration schedules for 100s of datasets?

I have over 100 different datasets on an ssrs-2016 site. Each one of those datasets needs a new caching schedule. I have created a shared schedule to apply to each dataset, but I am wondering if there ...
0
votes
0answers
15 views

Query not excluding right amount of records using in clause

I'm trying to find excluded records from one table from another. select old_fy.* from old_fy where "old_count_or_not" = "Count Current" or "old_count_or_not" = "Count Partial" Returns 557 rows ...
0
votes
0answers
7 views

Is it possible to replicate a cluster (not just a node)?

Making a master-master cluster is easy, as is replicating one of the master nodes to a read only slave. As is replicating that RO slave to other slaves. But, of course if the master node which ...
0
votes
0answers
13 views

Updating Feed according to privacy settings (PostgreSQL, Redis) using fan-out write approach [on hold]

I am planning a system design for a social network, with following relationships between users (like Instagram) and posts that they can post. if user A follows user B, user A can see all the content ...
2
votes
1answer
22 views

InnoDB errors and crashes with MyISAM database?

I have one server with one mysql database containing only MyISAM tables. There is no other databases on the server (except system ones of course). Since it moved to mysql 5.7.27 there are InnoDB ...
-1
votes
0answers
20 views

Storing past appointments, orders and invoices as jsonb [on hold]

Will that be wise idea to store past appointments orders, reports and invoices in a postgres's json b format. Idea is, once these entities are excuted user can't change the content other than voiding ...
1
vote
0answers
16 views

Merge join does not use index for sorting on PostgreSQL

I am running PostgreSQL 10.9 and stuck with a strange problem. My schema is a typical EAV with two tables: contacts and contacts_values. There are two relevant indexes: create unique index ...
0
votes
0answers
18 views

Postgres: strange long request: A is fast, B is fast, A WHERE IN B is slow

There is a lot of rows in table "logs" (the Request A FROM). Request A is quick and Request B is quick. Put together, Request A WHERE IN Request B is very long. Is that normal? Request A is very ...
1
vote
0answers
62 views

How to get all parents associated to a child, one row for each association [duplicate]

I have a table with two columns, Parent and Child. i need to get an output list showing a child and all associated parents, one parent per row. The youngest child will show as a child in rows equal ...
0
votes
0answers
30 views

Postgres - Why Planning time for a query is greater than the execution time? [on hold]

I am working with a customer who migrated from Oracle to Postgres and is experiencing slow query performance. While troubleshooting the query performance, the EXPLAIN ANALYZE returned Planning Time: ...
0
votes
1answer
16 views

Azure Analysis Service Cube Sizes Changed Since July

we have come across very strange thing the over all size and individual sizes of all AAS cube databases where reduced with out any changes happened. Did anyone saw this change dip and any cause?
1
vote
2answers
44 views

Select random database records between subset of records having the same count(*) in a query

I have this simple query: SELECT `value`, count(*) as `noHits` FROM `topic` WHERE identifier IN ('" . implode("','", array_keys($processedIdentifier)) ."') GROUP BY `value` ...
2
votes
1answer
37 views

SQL Server Installation - TempDB not created in the directory specified in ConfigurationFile.ini

I'm attempting to install SQL Server 2016 SP2 on a newly created EC2 instance. I'm using a configuration file I previously generated. In the configuration file I've specified where I'd like the TempDB ...
1
vote
1answer
19 views

Increase Postgres Transactions per second [on hold]

Is the TPS restricted by some sort of config parameter or underlying hardware? I'm coming up against a performance issue where my production DB is running 45 TPS, by comparison my local DB which can ...
1
vote
1answer
14 views

Postgres: Getting the “partition number” instead of row_number

Figure a table with the following data, how to exclude 'alone' values? id; data (1, 'foo'), (2, 'foo'), (3, 'foo'), (4, 'bar'), (5, 'bar'); (6, 'jak'); I try with this: select id, data, row_number()...
0
votes
0answers
12 views

Reclaim disk space after drop table from database in mysql

I have this version of MySQL server: mysql Ver 8.0.15 for Linux on x86_64 (MySQL Community Server - GPL) I use a some large tables. When I truncate database with truncate database <name>, I ...
0
votes
1answer
29 views

Removing all Schemas and Objects from a database, excluding specific Schemas and Objects

I have a database with three main Schemas; Global Permissions Unique Schema name based on the customers ID number (1, 2, 3, 4, ect...) Each customer has objects in all three schemas, with the Global ...
1
vote
0answers
40 views

oracle 11g select distinct issue

I have a big table (61mil rows) that has an indexed not-null column ID. I want to select the distinct values of that column. I expected the select distinct id from bigtable ; to run fast, making ...
0
votes
1answer
18 views

DB for searching posts by keywords in them (full text search) [on hold]

I'm trying to build some kind of social network, where users could post Posts, similar to Facebook. Each post could be in different Places, and it will also include hashtags for better search if ...

15 30 50 per page