0
votes
1answer
6 views

Best Approach to Migrating Oracle to MySQL - Run on EC2 in AWS

I'm trying to migrate an Oracle schema as well as all of the data within the DB to a MySQL database. I want to then make an EC2 app on AWS to kick off whatever I've written for this. Are there any ...
0
votes
1answer
18 views

improve long running query

I have this query INSERT INTO interactions( user_id, external_object_id, origin, interaction_type, interaction_sub_type, published_at, origin_id, created_at, updated_at) SELECT ...
0
votes
0answers
4 views

What is the sequence to enable the authentication in mongodb cluster without stopping the service

Assume that the cluster is running with authentication disabled. There are one mongos instance, 3 config servers, and two replication sets. each replication set has 3 mongod instances. My order is ...
0
votes
0answers
24 views

SQL Server Agent in Change pending state and could not restart

I have a clustered SQL Server. When the server is restarted accidentally, the SQL Server Agent was not started automatically. SQL Server Service has started and is in the "running" state. When I ...
0
votes
0answers
7 views

How do I determine which IP I should use for my MariaDB Galera Cluster?

I have set up MariaDB Galera Cluster (let's say 3-4 nodes). Which IP should I specify in the configuration of my application? Should I specify all of them or I should have some proxy in front of ...
1
vote
0answers
11 views

Avoiding “Row by row” fetch method when dealing with source LOB columns

I have a legacy PostgreSQL database source (ODBC) that I'm attempting to migrate to new SQL Server schema using SSIS. I'm getting a warning saying: 'Row by Row' fetch method is enforced because ...
0
votes
2answers
35 views

How can I determine which tables are causing the database to grow over time?

I have a database in SQL Server 2008 that is growing all the time, and I'd like to know which tables have caused the most growth over the past 6 months.
1
vote
1answer
24 views

Using NOCOUNT to Improve Procedure Performance

I am looking to improve the performance of a certain procedure and I wanted to begin with the insertion of the SET NOCOUNT ON. I've read a couple of articles on the subject: Aaron Bertrand SET ...
0
votes
1answer
19 views

What will happen during failover if the transaction is running on sql server instance?

What will happen during failover if the transaction is running on sql server instance? That is the question. Thanks in advance.
-2
votes
1answer
11 views

Error while uninstalling instance [on hold]

I am seeing this error message on my console when I try to uninstall SQL instance from a box via command prompt: SQL Server 2012 Setup is already running and cannot be launched more than once at ...
0
votes
0answers
16 views

MySQL Transaction with rollback upon @@error

I have done several transactions with MySQL but mainly using php's libraries as the handle. Using php you would have something as: $pdo->beginTransaction(); $pdo->execute(' query1; ...
0
votes
0answers
10 views

Divide a PostgreSQL database into schemas

My Postgres database will be focused on multidisciplinary organizations. The project axis is: a person could belongs to diverses disciplines (ex: arts, sports) for the same organization, and this ...
1
vote
1answer
36 views

MySQL JOIN two tables and get latest result

I want to JOIN two tables and get the latest result from each one of those two in a single table. I'm kind of concerned about speed too since tables are growing kinda fast. Close to 60-70k records a ...
0
votes
2answers
3 views

Cannot Restore Database in SQL Server 2014

I have created a backup of a SQL database in SQL 2014 and want to use this backup to restore it to a different machine that also runs SQL 2014, hence no version issues. However, I keep receiving an ...
0
votes
1answer
11 views

MySQL Server > 90% memory consumption

I have a fairly large (16 vCPU / 47 GB of RAM) linode box which hosts a running MySQL Server. This box currently does nothing else (and we are not planning to install anything else on it for now). ...
1
vote
1answer
37 views

Powershell functin to drop table(s) from SQL Server Database

### List of tables that require full sanitizing $requiredTables = 'table1','table2','table3' foreach ($table in $requiredTables){ function Delete-FromTable{ $SqlConnection = New-Object ...
0
votes
0answers
18 views

Postgres is using 100% CPU

I am using PostgreSQL on a machine with 4GB RAM. As soon as it starts an update, the PostgreSQL process will reach 100% cpu. CPU usage returns to normal after 40 minutes. I've tried tuning the ...
0
votes
2answers
15 views

Table constraint, number of row taken by a fk key

Is it posible to add a table constraint, to prevent an insert if there are already 3 row of the same fk key My table: ProjectTitles (id(pk), project_id(fk), title_id(fk)) Check if project_id has ...
0
votes
1answer
14 views

DBCC DBREINDEX in MS SQL Server 2008

We have done DBCC DBREINDEX for our production database which size is about 300 gb, it was running for 12+ hours, but i found that DBCC DBREINDEX is obsolete and recommended approach is using ALTER ...
0
votes
1answer
25 views

Individual SQL account per user?

I am designing a web application that will have probably around ~1000 users. The website is facing the internet but it can only be used by partners (i.e. the general public cannot just "sign up an ...
0
votes
0answers
14 views

Update a field in table when a combination of three fields with a second table is matched

I have a database form an old archaeological project which I imported into a mysql DB. I have a table "graves" with 400+ entries: "graves" id necr burials single multi 1 1 1 ...
0
votes
0answers
5 views

Role based access control protocol for resources in mysql database

I have a mysql database for an application which contains users and resources, like for example books, movies, tv-shows and music. Users should be able to view and edit specific entries of this ...
0
votes
1answer
19 views

Attaching Database Incorrect name in sys.master_files

I have been moving some databases from SQL 2008 to SQL 2012 using detach and attach method. I correctly map up all the files and the physical and logical names appear correctly in the properties of ...
0
votes
0answers
21 views

Some records are missing while selecting from table

I am trying to match the records having MAX(WORKITEM_ID) but some PROCESS_INSTANCE_ID are not coming though they are present in WORKITEM table. select WI.WORKITEM_ID as WORKITEMID ...
0
votes
0answers
24 views

How to emulate transactions if you don't have access to them? [on hold]

Purely hypothetically speaking, of course, let's say the database client you are using does not support the BEGIN, COMMIT, or ROLLBACK instructions (or they are not thread safe, and your code must run ...
0
votes
1answer
21 views

Sql Server 2008 : What is the cost of accessing an index?

I've just read this interesting blog post about selectivity notion. In the section 'When is better to not use a database index?', the author states : Accessing the index takes time, and consumes ...
0
votes
1answer
18 views

Better way to full text query across multiple tables?

I've got a rather large query across multiple tables and their fulltext-indices which (unsurprisingly) is rather slow: SELECT t0.[Key], t0.[Nr] FROM dbo.[Customers_View] AS t0 WHERE (t0.[Deleted] ...
1
vote
1answer
119 views

Trigger Performance - 1 or 2 Triggers?

I have a question about triggers performance. CREATE TABLE [dbo].[_test]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Date] [DATETIME] NULL, [DateYearID] [INT] NULL, [DateQuarterID] [INT] NULL, [Date1] ...
0
votes
0answers
9 views

pt-table-checksum toolkit for few databases from file

I've got a question. I'm doing a simple script right now and it isn't working like I want. #!/bin/bash cat /etc/backup.conf | egrep -v "(^#.*|^$|^--.*)" > /tmp/databases while read ...
0
votes
0answers
14 views

Simultaneous READ COMMITTED transactions updates a select for update columns

I have a READ COMMITTED transaction in which I am trying to update a row and increment a column value till it reaches a bucket value contained in another column. Please see the code below CREATE ...
0
votes
0answers
20 views

Third Party tools to monitor and administer Oracle database [on hold]

What will be the cost and features of any Third Party tools to monitor Oracle Database other than Oracle Grid Control/Cloud. Any open source also available?
1
vote
1answer
30 views

SQL Server statistics

I have run the Database Tuning Advisor and it has suggested that some statistics are created. Whilst this is great and I understand the purpose of statistics, when I have reviewed them it has created ...
0
votes
0answers
11 views

Difference between Handler_write and Innodb_data_writes

Handler write is the number of requests to insert a row in a table. InnoDB data writes is the total number of data writes. Questions are Does inserting a row count as a disk write? If I do an ...
0
votes
0answers
8 views

DB Design for Mobile App Clients

Hello I am new to designing DB for Mobile App where speed is the Key. My Mobile App will request to WebAPI and WebAPI will get data from MySQL. I have designed my tables in MySQL as per relational ...
2
votes
1answer
29 views

Optimizing a 3 table join query

SELECT job.id_job, job.fk_company, job.fk_user, job.fk_job_category, job.fk_job_type, job.fk_place, job.job_identifier, job.external_job_id, job.title, job.short_description, job.status, ...
0
votes
1answer
34 views

Inefficient queries on partitioned tables

Consider a scenario in SQL Server that includes a partitioned table with over 500 partitions. The number of partitioning column values in a temp table are less than 10. We join the temp table to the ...
0
votes
3answers
27 views

Initials separated by periods (e.g. J.E.F. Smith)

In a MySQL database I have a column that holds the initials of a person. However not all input is nice and clean. To give an example the initials for the name John Edward Fredrick Smith should be ...
1
vote
2answers
23 views

Will frequent small select queries slow down frequent write queries in InnoDB table in MySQL?

I'm running a MySQL database with tens of tables in remote server. To monitor the data, I write a small program to query to database via VPN connection every 10 seconds. Each query is a union of 20+ ...
1
vote
1answer
26 views

Grant privilege to see column names in null constraint violations when inserting in views

My database has two schemas, one with the actual tables and one that is used by an application. The application schema doesn't have any privileges on the actual tables. Instead there is a view for ...
1
vote
2answers
33 views

Should a table have a foreign key to another table if it already has a foreign key to another table that has that foreign key?

That was a hard title to digest even for me so I'll break it down. I'm very new to SQL, and I just designed my first database. I also am not very good at JOINS which might be the answer to my ...
0
votes
4answers
44 views

How can i take backup of particular tables in MS-SQL Server 2008 using T-SQL Script

I want to take a backup of particular tables available in my database in .bak file And all these should be done using T-SQL Script
0
votes
1answer
17 views

SELECT * FROM INFORMATION SCHEMA on V5R3M0

I have access to a client's V7R1 AS/400 and I can run queries like SELECT NAME FROM INFORMATION_SCEMA.TABLES and SELECT COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, ...
1
vote
0answers
31 views

How to speed up for huge tables in SQL select query?

I have the following huge tables. Table_1 with 500000 (0.5m) rows Table_8 with 20000000 (20m) rows Table_13 with 4000000 (4m) rows Table_6 with 500000 (0.5m) rows Table_15 with 200000 (0.2m) rows ...
0
votes
1answer
14 views

backup postgresql database to submit with project

I have a final year project written in Matlab in conjunction to a postgresql database called 'hm'. I asked in which way could I submit the database and I was told to perform a back up of the database ...
0
votes
0answers
9 views

Connection to mysql database- alternating usernames

My server has a max_connections value of 400 and a max_user_connections of 250. Since I am always connecting with the same user name, my effective max_connections is 250 instead of 400. To solve this, ...
0
votes
0answers
11 views

Creating many-to-many relation on demand?

Users can join projects. Projects can have many tasks. Each user completes the task at their own time, they can also have some other user specific settings on the task like the priority in their ...
0
votes
1answer
20 views

Does the scope for 'Alter Any Database' operate similar to 'Create Any Database'?

Does the scope for 'Alter Any Database' operate similar to 'Create Any Database', as in, only those databases created by Login-A under the 'Create Any Database' umbrella can be altered, and not the ...
1
vote
0answers
9 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
18 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
21 views

Server configuration for database installation [on hold]

I'm doing a payroll software on visual studio 2012 with C# and im gonna use postgresql as database, this is for a small business but if you have any recommendations regarding the programming language ...

15 30 50 per page