0
votes
0answers
11 views

SQLITE table joining with group

MESSAGE TABLE USERS msg_id | msg_to | msg_from | msg_body | msg_date user_id | user_name 1 1 2 hi 22/1/14 ...
0
votes
0answers
9 views

(libmysql): (filename not available): mysql_query

Hi everybody im running a game server connected to mysql and it crashes only because of mysql connection with the error in title.. when i dont use mysql and save data as files on harddrive it dont ...
0
votes
1answer
9 views

Postgresql Full Text Search sequence of strings

What I'm trying to do is that i have a bunch of html documents in which I need to search for certain groups of strings. I did build a ts_vector for all htmls but I seem not be able to find out if it ...
0
votes
0answers
7 views

DB2 running terribly slow on virtualized system for no apparent reason

Background infos: We are developing a RESTful service (for intranet usage only) using solely PHP 5.3 and IBM DB2 9.7 (Express). The Webserver is a Microsoft IIS 7 running under Windows 7 Embedded on a ...
0
votes
1answer
20 views

Issues with procedures, setting multiple values

I am trying to set multiple values but I am only able to set one value. This code fails: alter procedure modifyvalue @ID int, @flight varchar(6), @destination char(10) as begin update ...
0
votes
0answers
6 views

MySql full text query with truncate sign strange behaviour

I'm implementing a search mechanism on a customer site. I need to find products with "full-text" matching description. However, I noticed a strange behavior. Taking for example two records: (A) ...
2
votes
1answer
85 views

Is there any performance difference in using a unique index on primary key?

I know there are lost of similar questions to this one, but none that really answers this: Is there ANY difference in performance in using an unique index in a primary key, using a MyISAM table on a ...
1
vote
0answers
34 views

DBCC CHECKDB reports torn page. How do I find what is in the torn page?

Using SQL Server 2005 I get the following error when running DBCC CHECKDB SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual ...
1
vote
4answers
27 views

Make a Copy of a Microsoft SQL Server 2005 database from a Mirror Copy

I have a SQL mirror database in Microsoft SQL Server 2005. I would like to get a copy of it as a new database so I have the ability to read, write, and backup the database. I cannot break the ...
2
votes
2answers
34 views

How do you update a large MySQL table that's on a server?

I have an application on a web server. The PHP front end for the application queries a MySQL database which has a table that contains 60 million taken domain names. My application queries this ...
0
votes
0answers
8 views

Best way to setup postgresql load balancing and failover?

Ok so I know that my db is going to be postgres and I want to ensure that it is able to handle read/write queries in the future (instant messaging application so lots of small writes and a lot more ...
6
votes
0answers
54 views

Lower performance on newest servers

We have several db servers on production, 4 of them with very similar hardware configuration. Dell PowerEdge R620, only difference is that 2 newest ones (bought and configured 3 months ago) have RAID ...
0
votes
0answers
10 views

Connect Oracle database using AD account via OID

We have configured Oracle Internet Directory. We have integrated OID with AD. We have also registered Oracle database with OID. And we are now trying to configure authentication to the database with ...
1
vote
3answers
45 views

Best approach for Legal/Natural can have many Orders

I'm working on this model: where as you may see one NaturalPerson can have many Order and the same for LegalPerson the only difference between NaturalPerson and LegalPerson are a few so in that ...
1
vote
1answer
74 views

Schema unusable after deleting another database

I just get a problem with a customer's SQLServer. I'm reading articles related to schema, owners and permissions, but I can't get it out. I have two DB : DB1 and DB2. I have a schema, which has the ...
0
votes
0answers
32 views

Adding foreign key to MySQL does nothing

I have two systems: a dev system and a production system. On the dev system, I added a foreign key to a table using this statement, which has been created by phpMyAdmin: ALTER TABLE ...
0
votes
0answers
15 views

Implementing a functionality for processing heavy insertion

I use PostgreSQL 9.1 The scenario is: I receive heavy insertion into Table1 (about 100 rows a sec). For each new entry, I have to check it with the previous and next ones (check if those items are ...
2
votes
0answers
16 views

In Postgres, how to get a list of current defined savepoint?

I'm using postgres SAVEPOINT which create a new savepoint within the current transaction, and would like to display the list of currently defined savepoint in a connection. To be more precise: I'd ...
1
vote
3answers
68 views

Insert Missing Dates from a query

How can i insert missing dates from a query i created. The result below: Date Frequency 2014-05-18 5 2014-05-20 7 2014-05-25 7 2014-05-27 6 I want the result to have missing ...
1
vote
0answers
17 views

Database Migration with Liquibase using different DBMS

Our customer is using Oracle and we want to use MySQL for development. Therefore our MySQL Scheme has to be in sync with Oracle. I tried to use Liquibase, but I get problems at the time of applying a ...
0
votes
1answer
7 views

Use index intersection feature in mongo 2.6 to compound shard key

I am having three indexes like name,age,salary. I can use them as compound index as per 2.6 (name and age together). But can i use the same indexes as compound shard key like name and age. i also have ...
1
vote
0answers
38 views

SQLIO and its Flags

Any feedback on this will be highly appreciated. -t flag(Threads) – If I capture worker thread information using this query ‘SELECT SUM(current_workers_count) as [Current worker thread] FROM ...
-2
votes
0answers
20 views

Mysql .sql file taking more than 24 hrs to import, is there any solution for that? [on hold]

Mysql .sql file taking more than 24 hrs to import, is there any solution for that ?
0
votes
2answers
59 views

Find the closest bar, when searching for a drink

Problem: Find the closest bar that serves the drink(s) I'm looking for. Here you can find the generated MySQL code http://pastebin.com/5Uc2ewUW The API Request that interacts with this problem ...
1
vote
1answer
129 views

View the order of triggers firing

We have 2 SQL Server 2008 environments with some triggers against a table containing business logic Within the 2 environments, we can see that the triggers are firing in a different order (thanks to ...
0
votes
0answers
9 views

Lower resolution of record on MySQL

The database I'm currently working on logs about 50 columns of data per second on our plant. The current high frequency logging is due to ongoing test. However, going long term, this would not be ...
0
votes
1answer
22 views

Accessing Master database data into my database table

my database name LCMC i put a trigger on one table on update. and i want to insert the last 15 executed queries into a table. last executed queries are in the MASTER database as SELECT top(15) ...
0
votes
0answers
24 views

How to increase sql server performance? denormalization (making cascade delete off) vs making duplicate data

I have a database with following related table ( sql server enterptise edtion 2014) each state have many citites which each city has may municpalArea and so on State => Cities = > ...
0
votes
1answer
21 views

MySQL replication - slave hangs during ALTER table or BULK update - v5.1.71

We are facing the above mention issue. In this case if we try to STOP SLAVE then it hangs and we even can to restart DB. As I search in google for the same it looks like a bug. Id 38205 in V5.1. My ...
0
votes
0answers
9 views

How to ensure that another schema in available from the schema the webapp is connected to?

In an existing webapp and database architecture, the application connects to a MySQL instance where several schemas reside, beside the application schema; let's call it app_db. During certain ...
1
vote
1answer
52 views

SQL Server 2008 R2 on production — is it worth to upgrade to SP1/SP2

One of my company's mission-critical database is running SQL Server 2008 R2. SELECT serverproperty('ProductVersion') returns 10.50.1600.1. So, yeah, RTM. Now, long story short, this database is not ...
1
vote
2answers
26 views

show table name + number of records for each table in a mysql innodb database

How to list all tables in the current database, together the number of rows of the table. In other words, can you think of a query to come up with something like this in mysql? ...
-1
votes
1answer
84 views

Inserting data based on different conditons

Table T1 : Name Unique_ID Rollno. Type -------------------------------------------------------- paul ty001A JU00011 Junior paul ty001A ...
0
votes
0answers
25 views

Reset password for 'postgres' on v9.3 (Win Srv)

I'm trying to reset the password of the user 'postgres' on a postgres 9.3 installation, but have been unable to do so... I've tried every combination in pg_hba.conf I could find online (ex. 'host all ...
-3
votes
0answers
18 views

figure reports all are changed and not modifying [on hold]

Hi all dear I am facing some very critical things into my database figures and finly reports or coming wrong is there any kindful person will want to help me that some one changes it through query and ...
1
vote
1answer
65 views

Best way to add Foreign Key to massive table?

Say I have 4 tables: arrival (~100 million rows), departure (~100 million rows), airport (~30 million rows), airplane (small). arrival and departure each have 2 ForeignKeys: one to airport, one to ...
0
votes
0answers
12 views

PostgreSQL replication with periodic log shipping

I'm using Windows Server 2008 R2 with 64-bit PostgreSQL 9.2 on both test machines. What I wish to achieve is that one server will be a master and other will be a slave. This is just for tests, finally ...
9
votes
2answers
58 views

MySQL instance stalling - due to InnoDB log flushes?

An instance of MySQL 5.6.20 running (mostly just) a database with InnoDB tables is exhibiting occasional stalls for all update operations for the duration of 1-4 minutes with all INSERT, UPDATE and ...
0
votes
0answers
24 views

How to Create Oracle Connection to Navicat [on hold]

How I can Create Connection Navicat to Oracle 11g expres edition
-2
votes
1answer
42 views

SQL statement that return Component in each Order [on hold]

I have a product detail table that contain the component used in each product Product | Component ---------------------- Product1 | A Product2 | A Product3 | B Product1 | C Product2 | B ...
0
votes
1answer
21 views

InnoDB compression: memory usage

InnoDB offers table compression for Barracuda-type tables and the recommendation seems to be to "adjust" buffer_pool_size. The documentation is rather vague about the definite impact of compression on ...
0
votes
0answers
23 views

Calculating a running balance to store with transactions

I need to put a read-only copy of balance and transaction data from a legacy system, which will only be used to view/print statements. Balance | id | member_id | product_id | balance | | 1 | ...
0
votes
1answer
38 views

How to group uninterrupted squences and get min max?

I have table where I am storing some sequential data that indicate occurrences of some event given day. id from_id to_id date 1 2 1 2014-08-01 2 2 ...
0
votes
2answers
36 views

#1093 - You can't specify target table 'R' for update in FROM clause

As an attempt to answer Difference data between adjacent rows UPDATE Visits R SET Duration = TIMEDIFF( ( SELECT ReqTime FROM Visits N WHERE N.ID > R.ID AND N.Session=R.Session ORDER BY ID ...
1
vote
0answers
28 views

Sql Server 2012 Change Data Capture weird behaviour

In my Sql Server 2012 I have the following table in a database CREATE TABLE [dbo].[HumanResource]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NOT NULL, [IsHired] [bit] ...
0
votes
3answers
24 views

Column Concatenation

Is it possible to concatenate the rows from two/more different columns into one new column ? Example: C1 C2 C3 ---- + ---- => ---- a d a b e b c f c ...
1
vote
0answers
40 views

“Force Encryption” vs “Force Protocol Encryption” in SQL Server

I'm trying to understand how the different settings affect the behaviour of my server-client communication. On the server I have installed a self-signed CA with an issued exchange cert which also has ...
0
votes
0answers
12 views

About JD Edword EnterpriseOne installation

I have installed all the things required for JD Edward Enterprise One. JD Edward installs but when click on Enterprise One Menu, the web Server is not started showing error 'could not found web ...
0
votes
0answers
42 views

SQL Server 2008 R2 backup fails to restore on SQL Server 2008 R2 SP2

My DR SQL Server got automatically updated by Windows update from 2008 R2 to 2008 R2 SP2 and since then I can't restore backups from my production machine which is still on 2008 R2. 10 percent ...
1
vote
1answer
15 views

Using file .log.3.gz

I have a file which I need to look at for errors, I got it from someone its extension is mysql.log.3.gz and when I uncompressed it, it has mysql.log.3, It is a log file? And if I open it in text ...

15 30 50 per page