1
vote
0answers
5 views

Best db setup to accomplish yes/no list of clients for daily calls

I will preface this by saying I am a relative novice to Access but I have managed to develop some basic databases. I have some working knowledge of expressions and macros but VBA is still a bit of a ...
0
votes
0answers
9 views

MySQL server won't start with foreign_key_checks=0

I'm running Ubuntu with MySQL version 5.5.44 mysqld Ver 5.5.44-0ubuntu0.14.10.1 for debian-linux-gnu on x86_64 ((Ubuntu)) I have a DB with foreign keys. I would like to have the foreign key ...
0
votes
0answers
6 views

Demoting a MySQL Master to Slave

I recently had to fail my master over and promote a slave due to a network outage. All of that worked fine. Now that the network is back, I'd like to add my old master as a slave of the new master. ...
0
votes
1answer
10 views

Migrating all MySQL databases from from one server another. Getting error during import

I create a mysqldump on all the databases on the source server with this command: mysqldump -h mysql-01 -u root -p --all-databases > newdump.sql This takes about an hour, but runs fine. Now, ...
2
votes
1answer
24 views

How to capture PRINT statements from TSQL called by CLR stored procedure [duplicate]

I have a CLR stored procedure that (among other things) calls a TSQL stored procedure. The TSQL stored procedure runs some dynamic SQL, and it prints the SQL before it runs for debugging purposes. ...
1
vote
1answer
24 views

Ways to Reduce Database Size and possibly improve performace. Untouched enviroment.

I am new to an environment. The Databases are virtually untouched by a seasoned DBA. I am looking for ways to reduce DB size and possibly improve performance. Unfortunately, I only have WEb edition ...
0
votes
1answer
15 views

How can I get the latest value per unique ID, then count the number of entries with that value?

Ok, so I have a table that has device_id, lots of other stuff, and network_type. I currently run the following query: SELECT partner_name, COUNT( IF( network_type='ethernet',network_type,null )) AS ...
1
vote
2answers
12 views

Add MS SQL Server to virtual machine in Azure

I'm trying to get TDE in Azure. I read that it's possible only on a virtual machine. I built the virtual box, but didn't add SQL Server when it was created. Can I just install SQL or will I have to ...
0
votes
1answer
17 views

inner join on true

My table: abc +--------+ | letter | +--------+ | a | | b | +--------+ Query: SELECT * FROM abc t1 INNER JOIN abc t2 ON true Result: +--------+--------+ | letter | letter | ...
0
votes
0answers
25 views

SQL server only using 4 GB ram

I have a Windows Server 2008 R2 server running SQL Server 2012 Standard Edition. It won't use more than 4 GB of RAM. I checked max server memory variable and it's a 7 digits long standard number ...
0
votes
2answers
21 views

Dropping Global Temporary Tables

In Oracle when you try to drop a Global Temporary Table that is in use you get the following exception: ORA-14452: attempt to create, alter or drop an index on temporary table already in use This ...
1
vote
0answers
9 views

Connection Reset by Peer Socket Write Error - How to solve in SQL Server?

We have a vendor working on Java (JDBC) application saying they are getting the error "Connection Reset by Peer: Socket Write Error". They are insisting that the SQL Server (SQL Server 2012) is ...
1
vote
0answers
8 views

FILESTREAM access stuck in broken state

Following a reboot, two of our databases were marked as “Recovery Pending” and could not be accessed. These databases are both using FILESTREAM. In trying to fix them, we attempted the following: ...
1
vote
1answer
10 views

How to have remote standby PostgreSQL server in different location (AWS)?

We have a primary PostgreSQL 9.4 server running multiple instances in our DC. It is using Continuous Archiving via WAL-E out to AWS S3. I would like to have a hot/warm standby server in our VPC within ...
1
vote
0answers
20 views

Cluster Quorum Voting [on hold]

I have a cluster of 4 SQL Servers setup. 2 of the servers are in RackSpace in Chicago. 1 is in Rackspace, in Reston, VA, and one is in our office in Greenville, SC. I want to change the cluster ...
0
votes
1answer
12 views

Restore Postgresql data after hdd crash

My HDD crashed, so, I can't make a Postgresql backup. It seems that my data tables are OK (I can view the data via pgAdmin). However, when I run pg_dump I get this: pg_dump: Error message from ...
0
votes
0answers
10 views

Is it possible to move more than one database object into a schema using the `ALTER SCHEMA` statement in SQL Server 2008 R2? [duplicate]

I have a TSQL Statement like this: ALTER SCHEMA FindUsedAndUnused TRANSFER dbo.UsedUnusedNotSure_the_counts; And when I try to run it with multiple TABLEs or VIEWs I receive an error; Is there ...
2
votes
2answers
21 views

Disk size and log file growth during upgrades

I have four SQL Server databases. Per the maximum load requirements, each database file can be between 1 and 2 TB in size. The HDD is a multi-disk DAS with about 9TB of space. During a database ...
0
votes
1answer
8 views

MySQL / DRBD / Pacemaker on EC2

I am trying to setup DRBD/MySQL/Corosync/Pacemaker on AWS EC2 instances, though I am not sure if it will work since how to integrate VIP is a problem for me. Anyone have any thoughts on what to do ? ...
0
votes
0answers
18 views

Case statement in a where clause in Oracle

I am writing a report for a customer using SQL. The end result of this report is to show a group of people with an expired certification or expiring certification. The report has a ...
-3
votes
0answers
16 views

what is update cascading exactly in sql? [on hold]

We have three table declarations for P1(A), Q1(B) and R1(C) with referential integrity in SQL. create table P1 (A primary key); create table Q1 (B primary key references P1(A) on update ...
0
votes
1answer
12 views

Address Windowing Extensions Overhead

I just found another SQL Server (2008r2) with AWE enabled on a 64-bit OS/SQL combination. Has anyone done an research as to the overhead created by enabling AWE on the 64-bit OS/SQL combination? It ...
1
vote
1answer
10 views

SQL Server restore database file access error

I am trying to restore a database from a file on a remote machine. The script I am using is as follows: RESTORE FILELISTONLY FROM disk = '\\server\path\to\file.dmp' RESTORE DATABASE MyDB FROM ...
1
vote
1answer
14 views

postgres9.4 streaming replication not streaming

I configured a postgres pair for streaming replication, the pg_basebackup command was invoked successfuly on the slave, so I now have a copy of the master on it. The problem is that the slave does ...
0
votes
1answer
21 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager, sqlserver.exe is ...
3
votes
0answers
19 views

Postgres 4x Slower Than It Was

Our Postgres performance has gone down to 1/4 of what it was, and we can't figure out why. We have two machines with identical hardware (let's call them A and B): Intel(R) Xeon(R) CPU E5-4640 0 @ ...
0
votes
0answers
5 views

Permissions To Update Legacy DTS Packages

I am trying to grant access to allow users to view and update existing legacy DTS packages. The problem is that they cannot see the needed nodes under Management to begin working on them. I've tried ...
1
vote
0answers
27 views

Oracle migration to SQL Server

I am working in a Oracle 11g database migration to SQL Server 2012, I did the migration using SSMA v5.3 and all works fine. However, I did re-write code in some objects like triggers and stored ...
2
votes
1answer
13 views

Should the Redo log on a production MySQL server be configured to another location?

Concerning the innoDB storage engine, should the innodb_log_group_home_dir option (The directory path to the InnoDB log files) be configured to another disk, other than the default directory, in order ...
-1
votes
0answers
23 views

Stopping the SQL Server service instead of detaching database

I want to copy the transaction and log files for my SQL Server database and attach it to another SQL server on another machine.. I was wondering instead of detaching the database, can I just stop the ...
0
votes
0answers
22 views

Select query for finding jobs started at same time

I have a 'Job_Status' table with 3 columns: Job_ID (numeric) Job_Time (datetime) Machine_ID (numeric) At a regular interval (1 min), entries are inserted in the above table for the Jobs running on ...
2
votes
0answers
13 views

Can jsonb do fast search by *value* or even a partial value? Other types?

I have a person table where arbitrary data must be inserted. Since I'm using postgres 9.4, JSONB appears to be the right choice. Data Ex.: id: 1, name: "Joe Doe", preferences: { color: "red" , toy: ...
3
votes
0answers
27 views

Problem with Cluestered Index? or bad indexes? ( SQL Server 2008 R2 )

I have this query ( it was running in 2 minutes. With new indexes, it takes 40sec: select Top 30 codCliente from ( select t1.CodCliente, codcampo, valor, t1.chavealeat from ...
0
votes
1answer
14 views

Does Oracle Instant Client 12c support LDAP?

I've been using Oracle Instant Client 12c as a lighter-weight alternative to the full Oracle installation. It works fine when I resolve service names with tnsnames.ora, but now I would like to ...
2
votes
1answer
32 views

Password generator function

What's the best way of creating a password generator user defined function function in SQL Server if it is not possible to use non deterministic funtions within functions? I would like to create a ...
1
vote
0answers
7 views

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep '(galera|maria)' mariadb-libs-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.40-6.el7ost.x86_64 mariadb-galera-server-5.5.40-6.el7ost.x86_64 ...
3
votes
1answer
18 views

MySQL Multi-Master Replication Topology

Disclaimer: I've never worked with replication before, but I'm doing all my research. Not really having a bunch of in-depth knowledge about MySQL makes a lot of the documentation hard to understand. ...
2
votes
2answers
91 views

Fire and Forget SQL Triggers?

I have a 3rd party app that uses SQL Server as a back end. Specifically we have it on SQL2000, SQL2008 and SQL2008R2. Any solution must be available to all, but solutions for only some would still be ...
1
vote
1answer
11 views

How to determine if pg_dumpall is still running

Environment: Postgres 8.4 Debian Squeeze LTS Recently we switched from a backup solution around hot_backups to using pg_dumpall. This solution used a pid file as long as the hot_backup was ...
3
votes
4answers
43 views

Select using a different value than id on join [on hold]

I have two tables, normalized: table1 id quality product_id 1 100 1 2 100 2 3 10 4 4 50 2 and table2 product_id product material 1 ...
1
vote
1answer
24 views

MySQL Matching records across tables discrepancies

I have a database called match, within this database I have a number of tables. Of which in particular I need to marry up two datasets in different tables to identify email addresses that are not ...
0
votes
0answers
16 views

Postgres 9.1.16 Hot Standby

I am using postgres 9.1.16 (and i cannot upgrade :/) with Hot Standby. We have a few batch that perform some heavy writes, resulting in a lot of WAL produce in a short period of time. The standby ...
2
votes
0answers
219 views

How to encrypt user passwords for forum registrations? [migrated]

What is the most secure way to encrypt user passwords for phpBB or MyBB forum registrations? I don't want anyone to be able to access the user passwords, not even those who administrate the MySQL ...
0
votes
0answers
9 views

How Do you add multilanguage support in oracle 12c post installation?

I have oracle 12.1.0 database But currently has only english language support . How can I get multi language support without re installation?
0
votes
1answer
22 views

Tools Required to have online database (ms access) [on hold]

Currently i doing a project for college on databases. the scenario is this. I have a webpage with a form asking for basic details from a user. i want the information that is submitted to be ...
-1
votes
0answers
34 views

Is there any future scope with DBA profile? [on hold]

I have appointed as DBA. And I don't have any kind of experience. Right now I am fresher and I don't have any idea about How is DBA profile ? What should I do to become a good DBA ? Is there any ...
2
votes
0answers
12 views

sql error on script execution. try deleting repository before creating repository

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html but I got this ...
2
votes
1answer
25 views

Data synchronization across multiple databases

I have a Django application which uses PostgreSQL as a database. The application stores hierarchical data. It is like a warehouse management system with multiple branches and hierarchy. The current ...
0
votes
1answer
24 views

Using GROUPing or ROLLUP rather than SUMing every column

I am currently looking for a way to achieve what this query is doing without using SUM for every column and, if possible, GROUPing or using ROLLUP or something similar. This query gives me a total ...
0
votes
0answers
17 views

Oracle DB - DR corruption

One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...

15 30 50 per page