0
votes
0answers
112 views

Replicating from MySQL 5.1 master to 5.6 slave failing because 'INSERT … VALUES (NOW())' results in 'Error_code: 1062'

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...
1
vote
1answer
355 views

Dealing with single quotes in a dynamic query [closed]

I'm building a query as a string in my application layer to be executed over jdbc. The string is constructed as follows: "SELECT COUNT(DISTINCT ROOT_ID) as rows1 FROM DANIEL.UNIQUE_PHYSICIAN " ...
1
vote
2answers
43 views

Causing ORA errors in a program using JDBC. How can I find what's causing them?

So I'm building a java app to interface with the company's database. Whenever it causes an ORA error, it just prints something like the following to system output: ORA-00911: invalid character Is ...
1
vote
1answer
52 views

Union of data from all tables with name containing a substring

I have 500+ tables all containing a column called COLUMNDATA. The table names are like: TABLE_FIRST, TABLE_SECOND, ... ,TABLE_FIVE_HUNDREDTH. What I am trying to get is a column containing all the ...
4
votes
1answer
122 views

Should I use a subquery to help SQL Server find the correct plan

I have a query (which has components which are built on the fly depending on the selections a user makes in the interface) that runs in SQL Server 2008-R2 that runs in about 100 databases. Users are ...
0
votes
0answers
43 views

PostgreSQL 9.3 - Move table to tablespace - Slow?

I need a help with moving table to a different tablespace. I have a really large table that is not queried much often so I've decided to move it from tablespace on SSD to tablespace on HDD and save ...
0
votes
1answer
52 views

Error with my trigger. What should I do?

This trigger fails when it's called: create or replace TRIGGER UNIQUE_PHYSICIAN_TRG BEFORE INSERT ON UNIQUE_PHYSICIAN FOR EACH ROW BEGIN <<COLUMN_SEQUENCES>> ...
-1
votes
3answers
73 views

Query to return zero entries with COUNT

I have a problem with one task. I need to display various information through two diferent queries.(or one if it could be possible) The table has these fields. Location is set to x +------------+-----...
1
vote
0answers
53 views

oracle DB connection - hostdef extension doesn't exist

I am trying to connect to an Oracle DB through ERwin, yet I keep getting this error message: I know that the DB exists, as my coworkers are accessing it. The Username and Password are also correct, ...
2
votes
1answer
98 views

How to interpret this XML plan fragment?

I am looking at the query plan produced by SQL Server 2008 R2 and I'm not sure I'm interpreting it properly. Examples: <RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" ...
0
votes
0answers
13 views

Pat_ID Incrementing by 2 only after close

I am working on an internal project connecting my database to my application. I am using C# to write the program. I am still learning and this is more of a training tool than anything else. When the ...
2
votes
1answer
186 views

Storing multi-select data with single-select data

I've got a database with some multi-select fields. To keep it simple, let's just say those fields are MatchGender and Interests. I want users to be able to find people who match (hence Gender is a ...
1
vote
2answers
134 views

How to populate another column with a sequence value generated for an identity column?

I have a table that has a column that is determined by a sequence using the identity column thing, so after a record is inserted (or during, I'm not sure how it works behind the scenes, only that it ...
2
votes
1answer
118 views

Job is Storing History But 'Include Step Output in History' is not Checked

I have a SQL Server Agent Job. The 'Include step output in history' checkbox is unchecked. However, when I right-click oon the job and select 'View History', I can see that it is tracking step output. ...
1
vote
0answers
34 views

How to mark loser as winner in p2p replication conflict resolution

We have sql server 2008 databases in 2 different regions that are p2p replicated. Now we can see there are some unresolved conflicts - most of them update/delete conflicts. The way our system is ...
1
vote
1answer
49 views

How to model state change timeline

I've got an app where users can place orders for recurring delivery of a particular service. The orders table has columns service_id and state, where service_id links to the service the user has ...
1
vote
0answers
10 views

How I can read errors that occurred in the BBDD as processes incomplete in MS-SQL?

How I can to recognize the processes that failed on the SQL Server/bd, processes that any user run/exec. For example the last rollback occurred in the bd after some process failed. Would reading ...
2
votes
1answer
250 views

innodb , mysql Indexes difference when adding index

When I am altering one of my MySQL table to add an index I am getting below error in error log. Table a/b contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined ...
3
votes
1answer
166 views

Create Database and LCK_M_S

We are experiencing issues when creating a database in the SSMS GUI in that sometimes it times out complaining that it could not get an exclusive lock on the Model database. Other times the database ...
0
votes
1answer
42 views

Data extraction from 2 tables

Data in table A: X Y ------ m1 r1 m1 r2 m1 r3 m2 r1 m2 r4 m2 r5 Data in Table B: Z -- r1 r2 r3 r4 r5 Using a query I want a result like m1 r4 m1 r5 m2 r2 m2 r3 The data required ...
0
votes
1answer
31 views

Unknown column 'sitename' in 'where clause' [closed]

public function getSiteValues($value) { $this->db->select( 'site', 'id, option_name, option_value', NULL, 'option_name=' . $value ); // database, what ...
4
votes
1answer
236 views

Moving Transaction Data To Another Database For Reporting Purpose

We got a requirement from our developer group, to do the followings: Frequently (every 30mins) move the transaction data out of live database to another database Secondary database will be utilize ...
2
votes
1answer
286 views

Merge duplicate rows into one row

I have a table like below in MySQL: +-----+------+-------+-----------+----------+---------+ | #id | NAME | empid | c_lan | Java_lan | Dot_lan | +-----+------+-------+-----------+----------+-----...
3
votes
1answer
139 views

ORA-00845 after deleting files accidentally at /dev/shm

I have two instances (ORA1 and ORA2) of Oracle 11g at the same machine. One is starting the other cannot startup anymore. What happend: First my disk was full, so I accidentally deleted all ora*-...
1
vote
1answer
229 views

Why isn't Postgres doing an index-only scan?

I am using Postgres 9.4. This is my table: id | integer | not null default nextval('frontend_prescription_id_seq'::regclass) presentation_code | character varying(15) ...
1
vote
0answers
49 views

Delete using join or using sub-query?

I need to delete rows from a table based on what is present in a temporary table. For me, both of these statements work : DELETE from main_table where `id` in (select `deletable_id` from ...
0
votes
1answer
29 views

Instant File Initialisation on Windows Oracle Server

I require to add additional datafiles to a SmallFile tablespace. The process took several minutes on my system for 1 datafile. Is it possible to allow Oracle the same capability as SQL Server using ...
1
vote
1answer
183 views

all_tables and dba_segments giving different space occupied by the same tables

When I ran the below queries they gave different space occupied by the same table: select bytes/1024/1024 as space, owner from dba_segments where segment_name='PARAMETER_STATUS'; SPACE OWNER ---...
2
votes
2answers
2k views

SQL Server varbinary column modifying inserted data

We have a table in our database for storing photos, the datatype of the actual photo data is varbinary(max). When inserting a photo from the application, the data is correctly stored and the photo ...
1
vote
0answers
110 views

Query execution taking long time

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext select ...
1
vote
1answer
85 views

Calculating percentage of count and adding it to the count in MySQL table with the query [closed]

I have following basic MySQL query and I my aim is to artificially inflate the amount of today's orders by 75%. Is there a more efficient way of doing this without using COUNT twice? SELECT COUNT(...
4
votes
1answer
160 views

Preventing full backups for unmodified/slightly modified databases

Is there a way to either: ensure that unmodified databases are skipped during SQL backups, or even better choose between DIFF or FULL backup depending on the percent database changed since last ...
0
votes
0answers
840 views

How to make search faster in mysql DB with > 2m records, only numbers

I have a table with sim card data with over 2m-3m records. The design is a column sim_number = varchar(11) with data like number (0123456891) When the table is under 1m records it's still fast but ...
10
votes
1answer
191 views

Why is the secondary selective index not used when the where clause filters on `value()`?

Setup: create table dbo.T ( ID int identity primary key, XMLDoc xml not null ); insert into dbo.T(XMLDoc) select ( select N.Number for xml path(''), type ) from ( ...
0
votes
1answer
222 views

MYSQL fulltext - What's the right way to get the relevance from one column?

I want to make one column more valuable than others like it's been done in query bellow.This example shows that only one fulltext index is needed And this answersuggests that three fulltext indexes ...
3
votes
3answers
173 views

Is it better to create another table to possible null values in relational databases?

I'm designing a relational database to use in MySQL. I have the next situation: In one table there are fields that in the most of situations are NULL. The fields would be like: Table name: tabla ...
1
vote
0answers
27 views

db2 Rollforward create active log in the active directory in v10.1

I have one master and one slave DB, they are not in HADR. for each 15 mins, the master archive log will be rsync to the slave DB and do the rollforward to end of logs in slave. But I find out in ...
1
vote
1answer
70 views

MySQL trigger level

I'm looking for a way to find out if a row in a table is updated by a trigger or by regular input. In example, I have two tables: TABLE 1 table1_id INT(11) name VARCHAR(255) last_date DATETIME ...
0
votes
1answer
41 views

Table1 ID is auto increment and i also want to store the information from table 2 against that auto generated ID

This table has an auto increment ID on back end. "INSERT INTO `test`.`personal_info` (`username`, `email`,`password`) VALUES ('$username','$email','$password')"; This was for signing up of one ...
0
votes
1answer
365 views

Strange error in trace file for NSAn standby process

One of the Oracle databases I help manage is the primary in a standby configuration, with two standby databases. I started finding repeated entries in the alert log on the primary for a failure to ...
0
votes
1answer
57 views

Query trans log or tempdb?

New DBA, all of our databases are SQL 2005. All of our servers run in Simple recovery mode. I work for a school district, where we report student attendance to the state. I run a query to fix ...
4
votes
1answer
44 views

Doing a select based on a count(), a date range, and string match

I'm going to do my best here. I Have a list of citations that were written and a and some information about those citations. I need to select the citations that have been voided in a given date range ...
1
vote
1answer
31 views

How can I filter databases by owner using psql?

I know I can list my postgres databases with the following command: # list only the databases psql -U openerp -q -t -c "select datname from pg_database;" template1 Or # show a full listing of ...
2
votes
3answers
165 views

All My Databases Are Gone?

Today I changed my username and password in MySQL and I logged into phpmyadmin to see that all my databases were gone. I've tried changing the datapath but then I realized I didn't see any of my ...
1
vote
1answer
327 views

Restricted user on my local SQL Server database?

I started working at a new job and when I opened up SSMS and tried connecting to my local DB (by connecting to ".") I got a cannot connect message. I was finally able to connect to my local DB by ...
1
vote
2answers
2k views

SQL Server Auditing is not available in Standard editions?

If the Auditing option is not available in SQL Server 2008 R2 Standard edition, then why I still see it under the Security object in SSMS? After reading online, it seems that my option is to use the ...
1
vote
0answers
62 views

Update all foreign keys to a different primary key

In a MySQL database, I have a table full of business information. Lots of businesses have been inserted twice due to human error, so the same information exists with two different primary keys. Let'...
1
vote
1answer
42 views

generate new column from another table column, treating nulls are unique

I have a table that looks like the following: |device_id | login_id | ----------------------- | 1 | NULL | | 2 | A | | 3 | A | | 4 ...
5
votes
2answers
550 views

Does SA account need to be called “SA” or can I rename it safely?

We have some applications on our network (from before my time) that use SA account in their SQL Server connection string. It's hard-coded in the source code, and for whatever reason, we can't change ...
4
votes
1answer
415 views

Best index for similarity function

So I have this table with 6.2 millions records and I have to perform search queries with similarity for one for the column. The queries can be: SELECT "lca_test".* FROM "lca_test" WHERE (...

15 30 50 per page