0
votes
2answers
40 views

inner join select - group by?

I have 2 tables (Oracle database): ANEXA2A_TABEL1: id fk_id_anexa pet1 pet2 alt1 alt2 1 123 10 1 20 2 2 321 11 2 10 3 ...
1
vote
1answer
26 views

how to cache a subset for cascading select queries in mysql

Here is another database problem I stumbled upon. I have a date-range partitioned MyIsam look-up table with 200M records and ~150 columns. On this Table I need to perform cascading SELECT-Statements ...
0
votes
2answers
31 views

How to most efficiently store possible combinations of categories?

I have a table of categories (currently with 14 rows, not likely to change). A need to cache combinations of categories emerged, so I'm creating a table of allowed combinations (only few hundreds of ...
0
votes
1answer
39 views

Proper use of extract function? [on hold]

I am trying to select names of employees who were born in 1985. I am doing this but it is giving me an error. SQL> select fname, lname, count(E#) as "total" 2 extract(year from date, dob) as ...
0
votes
0answers
56 views

Select only rows that equal x but not x and y?

I'm having quite the challenge with selecting hierarchical data in mysql although I feel the schema should be optimized for it since it's based on the wordpress database model. I've got 4 tables... ...
-1
votes
1answer
22 views

Users' physical characteristics - design

I have to build a database for an employment agency. For each user will be stored physical characteristics like height, weight, hair color...(9 fields in total). I thought I could just build a ...
2
votes
0answers
10 views

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface ...
-1
votes
1answer
26 views

What MySQL activity eats CPU? [on hold]

I have noticed weird CPU consumption peaks for MySQL process. When I monitor running queries, it's empty or some reasonable queries being executed. How do I better address the problem? Is there a ...
1
vote
1answer
12 views

Is it safe to disable InnoDB doublewrite buffering when setting Innodb_page_size = filesystem page size?

As I understand, doublewrite buffering is needed to avoid partial write, because Innodb_page_size default is 16K, while filesystem page size normallly is 4K; I wonder if I set "Innodb_page_size = ...
0
votes
0answers
10 views

Tool for browsing JavaDB

I have bought a Java web based application which uses a JavaDB to store data. In the application files, there are 2 .db files named ff.h2.db and ff.trace.db where "FF" being the abbreviation of the ...
1
vote
1answer
21 views

Does index occupy disk memory for rows for which index expression is NULL?

Let's assume that I have following pg_trgm index on mydata JSONB column: CREATE TABLE mytable (mydata JSONB); CREATE INDEX trgm_index_1 ON mytable USING gin ((mydata#>>'{myfield}') ...
0
votes
0answers
31 views

Can't connect to other instance of SQL 2012

I'm working through a Microsoft exam study book. I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC. The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the ...
0
votes
0answers
39 views

SQL Server consuming large amount of RAM [duplicate]

I have Server 2012 with two 2.10 Ghz processors and 64GB of RAM. I have SQL server 2008 installed on this server. but this SQL server is consuming 70-80% of memory. I have limited SQL memory to 24GB ...
-2
votes
0answers
9 views

data lifespan reseaych [on hold]

I am trying to find info on "data life span" and data life span classes - what causes data to be deleted or archived..but am having trouble finding much information. So far I've seen a lot of ...
0
votes
2answers
14 views

How to check if restored database is the same as original

Is there a way to check if restored backup of Oracle database is the same as the original database? Is there a simple way to check it if I have the original database?
3
votes
2answers
52 views

How do I pass multiple statements into sqlcmd?

Wanting to automate some tasks instead of firing up SSMS for everything, I'm trying to write a batch file to run these statements, which work perfectly when I paste them into the sqlcmd prompt. They ...
1
vote
0answers
12 views

PostgreSQL security threats in external modules or PL languages

In reading the answer to question I came across a paragraph that indicated that some PostgreSQL PL languages and/or contrib modules can be used to compromise the security of the system. Is this only ...
1
vote
0answers
9 views

MySQL Cluster 7.4.6 - Analyze table failure on 15m reference table

I'm running MySQL Cluster 7.4.6 on Azure VM's with the following infrastructure: 2 x Mgmt Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x MySQL API Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x Data ...
0
votes
0answers
17 views

Is it possible to retain access to table that will be dropped and recreated?

I have a GIS table which is small and is dropped and recreated from MAPINFO. Each time I drop and recreate that table I grant access to roles created. Is it possible to sustain access during drop and ...
0
votes
1answer
18 views

How to exceute view without DBLink in oracle server

I have 2 views, example V1 from Database DB1 , V2 from database DB2, these 2 database server are remotely configured, I can able to execute these views separately without database link in the ...
0
votes
0answers
22 views

manual data migration/rescue MySQL version: 5.6.23

MySQL died and could not be started. So I transferred my database files via rsync to another server and restore from back up. Now I am trying to access my data with my updated records. mysql> use ...
0
votes
1answer
27 views

INFORMATION_SCHEMA Pattern

The INFORMATION_SCHEMA views are a standard set of views that most major DBMS provide. What is the name for this design pattern? For instance, let's say there are a dozen source databases for ...
2
votes
2answers
35 views

MySQL taking too much CPU

Below is my .cnf file and if I see my CPU consumption 99.99% of it my the mysqld commands. The MySQL server is connected from remote machines that update data in it frequently, but I make sure that ...
1
vote
1answer
23 views

Load file based on line number in sqlldr

I am trying to load header and detail records from a file. The only way I know the difference between the header and the detail records is the line number. The first line is always the header and the ...
0
votes
1answer
44 views

Does my ERD look well designed?

I am making a database at no cost for a local dance school. I'm still very new this would like to be sure that I designed it appropriately. From the front end, the parent will: fill out their ...
1
vote
1answer
73 views

Index to filter a view before joining the underlying tables [on hold]

Using SQL Server 2008 R2 Suppose you have a query like the following select top 1 * from view_cms_user where UserId = 1234 or UserPasswordRequestHash = 'anxazno121o3n' view_cms_user is basically: ...
0
votes
2answers
22 views

How to solve “Can't connect to local MySQL server through socket” error?

I kept getting this following error every time I tried to restart MySql. It was working fine before I changed the default data directory. ERROR 2002 (HY000): Can't connect to local MySQL server ...
0
votes
1answer
50 views

need to find instances which have multiple rows with the same userID and ResourceID and have a location of 1 and also have other locations [on hold]

I have a table with User_ID, Resource_ID, Location_ID, INstance_ID 1,1,1,1 1,1,2,2 1,1,2,3 2,2,3,4 2,3,3,5 2,3,5,6 3,1,2,7 3,1,7,8 4,4,1,9 4,4,2,10 5,5,1,11 1,1,3,14 4,4,1,15 1,1,10,18 1,1,1,19 ...
0
votes
1answer
45 views

SQL Server : Restoring database mirroring once its turned off

I was running security updates on the sql server mirror setup and I encountered split brain scenario as mentioned here Should I pause Mirroring and stop SQL Server services before running windows ...
0
votes
2answers
32 views

Set Oracle Home (install Oracle Home) for Toad 12.6

I had Toad 11.5 and I'm trying to install Toad 12.6, to connect to Oracle 11g on a 64-bit Windows 7 machine. No matter what I try, when I start Toad 12.6, I get the error: "No valid Oracle clients ...
0
votes
1answer
22 views

Does it makes sense to partition on a foreign key?

I have a MySQL table which looks a bit like this: ID (BIGINT, PK), OtherID (INT, FK, indexed), NegativeTimestamp (BIGINT, indexed) Selects should go very fast, updates almost never happens, inserts ...
0
votes
3answers
49 views

Time sheet, rates, date dependent

I am trying to figure out the best database design for the following; I have individuals (stored in Agents table) that enter their billing or time worked each day for different projects. Now we have ...
0
votes
0answers
15 views

SQL Insert with HTTP1.1 [migrated]

Sorry for an amateur question but I have no idea why this does not work. I have a "add.php" to connect to the SQL server <?php include("connect.php"); $link=Connection(); ...
0
votes
0answers
24 views

What is restarting SSRS service once a day?

My 2008 R2 SSRS service (10.50.1600.1) is consistently restarting every morning at 2:30 AM and I can't figure out why. The RecycleTime setting in rsreportserver.config is unchanged from the 720 ...
-1
votes
0answers
14 views

Connecting to Oracle Database on Port other than 1521

I have two machines on the network and on one Oracle 12 c is installed on port 1521. I need to connect to this Oracle database from my other machine but for some reason I need to connect from port ...
2
votes
0answers
49 views

Transactional Replication in SQL server 2014

We need to set up transactional replication in SQL server 2014, Enterprise edition so that: Database to be replicated from Publisher is approx. 2 TB in size. This would be used 24*6. Here we also ...
0
votes
1answer
9 views

How to store list data in our LMS?

I am looking at how we can store list information in our database. The example in question is regarding products. For every employee there will be a primary product and as many secondary products as ...
0
votes
2answers
31 views

Why does “DELETE WHERE (VARCHAR)=0” execute successfully?

DELETE FROM stats WHERE name=0 "name" is type VARCHAR(64). The above resulted in all records in the table being deleted, instead of just the 10~ that should have been affected. Only that many were ...
0
votes
1answer
26 views

Call trigger during SQL Loader insert

I'm trying to insert data from a file into an Oracle table using SQL loader. The primary key is populated by a sequence where the nextVal is called from an insert trigger. When I try using sqlldr, it ...
0
votes
0answers
22 views

Designing multi-table notes

I have several tables (Providers, Items, Users) representing items that my users can comment on. In the OO mindset, if the above tables were classes, they would each be a subclass of Commentable, ...
0
votes
1answer
23 views

phpmyadmin like interface for Oracle [on hold]

Is there any phpmyadmin like interface for Oracle? Currently most of my work is on a remote machine, and SQL Developer is really heavy and slow on it. It would be nice if there was web interface that ...
0
votes
0answers
37 views

Database deploy automation

In my company the developers use migrations for the schema changes in the database server and for install new databases too. More precisely they use Active Record (Ruby version). They have a project ...
0
votes
1answer
16 views

need information on a deleted SSRS report

In SSRS, once a report is deleted, the ItemPath no longer appears in the ExecutionLog because the Catalog no longer has the report information. I can track down the ReportID, but I can't find ...
3
votes
1answer
303 views

Storage size of a bigint table

I am working with a table that has this format : CREATE TABLE dbo.ID_STORE ( WORKING_ID bigint PRIMARY KEY CLUSTERED ) The table stores around 2 millions rows, but the stored ids are not ...
2
votes
1answer
74 views

MS SQL high tempdb disk I/O during merge replication of BLOBs

Having a merge publication for replicating BLOBs (sql type - image), got very high tempdb disk I/O for my size of data. Publication is download-only and has no filters. High disk I/O is caused by ...
0
votes
2answers
40 views

MS SQL Server 2008 Transaction log file back up failure

I've done some reading around this subject here and on StackOverflow but nothing really answers my question enough for me to go forward. I'll explain we have a MS SQL 2008 server running, the ...
-5
votes
0answers
24 views

Comparison of columns with in the same table differed by date parameter [on hold]

How to write a SQL Expression to match the data of a dimention between the same table. regards dake
0
votes
1answer
19 views

Normilsation - 2NF and 3NF

I've been through several questions and youtube tutorials, i understand that 2NF is removing the partial dependencies and 3NF is the transitive ones, but i can't get my head around how the following ...
5
votes
3answers
200 views

Check if any of the values is in a subquery result

I have a complicated subquery that returns a list of order IDs. I need to get a list of customers who have these orders. The problem is that there are two ways of assigning a customer to an order (one ...
0
votes
1answer
39 views

How to view the latest entries in all tables in an Oracle DB? [on hold]

I wanted to examine a running Oracle instance on one of our servers, but nobody knows, if there's still any data of interest stored in the database. Unfortunately our last Oracle admin has left our ...

15 30 50 per page