All Questions

Filter by
Sorted by
Tagged with
-1
votes
0answers
9 views

How to search one bible verse from a source that may contain ranges?

My WordPress system contains posts with a field containing Bible references and ranges, eg. "John 5,1-10; Matthew 3,2; Mark 1,1-5". User searching for "John 5,3" or "Matthew 3,2" or "Mark 1,2" all ...
2
votes
0answers
18 views

History of updated rows

Imagine we have a CRUD application in Python and are using SQLite. Let's say we have in SQLite a table called CUSTOMERS: CREATE TABLE CUSTOMERS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT ...
0
votes
2answers
19 views

Group results from two differenct tables on same hours

I have two simple tables: indoor id | timestamp | temp | humi outdoor id | timestamp | temp and two selects which give me time and average temperature grouped by same hour for the last 24 hours: ...
0
votes
2answers
18 views

Monetary value in integer over decimal datatype

I have came across several articles that mentioned that advise on not to store monetary value as decimal, but use integer instead. The reasoning that it does not store actual value and will cause some ...
0
votes
0answers
5 views

What is Diagnostic.data file in MongoDb data folder?

I'm trying to create a backup server for my mongodb using the strategy of copying files. I wonder what is Diagnostic.data folder? Should I copy that too? or I can simply ignore it? My Diagnostic....
0
votes
0answers
6 views

select rows and calculate number of rows based on parent column value

I have a total of three tables with a many-to-many relationship. 1.) users id | email ----------- 1 | usera@example.com 2 | userb@example.com 3 | userc@example.com 2.) accounts id | userId | ...
0
votes
1answer
15 views

deadlock detected during oracle expdp

I have an Oracle 11g and I wanted to export all my shcema objects, with this command: expdp as '/ as sysdba' directory=DIR dumpfile=DWH%U.dmp logfile=DWH.log filesize=40000m parallel=32 schemas=DWH ...
4
votes
1answer
91 views

Double entry accounting schema design

We are implementing a software that allows to send "virtual" money between user internally. We have started our database with a single entry as follow (simplified table). We only one record one ...
0
votes
1answer
14 views

How to have MS Analysis server setup of both modes: multi dimension and tabular

Ref: Is there a way to install both tabular and multidimensional modes? The answer was .."You answered your own question. You simply install another instance of SSAS.".. My MS SQL 2014 has a ...
0
votes
0answers
24 views

SQL Express Backup and Restore to Different Server

I have been translating an old ADP file format to a more current VB front end using SQL Express Back-end. In order to do this project the owners had me use either VPN or Team-Viewer in to a ...
0
votes
1answer
11 views

Implementing Feature max limit (Logical)

so this is a more of a logical question. I'm having trouble deciding on what I will use on implementing limit, let's say for example ticket limit where I have 2 plans, one is standard which have 100 ...
0
votes
1answer
12 views

pg_restore: [archiver] did not find magic string in file header: please check the source URL and ensure it is publicly accessible

I have been trying to push a dump file from my local Postgrel DB (which I uploaded into my Google Drive and is accessible to public) into my Heroku remote DB with the following URL: heroku pg:backups:...
0
votes
0answers
13 views

Storing parent-child with n amount of depth

I am recording information in a MySQL database about the components web page. For example, page A has 2 tabs, each of which has 5 links inside it. Some of those links may actually expand to be a group ...
0
votes
0answers
4 views

Dimensional Modeling in Redshift - How wide to go?

I am playing with Redshift as a solution for a data warehouse I am architecting and I am trying to get my head around best practices for dimensional modeling in this case. I am using one source ...
0
votes
2answers
30 views

Mssql database old bakup restored on production server

I am using mssql server 2016, I have accidentally restored the 24 hours old database backup file on production server, so I have lost the data for today, means I have lost the data of 24 hours, is ...
0
votes
0answers
25 views

More Efficient 3-Period Rolling Average Calculation

I have a table of numeric answers to survey questions. The goal is to call a stored procedure, with a parameter for PeriodType ("Quarter", "Month", or "Year") that returns this output: Year Period ...
-1
votes
0answers
21 views

Which SQL database is good for Angular? [on hold]

I am trying to create a project with Angular V8, and like to know what SQL database is good for that?
-1
votes
0answers
37 views

How do you objectively measure the effectiveness of a data model?

Not sure which topic this belongs under, but I'm doing research on the theory behind the following questions: What is the best data model for a particular data set (let's say this data set is large, ...
0
votes
1answer
27 views

Is this Database Model for university is correct

The education system in our country is a little bit different from other countries. We take subjects all through the year and finish the year with the same subject. We have 4 main exams through the ...
0
votes
0answers
14 views

Is possible to send email alert / notification for long running query in OEM

Due to long running queries our batch failed sometimes so we requested to identify if any query is running more than 5 min then it should be killed and alert / notification to the team. Is this ...
1
vote
0answers
17 views

Windows MySQL: Create table with DATA DIRECTORY

I'm using Mysql on Windows 10, can I create a new table on another drive(different than the drive that contains the MySQL data directory) without creating a new MySQL instance? When trying to create ...
0
votes
0answers
20 views

Sometime duplicate record produced despite validation through select statement in mysql

I have this old code snippet in PHP. I am saving user vote for each question. For a single uniquest question user can enter only one vote but sometime (not always, unable to reporduce it) the user ...
0
votes
0answers
4 views

Auto-complete in pgAdmin: how to get it to automatically appear?

It looks like auto-complete is only activated after hitting ctrl + space https://www.pgadmin.org/docs/pgadmin4/4.12/keyboard_shortcuts.html This is unexpected to me: not quite as "auto" as I would ...
0
votes
1answer
26 views

Find records size in kb/mb/gb for one client from multiple table in one database

I have multiple client using same database, i need to find client wise size utilized.
1
vote
2answers
21 views

differences between EDU and thread

in db2, there is this command that shows active EDUs (engine dispatchable unit): db2pd -edus there are 2 fields in output:EDU ID and TID according to db2pd-page each are defined like this: EDU ID: ...
-1
votes
0answers
29 views

Unknown column 'type' in 'where clause' [on hold]

I have a Joomla / VirtueMart ecommerce site using a payment plugin from vivawallet . I've started to get the below error when a customer pays for their goods 1054 error Unknown column 'type' in '...
0
votes
0answers
9 views

Design: Maintaining Common Database Entries for Different Users

Scenario We have a requirement that presents some items for the users that they can add to their 'shopping' cart. There are some common items between users, but users can add / edit the names of the ...
0
votes
0answers
19 views

MySQL Delete with Sub-Query Costs Hundreds of Seconds While Select Query Costs Much Less

I have two tables which are defined as below: CREATE TABLE `a` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `data` ...
0
votes
1answer
19 views

ER Diagram Question

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 ...
7
votes
1answer
46 views

Using XQuery to filter out some children, but preserve parents

SET NOCOUNT ON; DECLARE @xml AS Xml = '<a><b>bbb</b><c>ccc</c><d>ddd</d></a>'; SELECT @xml; SELECT @xml.query('/a/*[self::b or self::c]'); SET @xml....
0
votes
1answer
13 views

How to change default collation for any charset in MySQL?

How to change the default collations listed by SHOW CHARACTER SET? For utf8 I need to change it to utf8_unicode_ci. Or is there any switch to enforce the _unicode_ci over _general_ci for any UTF8xx ...
1
vote
1answer
57 views

T-SQL Stored Procedure Returns Before Completing

We are running into a very curious error. We have two production SQL Servers. We call a stored procedure on one (call it Server_A) that calls a stored procedure on the other (Server_B). The stored ...
1
vote
1answer
34 views

Should a DBA be able to write basic T-SQL? [on hold]

I am a SQL Server database developer (not a DBA) and I find myself frustrated working with my company's new DBA. I'm trying to figure out whether my expectations are unreasonable. For the sake of ...
1
vote
0answers
5 views

Restart a GTID Based MySQL Master-Master Replication

I can see many good articles around the web about setting up MySQL Master-Master Replication with GTID. However, strangely enough, I simply can't find the same about in how to stop and start it. My ...
1
vote
1answer
20 views

MySQL: How to determine a value type?

I am looking for some function that will return the type of given value/result like TYPE(value). Similar as for charset/collation for which there are functions CHARSET(value)//COLLATION(VALUE). I ...
1
vote
0answers
19 views

SQL Server : Memory pressure,Spiked user connections and CPU usage

I have the below sql server environment. SQL Server 2016 standard edition. 128 GB RAM 96 GB alllocated to SQL Server 8 tempdb's with 1 GB each. Have a major database with 2.5 TB size. Reporting also ...
3
votes
1answer
39 views

Seting MAXDOP for SQLserver 2016 and above

I was going through MS documentation reg: setting MAXDOP starting SQL2016 as that Automatic soft NUMA enabled by default and getting confused on how to make the changes to current SQ2014 and SQL2012 ...
4
votes
2answers
53 views

Fast alter column NVARCHAR(4000) to NVARCHAR(260)

I have a performance problem with very large memory grants handling this table with a couple of NVARCHAR(4000) columns. Thing is these columns are never larger than NVARCHAR(260). Using ALTER TABLE [...
-1
votes
0answers
18 views

Oracle 12c- AWR deadlock finding

Its easy to find out locking from V$ views. I am investigating AWR with deadlock detection. Can anybody please provide the SQL query?
0
votes
0answers
8 views

Import Excel sheet to access database using vb.net [on hold]

I am developing software in vb.net for sales invoices. Where I need to import invoice data from excel file to vb.net Grid Data View and then save into access DB. I will use DB data in the future for ...
0
votes
0answers
15 views

Show Processlist state “Statistics”

Please note that "its not a duplicate thread because I already set variable optimizer_search_depth and didn't find any impact". Sometime, our database/application services crashed due to max ...
0
votes
0answers
38 views

Linguistic corpus design: order elements of different tables

I'm trying to design a database for a linguistic corpus search engine. Basically there is a manuscript which contains several songs, and every song in turn contains stanzas and proses. Since stanzas (...
0
votes
0answers
7 views

IDERA Rapid SQL- Typing Latency Causing dropped characters [on hold]

Just wondering if this is just the setup in my current company with all of the security installed on this machine. There is MASSIVE latency in typing so much so that you have to very purposefully pay ...
2
votes
2answers
48 views

Should I put criteria inside my join or where clause when optimizing?

I am trying to figure out whether query 1 or 2 is more optimal and it appears that having my criteria inside my WHERE clause is more optimal than inside my JOIN clause: -- 1) "ups" inside where ...
1
vote
1answer
42 views

SERVERPROPERTY('HadrManagerStatus') equating to 1 even if Always On is not configured

We have a SQL Server Enterprise 2017. I would like to get insights as to why our SERVERPROPERTY('HadrManagerStatus')returns 1 even if Always On is not configured in this instance. I have a local ...
1
vote
1answer
38 views

Cannot choose Storage option on a table in SSMS for standard edition

I am looking into partitioning of tables for SQL Server on two different machines. One machine runs Microsoft SQL Server (RTM) 2016 Developer Edition, and the other is running Microsoft SQL Server ...
0
votes
1answer
18 views

DML queries with different performance on similar servers

I am measuring the performance between two servers that serve a database via MySQL 5.6. The DB1 server is a dedicated database server and the DB2 server shares resources with other services such as ...
1
vote
1answer
6 views

Cannot remove orphaned InnoDB Temp Table - missing .frm file

For the second time, I have encountered an issue, where our MySQL server (MariaDB v10.1) suddenly threw an error - Could not remove temporary table: './database_name/#sql-4593_791', error: 120. ...
0
votes
0answers
13 views

select * from schema.table takes longer than explain analyze select * from schema.table from pgAdmin 3 [duplicate]

I have a table which contains 300.000 rows. I am trying to select * from schema.table from pgAdmin and psql. Execution time from the pgAdmin: explain analyze select * from schema.activity; "Seq ...
1
vote
1answer
17 views

IORA-00904: Invalid Identifier when converting Radians to Degrees

I am using this simple query in Oracle SQL Developer to basically convert a value in Radians to Degrees but I get error at the function itself. SELECT Degrees(1.571) as ANGLE FROM DUAL; Error: Ora-...

15 30 50 per page