0
votes
0answers
4 views

Getting vacuumdb :invalid page header in block error while vacuuming

I am newbie to PostgreSQL and using version 9.2.Disk space for data folder is full causing DB to stop. When i am trying to perform a vacuum to reclaim space, i am getting below error. vacuumdb: ...
0
votes
0answers
6 views

How to synchronize java application products catalog with ERP

I'm having a point of sales with the following database tables: CREATE TABLE PRODUCTS ( ID VARCHAR NOT NULL, REFERENCE VARCHAR NOT NULL, CODE VARCHAR NOT NULL, CODETYPE VARCHAR, ...
0
votes
0answers
10 views

How to populate Oracle 10g tables related via foreign key?

As the title says, how do i fill random data in tables, which have foreign key references within each other. I want to then practice all the SQL commands, like, SELECT commands, JOINS, SET FUNCTIONS ...
0
votes
0answers
5 views

replication error Error Duplicate entry… for unique key

I have two database that one of them is replicated of another one,my tables have unique key on some column ( NOT primary key ),so if in replication process an Error Duplicate entry..... occur,these ...
1
vote
2answers
28 views

Need separate columns that calculate percentage

I have the following table: NAME Alex Bob Bob Tim Alex Roger I need to produce the following: Name Count Percentage Alex 2 33% Bob 2 33% Roger 1 16.6% Tim 1 ...
0
votes
1answer
32 views

Pivot table with MySQL

I'm trying to create a pivot table like output (cross table? Not entirely sure about the difference). The idea is to have rows, columns and summary values (specifically: distinct count). The data ...
1
vote
0answers
30 views

Low batch Batchrequests/sec

I am running this query to do massive deletion in my database. I am looking at Batchrequests/sec and it is quite low (like 15% of what my server can handle) Is there any way to rewrite this query to ...
0
votes
0answers
7 views

Will deletion of an RDS db snapshot affect the running instance?

Will deletion of an rds db snapshot affect the running instance? (I assume not but I'm being a bit paranoid since it's an extremely important customer db.)
0
votes
0answers
5 views

PHP error log naming by date

Running MySQL 5.5.1 on Server 2008 R2 Currently using the following directive in php.ini error_log = C:\path\${COMPUTERNAME}.log, that works fine. Does anyone know of a similar variable I can use ...
5
votes
2answers
348 views

Is there any difference at all between NUMERIC and DECIMAL?

I know that the NUMERIC and DECIMAL data types in SQL Server work the same: the syntax for creating them is the same, the ranges of values you can store in them is the same, etc. However, the MSDN ...
1
vote
0answers
24 views

MySQL CPU & Memory Spikes

Every couple of days, my server's CPU and memory usage spikes up to 100%, making our vBulletin forum almost unusable for 5-10 minutes. CPU is typically at 1-2, Memory at 3GB. During the spikes, CPU ...
0
votes
0answers
19 views

Login failed for user 'x'. Reason: Could not find a login matching the name provided

I get this error Login failed for user '****'. Reason: Could not find a login matching the name provided. [CLIENT: 10.4.3.5] Right around 3 AM ish but the application connecting to sql server ...
3
votes
1answer
50 views

Row size error with MySQL

I'm running a MySQL server on my Macbook (for testing). Version is 5.6.20 from Homebrew. I started running into "Row size too large" errors, and I've been able to reduce it down to this test case. ...
0
votes
0answers
3 views

How to determine database read/write ratio on MongoDB MMS?

By looking at MongoDB MMS charts, is there a way to calculate a database read/write ratio, or roughly determine whether a database is read-heavy or write-heavy? Assume I do not have contact with ...
1
vote
1answer
18 views

What does it mean? ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Q 1: Whenever an Oracle SP wants to return error code/message, it fails returning below exeption: OLE DB provider "OraOLEDB.Oracle" for linked server "ORASRV" returned message "ORA-06502: PL/SQL: ...
4
votes
1answer
112 views

How to display rows that are missing from aggregations?

I create a view to display ValueRange like this: ... ValueRange=case when Value1>60 and Value1<=65 then '60-65' when Value1>65 and Value1<=70 then '65-70' ...
0
votes
2answers
27 views

Management Studio System.OutOfMemoryException

I'm using Microsoft SQL Server 2012 and trying to run a simple query against it within Management Studio. I'm getting the following error: An error occurred while executing batch. Error message ...
0
votes
0answers
27 views

Modeling global and private parameters

I'm trying to model a database that will be used for management and execution of SSIS packages. The entities are Client, Job and Package. A Job is the managed unit that references Client and Package. ...
0
votes
2answers
27 views

calculating max and joining tables

Just need a little help as new to SQL. I have a table which contains readingtime (records every 4 seconds during the day) and an energy reading. I wanted to know how much energy was used in a day. ...
0
votes
2answers
43 views

Log File Size near 100% - How to find Active Transaction [duplicate]

The transaction log file size is nearing 100% on one database. I run the below and both return 0 so no active transaction running. The last query tells me that the database is in SIMPLE mode, but ...
-1
votes
2answers
21 views

How to convert time to minutes in Mysql

I want to change the time to minutes and update the table and insert the value in the field minutes Id time minutes 1 01:00 ? 2 00:44 ? 3 01:13 ? ...
0
votes
0answers
30 views

Storing Configuration for bespoke maintenance plans

I got fed up with creating maintenance plans on several SQL servers. So I've devised a script that generate a series of SQL Agent Jobs (with notifications) that utilises Ola Hallengren's SQL Server ...
0
votes
0answers
7 views

Neo4j vs MongoDB (pros and cons)

I am working on a design of a system in which I need to maintain relationship between various kinds of real world entities and also have to handle documents(can have one or more attachments with 1 ...
0
votes
0answers
8 views

Error while inserting values in array in Postgresql

I am writing a Postgresql function that saves some Ids information into the array and later on processing them one by one. I am new to postgresql and finding some difficulties to work with arrays ...
0
votes
2answers
33 views

How to store user's language knowledge (150+ languages) in mysql DB

Users in my website must be able to select languages they know (English, German, etc), so I have a table languages with 150 languages (id, name) and table users (id and a lot of other fields). ...
0
votes
0answers
28 views

Slow mysql UPDATE with IF() conditions

not sure why I can't even EXPLAIN this query. Mysql refuses to EXPLAIN it. Table contains a million meaningless test entries. Full schema and data dump of the table available here: ...
2
votes
1answer
31 views

Is data warehouse monitoring same as database monitoring?

I have a requirement, where data warehouse population is to be monitored. I am in confusion, and needed a clear picture. Is data warehouse different than database? eg. For monitoring database we ...
0
votes
0answers
11 views

Optimal Database Configuration

We have developed a Multilingual website based on Drupal platform. I want to know the optimal configuration for MYSQL database (an possibly server hardware) if we were to expect 50,000 hits per hour ...
0
votes
1answer
39 views

Simplest way to edit single entry in XML column?

As I understand MS SQL Server Management Studio doesn't allow directly editing/replacing entries in XML columns via GUI (copy/paste doesn't work etc.). What is the easiest option to replace a single ...
1
vote
0answers
16 views

Mysql syntax error when i add on completion preserve

I have written this event in mysql DELIMITER $$ CREATE EVENT le_drop_database ON SCHEDULE EVERY 1 WEEK ON COMPLETION PRESERVE STARTS CURRENT_DATE + INTERVAL 4 - ...
1
vote
1answer
10 views

Import multiple CSV fields into one MySQL field

I'm trying to import our CSV data log into our MySQL. The first two fields of the CSV are Date and Time, and I would like to combine that into one date time (which can be searched) onto MySQL. CSV: ...
0
votes
1answer
25 views

How can I automatically add a foreign key to a table on select which is stored in an associated other?

I have a database with some tables among wich these 3 : organizations organization_id PK teams team_id PK team_organization_id FK users user_id PK teams_users tu_id PK ...
0
votes
0answers
9 views

Mongodb x509 certificate for client and cluster member

I am newbie to mongodb, i understood the concepts and architecture in mongodb document. I would like to setup (1) mongodb server and cluster members (2) x509 SSL security for the server, client ...
1
vote
3answers
107 views

Can I use PHP function strtotime() in SQL queries?

I have this table, and I need to use a PHP function in the query. id time lastTime 1 08:02 2 08:04 3 08:30 I am using this query with the strtotime(), and it's not working: ...
1
vote
3answers
45 views

Removing chat history for a particular user from database

I'm currently developing a web chat application using SignleR and SQL server this is my database schema so far I've added an option where the user can Clear Chat history for a particular ...
0
votes
0answers
30 views

Oracle 11 table design for better performance for reports?

We have a requirement to design a report page. A few factors we have are: number of fields in report is 70 computed fields is going to around 14*8 (based on toggles) a filter is going to have ...
0
votes
1answer
19 views

Update table inner join

I have two tables and i need to update one of them with respect to the id's of the second table first table success log Id pid shiftid 1 2 2 2 3 2 ...
0
votes
1answer
27 views

Simple Query optimization using ORDER BY

The following is a simple query that is taking more than 10 seconds to execute: select * from inventory.asset ass where ass.product_id=83 and ass.expiry_date > now() and ass.status=1 order by ...
-2
votes
0answers
25 views

Database Timeout expiring when tables fill up

Once my database starts to fill up with the tables being used, my stored procedures are taking longer to execute. If I truncate the data and execute again, execution time usually takes 3 minutes. Once ...
0
votes
1answer
21 views

Best open source DB technology to store and query large, sparse matrices [on hold]

I have a large vector space model, in which each point is a multi-variate observation. In other words, I have a large number of pretty large records, mostly of ints and floats. I started with ...
1
vote
1answer
35 views

PostGIS vs. SQL Server for GIS data

So I'm recently starting at a new company and have a lot of ArcGIS users who seem really keen on going forwards with a PostGIS instance to serve some data to our customers. While I don't have an issue ...
0
votes
1answer
33 views

Translating MySQL query to PostgreSQL

I have a query which works fine in MySQL, however when I try to recreate the same query in PostgreSQL (same DB structure) I just get a syntax error. MySQL: SELECT ticket.queue_id, queue.name, ...
0
votes
1answer
21 views

Pivoting some row data into columns (SQL Server 2008 R2)

Sorry if this has been answered before but I'm exhausted and on a time line. Maybe I'm just an idiot. I'm designing a data export from One application to import into another. Full-Disclosure: I did ...
1
vote
1answer
20 views

Am I using the correct data types on SQL Server side to call an Oracle 10g function?

When calling an Oracle function with the following in parameter types NUMBER(7,0) VARCHAR2(8 BYTE) VARCHAR2(4 BYTE) DATE and return type NUMBER(14,5) from SQL Server 2008R2 via a linked Oracle ...
1
vote
1answer
38 views

Query hint? for deduplicated CTE in Merge

Referring to this link: Optimizing MERGE Statement Performance The following criteria are given for ideal performance: Create an index on the join columns in the source table that is unique and ...
0
votes
0answers
33 views

How I can monitor SQL Server 2012 databases to determine the security privileges that are called by different processes

Is there any tool that can identify the SQL privileges or roles that are being called on query by query basis. We need to know which ones are being used at each time on a Microsoft SQL Server 2012.
-1
votes
1answer
23 views

aggregate type problem [on hold]

i have that procedure : Create PROCEDURE [dbo].[spMerrShenimetBazePerPagese] @PunetoriId int AS Select p.PunetoriId, p.Emri, p.Mbiemri,p.Vendlindja,pg.Muaji, Sum(p.Paga) as Paga, Sum(pg.Bonusi) ...
0
votes
0answers
26 views

What is the difference between Row and Table Expressions in MySQL

Can anybody explain with example what is a Row and Table expression and what is the difference between them. Any example for clarification will be appreciated.
0
votes
1answer
52 views

Is normalization advisable on transactional data?

I have read a lot of articles about normalized vs denormalized schemas, but I find very little mention of the cost of row insertion. I am considering the impact of converting a 100% denormalized ...
-2
votes
0answers
32 views

What track should i study towards? Oracle 11g, Oracle 10g or Oracle 12c [on hold]

i am in the process switching careers, i am really interested in databases due to me doing php dev part time. Ive researched the different types of db's, and have decided to go the oracle route, but ...

15 30 50 per page