1
vote
1answer
366 views

Optimize large table design

First, I am a complete novice when it comes to databases, but have been given the task to speed up queries on a large set of data. (Hundreds of millions of records) The current implementation is a ...
1
vote
3answers
122 views

Data Warehouse measures without a corresponding dimension

I have an operations database that contains this table: salesQuality salesPrice salesCategory According to my business requirements, the salesQality and salesPrice are measures. However, ...
1
vote
0answers
182 views

How I can create user defined roles

I have a database in mongoDB 2.6.4 in which I want to restrict the users as per their level. I want to give read privileges to some users and insert/update privileges to some other users on a ...
1
vote
1answer
78 views

MySQL replication slave of slave not receiving updates

I have 4 servers: A, B, C and D. A and B are in a master-master setup. C is a slave to B and D is a slave to C. Changes on A or B get to all nodes other than D. I need them to get to D Changes ...
0
votes
2answers
768 views

Check if database has changed to determine need to perform backup

I want to check SQL server database is modified or not. Reason to check database is modified is for backup(sql database backup) purpose. So I will be doing a full backup first and if any data ...
1
vote
2answers
666 views

Understanding multiple table join with aggregation

I have a basic question on how JOIN works on multiple tables. I want to count occurrences of Foreign Key in link1 & link2 CREATE TABLE main ( id SERIAL PRIMARY KEY, name text NOT NULL ); ...
0
votes
1answer
100 views

Can not run PostgreSQL after drop table

I've deleted database from PostgreSQL and after this I can do nothing. Here what i receive with createuser $ createuser -D new_user createuser: could not connect to database postgres: FATAL: role ...
0
votes
0answers
26 views

Login failed for user 'x' [duplicate]

We receive an error Login failed for user 'x' sometimes from our application. We are 100 % sure the login is working because we checked it by manual login from SSMS as well as from the application. ...
0
votes
2answers
41 views

sync 2 tables in a single database in mysql with no duplicacy [closed]

I have 2 tables in a single database of MySQL. The structures are like this: mysql> desc main_tbl; +-----------------+--------------+------+-----+-------------------+----------------+ | Field ...
1
vote
1answer
549 views

When try to do Mysqldump Backup from console then getting such as error [closed]

mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect when i am tring to do MySQLDump backup from console then getting such as above error. I am ...
2
votes
1answer
264 views

SQL aggregate function performance in a table with many records that is well-indexed

My question is about 3 tables that stores data of a single entity, and there is a report generation feature that refers these tables and calculate COUNT and AVG information. There are three tables: ...
1
vote
2answers
275 views

Determine whether there is any blocking while deleting large number of records [closed]

I would like to know whether there is any way to determine why it is taking too much time say 3 minutes for deleting 50K records from a database hosted in Sql Azure. I have clustered index on primary ...
0
votes
1answer
91 views

Compare two columns for difference mark the difference in mysql

I need to compare two fields and mark the similar fields in third table. For Example: Tables customer: phone id, phonenumber followstatus received_Customer: rc_id, rc_phonenumber. I ...
7
votes
2answers
1k views

Can rebuilding indexes cause worse performance after the rebuild is finished?

We have a customer database that is heavily fragmented - practically every table with more than 1000 pages has >95% fragmentation. Fill factors are set to sensible values, but page space usage is ...
0
votes
2answers
685 views

How can i automate the process of log shipping monitoring

I have log shipping configured between my Prod SQL server 2005 and QA SQL server 2005. Per the requirement from Business we need to provide them with a report at the end of the day for the LOG ...
0
votes
1answer
4k views

How to set ADR Base directory correctly on OracleDB on Linux?

Installed Oracle Database on Linux based OS. Listener is ok. But Oracle is not. (I changed all angular brackets to vertical, because parser not shows angular brackets) ORA-48108: invalid value ...
2
votes
1answer
583 views

SSIS Dataflow Task issue, moving data from SQL Server 2008 to MySQL via ADO.Net

Can you please help me in getting this problem solved.. I'm trying to build a SSIS package where I'm moving the data from SQL Server 2008 to MySQL. However I'm getting a weird problem in dataflow ...
1
vote
1answer
513 views

Index rebuild log growth

How much log index rebuild will generate.I remebered reading rebuild index should generate same amount of log file as table size.But my tests are showing otherwise.We need this estimate since we are ...
1
vote
1answer
635 views

Postgresql Rename Table without Updating View Definitions

I've found out today that renaming tables in Postgresql also renames the VIEW definitions for Views that use the table I renamed automatically? Is there any way to turn this off? So I rename the ...
2
votes
1answer
2k views

SQL Server Agent Error 1053

A few months back I installed SQL Server 2008R2. At the time of installation I used 1.Mixed Authentication 2.NT Authority\NetworkService as the SQL Agent user name, and the same user name for all ...
3
votes
1answer
192 views

Trace Flag 3688 not working on SQL Server 2014

We are using some third party tools that fill up the SQL Server logs with entries like: SQL Trace ID 1 was started by login "sa". SQL Trace ID 2 was started by login "XX\xxxxx". SQL Trace stopped. ...
1
vote
2answers
62 views

Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query

I have this query for get all the pais_id given a fabricante_distribuidor_id and producto_solicitud_id, the query works fine. SELECT DISTINCT nom.pais_id FROM negocio.fabricante_producto_solicitud ...
0
votes
0answers
102 views

Cannot connect to mysql server

Hello I am trying to connect to mysql server from php using PDO. But I get this error : An error occured : SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket ...
0
votes
0answers
251 views

How to ensure MYSQL imports of .sql files properly retain foreign key relationships, constraints, etc

Recently, we restored a MySQL '*.sql' file on two separate brand new MySQL instances. The MySQL version is 5.5.40 running on CentOS 6.6. In one instance, everything restored fine. On the other, a ...
2
votes
1answer
100 views

Can I grant multiple remote LocalService accounts access to a SQL Server database?

I am designing a multi-environment Windows-based software product that will extensively employ Windows services running as LocalService to perform data access operations. All of the data access ...
1
vote
1answer
44 views

How to determine efficacy of index on child side of foreign key

Given a parent-child relationship between two tables, such as: table ORDER order_id PK (already indexed) order_name table ITEM item_id PK (already indexed) order_id (FK to ...
0
votes
1answer
852 views

MySQL is inserting “” as 0 in decimal fields. How to stop that?

The fields are nullable, so they do allow nulls. Why would MySQL convert "" to 0 instead of NULL? Is there a way to force it to be NULL instead?
1
vote
0answers
21 views

AlwaysOn SQL Agent Jobs [duplicate]

We are running AlwaysOn on three replicas. The primary and first secondary are synchronous for failover purposes. The second secondary is a read-only asynchronous server for reporting. The only thing ...
1
vote
0answers
106 views

Why database replication fails when database mirroring is broken?

I'm trying to understand what effect database mirroring can have on replication in SQL Server 2008. Here is current environment: (don't ask me why it was done this way or to change it) Server A: SQL ...
12
votes
1answer
524 views

What is the cause of this problem with CONVERT()?

Consider the following two statements: PRINT CONVERT(NUMERIC(38, 0), 0x0100000001, 0); PRINT CONVERT(NUMERIC(38, 0), 0x0100010001, 0); Both statements return -1; isn't that incorrect since the ...
1
vote
1answer
3k views

How do I set up a Derived Column Transformation to get row number in SSIS 2014?

I am trying to import a ragged right flat file. I am wanting to import the file as one column and used Derive Column Transform to add a row number to each row. I would like to end up with a column ...
0
votes
0answers
9 views

Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues [duplicate]

I've been working on setting up clustered environment with a two new DTC roles, DTC1 and DTC2. I set up DTC1 which allows both clustered VM's and SQL Server Instances to function correctly. However, ...
0
votes
0answers
276 views

PostgreSQL replace primary key and converting non-serial to serial type [duplicate]

I'm basically building my own version of phpPgAdmin (if I get good enough to make it good enough I'll post it on a repository hosting service) and currently I'm revising my primary key tool to replace ...
3
votes
0answers
81 views

Are there any outstanding critical security issues for Sql Server 2000?

Are there any outstanding (unpatched) security issues for Sql Server 2000? This isn't really for me: I moved on from Sql Server 2000 long ago. However, when answering questions here and (more likely) ...
1
vote
0answers
53 views

How to use the value from record like as varchar?

I'm trying update a old table with result of selec for another tables but get a error using this sintaxe (e.g.): DO $$ DECLARE _roles refcursor; _onerole varchar; _record RECORD; ...
2
votes
1answer
351 views

Sql Server 2008r2 Replication Snapshot Agent Hang

I am setting up a new merge publication, but I can not get the snapshot agent to run successfully. In fact, I can not run any snapshot agents for any of the other publications on this server now. ...
1
vote
3answers
1k views

How to see percentage of existing values for all columns in mysql table?

I have three large-ish tables (~20 columns each) and I want to know what percentage of rows have a value for each column. For instance, this table: ID | TITLE | SERVING | NOTE ...
3
votes
1answer
419 views

Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues

I've been working on setting up clustered environment with a two new DTC roles, DTC1 and DTC2. I set up DTC1 which allows both clustered VM's and SQL Server Instances to function correctly. However, ...
2
votes
2answers
155 views

Does changing a Postgresql table's tablespace compact it like “vacuum full” or “cluster”?

I need to reclaim disk space in a table in a Postgresql 9.3.2 database to be used for other tables. The standard suggestions to accomplish this are: "VACUUM FULL" or "CLUSTER" or copy the contents ...
1
vote
1answer
61 views

Mysql replication problem after export/import on already working replication

I have 2 databases in master - slave replication. I had some errors in the replication due to inserts in the slave, so I corrected it and executed: stop slave; set global sql_slave_skip_counter=2; ...
0
votes
1answer
173 views

Orig DB = No Corruption, Backup/restore = Corruption?

We are setting up offline DBCC checkdbs on an offline server so we can still do our checks, but not interfere with production. When we backup the Master DB and restore it (even directly on a local ...
1
vote
0answers
280 views

Please help me resolve this SQL mirroring error which comes when I ‘Start’ the mirror. The network address can not be reached or does not exist

Here are all the steps I took to build the mirror for the db MIRRORDATABASEI am using separate physical servers for mirroring. I ran: ALTER DATABASE MIRRORDATABASE SET TRUSTWORTHY ON to ensure ...
1
vote
2answers
1k views

How to set the sequence to the last used id for all tables in Oracle?

I'm working on an open source elearning system called Moodle which usually uses MySql or Postgresql, but can also use MSSQL and Oracle. A client wishes to use Oracle, which I have limited experience ...
1
vote
2answers
524 views

How to calculate a total by comparing current and next row

I have a table with some rows: I have a few questions to accomplish the task altogether. Is it possible to calculate total of transmitted and received based on checked_date and ip and connect_time ...
-2
votes
2answers
35 views

creating tablespace failed!

I've restored a db and its failed with many errors. When I look into the log file, I found that the tablespace does not exist. So when I try to create a tablespace in plsql am getting the following ...
-2
votes
1answer
39 views

Allow me to transpose rows into columns [duplicate]

I have a table data as shown below. +---------+----------+-------+--+ | Name | Semester | Score | | +---------+----------+-------+--+ | John | Sem 1 | 80 | | | Michael | Sem 1 | ...
3
votes
2answers
2k views

Getting the number of Saturdays and Sundays in a month

I am trying to get the number of Saturdays and Sundays for a given month represented by an end_date and a start date. I have been trying to understand the algorithm in the SO question here . I have ...
10
votes
2answers
415 views

How to measure or find cost of creating a query plan?

I have a typical case where parameter sniffing causes a "bad" execution plan to land in the plan cache, causing subsequent executions of my stored procedure to be very slow. I can "solve" this problem ...
0
votes
1answer
452 views

Remove duplicate terms from column

This the tags column where all terms should be listed only once. Would like to remove all additional words from this column. For example the below contant: Lakshmi Bar & Restaurant, Dining ...
1
vote
2answers
179 views

Unable to describe table in oracle

I'm trying to get the description of a table in oracle because I need to know what foreign keys does it have and which tables they refer to. I'm using desc but all I get is "ORA-00900: invalid SQL ...

15 30 50 per page