0
votes
1answer
53 views

how big of a role does hardware play? [closed]

I'm the developer, not the DBA. I don't know much about setting up databases but i'm concern of the setup at my current work. The server is installed on desktop PC hardware(i7, 16GB RAM, 1 TB SATA ...
0
votes
0answers
25 views

Canonical Cover for Functional Dependencies ho

I'm trying to decompose a relation into 3NF and I'm given the following information: Given R(A B C D E F G H I) Keys: {A,B} {A,D},{B,D} FDs: AB-> DE A->I B->CFGH G->H AD->BCEFGH ...
1
vote
1answer
30 views

SSIS Package Security

I am writing a Package for one of my client according to his requirements. Package development is totally complete now time is to protect it with some security. Is this possible I encrypt all the data ...
1
vote
2answers
95 views

Backup Error (.bak)

I need to backup the database in SQL Server 2014. When I am trying to do so, I am facing this problem which is not saving backup as a (.bak) extension. And when I try to select (Files and ...
0
votes
0answers
16 views

Mysql Select Categories and count of sub items [duplicate]

I have some problems on handling date from multi tables an once for example SELECT fl_categories.*, COUNT(fl_seeds.id) AS seeds , COUNT(fl_feeds.id) AS feeds FROM fl_categories LEFT JOIN fl_seeds ...
2
votes
1answer
59 views

Create Table not working

Forgive me if the question is very simplistic; I am a bit of a novice when it comes to SQL. The following CREATE TABLE syntax was generated by MySQL workbench from my model; It gives me errno: 150. ...
3
votes
0answers
90 views

Superkeys of this relation

I am trying to find the superkeys of this relation, but I am having troubles finding out how many superkeys there are and exactly what they are. I figured out that the candidate keys were ...
1
vote
2answers
122 views

Mysql date_add returns wrong row in python, right row in phpmyadmin [closed]

I am trying to get the first and last record from a month. In phpmyadmin I ge the correct result. In python I don't. In fact python returns the same row for both of these queries. First number is ...
0
votes
0answers
67 views

what is causing Errors running from Localhost

wp_users: InnoDB: Tablespace is missing for table 'ftbw/wp_users' wp_usermeta: InnoDB: Tablespace is missing for table 'ftbw/wp_usermeta' wp_posts: InnoDB: Tablespace is missing for table ...
1
vote
0answers
821 views

MariaDB is ignoring /etc/my.cnf

The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. But SELECT @@innodb_buffer_pool_size; returns 134217728. When I execute: /usr/libexec/mysqld ...
0
votes
1answer
110 views

Critical tablespace usage UNDOTBS (98%)

This tablespace is in my case 8GB. I'm on oracle 10g and got critical warning: Tablespace usage critical: UNDOTBS (96%) I also executed this command: select sum (bytes/1048576) MB FROM DBA_SEGMENTS ...
1
vote
2answers
115 views

what is the most simple and easiest way to backup and restore on oracle 11g?

Im new on oracle 11g i come from SQL Server administration and the process to back up and restore its very easy and intuitive. I was searching how to make backup and restore on oracle 11g in many ...
0
votes
1answer
291 views

Mysql - Examine last query run by thread in sleep state

I am seeing some threads in the "sleep" state for longer than normal. Normal maybe being 1-3 seconds with the abnormal being up to 60 seconds or longer. It makes sense that this is an application ...
0
votes
1answer
69 views

Index rebuild, data compression generated Large TLog

We are following vendor recommendations for a index rebuild changing the fillfactor and enabling data compression, on the test server the results have us wondering what is going on that would cause ...
3
votes
2answers
275 views

SQL Server 2008 R2 - Unable to delete Login

I've been using this site for a while and this is the first time I've had to ask a question, but just wanted to say "Thank You" to everyone who has helped me in the past (without knowing they did so). ...
3
votes
4answers
360 views

Mysql Order By affecting a Query with column alias, group by, and having

Description: I have a query with column alias, group by and having. It's getting altered when I add an order by. This strange behavior is only happening in 5.6.16 and 5.6.21 (which I was using in ...
1
vote
1answer
322 views

Getting Data Type ID in MySQL

So, In SQL, We have the following query to find the system data type ID of columns in SQL Server; select name, system_type_id from sys.columns where object_id = OBJECT_ID(N'sometable') It gives the ...
0
votes
1answer
43 views

Right way to get references to an object in Oracle?

I want to find all the objects referencing my object. I came up with this query, Is this the best way to get all references to an object? (I know this doesn't include constraints, I handle that ...
4
votes
1answer
16k views

mysql Lock wait timeout exceeded; try restarting transaction

we are running java application, running for ages, back end is db is MySQL, recently updated to mysql 5.6. Everything was running fine, past week started getting this error Lock wait timeout ...
0
votes
1answer
106 views

Install Developer Edition ASE in Vagrant/Virtual Box

It is possible to deploy a development version of Sybase in a Vagrant/Virtualbox instance? I was planning on using a CentOS vagrant box to create a development environment but am not sure if it's ...
0
votes
1answer
46 views

Lose some FDs in 2nf normalization?

Suppose we have R=(A,B,C,D) and FDs are {B->C, C->D}. The only candidate key is AB, then A and B are prime; C and D are not prime. B->C breaks the 2NF requirements because is a partial dependency. So ...
0
votes
2answers
46 views

Table partition should not be selected

I am looking to partition a table (nearly 30M rows) by date ranges (mysql version : 5.1.73) CREATE TABLE `TABLE_X` ( `name_x` varchar(50) NOT NULL, `type_x` varchar(5) NOT NULL, `status_x` ...
0
votes
1answer
1k views

Query Netezza to find all tables in views

I am trying to recreate the following query in netezza and am struggling: SELECT view_name, Table_Name FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE WHERE View_Name = '<giveViewName>' ORDER BY ...
5
votes
2answers
502 views

Is it possible to change the default style used by CAST/CONVERT when converting DATETIME? [closed]

When you attempt to CAST a DATETIME as VARCHAR in SQL Server, the default date formatting style is a fairly inaccurate date format that loses the precision of both seconds and milliseconds. For ...
1
vote
0answers
20 views

What is a .cof file that the database is linked to?

I am on working on creating a script that de-link and re-links all the linked tables from the front-end. I'm working on an exisiting database that has been created and pre-configured. When I click ...
1
vote
2answers
55 views

mysql copying to tmp table duration

I have a web site which started to have performance issues because of a mysql query which is executed for each request. I have the following table structure. Post table (125000+ records) id: ...
1
vote
1answer
873 views

Does AWS Aurora suffer from the same limitations that MySQL suffer from? [closed]

Specifically, MySQL has a limitations max row size as 64kB. I would like to know if Amazon Aurora, which is supposedly a drop in replacement for MySQL suffer the same limitation.
10
votes
3answers
593 views

Combining separate ranges into largest possible contiguous ranges

I'm trying to combine multiple date ranges that may or may not overlap into the largest possible contiguous date ranges. For example: Data: CREATE TABLE test ( id SERIAL PRIMARY KEY NOT NULL, ...
3
votes
1answer
178 views

What is the difference between public_dependency and dba_dependencies?

I know that PUBLIC_DEPENDENCY has only the objects and references Ids, and the DBA_DEPENDENCIES does not have the Ids, but the Type, Owner, Name, etc of them. But beyond that, what is the difference ...
0
votes
1answer
52 views

Running Aggregation logic on multiple shards of MongoDB

Suppose we have 5 shards in MongoDB having collection of data, and I have to write an Aggregation logic which should work on each of 5 shards in my cluster and collect data from these shards. Should ...
0
votes
2answers
1k views

ORA-00600 argument description

I am experiencing several ORA-00600 error events, presumably during exceptionally high I/O. Does anyone know where I can lookup the meaning of the following arguments for ktspfmdb:objdchk_kcbnew_3? ...
2
votes
3answers
171 views

Order by query optimization for multi select data (enum)

We previously used to store multi select data (enum) using pipe separated characters, as shown below like this - which made ordering on that enum data very simple. ╔═══╦════════════╦═════════════╗ ║ ...
0
votes
1answer
2k views

Oracle 11gR2 RAC unable to connect to SCAN address [closed]

I'm having a problem with my RAC environment. I am using RedHat 6, Oracle 11.2.0.4 SE. Have a 2 node RAC setup using ASM. When connecting using SQL Developer, i can connect to my service ...
0
votes
2answers
49 views

How to get a column of the select to be “cumulative” (like in excel)?

This simple query (written in MySQL) is counting the number of WP posts published every day. But I need another information. I want to know the cumulative number of post for each date returned by the ...
1
vote
1answer
53 views

Is there something I can do to make this UPDATE run faster?

I have a relation EnumeratedSensorReading that includes a siteid and a quantityid column. I want to replace these two columns with a single sensorid column. I have added this column, and it is ...
4
votes
1answer
241 views

SQL Agent Jobs Automatically Disabled After Modifying Maintenance Plan

I modified a maintenance plan yesterday, to find out this morning (by using the last modified date from sysjobs) that all jobs related to the maintenance plan are disabled. I can't figure out why ...
1
vote
2answers
85 views

Does InnoDB allow adding columns to a table with concurrent READ/WRITE of rows?

I have a large (3M rows) InnoDB table in MySQL 5.6.21 in production and I want to add some columns. From the MySQL Documentation on Overview of Online DDL I understand that, even if this is an ...
1
vote
2answers
2k views

Merge faster than Insert

Are there any advantages/disadvantages of making use of a merge over a insert function? Can an insert statement make use of the `OUTPUT' Note: the ON clause for the merge is set to 1=0 (always ...
0
votes
2answers
259 views

SQL Server : replication between two different locations

I have problem setting my replication between two servers on different locations (different network). Steps I have done: setup aliases in SQL Server Native Client configuration on both servers ...
1
vote
1answer
32 views

can log shipping to log shipping?

I have one production SQL Server 2008 Database with log shipping set up for that server in US. I have a account in the log shipping database so I could sometimes run query on log shipping database. ...
0
votes
2answers
195 views

Best configuration for MySQL? InnoDB and MyISAM

I read that InnoDB is supposed to be better at writing into MySQL than MyISAM, however, I'm trying it out, by running 3000 MySQL queries(Inserting rows, 8 Columns + id)... but results haven't turned ...
0
votes
0answers
2k views

error 1067 process terminated unexpectedly

I am facing the following error while creating the Mysql instance from command line in Windows server 2012. Steps i follwed for creating a new Mysql Instance as a window service: I have stopped the ...
0
votes
1answer
73 views

Display the choices even if no rows found in associated table

I have the following 3 tables for a small voting/polling feature: CREATE TABLE IF NOT EXISTS `options` ( `option_id` tinyint(4) unsigned NOT NULL, `poll_id` mediumint(8) unsigned NOT NULL, ...
0
votes
1answer
19 views

'mysql' database in fresh MySQL installation

I installed MySQL database and according to show databases command I have a database named 'mysql'. Is this database used for holding some internal values for MySQL? In addition, is it possible to ...
0
votes
0answers
39 views

where does MySQL store data which is inserted into tables?

I have a small table named animals in database named test: mysql> select * from animals; +----+------------+-----------+ | ID | species | location | +----+------------+-----------+ | 1 | ...
1
vote
2answers
152 views

Where is Connection String Located as it relates to Availability Group Listeners?

I am trying to teach myself about Availability Group Listeners and see that I need to update a "Connection String." I know that I have a connection string in my web.config file on the Web server, but ...
1
vote
1answer
118 views

wm_concat in a specific order

I have a query that makes something like this: +---------+---------+------+ | Patient | Pattern | Rank | +---------+---------+------+ | a | 0 | 1 | | a | 1 | 2 | | a ...
11
votes
2answers
598 views

Help with PIVOT query

I have a table with below structure : CREATE TABLE [dbo].[AUDIT_SCHEMA_VERSION]( [SCHEMA_VER_MAJOR] [int] NOT NULL, [SCHEMA_VER_MINOR] [int] NOT NULL, [SCHEMA_VER_SUB] [int] NOT NULL, ...
1
vote
1answer
123 views

Open port 1433 to use SSMS securely

I have a SQL Server placed in DMZ and I want to give access to internal users (and VPN clients) to use SSMS to remotely connect to it via port 1433 so server will accept the connection only form ...
0
votes
0answers
33 views

I want to pivot a table and aggregate a column into strings [duplicate]

I have a select statement producing the following: +---------+---------+------+ | Patient | Pattern | Rank | +---------+---------+------+ | a | 0 | 1 | | a | 1 | 2 | | a ...

15 30 50 per page