0
votes
0answers
5 views

Benchmark New NoSQL DB? Hyperdex, Aerospike, MonetDB

I would like to find the fastest database (preferably free) for some OLTP and a lot of OLAP. I reduced my canidates to two groups: a) MonetDB vs RocksDB vs Couchbase OR Redis -> for an in memory ...
1
vote
1answer
14 views

Postgres create an insert return rule

I am failing to create a rule which will return the insert's data. The table is: CREATE TABLE foo(a int, b text); My attempt for the rule is: CREATE RULE return_data AS ON INSERT TO foo DO ...
0
votes
0answers
23 views

RTF to HTML tags conversion

I have multiple RTF files to convert into HTML, do we have any mapping of tags so I can write a SQL Server function for this conversion?
3
votes
1answer
67 views

What is the minimum required compatibility level to use parallel SELECT INTO?

What is the minimum required compatibility level to use parallel SELECT INTO in SQL Server 2014?
0
votes
1answer
18 views

Is there a way to get an event when there's a change in a table?

Using Azure Sql Server, and in C# if that's relevant, is there a way to get an event when data in specific table changes? In one table we need an event if any column changes in a row. In a 2nd table ...
0
votes
0answers
7 views

How do I set up Azure Sql Server to have multiple instances?

We are setting up a new SAAS application on Azure and while we have used Azure before, not at this level of multiple apps, etc. We plan to have both a web app and a cloud app in both a US and EU ...
2
votes
1answer
20 views

is it possible to do a reverse pattern search in a database?

I have 2 database tables with rows containing strings. If I combine two strings, one from each table, as input I need to be able to find where the parts of the strings are located in each table. For ...
2
votes
0answers
8 views

Perl API for MongoDB (MongoDB::Async) does not have a callback argument?

I want to benchmark MongoDB with perl Async API. (MongoDB::Aysnc). but when I insert 70K times ASYNCHRONOUSLY in a loop, I just receive 30%-40% response against the queries from MongoDB. While MongoDB ...
0
votes
0answers
11 views

How to run ORACLE 12C EM?

I have installed and created a database in oracle 12c in ubuntu 14.04 . Now I can login to the CLI using sqlplus \ as sysdba and run sqlcommands , but I can't login to the EM from the web. The name ...
0
votes
1answer
13 views

where is the oracle 12c logfile?

I am getting all of the following error first ORA-12162: TNS:net service name is incorrectly specified when I export the ORACLE_SID , I get the following connected to an idle instance and I can ...
3
votes
4answers
190 views

Replace relational database with “poor” design in software product with non-relational DB?

Think of a software system you look at, based on classic, relational databases (SQL Server, Oracle), NHibernate as object-relational mapper (ORM), a business logic model layer on top and a huge number ...
0
votes
1answer
22 views

Using subqueries in delete query

I have a table candidate. It contains two columns name and roll. The values in all three rows of data are AA and 10. Now I want to delete only the second row. How can I do it?
0
votes
1answer
12 views

MySQL order of query

My query return like this. 12 14 14 99 78 78 54 I want result to be sorted so that no same number comes consecutively in the result. The result that I want is like this. 12 14 99 14 78 54 78
0
votes
1answer
6 views

How to check mysql password change and other events logs

Recently someone change my phpmyadmin password and drop database I think it was sql injecting. Now I want to find information about this like when, how and who change my password Please tell me ...
1
vote
1answer
23 views

Dynamic Number of Columns in Pivot Table

I have a table to store StudentID, SubjectID, ObtainedMarks. Now I have to create a pivot table to show studentID and obtainedMarks in different subject. Number of subject may differ. I could generate ...
-1
votes
0answers
34 views

Is there a list of best practices for Azure Sql Server?

I was talking with a Sql Server expert today and learned that Azure Sql Server can take up to a minute to respond to a query that normally takes a fraction of a second. This is one of those things ...
0
votes
1answer
7 views

The number of copies for each table stored in physical storage

I am new to Postgres and the database field. My question is that how many copies of each table are stored in physical storage device (memory, disk and so on)? I assume we need more than one copies for ...
2
votes
0answers
17 views

How to scale a multi table query with a large number of users in Postgres?

I see this as a compound of two related problems, but I might just be confusing things. I want to be able to do a multi table search, but over a large amount of rows. The number of rows being made ...
0
votes
1answer
12 views

Does the keyword NEW have the per-connection basis aspect to it?

I am watching a mysql table with an after insert trigger and i have started to receive many inserts.I am using NEW.message to get the last inserted message. Since i am receiving many inserts from ...
0
votes
1answer
15 views

What to monitor (key indicators) for MySQL server

I have installed Munin for monitoring my MySQL database server. It enabled a large amount of MySQL plugins out of the box. Since running these plugins can be CPU expensive I want to limit them to the ...
0
votes
1answer
16 views

Trying to load a file into a database on virtual machine

I have set up a Postgres db on a linux vm and have been having no issues using a GUI to connect to it. However, I am trying to load a large, 32GB, file onto it and so am skeptical of the old way I was ...
0
votes
1answer
18 views

Cannot connect with OLE DB

OLE DB connection... Can anyone suggest me on this. Authentication with windows security works in 2012-2005 "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False; ...
1
vote
0answers
23 views

Combining fields to make a unique record or keeping them separated

I've been asked to implement what has before, been a bunch of CSV files, into a MySQL database. I'm at a point in the design where all the schemas, tables and fields have been mocked-up; however I'm ...
0
votes
0answers
13 views

MySQL - Pivot-style (row -> column) results in subquery

SELECT j.departure, stopDepartures.* FROM journey j JOIN journey_day ON journey_day.journey = j.id JOIN service ON service.id = j.service JOIN pattern ON j.pattern = pattern.id JOIN ( SELECT ...
2
votes
2answers
46 views

Unexpected result from query based on old column value

I need to update a column and based on the old value, update a second column. After googling I came up with THIS (*nr 4) solution: copy the table to have the old value at hand. The table looks like ...
0
votes
0answers
5 views

Deploy Database to Windows Azure SQL Database show error in exporting database

When i try to deploy database to azure or export data tire application its successfully creating schema but it show error in exporting database
-2
votes
0answers
14 views

increasing Mysql DB Size and Server Size [on hold]

I have installed xampp on my windows machine, i'm using MySQL, How to increase the size of mysql server and databases in it? Kindly help me..! Thanks in advance...!!!?
0
votes
0answers
24 views

Password of the oracle user in oracle linux?

I am trying to install oracle 12c on my virtualbox oracle linux 6.5. I ran the command oracle-rdbms-server-12cR1-preinstall , which created a user oracle . But I can't seem to login to the user cause ...
0
votes
1answer
9 views

Apply settings to multiple output columns in SSIS flat file source

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to ...
0
votes
3answers
46 views

How to resolve stored procedure output parameter error?

Stored procedure displays the following error: Procedure or function 'getFavoriteList' expects parameter '@category_name', which was not supplied. The code: ALTER PROCEDURE ...
1
vote
1answer
26 views

MySQL keeps getting “connect” commands 100X per minute!

My server was having performance issues, things loading slow, pages not loading, etc so I ran the "top" command after logging in via SSH. I noticed the CPU kept jolting up to 40%, on and off, when ...
1
vote
2answers
36 views

Monthly report by time

I work in a parking company. We need a report of monthly vehicle exits by time. select hour(datetimeout) as 'dateout',count(*) from to_leaveveh where datetimeout between '2014-09-01' and ...
0
votes
0answers
17 views

How to load data from MySql to MS SQL Server database?

I have the similar schema in both MySQL and MSSQL Server database. How can I migrate data from MySql to an empty (no data) MSSqlServer database? MSSqlServer DB is empty with just the schema. I could ...
0
votes
1answer
22 views

composite index vs normal index

I need to index some tables and for that i found that there are different kinds of indexing. I am kind of clueless on their proper place of usage. Should i create index on all the fields that want ...
0
votes
0answers
9 views

How can I load csv data into mongodb and choose the types I'd like to have created for each column?

I'm looking for a way to load csv data in mongodb and specify the types that I'd like to have created for each column? I've been using mongoimport but I find it quite painful because there doesn't ...
3
votes
0answers
49 views

SQL Server cluster resource won't come online unless its on port 1433

The 2-node SQL Server 2008 R2 cluster works fine until one of the resources got removed. I successfully added it back. However, the cluster is not able to online the SQL Service unless it is on 1433 ...
-1
votes
1answer
25 views

How do I select data with a case statement and group by?

I'm trying to manipulate data a little by using a case statement but can't seem to figure it out. Stops -------------------- 1Stop 1-Stop 1 stop 1 Stop 1stop 1 Stop 2-Stop Im trying to come up ...
0
votes
2answers
68 views

Tsql Query speed slow due to Or within where clause, causing index scan instead of seek

I have been working on making this query work more efficiently. I found that the number of Ors within the where clause are the biggest problem within this query. This query sits in a stored ...
0
votes
1answer
21 views

Can you store PHP code in mysql database?

I'm creating a codex that will store example of functions and examples on how to use functions. Can I store this information in a database? Also, is there a proper way of displaying code on a page?
0
votes
1answer
17 views

dm_exec_query_stats in PostgreSQL

I recently started using PostgreSQL after using SQL Server for a while. Is there something like dm_exec_query_stats? I haven't been able to find anything other than logging every long running query. ...
0
votes
2answers
14 views

Update a date_modified MySQL Record Field ONLY when other fields have changed using CASE statement not working?

I have asked my question on Stackoverflow but have not really gotten any answers so I am trying over here now. I have the MySQL query that is ran in a PHP script below. What it does is Inserts a new ...
2
votes
1answer
23 views

convert string allow null col to int?

I want to convert string to int my string type [DT_WSTR] and my expression ISNULL(col) || TRIM(col) == "" ? (DT_I4)0 : (DT_I4)col I get this error [Derived Column [518]] Error: The conditional ...
0
votes
2answers
35 views

Change SQL Server backup destination while retaining server's knowledge of location

I currently have a number of SQL Server (2008 R2) databases that are receiving tlog and differential backups. The backups are currently being stored on a NAS that is going to be repurposed. I need to ...
0
votes
0answers
14 views

Best upgrade path for MySql 4.1 to 5.5?

Background Our production environment runs on a system that nobody wanted to update for a long period of time. With a new sherrif in town, we're going to update it. Production is MySql 4.1 with ...
0
votes
2answers
18 views

MySQL Count Rows with Two Cells the same

I have a db where the cells are height and width. (It's for banner ads) Some banners are the same width, but different height, or visa versa. for example: row1 hieght = 600 width = 120 row2 hieght = ...
2
votes
1answer
17 views

postgres: Database replica with some schemas writable

I have two computers. Computer A is dedicated to collecting data and storing it in its local database. Computer B is for analysis. A is running flat out just with the data collection, so I want to ...
0
votes
0answers
10 views

Couchbase - Get document creation date

Is there a way we can get a document's creation date in Couchbase (2.2.0). We are currently not storing creation date in our documents, so wanted to know if couch stores that as part of document ...
0
votes
1answer
30 views

How to add a linked server to a sql server management studio?

I have an account in sql server management studio, which I can login to database B, which is on server X. I also have a crystal report on my local PC. Using the crystal report, I can access a ...
1
vote
1answer
21 views

How to find non utf8 data in mysql

Ok so I have a mysql database containing data that is input from various customers. The customers are told that their data should only be encoded as utf8 however I have become aware that this is ...
2
votes
1answer
19 views

How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?

Let me state up front that I'm not proficient in Oracle at all, MS SQL yes but not Oracle; which is why I'm asking this. Current Setup Oracle 10g Release 1 running on Red Hat Ent. 3 (no support) ...

15 30 50 per page