0
votes
0answers
1 views

Postgresql - Streaming replication - STONITH

Current situation: 1- Postgresql, streaming replicaiton, Master-slave 2- Master failed, i created trigger file. Slave is promoted to new Master After the old master restarted successfully. I have ...
0
votes
0answers
6 views

adding primary key to existing table in mysql is taking time

since more than 22 hour one script i have executed to alter table for adding primary key on a table which is having 22.5 crore records. Note the columns are only 1 that is of MSISDN. In the ...
0
votes
0answers
5 views

How to design a demographics database?

I have a bunch of stores. Each store has the same properties (ethnicity, marital status, income, and so on). Each of those properties has subproperties like (white, black, asian for ethnicity and ...
0
votes
1answer
11 views

MySQL insert position value

I have trouble while inserting the values corresponding to a column: position. I have multiple inserts like this: INSERT INTO category_product(id_category,id_product,position) VALUES(2,1,1); INSERT ...
0
votes
0answers
3 views

sqlplus output is blank

I have a pre-written unix shell script which is calling .sql file and used to spool into .xls It was working fine until today. Today it spooled blank file. There is no error. No message like "no rows ...
0
votes
0answers
9 views

SQL Server 2008 R2 Service pack 3 won't recognize all instances

I have two instances on one of my servers, and when installing service pack 3 the GUI installer does not recognize one of the instances. Server is Windows Server 2008R2 Enterprise x64 SP1 Both ...
0
votes
0answers
3 views

How to split a large table in Teradata

I'm trying to load data from a very large table (200 million rows) into a Presentation Datamart (PDM) for an Enterprise Data Warehouse using Teradata 14.10. I want to split this large table into ...
1
vote
1answer
16 views

Problem Getting Simple Replication to Work in SQL Server 2008/2012

I can't resolve a problem with replication. The publisher/distribution side seems just fine, but when I subscribe and view in the replication monitor I always get this error: "a required privilege is ...
0
votes
1answer
11 views

can I give permission to insert into view, but not to referred table?

Here I have a view in public schema referring to the table in private schema: CREATE OR REPLACE VIEW public.products AS SELECT products.id, products.product_id, products.title, products.company_id ...
0
votes
1answer
9 views

postgresql unable to login

I created a user named 'client', witch refuses to connect. Here's my client: CREATE ROLE client LOGIN ENCRYPTED PASSWORD 'md5d5bc32b75da65fe60067f501a4bb6665' NOSUPERUSER INHERIT NOCREATEDB ...
2
votes
2answers
36 views

Changing SQL Server service account passwords enterprise-wide

In the event of a DBA leaving an organization, what options can the surviving team members pursue to change passwords for service accounts portfolio-wide? While using Configuration Manager appears to ...
2
votes
4answers
54 views

SQL Server 2008: how much RAM memory should SQL Server use in a 8GB RAM server?

We have SQL Server 2008 and 8GB RAM in a customer, hosted in a Windows 2008 R2 SP1, and consider the following amount of free memory: and consider the following running programs: Scenario: ...
0
votes
0answers
6 views

How to create column group in WiredTiger engine in mongodb 2.8?

MongoDB 2.8 supports WiredTiger strorage engine, and WiredTiger supports column grouping. How we can create a collection in mongodb 2.8 with grouped columns?
2
votes
1answer
33 views

dbcc memorystatus - buffer pool target on VM higher than max memory

I'm doing some digging into potential memory/configuration problems on a sql server 2012 SP2. I stumbled upon something that seems a bit strange in the performance counters as well as the dbcc ...
0
votes
0answers
14 views

preventing FullTextSearch from using wildcards

I am using FTS in a sql2008 sql server and had a user complain about some searches breaking. after root cause analysis we found only searches like U.S.A. fail because FTS tries to run wildcard matches ...
2
votes
1answer
14 views

How to get the spatial index in CREATE TO script?

Is it possible to get the spatial index using the create to script using SQL Server 2012? When I write out a table using SCRIPT TABLE AS > CREATE TO in Microsoft SQL Server Management Studio 2012, I ...
0
votes
0answers
25 views

How can I insert rows into a table from a select query that brings duplicate entries?

I am using PostgreSQL. I have a table with columns: tutor_id subject_id I want to populate this table with the result of the following select: select tutors.id, subject_id from courses_subjects ...
0
votes
0answers
6 views

Problems with migration from Amazon RDS MySQL to MariaDB

We are trying to migrate from Amazon RDS MySQL to MariaDB for the performance benefits given by MariaDB. We have copied all the data from Amazon RDS MySQL to MariaDB and the database is up and ...
0
votes
1answer
6 views

Is content of the pg_autovacuum saved when pg_dumpall is used to backup the database?

From the docs: pg_dumpall also dumps global objects that are common to all databases. (pg_dump does not save these objects.) This currently includes information about database users and groups, ...
0
votes
1answer
16 views

one table for all blob with a one to one table for metadata which link to one or many tables?

I'm going to start by saying that I'm not a DBA but i got that role in my current project so I'm doing my best. The application must be able to store files(attachments, official documents, etc) The ...
0
votes
1answer
14 views

parsing and purpose of oracle audit (.aud) logs

I am looking at the oracle audit logs and am trying to understand and parse. The format appears to be consistent: Date Length: Action: ...etc My questions are: 1) what generates these? Is it every ...
1
vote
0answers
8 views

Optimizing postgres row overlap constraints involving UUIDs and GIST

For various reasons all my tables have UUIDs as primary keys and I need to exclude duplicate rows where the combination of area_id, user_id, and finished_at <-> started_at window. The only way I ...
0
votes
0answers
3 views

parsing and purpose of oracle audit (.aud) logs

I am looking at the oracle audit logs and am trying to understand and parse. The format appears to be consistent: Date Length: Action: ...etc My questions are: 1) what generates these? Is it ...
2
votes
1answer
35 views

PostgreSQL CREATE INDEX memory requirement

I've got 6GB of RAM on my laptop and for a test I'm creating a 50mil-rows table in PostgreSQL 9.3. I then want to create an index on the table. The table and the resulting index together (or twice ...
0
votes
1answer
16 views

Forget login from connection drop down menu [duplicate]

Recently I logged myself as a different user (testUser) but now that user seems to be persisted in the drop-down menu of connection dialogue box and I couldn't find a way of getting rid of it. Even ...
0
votes
0answers
18 views

UPDATE/DELETE performance on partitioned table

Hi I'm using table partitioning in my Postgres 9.3. I've notice that the DELETE and UPDATE queries are much slower when I'm doing them via the parent table. I see that the constraint_exclusion is ...
0
votes
0answers
4 views

IQ: How to load floats with , as decimal delimiter

I've got a table with a float as well as an csv file which should be inserted into this table. Unfortunately this csv is encoded using , as decimal delimiter on that float. Is there any way to load it ...
0
votes
1answer
17 views

Email open rate calculations in subqueries with postgres

So I'm relatively new to PostgreSQL, but here we go: I have a pgsql database that is receiving HTTP Post Email Events from my Sendgrid email server, and am trying to make a dashboard that displays ...
2
votes
1answer
31 views

resource wait SQLCLR - wait_type CLR_SEMAPHORE by SPID 0

Since a few weeks I have a continues increasing waittime for this specific wat situation: name wait_info timestamp 38:57.3 wait_type CLR_SEMAPHORE opcode Begin ...
0
votes
0answers
13 views

Can I use xtrabackup to import a database without altering others?

Context: Each time a demo branch is built, I want to download a copy of the prod database and setup it onto the demo server. This way under the MySQL I have X database corresponding to X demos. I ...
1
vote
0answers
11 views

Multilanguage category structure - standard vs. normalization?

I'm building a multilingual application and I need some advice on how to structure the table. Basically I have a category table based on nested set. There are 4 languages and I plan to enlarge this ...
0
votes
0answers
28 views

SQL Server - Error 3202 during Restore

While attempting to restore a 4 TB MDF/data database with a 1.8 TB LDF/log file, I'm receiving the following error: Write on '???' failed: 1117 (The request could not be performed because of an I/O ...
1
vote
1answer
12 views

SQL Server 2012 Business Intelligence licensing

I have Microsoft SQL Server 2012 Entreprise Edition license, What are the tools needed to work on SSIS/SSAS/SSRS? Since BIDS was replaced with SSDT on the 2012 version, does it mean I will need to ...
0
votes
1answer
13 views

How Can I generate a data dictionary which contains the data types of a Json file.

The data dictionary should be generated from a CSV file of sample data.
0
votes
0answers
9 views

MySQL Query lock acquisition order

I have a query that joins across many tables. In one of our workflows another query deadlocks with that query. Iv'e read that one step towards prevention of deadlock is to acquire locks in the same ...
0
votes
1answer
15 views

Can any one Explain me What is the Use of Cascading Replication in Postgresql?

What are the advantages of cascading replication in PostgreSQL. I have done Testing On this With three nodes. M1---->S1----->S2 What is the Use if My master(M1) goes Down(failover). Where the ...
0
votes
1answer
33 views

PAGEIOLATCH_SH and LCK_M_IX wait type

I'm seeking for a resolution into wait types I observe on one of my servers. I've been keeping wait statistics for a long time and can positively say that the top two are PAGEIOLATCH_SH and LCK_M_IX ...
0
votes
1answer
41 views

Reassigning surrogate keys?

I have a few tables with surrogate keys (SERIAL PRIMARY KEYs unique to each tables). These tables are used by other tables, with references to these keys. My usage of these is quite simple : select ...
1
vote
1answer
10 views

How to make distributor highly available in Always On Configuration

We have clients requested us to configure Always on with Replication. Microsoft does not support it. "The distributor should not be a host for any of the current (or intended) replicas of the ...
2
votes
2answers
30 views

SQL Server Management Studio: how to parse stored procedure code and check if table columns exist?

I'm afraid that SSMS won't parse table columns within a stored procedure. When you click in Parse option SSMS says that parse is completed, even when a procedure is selecting a column that does ...
-1
votes
0answers
32 views

Performance issue when we directly insert into #temp table

It might be silly one but I am new to query optimization so I want to know the which query has the better performance select * into #temp from MYTable or Create table #temp ( \\same ...
1
vote
0answers
22 views

Optimise query: find items that are geographically touching, but without association

I have a very specific problem, I am not entirely sure if this is the right place to ask this question. From our client we get data submitted to us, and to verify the quality of that data, we run a ...
0
votes
1answer
28 views

Move/Copy unique entries only from TableA to TableB, if it's not in the destination table

I'm required to move every unique entry from TableA to TableB, it the unique entry from TableA is not already in TableB. Both tables look the same, they don't have any keys, but the combination of to ...
0
votes
2answers
23 views

SQL Server De-duplication Trigger

I have a table that contains columns of Country, City, Location, Description. Due to the size of the description field it's not possible to bind the four fields into a composite key to prevent ...
0
votes
1answer
22 views

Restore back up strategy for history tables

I have historical/log tables which are: very large holds data that is not rarely queried only inserts are performed (constantly, very often) I want to either compressed them or move them to ...
0
votes
3answers
42 views

Duplicate values

Here is my table : PlayerId NoOfTeams 1 3 2 2 3 2 4 NULL 5 NULL I want to display PlayerID having same No.OfTeams including NULL values. Could any one please ...
4
votes
1answer
103 views

DBCC DBINFO showing wrong information

Though DBCC DBINFO() is undocumented, but we all know that dbi_crdate: Database creation datatime dbi_dbccLastKnownGood: the completion time of the last 'clean' run of DBCC CHECKDB For one ...
0
votes
0answers
7 views

MongoDB all replica set members are “OTHER”?

I am setting up a MongoDB replica set using EC2's image: https://aws.amazon.com/marketplace/pp/B00CO7AVMY/ref=dtl_recsim_B007IBMJPI_B00CO7AVMY_3 MongoDB version 2.6.5 I have managed to set up ...
0
votes
0answers
18 views

Signal in MYSQL procedure with parameters?

Following is from my MySQL dump DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `test`() SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Mobile Number Exists'$$ CREATE ...
1
vote
0answers
17 views

Strange MySQL replication error 1146 (Table doesn't exist)

I'm getting a very weird MySQL replication error No. 1146 for a REPLACE INTO query on a slave host replicating all tables in all databases from a master, and I'm having a bit of a hard time ...

15 30 50 per page