2
votes
2answers
127 views

Do valid to/from columns on a fact table make sense?

I recently came across "valid from" and "valid to" columns on a fact table. Obviously this is common for dimensions but I've not seen them on fact tables before and can't find any info suggesting ...
0
votes
1answer
37 views

Understanding MongoDB Aggregation

Pretend that our collection has 1M document Now if i do aggregation like this: db.users.aggregate({ $group: { _id : "$gender", avgAge : { $avg : "$age" } } }) then how it ...
1
vote
2answers
335 views

SQL Server database backup to store only the last 7 backups in a file

I want to create a scheduled task that will run (every night) a SQL script to fully backup my database X to a file. I want that file to store up to 7 full backups. The way I tried doing this is using ...
0
votes
1answer
4k views

Connection problem different errors .net application

We have a SQL Server with some relational databases. We have another webserver with applications which communicate with the databases. We have an issue with one of our customers. We get some errors ...
0
votes
0answers
141 views

Strange SSIS-Package problem ( ASYNC_NETWORK_IO)

I've read a lot of posts here about this warning. Have been searching on the Internet, but not like this case. We are having problem with integration services packages. When I run the query (that ...
1
vote
1answer
58 views

Critical tablespace usage UNDOTBS (96%)

This tablespace is in my case 8GB. I'm on oracle 10g and got critical warning: Tablespace usage critical: UNDOTBS (96%) I also executed this command: select sum (bytes/1048576) MB FROM ...
0
votes
0answers
39 views

Challenged with modeling a big DB

I'm tasked to develop a gaming web application system with relatively large database - it should hold the data about 300 million players, the orders/payment of each player - ~3B records - , and other ...
4
votes
1answer
233 views

IO request time and less write latency

I am facing issues related to constantly growing log file due to which I am getting error. When I checked SQL Log I found below messages (error log is filled of these messages almost 90%) SQL ...
2
votes
0answers
123 views

Hiding server folders for specific user in SQL Server Management Studio [closed]

Is it possible to hide folders like Security/Server Objects/Replication/.. for a specific login? I have a user who now connects to the SQL Server and he can only see hes own database. This is fine but ...
0
votes
2answers
106 views

Selecting different values from different columns [closed]

I need a query to select different values from different columns as shown below: timestamp queues queuesname groupnumb 23-01-2014 FNG CGI ...
1
vote
1answer
288 views

Table with more than 100 columns

I have a table in my MySQL database which contains data about XRF analyses. There are about 50 chemical elements and for each element there are two values to be stored (Area and Count). Users need ...
0
votes
1answer
64 views

Database MySQL - Transpoing Table from one form to other

SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'MAX(IF(function_NAME = ', function_NAME, ',budget, NULL)) AS ', function_NAME)) INTO @sql FROM country_report dr ...
3
votes
1answer
688 views

Delete using a composite key

I am trying to wrap my head around creating a delete statement for a table with a composite key. I would like to create something like: DELETE FROM table_example1 WHERE COLUMN1, COLUMN2 ...
2
votes
1answer
189 views

Replace value using several criteria in another table

Brief illustration : If I want to replace a single string using multiple criteria from another table, I can use this statement : -- assume table_2 has column 'value' containing records such as 'd', ...
-3
votes
1answer
80 views

How to migrate a database from SQL server to Oracle? [closed]

I have been assigned a task to migrate a database from SQL server to Oracle. But I have no idea about how to do it. Also, is there any need to change the existing data model?
1
vote
1answer
92 views

Moving SQL Server 2012 Database to SQL Server 2008 R2

I follow the answer of Mr. Kin in this post How to move a database from SQL Server 2012 to SQL Server 2005 I run the query without errors, but when I check my blank database created on SQL Server ...
0
votes
0answers
463 views

Best way to run an ETL on a production MongoDB database

We have the following environment: 3 servers + 3 replica set servers Each server has 3 shards Our main collection has around 40,000,000 documents that average at around 6kb Our shard key is ...
0
votes
1answer
69 views

Access SQL Server Analysis Services Remotely for Data Mining Tool

I have SQL Server Enterprise trial in one computer. I want to use that the Analysis Sevices of that computer as a backend for using the data mining tool for excel in other computers. I was able to do ...
0
votes
1answer
113 views

I want to start the Postgres database

I run this: $ postgres -D foobar It just hangs. There is no error message. I newly created this database with the initdb command. What should I do?
1
vote
1answer
127 views

MySQL schema recovery

Is there a chance to recover overwritten schema or table in a schema? I have accidentally overwritten schema with the back-up from other source.
0
votes
0answers
41 views

How should deal with Game Database

I am new in Game development, and want to develop Playing Card game in android but i have no idea that how manage game database for different user (which are connected through Facebook) and their data ...
4
votes
2answers
384 views

Converting outer apply with Correlated subquery in SQL Server to SQLite

I need to convert a query in SQL Server to SQlite and I have replaced the outer apply to left outer join, but how to limit the subquery to return only 1 in this situation? And how to pass the ...
1
vote
1answer
108 views

Dealing with non active transaction in log file and shrinking

I have posted the first part of my question here & I don't want to flood my question with a loads of information and would force people to alter their answers for my each question. I think I am ...
1
vote
1answer
66 views

postgresql - granting schema to users

I have (2) postgresql databases. I basically used the same pg_dump export file to create the (2) db's on different machines. The DDL is the same, however, I am getting the no relations message on one ...
2
votes
2answers
752 views

new Neo4j install: “No authorization header supplied” even after editing config file

I just installed Neo4j today to play around on my Ubuntu EC2 instance, and I'm having two problems. First, the ubuntu install did not create a neo4j command so I'm not able to issue commands from the ...
2
votes
1answer
105 views

Number of SQL Server languages

As per MSDN There are currently ten SQL Server languages. The report server language for a given report server instance will always be one of the ten available languages. Support for all ten ...
1
vote
1answer
69 views

Cannot Create Backup Device - SQL Server 2008 R2, Error 1326 (permissions look ok)

Trying to create a backup device for a new db. I'm using management studio and just using the "New Backup Device..." wizard and giving UNC path to the backup directory. There is a pre-existing db on ...
0
votes
1answer
177 views

How could I improve my DB design?

I'm a second year software engineering major looking to create an iOS app that connects to a MySQL database (database not yet created) over the summer. I have a strong understanding of programming and ...
2
votes
0answers
49 views

How long does the final phase of an online index creation take?

In reading the whitepaper: Online Indexing Operations in SQL Server 2005 it says: The online index build process can be roughly divided into three phases: Preparation Build Final ...
0
votes
1answer
135 views

Intermittent “access denied” (1045) message from MySQL

I'm importing a fairly large (100GB+) database from MySQL to PostgreSQL using pgloader. After a seemingly random amount of time the process dies with the following error: An unhandled error condition ...
0
votes
1answer
230 views

Triggers on Insert or Update SQL Server (Spatial)

I am looking at creating a trigger on a live SQL Server spatial table that will update a column when a user either: Creates a new feature Updates the geometry of a feature in a GIS application ...
0
votes
1answer
529 views

Put Postgres query result in array

How can I put an sql query result in a string array with Postgres? I have some attributes in the column 'zone' of the table 'mytable' and I must put them all in a String[] areas; This is my first ...
1
vote
0answers
20 views

source control for SQL Agent Jobs

Our SQL Agent jobs execute different DTSX packages at various steps. e.g \DEVLserver\DTSX\package1.dtsx I want to keep the agent job script in TFS but when I promote it is there any way to change or ...
0
votes
0answers
472 views

Removing locks in Oracle without being admin

3 wild sessions each got a row exclusive lock in the same table: SELECT * FROM DBA_DML_LOCKS; How can I remove the lock without being admin? If I was admin I would list (SID, SERIAL#) of the ...
1
vote
0answers
137 views

Which major database platforms support TTL?

I need to store some data in a database that will be hosted on Amazon Web Services, and I have complete freedom over choosing which database platform to install, based on what I think will best suit ...
0
votes
1answer
142 views

Is it possible to set a timer for autovacuum in PostgreSQL

I am running PostgreSQL 9.4.1. I am currently cleaning up data, which requires me to run expensive queries. It seems like my tables get "locked" up every day at the same time in the afternoon. My ...
0
votes
2answers
663 views

SQL Server user cannot select from a table it just created?

I'm having trouble understanding permissions in SQL Server (in this case SQL Server 2012, but not sure how version-dependent this issue is). I can create a database, create a login/user on master, ...
0
votes
1answer
88 views

Overload resolution failed

I am using reporting services to generate a list of families in my database. After the first family member in the list, I want to put the family's address: family, First 123 la la lane Somewhere, Ca ...
0
votes
0answers
52 views

Smallest unique string among multiple columns

Somewhat similar to the Largest Common Substring (http://en.wikipedia.org/wiki/Longest_common_substring_problem) I'm trying to find the smallest unique string from a table. In some tables, its just ...
2
votes
1answer
415 views

Getting the count of same value in consecutive rows that are ordered by different field

I have a table with the following structure finals(ID, name, result) CREATE TABLE `finals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(10) DEFAULT NULL, `result` char(4) ...
2
votes
0answers
22 views

Listener.ora problem when I copy OVA

I deployed a new VM Oracle machine using a copy of my existing Oracle VM. As a result, the new VM inherited the same host name. This is redhat linux 6.5, Oracle11g. I changed hostname everywhere as ...
1
vote
1answer
709 views

Moving a date between tables is causing error ORA-01841 [closed]

Here's my script: INSERT INTO BRAND_RECORD SELECT STRENGTH, GENERIC_NAME, TO_DATE(a1.FIRST_CLAIM_DATE) as INTERCHANGEABILITY_DATE FROM DRUG_INFO INNER JOIN ( SELECT ...
3
votes
1answer
195 views

xp_cmdshell in a transaction

I need to run multiple scripts in a certain folder in a transaction and rollback if there are any errors. At this point I'm just trying to get the rollback to work without a try catch. Currently when ...
4
votes
1answer
1k views

How to atomically replace table data in PostgreSQL

I want to replace the entire contents of a table, without affecting any incoming SELECT statements during the process. The use case is to have a table which stores mailbox information that is ...
11
votes
1answer
191 views

How to optimize a query so that it seeks on one index first, and then another index after that

I have two sets of earth measurements from satellite data, each with time fields (mjd for mean julian date) and geography positions (GeoPoint, spacial) and I'm looking for coincidences between the two ...
0
votes
1answer
122 views

postgres fetch record from partitions without the check constraints

I am using postgres 9.4, I have a messages table that has 100M records, messages belongs to one feed_id, so I decided to partition the tables by posted_at. Table "public.messages" ...
0
votes
1answer
475 views

Issuing Inserts/Updates to Progress OpenEdge via ODBC

I'm attempting to build some ETL to integrate our SQL Server environment with a remotely hosted 3rd party app running Progress OpenEdge. I have a linked server to it set up in SQL Server 2014. ...
0
votes
1answer
53 views

Restore user db from UNC

I need to create a job that restores all user databases from UNC to my SQL Server. All the backups, for 3 days, are located in the same folder and I need to restore the last modified backup. What is ...
0
votes
1answer
49 views

improve database design for monitoring application

I need assistance with my DB design, I have a monitoring script that produce the following data every minute , and produce stats about virtual machine performance. Array ( [timestamp] => ...
0
votes
1answer
40 views

Updating across row and column in SQL

Bit of a strange question. Entries in this table have three relevant columns; drug, date_1, date_2, seq_id I am trying to make it such that every drug with the lowest seq_id has a date_2 equal to the ...

15 30 50 per page