1
vote
0answers
4 views

DBMS_METADATA.GET_DDL not displaying complete DDL for big tables

While generating the DDLs for a schema, big tables' DDLs are getting truncated. After displaying close to 110 columns I am getting ... I am using SQL developer for running : SELECT ...
0
votes
0answers
2 views

Postgres 9.4 on kubuntu 14.04 won't start

I've had postgres9.4 running without incident for around 5 months. Today after a restart I can't get postgres running. When I open pgAdminIII and try to connect to my server I get "Server doesn't ...
0
votes
1answer
4 views

SQLite Data Types In Context of Disk Space

I would like to better understand which data types in SQLite take up more disk space. I've looked through official documentation but could not find anything in context of storage space. Any guide ...
0
votes
1answer
11 views

MySQL - LOCK IN SHARE MODE for EXISTS query

I am starting a transaction and I need to check that a record exists, I don't need any values, but I need it to exist for the duration of the transaction for everything to remain valid. It's VERY ...
0
votes
0answers
8 views

SQL always on / SQL Failover Cluster

Is it possible to have two SQL instances on the same windows failover cluster with one instance using always on (no SQL failover cluster), and the second instance belonging to a SQL failover cluster?
5
votes
2answers
19 views

SQL Server, set of tables grow and shrink by large amounts. How to allocate

I have a SQL Server 2014 database with 100+ tables that have a 5% growth rate over the course of a year. Lots of reading, very little writing. This database is going to expand by another set of 20+ ...
0
votes
0answers
11 views

What kind of database should I use?

I'm designing a new system and I'm wondering what kind of DB should I use for my needs. I have a tree structure of nodes, where each node has historic values. For each historic value it should hold 2 ...
1
vote
0answers
8 views

Join integration query involving multiple associations

I'd like some assistance in fixing this query. Let me explain the background on what it currently does, and then what I need to integrate. First, here are my current tables. users (performers) table ...
0
votes
0answers
6 views

Comparison of Performance Metrics between File System and RDBMS

currently our client is has numerous interface implementations into Oracle EBS and Retail Sales Audit that uses a File System. Data in the form of flat files are being processed by Shell Scripts ...
0
votes
1answer
8 views

Can I do VACUUM FULL to pg_largeobject table?

I have two tables (table1, table2) in a Postgres 9.1 database. Both having oid type. Each table 1 million records. And pg_largeobject table size is around 40GB. I have removed 0.9 million records from ...
2
votes
1answer
33 views

What server configuration and database should I use?

I am new to Database's and want to work toward installing a Database in the small company I work at for production and eventually other uses. The company has only 15 employee's and three departments. ...
0
votes
0answers
9 views

invalid default value (mysql 5.7) for timestamp field

1067 - Invalid default value for 'shift_start' This worked in mysql <=5.7. I couldn't find any documentation about this...What is the issue with this? CREATE TABLE `phppos_register_log` ( ...
0
votes
0answers
10 views

Issues with MySQL installation

First of all, excuse the length, this post is very long, and needs some background, second; it has been hard for me discerning the signal from the noise, please bear if some of this is not relevant: ...
1
vote
1answer
7 views

Creation of DB in mySQL to sort and filter data

New to this forum, so thanks for taking the time to read my post! ;-) Struggling to design the correct database / structure for what I'm trying to do. Let me try and explain the situation. We are ...
3
votes
0answers
20 views

Counting show variable result in mysql

I am reading this article and there doesn't seem a way to do something like this: SELECT COUNT(*) WHERE SHOW VARIABLES WHERE Variable_name = 'innodb_ft_cache_size' I can do the below but this ...
1
vote
0answers
21 views

Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist/Tasks [on hold]

Recently I'v achieved Oracle Database 11g Administrator Certified Associate (OCA) after passing two exams (1Z0-051 & 1Z0-052), then I got a Job as an Oracle DBA in startup company. So, I would ...
2
votes
1answer
18 views

MySQL users not visible after import

I have a Percona MySQL database 5.6 running in a linux machine. I have created new users called test1 and test2. What I did was I imported mysql database from my test setup to this new setup. After ...
2
votes
1answer
27 views

MySQL connection process slow for non-root user

I'm using Percona server 5.6 on Linux. When I connect to MySQL from the command line as the root user, it connects immediately. I have also created a new user in the database, but when I try to ...
0
votes
0answers
11 views

Sql Dependency with Service broker working fine when sql server presents local system but its not working when database is at remote system [on hold]

I have an application which uses sql service broker and sql dependency in c# application. Its working fine when my database is at the local machine but it does nothing when the database is at remote ...
0
votes
2answers
27 views

ORA-01830: date format picture ends before converting entire input string

I am trying to run the query on an Oracle database select to_date(trunc(sysdate) || '13:00:00','DD-MON-YY HH24:MI:SS') from dual; and get the error ORA-01830: date format picture ends ...
2
votes
0answers
27 views

Remote access to SQL Server 2008 R2 on Windows Server 2012 R2?

I have SQL Server 2008 R2 (named instance) on a Windows Server 2012 R2: Enabled remote access to SQL Server Enabled shared memory & TCP/IP protocols & named pipes for the SQL Server ...
6
votes
1answer
157 views

Azure: Many Failed Login Attempts Logged

I run a SQL Server on an Azure Virtual Machine. I have noticed in the Event Logs of the server lots of failed SQL Login attempts using a ton of different usernames (none of which exist): Login ...
2
votes
0answers
24 views

Why is a gin index on a jsonb column slowing down my query and what I can do about it?

Initialize test data: CREATE EXTENSION IF NOT EXISTS pgcrypto; CREATE TABLE docs (data JSONB NOT NULL DEFAULT '{}'); -- generate 200k documents, ~half with type: "type1" and another half with type: ...
0
votes
0answers
17 views

Calculating table size

I'm trying to follow these steps: Space estimation to estimate the size of my table that I'm creating. I specified an INITIAL as 1M and using the steps above I have the following estimations: ...
0
votes
0answers
10 views

Event 17058 - initerrlog: Could not open error log file (SQL Server)

I'm new to SQL Server and encountering an error when running sqlservr.exe (Microsoft® SQL Server® 2008 R2 SP2 - Express Edition) Error 17058, Severity: 16, State: 1. initerrlog: Could not open ...
1
vote
1answer
25 views

Oracle: Mutually modifying two tables?

Suppose I have two tables I want to keep in sync: create table a(x number, s varchar2(10)); create table b(x number, s varchar2(10)); It's easy to keep B synchronized with A, using triggers such ...
1
vote
0answers
14 views

Replication of specific tables using Postgres 9.4.4 and Amazon Web Services

I have currently setup a Postgres 9.4.4 RDS instance on Amazon Web Services. On this instance I hold 20 tables. In addition I also have Postgres 9.4.4 installed on my local server (OS: 64-bit Linux) ...
0
votes
0answers
25 views

Sharing a database over the local network [migrated]

We have some plate nesting software at work which I use daily. Recently, I thought I'd try to get the shared database up and working so the boys in the workshop could use the software on another PC ...
0
votes
0answers
31 views

column values combination

I have chains of nodes like A -> B -> C -> F D -> E and store them in an Oracle table pair with 2 columns left_node and right_node left_node right_node A B B C ...
-1
votes
0answers
27 views

What is the right database for my use? [on hold]

I need to insert and select them by name, but almost never update. I have 7B records in this format: Id | name(40-50char) | status (bool) what is the right database type for my use? thank ...
-1
votes
0answers
15 views

programme scrambeled the screen [on hold]

i am having problem with my programme i purchased.program is in vb and datbase used is SQL 2005 database.problem is that when i used to enter or querycertain no of data its screen scrambled and i ...
-4
votes
0answers
20 views

sql server stored procedure clockin [on hold]

how to create a stored procedure with clockin,clockout columns and I want to show the time worked from them and the min_leave_time when user clockin and out for breaks on a 8 hr. shift with lunch only ...
4
votes
3answers
64 views

Return even empty groups when grouping by date

I have the following query: SELECT DISTINCT COUNT(CD_BarCode) ,CD_Carrier ,SUBSTRING(CONVERT(VARCHAR,DT_Arriving,103),1,11) Date FROM TB_AGIL WHERE ...
0
votes
2answers
13 views

Percona XtraDB - Random deadlock

Randomly my database gets locked completely and queries hang and they pile up until it gets "Too many connections". Below is my mysql log file, I couldn't find anything related to the error system ...
6
votes
2answers
49 views

Entity relationship problem

I think my question is stupid but I just can't figure out how to solve it: I have 4 tables related like this (it's an example): Company: ID Name CNPJ Department: ID Name Code ID_Company ...
0
votes
0answers
25 views

User is An employee. Role or relation

I've created a database based on a party-model. In short I show you the tables: parties, kind, party_to_party_relations, role, party_roles table parties: CREATE TABLE `parties` ( `id` int(11) NOT ...
0
votes
0answers
26 views

RAID 10 array configuration for SQL Server

I have a question regarding RAID 10 and SQL Server. My plan is to purchase an HP DL380 G9 with the 24 drive config. The question is how to break up the array. The drives will be divided between the 3 ...
0
votes
1answer
17 views

Forgot to run END_UPGRADE during a Timezone File Upgrade (ORA-56924)

I ran the following to upgrade my timezone file from 4 to 14. The issue was after running the upgrade I forgot to run DBMS_DST.END_UPGRADE and put the DB back up and enabled incoming connections. ...
5
votes
2answers
261 views

Tell SQL Server a query is ad hoc and not to optimize based on it

Is there a way to run a one-off query against a production SQL Server database and tell it not to make any future judgments based on that query. E.g. Store execution plans, recommend indexes, etc. ...
0
votes
0answers
18 views

Identifying high load sql

We had an oracle outage some days ago. We have inbetween awr tools. I genarated awrrpt report but dont see anything suspicious. Which report should I generate to see sql, which caused very high cpu ...
0
votes
0answers
24 views

Normalize to 3NF Question - Postal Codes/City [duplicate]

Normalize to 3NF and design an ERD for the following data: Name Street City Province Postal Code Home Phone Cell Phone Just want to see if I am doing this right. PERSON NameID Name Phone Number ...
0
votes
1answer
10 views

Postgres 9.3 - Problem to initialize folder as a data folder

I have a problem when I want to initialize a folder as a data folder: postgres@ccruzado-test01:~$ /usr/lib/postgresql/9.3/bin/initdb -D /datadrive/postgresql/ The files belonging to this database ...
2
votes
2answers
61 views

Add a flag when certain conditions are met

I have a table where when an employee works LEAVE1 and LEAVE2 paycodes on the same day then in the new column called 'FLAG' we need to put a 1 for LEAVE1 and a 2 for LEAVE2, when these paycodes are ...
1
vote
2answers
49 views

MySQL - How to make a DATEDIFF in years?

This is my first post (and English is not my mother tongue) so I hope I won't screw this post up. I am new to MySQL but I learned a lot with 100+ youtube tutorials and your numerous posts. I designed ...
2
votes
1answer
22 views

Availability Group environment clone

I've been assigned a project where we have an active secondary environment that I'm confident that Availability Groups would address but have some questions that I hope someone can answer for me. ...
0
votes
0answers
15 views

mysqldiff utility on all tables

I am using the mysql diff tool at http://dev.mysql.com/doc/mysql-utilities/1.3/en/mysqldiff.html It works great but I have to do this for each table mysqldiff --difftype=differ ...
0
votes
2answers
46 views

How to create Date table

I have problems when I try to create my DimDate. That's what I have tried: CREATE TABLE [dbo].[DimDate] ( /*[ID] [int] IDENTITY(1,1) NOT NULL--Use this line if you just want an ...
0
votes
1answer
16 views

MYSQL count time between each in/out and show total

I am having an issue with my time clock query. Basically users clock in/out several times per day (can clock in/out unlimited times per day), and it is counting the time between the first clock in and ...
0
votes
3answers
24 views

Unique full text index?

Is it possible to create a UNIQUE FULLTEXT index? I am using a mysql diff tool that is complaining that I am using duplicate indexes. I have a column that needs to be unique but also used for full ...
0
votes
1answer
18 views

Is it good to save Keywords stored by users in a new DB schema?

My question is more from the schema design and of further performance of the DB. I'm designing a DB schema which will store primarily strings. Actually, users work on these string, as normal mortals, ...

15 30 50 per page