0
votes
0answers
5 views

Minimize table joins in design

Probably didn't come up with the best title, but I'll explain what I'm trying to do. I need to be able to track gym members, trainers, workouts, and gym locations. I've created a simple example below. ...
1
vote
0answers
13 views

AlwaysOn FCI + HA Setup Question

I am planning to create FCI + HA solution in the same datacenter, but running into some problems. I'd really appreciate if someone can provide some guidance. Here is the current configuration (All ...
0
votes
0answers
5 views

How to append records from one complete table into a partly populated differently formatted table?

I have two tables of interest linked in a MS Access 2007 database. The master table called EMPL_MASTER (from which I only have read access, I cannot make changes) updates every time a system ...
0
votes
0answers
14 views

SQL Schema Linking Products and ProductPricings to Vendors

I'm struggling to find a good schema for my current task, and would greatly appreciate a little input. I'm working with a very large project that includes the tables Products, ProductPricings and ...
0
votes
0answers
10 views

What is “good” single-block read latency?

Is there a reference anywhere that I can go and see what kind of single-block read latency I can expect from Oracle given a certain hardware configuration? I can run a query to show the current ...
0
votes
0answers
9 views

EXPLAIN (with subqueries) is giving results I don't understand

I have a query that relies on a subquery, and that subquery relies on another subquery. When I run an EXPLAIN on the full query, in does a full table scan of the table in the primary select. However, ...
0
votes
0answers
6 views

Adding standard set of constraints (rules) to PostGIS `raster` type column

I am trying to enforce some standard PostGIS-2.1.3 (PostgreSQL-9.1.14) constraints (rules) to be applicable on the raster type column using the following command: ALTER TABLE schema1.table1 ADD ...
0
votes
0answers
15 views

Beginner questions about SQL and relational algebra

I'm doing some exercices waiting for the exam. I have some doubt. RELATIONAL ALGEBRA These are the table: Newspaper (Cod_n, Name_n, Publisher) Article (Cod_a, Title, Topic, ...
0
votes
2answers
33 views

Stored Procedure null parameter within where clause

I want to use a parameter within where clause only if it's value is provided by strongly typed dataset, this is what I am trying at the moment, I get right results when i provide parameter3 and no ...
0
votes
2answers
15 views

Null column for username and password when using Login with *social network*

I want to know what are the conventions for columns like username and password when your application supports login with a third party, like login with facebook for instance. Given the fact that when ...
0
votes
2answers
20 views

How do I prove that the act of removing foreign keys doesn't corrupt existing data?

My boss and I are having a difference of opinion about whether or not to use foreign keys in a MySQL/InnoDB database. I'm for using them for enforcing RI and taking advantage of ON DELETE CASCADE and ...
0
votes
1answer
10 views

Need some help with this query or some ideas for change it to better model

I've a dilemma in my application and I don't get how to solve it at DB level. The idea is that a user can be subscribed to one or more services but services are show depending on user type. This can ...
2
votes
1answer
30 views

Foreign key, key split in two tables

I have to record a list of events made of action, reason (optional, may be multiple), user. I have a master table with all the valid action, and another with all the valid action-reason combination. ...
0
votes
1answer
16 views

How do I choose primary keys for star schema BI data warehouse?

I am extracting sales turnover data from a Microsoft Dynamics Database into another SQL database that will be used by the BI tool of choice. This data is coming from G/L (general ledger) entry items. ...
0
votes
0answers
19 views

Schema for multi-account database

I'm building an app which will have accounts for organisations leading to organisation.myapp.com subdomains for their account access. I'm putting together the schema for it and I have a few ...
0
votes
0answers
12 views

How to login as common user in Oracle using Toad?

I have created a common user in Oracle and the pluggable database name is pdborcl. I am able to login as sysdba with the common userid and password but not able to login as a normal user. Can anyone ...
0
votes
2answers
42 views

Is there a way to do a textual search through all stored procedures in a table?

I've just inherited a database with a number of tables and stored procedures. I use Microsoft SQL Server Management Studio. One, or possibly more, stored procedures update a specific table. If the ...
1
vote
1answer
48 views

Why is there a collation conflict between system views

I'm using the following statement to retrieve a list of triggers from the database: select tr.name from sys.triggers tr union all select tr.name from sys.server_triggers tr; However on my local SQL ...
-1
votes
1answer
31 views

Displaying records in a SQL Server #temp_table [on hold]

what's the select query syntax for displaying the content/records in a #temp_table on a SQL Server
-1
votes
0answers
16 views

CSS layout picture [on hold]

how to regroup pictures in the same line and the paragraph under here HTML <div class="img-right"> <img src="rock.png"/><p>Rock</p> <img ...
2
votes
1answer
20 views

Why is there no data loss with mysql innodb_flush_log_at_trx_commit set to 0?

Here is the MySQL info: mysql> show variables like 'innodb%flush%log%'; +--------------------------------+-------+ | Variable_name | Value | ...
1
vote
0answers
17 views

RDS mysql instance eating up memory and swapping

I have an issue with memory on a RDS instance which is of db.m2.4xlarge class. Below are the specifications of the RDS instance Instance Class: db.m2.4xlarge ( 68.4 GB of RAM ) Engine: ...
0
votes
0answers
18 views

SSIS Package truncation and possible data loss (error code: 0xC020901C)

Good morning all, It's been 2 days now trying to figure out how to solve this issue, still no answer. Maybe you can help me out. Here is the thing. I have created an SSIS package to import data from ...
3
votes
5answers
63 views

Find all values not present for other values of other column

Let's suppose I have a table with integer columns a and b (each pair (a,b) is unique) and following data: a | b ------- 1 | 2 1 | 3 1 | 4 1 | 5 2 | 1 2 | 3 2 | 4 3 | 1 3 | 3 Now I need to ...
0
votes
1answer
27 views

Planning on building a big web service. What kind of developers do I need? [on hold]

I'm a designer. I'm looking for web/mobile developers to help me build a similar platform like Airbnb or Yelp, but I don't know a lot about backend or on what technologies these two sites are built ...
1
vote
0answers
36 views

SQL Query Optimizer - how does cost vary with resource availability

When the query optimizer calculates the cost of an execution plan, can you expect the plan to differ depending on the amount of resource available to it? Take the following scenario: You have a ...
0
votes
0answers
8 views

DB2 Trigger for EVENT and ARCHIVE TABLE

I have a requirement on DB2. There is a two Table EVENT and ARCHIVE. Both table has ROW_ID and STATUS field. Case 1: When Update STATUS Zero to One at EVENT table that row will insert at ARCHIVE ...
0
votes
0answers
10 views

Optimal layout strategies for Time-Series using Columnar storage

In the context of time-series and specifically columnar storage systems. Question: What are the processes or heuristics that are used to determine how best the columns of contiguous values be grouped ...
0
votes
1answer
24 views

PL/SQL group orders by date and sum the total

I need to group orders by date and sum the total, My table looks like this : TEST_DATE TEST_ID - NUMBER SUCC_ID - NUMBER I need to group by date and sum the total, this is my query: SELECT ...
-1
votes
1answer
14 views

Automatic backup MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
0
votes
1answer
16 views

Count(*) as rolecount, filter by rolecount = 1

How can i filter out the rows who only got rolecount = 1? WHERE rolecount = 1 gives an error. Can't really figure out how to do it. SELECT u.uid AS uid, u.name AS name, u.picture AS picture, ...
-1
votes
0answers
17 views

Attaching a recovered database [on hold]

I'm unable to attach a database in SQL Server 2012 Express Edition. I've formatted my drive unexpectedly but I was able to get the database back by recovery methods. What do I need to do to attach ...
0
votes
1answer
23 views

Is there any performance difference between a group by statement and nested select statements in sql?

I am curious to know about the differences between using group by statement and nested selects to achieve the same result. for example consider I have two tables such as the following: tblPurchase ...
-4
votes
0answers
14 views

Why a view should be created?

Am new to database, why VIEW is needed in database, can anyone give a clear note on this?
1
vote
1answer
23 views

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the ...
0
votes
1answer
13 views

how to store complex data using mysql and jsp

At present i am doing small web application called slam book .We know slam page contains so many fields .By using mysql tables it takes too many columns and leads to complexity for accessing the ...
1
vote
1answer
12 views

mysql 5.6 gtid replication: is log_slave_updates required?

I've read the docs saying log_slave_updates is required. It makes sense for a general promotion situation. But is that really still required for something you're intending to be a read only slave ...
3
votes
1answer
290 views

Bad Design or Complicated Query?

Problem: For fun I am building a Database for lottery results to get some statistics off of. As of now I am only interested in a Pick 3 style lotto and might introduce more later. How would you ...
-4
votes
0answers
22 views

Error arithmetic overflow error converting expression to data type int [on hold]

when i check report of sql server it show, Error, arithmetic overflow error converting expression to data type int. How to solve this problem.?
0
votes
2answers
16 views

Is my subquery inneficient. It is extremely slow

I have two tables. Member information and login entries. I am simply trying to display the member information table sorted by the last login access date. So i created this query, but it is extremely ...
0
votes
0answers
11 views

MySQL Cluster lock wait timeout exceeded when trying to deal with huge amount of queries

I'm trying to deal with many connections and sometime I get following error: ERROR : Lock wait timeout exceeded; try restarting transaction The bigger number of queries the least number of ...
1
vote
0answers
17 views

Change Data Capture not running when Mirror is Suspended

We have 2 SQL 2012 SP2 Enterprise servers that have some mirrored databases. One of these databases also has CDC enabled on a number of tables so that we can run some business logic when there are ...
1
vote
1answer
17 views

Generic Trigger on MYSQL to replicate data on other table

I'm currently doing a history table that basically logs every single modification in a history table, and adding the Action executed. CREATE TABLE `competencies` ( `id` int(11) NOT NULL ...
0
votes
1answer
9 views

Strange issue with MySql 5.6 replication

I have a strange issue with MySql 5.6 Master-Master replication. I'm not sure if its entirely a replication issue or a client issue. We have two MySql databases on two different RHEL servers. We have ...
0
votes
0answers
12 views

To know list of users having access to Views

Please help me to find out the list of users who are having access to particular user defined views in Oracle.?
1
vote
1answer
13 views

Joining timestamped records with the most-recent-prior records from another timestamped table

Say I have 2 tables: Table: sales timestamp timestamp without time zone amount numeric Table: prices timestamp timestamp without time zone price numeric How can I get a ...
0
votes
0answers
6 views

What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL?

What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL? I'm used to MySQLWorkbench for working with MySQL databases. Now I have some sqlite databases to work with and would ...
0
votes
1answer
14 views

mysqldbcompare - ERROR: The list of objects differs among database

I'm running: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago) # rpm -q mysql-server mysql-server-5.1.73-3.el6_5.x86_64 # and mysql> SELECT VERSION(); ...
1
vote
0answers
20 views

Sql Server Installation Code Error

My problem is this, I want to Install Sql server 2014 in my Pc but i have a problem with it: SQL Server Setup failure. SQL Server Setup has encountered the following error: The SQL ...
0
votes
0answers
13 views

Connect to a Remote MySQL

I'm trying to connect to a MySQL remote Server but I always get: RROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111 "Connection refused") I follow this rule in the remote server GRANT ...

15 30 50 per page