0
votes
0answers
2 views

Is this a good way to model course assignments?

I'm having trouble designing a data model that allows for the following: Courses can have many assignments. Assignments can be defined recursively. e.g. "There is reading homework every tuesday". ...
0
votes
0answers
3 views

Entity ID field that can refer to multiple tables?

In designing both audit tables and notification tables, I've run into an issue where I need a row to refer to an entity in another table, but which table that entity is isn't always the same. For ...
0
votes
0answers
5 views

Server configuration for database installation

I will program a payroll system on visual studio 2012 C# and will be using postgresql as database for a small business but if you have any recommendations they will be well received. Now, what i need ...
0
votes
0answers
4 views

MySQL group concatenation - creation of insert statement on temp table

I have a temporary table TEST_GROUP, from where I'm working its data to fill another one. From this table, giving the example in the picture, my expected result is to group these three rows, so I ...
0
votes
0answers
5 views

Oracle: convert upper on the fly

select translate('hal','abcdefghijklmnopqrstuvwxyz','bcdefghijklmnopqrstuvwxyza') from dual; This return me correctly 'ibm' But i want IBM,how to translate on uppercase on the fly without retyping ...
0
votes
0answers
2 views

Merging Multiple SQLite DB's While Retaining Duplicate Data?

I have 8 SQLite databases that i need to merge. The problem is, they all share the same unique ids (but different data for these ids). Table 1 is for accounts and each account is assigned a unique ...
0
votes
2answers
10 views

Select MAX DATE from joined Table

I have two tables, PROJECT and BILLINGS, as follows: Project_ID Project_Client ---------- ------------------ P1 ABC Company P2 DEF Company P3 GHI Company Proj_ID ...
0
votes
0answers
5 views

Optimize Wordpress Mysql Query that take 5 seconds to execute

Here is my original post: http://wordpress.stackexchange.com/questions/189736/optimize-wordpress-query-that-take-5-seconds-to-execute I have a large wordpress mysql database (Server version: 5.6.22): ...
0
votes
1answer
17 views

Selecting where nullable boolean is not true

I have made the following code for select a record that isn,t true. SELECT * FROM Table WHERE Bool != 'true' OR Bool IS NULL; Why is the check Bool != 'true' not enough for a nullable boolean?
0
votes
1answer
6 views

Postgres 9.4, replication slots, doesn't work failover master

I've installed postgres master and slave nodes by this manual: At the master (10.0.0.1): sudo -u postgres initdb -D /data/postgres/main Change postgresql.conf: listen_addresses = '*' wal_level = ...
0
votes
0answers
8 views

Storage strategy for polynomials

What is the most space efficient way to store arbitrary length univariate polynomials? I have a large amount of polynomials that look like 3*x^7 + 12*x - 13 9*x^32 - x^14 + 2*x^3 - 9 ... Each ...
0
votes
0answers
9 views

Requirements for Setting up mysql cluster

I am very new to MySQL cluster, have been reading a lot online but could not find answers to my questions. I am setting up a MySQL cluster for an application that may scale in months to come. ...
0
votes
0answers
10 views

doing a insert while selecting an specific user

I'm importing and legacy database to a new database, and changing data format. In this legacy database, I have data as following: Interaction id: 5458d717cd07870859000004 user_id: ...
0
votes
0answers
16 views

How many database users/admins should be created for a website?

I have created a CMS website that only had one database connection for both the admin area and the user area and it only had one user("root") with no password, and now I want to upload it, but I am ...
1
vote
2answers
41 views

How can I Insert when not in table and when max timestamp T-SQL

I am trying to insert rows from one table to another that are not in the one I am moving them to. I also want to only move the ones that have the highest datestamp. (I want to only insert rows that ...
0
votes
0answers
10 views

Creating a flexible table containing prices and periodes

I'm creating a system of availability for rooms and with a calendar according to the days, with every day have it's own price. Room Type | 01 | 02 | 03 | 04 | 05 | ... | 31 | ...
0
votes
2answers
19 views

Fixing MyISAM database without losing data

My old server was crashed but I was able to recover the databases from MySQL through testdrive. I'm trying to dump a database using mysqldump but it gives error for certain tables are crashed and ...
1
vote
0answers
44 views

Parameter Sniffing Question [on hold]

My question is: If we employ a plan guide, why would we still experience the effects of parameter sniffing (ie: Where the query returns results at different speeds, 1s, 1s, 1s, 15m, 2s, 2s, etc..) ...
0
votes
0answers
13 views

Reverse Engineer not updating new Objects Oracle Data Modeler

I Have a problem. I using Oracle Data Modeler. I did reverse engineer for generate physical model. I'm using Oracle Data Modeler. I did reverse engineering of a database(?) to generate the physical ...
-1
votes
0answers
9 views

Empty Subreport is causing the entire report to show empty

I have a report in a Microsoft Access database that contains a subreport. Whenever that subreport is left empty the entire report returns empty values for every field. I am at a loss as to why this ...
0
votes
0answers
13 views

Select custom meta_key and meta_value from wordpress in single query [migrated]

I have a custom field named 'video_code' and yoast seo's custom field named '_yoast_wpseo_title', both under meta_key column like this: meta_id | post_id | meta_key | meta_value 123 ...
0
votes
0answers
20 views

The Service Broker endpoint is in disabled or stopped state - AoAG - SQL 2012 - 15 minute interval

I receive this error message in SQL error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related ...
0
votes
2answers
19 views

Selecting distinct records having multiple properties

For following table data: ID | Property ================= 1 | Sweet 2 | Sweet 2 | Sour 3 | Hot How can I get the ID's having Property Sweet AND Sour (in this example, 2) ...
4
votes
2answers
119 views

Deleting other files during maintenance plan

I have an SQL Server 2012 maintenance plan which does the normal stuff (rebuild indexes and update statistics, back up DBs, deletes .bak files older than X days, etc). Everything is working fine with ...
1
vote
0answers
5 views

MariaDB Galera Cluster Deployment

I am looking to experiment with MariaDB 10 Galera Cluster. I am looking for highly available, scalable and reliable architecture. Basically I am curious what would be the better architecture and would ...
2
votes
0answers
24 views

Backup-SqlDatabase: Cannot bind parameter 'InputObject' Error Being Thrown

I have a PowerShell script that is used in a fairly complex automated process. One thing it does is creates a database backup, and for that we are using the Backup-SqlDatabase cmdlet. I am also using ...
2
votes
0answers
30 views

Torn page SQL Server 2008 R2 RTM

DBCC results for 'bad_db'. Msg 8939, Level 16, State 98, Line 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -6794535623816839168 (type Unknown), page (26876:998677113). Test ...
3
votes
4answers
109 views

pgsql select distinct on multiple columns

Supposing we have four columns (a,b,c,d) of the same data type, Is it possible to select all distinct values within the data in the columns and return them as a single column or do I have to create a ...
0
votes
2answers
28 views

Merge MySQL tables without data repetition

My situation is this: I have several DIFFERENT tables in my MySQL database with the same name columns. Such tables can contain (or not) the same data. What I need to do is a kind of "merge" between ...
0
votes
1answer
36 views

Which columns (and order) to choose for a clustered index to maximize query performance

In our database we have a table that looks more or less like the example below. In the past we always created the CLUSTERED INDEX on the ID column on the table. CREATE TABLE [Measurement] ( [ID] ...
0
votes
1answer
30 views

how to use a specific column for a day

CREATE TABLE `csptargets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `cspcode` varchar(11) NOT NULL, `vol`decimal(20,3) NOT NULL ...
0
votes
0answers
23 views

Can connect successfully to SQL Express but not SQL Server

On my local machine I have installed: Microsoft SQL Server Enterprise Evaluation Edition (64-bit) 12.0.4100 SP1 Microsoft SQL Server Express Edition (64-bit) 12.0.2000 RTM I installed both using ...
-1
votes
0answers
36 views

Error log “errorlog.6” is corrupt and unreadable. how to run checkdisk utility? [on hold]

I am a laymen and have no idea how to execute sp_cycle_errorlog to fix my problem of removing or fixing corrupt errolog.6 file. Can someone please suggest me on how to get this rectified?
0
votes
0answers
22 views

Where do In Memory Databases typically bottleneck in regards to speed? [on hold]

Normally Databases bottleneck at I/O, not at processing power. When all the data is already in Memory, which piece of Hardware would be the most worthwhile to improve for vertically scaling the ...
0
votes
1answer
14 views

Postgres Partition Table Trigger inserting duplicate records

I have a trigger applied on my database table. But when i insert data into it via hibernate jpa it creates duplicate rows in master table. Here is the trigger CREATE OR REPLACE FUNCTION ...
0
votes
0answers
9 views

Failure to start instance resource on1 node of a 3 node of an Oracle 12c RAC

After adding a 3rd node to our 2 node 12c RAC, one of the existing node is now unable to start the database resource. Extract from crsctl stat res -t: ora.datacdb.db 1 ONLINE ONLINE ...
0
votes
0answers
11 views

What are the type of drivers for Communication with Java?

I am developing one application using core java and Mysql Database. As i read in Most of the site, they suggest that use type 4 driver for communication using JDBC. In JDBC Connection i have use ...
0
votes
0answers
9 views

change the name of the database according the changes in while loop [migrated]

<?php $sql="SELECT topics FROM subjects "; $result=mysqli_query($db,$sql); for($x=1;$x<=4;$x++) ...
1
vote
1answer
34 views

How to safeguard a symmetric key in SQL Server

I've got a database in which I need to store the encrypted values for a column. I use the SQL Server encryption format for encryption. The format is as follows: CREATE MASTER KEY ENCRYPTION BY ...
1
vote
1answer
53 views

TempDB default number of files in SQL Server 2016

Noticed the docs for SQL Server 2016 CTP2 state "by default, setup adds as many tempdb files as the CPU count or 8, whichever is lower." ...
0
votes
0answers
20 views

Searching on MYSQL database using LIKE having 1billion records [on hold]

I have a database public profile for university and the table grew in no time now i have more than 1 billion records and searching students records over these set of data takes over 50sec to 1.5 mins ...
1
vote
1answer
40 views

Optimizing a query that performs worse on a smaller dataset

I am trying to run this query. The * is just for simplification, I'm selecting ~10 specific fields for some calculations. SELECT * FROM `orders` LEFT JOIN `orders_processed` ON ...
0
votes
0answers
22 views

Why is MariaDB 10 refusing to use my index on a date field?

I have the following table definition: CREATE TABLE `bets` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `id_mp` bigint(20) NOT NULL DEFAULT '0', `coin` char(3) COLLATE utf8_unicode_ci NOT NULL, ...
0
votes
1answer
24 views

SQL Server Failover Cluster Instance compatible with VMware HA?

Imaginary Setup: Microsoft SQL Server Failover Cluster Instance on virtual machine in an ESX-Cluster. Question: In case of a hardware failure, what will happen with both high availability ...
0
votes
1answer
27 views

How to modify maintenance plan using T-SQL script in MS SQL Server 208

How can I modify a maintenance plan in SQL Server 2008 using a T-SQL script? I want to change the schedule of a maintenance plan and change the path of the .bak file . All these changes should be ...
2
votes
1answer
41 views

Dumping stored procedure result to a text file programmatically

How can I save stored procedure execution result to a text file? I need to do this from SQL script (not Management Studio nor external utility) and I need to preserve correct characters encoding ...
0
votes
0answers
7 views

After merge replication setup, tables at subscriber not getting any data from publisher

I have created a merge replication setup through Replication Wizard. After sync, it is observed that the subscriber DB gets created with the exact tables in publisher as intended, but on the ...
0
votes
0answers
13 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
0
votes
1answer
172 views

Mysterious inequality behavior when comparing date strings

Can someone explain this mysterious Postgres behavior? I'm performing the following queries at the psql command line. mydb=> select '20150526' > '2015-05-25'; -[ RECORD 1 ] ?column? | t ...
0
votes
0answers
2 views

How to subtract records from a table based on their existence in another

I have an Access 2010 table Assignment key Empl Number key Year Number key Week Number key Proj Number It assigns employees to zero or more projects for given work weeks, thus, all ...

15 30 50 per page