0
votes
2answers
186 views

Storing data in PostgreSQL: One table or two?

I've just started using PostgreSQL 9.2 and my data consists of product prices at various points in time, usually a different price every month. Question: Because every product can have different ...
7
votes
2answers
2k views

Updating a table with more than 850 million rows of data

I have been tasked with writing an update query to update a table with more than 850 million rows of data. Here are the table structures: Source Tables : CREATE TABLE [dbo].[SourceTable1]( ...
1
vote
1answer
86 views

Does PostgreSQL work well as a workstation-based DBMS?

I've been considering PostgreSQL for an application I am writing in .NET WinForms, and the app is intended to be standalone with occasional sync-ing with a web service. I plan to use Sql Server for ...
2
votes
3answers
2k views

Getting 'specified network password is not correct' when trying to change password

After changing my network password, I went straight to the SQL Server Configuration Manager (SQL Server 2008) to update the passwords for the SQL Server and SQL Agent services. (Background info: the ...
7
votes
4answers
634 views

How to create a database for unknown kinds of data?

I am in the process of designing a database for a new PHP/MySql-based application. My problem is that I do not and cannot represent what should be saved in the database because it is unlimited and ...
3
votes
1answer
583 views

Simple MySQL query randomly takes forever

I'm having an issue on my server with a simple PHP send emails script that runs every minute via a cronjob. The script contains a MySQL query that runs very fast most of the time, but randomly will ...
2
votes
2answers
953 views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
2
votes
1answer
120 views

Mismatch between size computed from pg_buffercahce Vs shared_buffers in postgresql?

I have a rather naive question regarding the size of shared_buffers computed from pg_buffercache and the shared_buffers size mentioned in postgresql.conf. Based on my understanding pg_buffercache ...
0
votes
1answer
44 views

Misunderstanding statement in MySQL documentation

I can't understand this statement in Optimizing Data Size: Declare columns with identical information in different tables with identical data types, to speed up joins based on the corresponding ...
0
votes
1answer
673 views

How to fix filestream?

I have SQL Server 2008 R2, when I try to access any value stored in filestream I get the following error: Msg 233, Level 20, State 0, Line 0 A transport-level error has occurred when receiving ...
-3
votes
2answers
4k views

Creating an admin user in Oracle

How can I create a "root" (like on MySQL) in Oracle? I installed Oracle database on my system, for homework, for school (faculty) but it didn't give me the option to make a root user. Well at least I ...
1
vote
1answer
642 views

how to set a column to fetch the date now?

hi i have a sample table named datenow and used the following to create my table on flamerobin to have a column that gets the date today automatically when an entry is added. CREATE TABLE "DATENOW" ( ...
3
votes
1answer
637 views

Backing up file groups with restore to earlier backup

I have a task: I have created a database with a filegroup lamb that has a few tables. I need to extract a csv into a table in a filegroup named lamb and back up that filegroup. Then extract another ...
4
votes
1answer
1k views

What is a partitioned view?

What is a partitioned view? I googled but could not get a satisfactory result.
1
vote
2answers
307 views

How should I store multiple relationships (many posts to many categories)?

I have posts stored in a posts table and I want each post to have multiple categories, what is the most efficient way to store the categories and their relationships ? I thought of it this way first: ...
1
vote
1answer
336 views

Postgres: Given some parent id's how can I SELECT X child records for each?

In Postgres, if I have : Parent Table id, name 1, Parent1 2, Parent2 ..... 5, Parent5 Child Table id, parent_id, name 1, 1, Child1 2, 1, Child2 ..... 6, 2, Child6 ..... 25, 5, Child25 so 5 ...
1
vote
0answers
148 views

how can Audit All Login To SQL Server BY ODBC Connection

I MAke Report By Access Form On SQL database I make ODBC Connection For login To Update the data From Database Now I want Audit All logins To know who make Update today Or who make Update Now ? ...
1
vote
2answers
4k views

Is there a way to stop MySQL Replication on the master?

I want the master to stop replicating data to the slave. I know I can do that on the slave with STOP SLAVE;, but I wonder if there is a way to do it in the master. One possible solution might be to ...
1
vote
1answer
232 views

Switching to NoSQL for native JSON use?

I am rather comfortable writing concrete schemas with explicit primary keys, foreign keys, indexes, views and stored procedures. For queuing I use a NoSQL solution called: Redis. Recently I heard a ...
1
vote
1answer
144 views

Is there a way to recover this database (MySQL)

I did a "cold" (db offline, all filesystem files) backup of a MySQL db. I wrote the backup to an ISO image. Unfortunately Joliet filenames are not default. I didn't realize that until attempting to ...
0
votes
1answer
381 views

trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error [closed]

I am trying to execute a simple CREATE TABLE query on an oracle10g database using java. This is what I am doing: Connection conn = //create connection //open connection. No errors/warnings are ...
2
votes
1answer
124 views

how to build table relationships in a firebird database?

I am a beginner in Delphi and I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following ...
1
vote
0answers
36 views

parenthetic grouping of join clauses

What is the difference between these joins? a left join b left join c (a left join b) left join c a left join (b left join c) Does the grouping only affect the order of the joins? Will the query ...
2
votes
2answers
138 views

After moving a DB to a new disk, the log file isn't dumping data to the DB

I recently added a new disk to our SQL Server box and followed these steps from Microsoft to move the .mdf file to the new drive. I opted to leave the log file on the original disk for performance ...
1
vote
1answer
135 views

Database design: nested tagging

I have a situation that after an initial thought ended in the following tables: section: id, name section_tag: id, name section_tag_map: section_id, tag_id item: id, name ...
1
vote
3answers
148 views

Help with modeling this table

Thanks for reading my post...I'm new at setting up databases and am working on a simple practice app. I have a table called PhoneNumbers, which hold a list of phone numbers (duh). I have two other ...
0
votes
0answers
165 views

SSIS Data Flow Task Slows Down [closed]

I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it ...
1
vote
2answers
2k views

High Mysql Load , over 700% CPU

I had high mysql load on server linux 64 bit , 24 G.B ram , Intel(R) Core(TM) i7 CPU 950 @ 3.07GHz , Alot of quiers in sending data mode Here is mysql status ...
0
votes
2answers
65 views

Accessing Database without using SQL

This might be some ambiguous but I have not much info about this so I need some start point; As a general idea; in conventional RDBMS', there are a DB engine and storage of data. We use the language ...
1
vote
1answer
874 views

How do I specify a linked server to a remote database over tcp/ip?

I have a remote database running on an IAAS provider and I need to be able to execute joined queries from my local workstation. I am having trouble because when I attempt to create the link it is ...
2
votes
2answers
437 views

Creating sequence for longer numeric values

I need to create a database model that includes a field to store 20 digit unique values. Which will be used by many clients over an API. The value must be 20 digit long, numeric and unique. Best ...
0
votes
1answer
133 views

How do I stop a query from running if the row is locked?

I have a section of code that locks the database, updates it and then confirms. This is all working fine, if another user attempts to update the same row they cannot and their changes are discarded. ...
3
votes
3answers
812 views

Relational vs Non-Relational Database for Events Database

I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
0
votes
1answer
96 views

Accidentally Deleted SQL Server Log Reader Service Account [closed]

Uh, I accidentally deleted the Security Login in my SQL server that allows for the reading of log files. Now, I can no longer see any of the log files in my SQL Server Logs node of SMSS:( What ...
2
votes
2answers
203 views

PostgreSQL and default Schemas

Whenever I create a brand new database in PostgreSQL Maestro it creates the following list of default schemas: Now from my understanding Schemas are like folders for organization, etc. So the ...
1
vote
1answer
638 views

sql web-application Connection String for member of a domain group [closed]

In my testing environment, I have a local sql express (2008R) server instance. I've created a domain group and given it a login in the database. But now, how do I consctruct the connection string ...
4
votes
1answer
270 views

Accidentally turned down SQL memory too low to log in, how do I fix?

I turned down the Maximum Memory of the my SQL Server instance to 15 MB... Now I can't log in to increase it. How can I increase the maximum memory without logging in? Version is SQL 2008 R2
0
votes
3answers
356 views

Reasons for incremental backup on Progress OpenEdge

In the case that storage is not a problem: are there actually any good reasons for doing incremental backups instead of just doing full backups? Edit This could actually refer to any database with ...
5
votes
2answers
2k views

Why use separate databases for high traffic/volume tables?

While looking at the database structure of an application I am using I recognized that it uses 3 different databases on the same SQL Server instance for different things. The first one contains the ...
1
vote
2answers
291 views

Clustered vs Nonclustered Index

My database currently has a primary Key/Clustered index on the ID column for each table. However, the application that connects to the database is always looking at views defined as: SELECT * FROM ...
1
vote
1answer
199 views

IIS takes longer to run queries than SMSS

I'm completely stumped on this one. We're running a pretty usual intranet app here, classic ASP frontend and SQL Server 2005 backend. Occasionally, once/twice a week, a certain stored proc takes ~50x ...
2
votes
2answers
707 views

Tool to export data with all relational data?

Is there a tool to export data from selected rows in a table with all data stored in other tables in other tables linked by relational design? The purpose is to ease migrations of bits of data ...
6
votes
1answer
940 views

LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR

We have a process that generates an inventory report. On the client side, the process splits of a configurable number of worker threads to build a chunk of data for the report that corresponds to one ...
0
votes
0answers
80 views

In regards to GS1 barcode - what size DB field are used?

In regards to GS1 barcode - what size DB field is used or is the entire GS1 typically not stored in database, but rather processed in the application layer and stored in the database as a collection ...
2
votes
1answer
2k views

How Should I Configure Memory for Multiple Instances of SQL Server?

We have a set of SQL Server instances (2008 R2) that run on the same virtual server. Each instance represents a stage in our development cycle (Dev/Test/Stage/etc.). The instances all need to be ...
1
vote
3answers
3k views

SQLCMD command is not able to insert accents

I am trying to run sqlcmd.exe in order to setup a new database from command line. I am using SQL SERVER Express 2012 on Windows 7 64 bits. Here's the command I use: SQLCMD -S .\MSSQLSERVER08 -V 17 ...
2
votes
2answers
356 views

How can I automate copying DB2 table data between remote Servers?

I have two IBM DB2 servers at separate remote locations. I need to copy data from several tables on one database on the first server to another database in the second server. Previously I've used ...
3
votes
2answers
604 views

MySQL Full Text search increase relevance for exact matches?

I have a MySQL database of ~10,000 organisation names that I want to be able to search. I would like to use a full text search because this would enable me to find "institute of doobry" by searching ...
1
vote
1answer
1k views

Limiting user access to tables based on a ROLE

I have a SQL Server 2005 database to which I would like to LIMIT access. I have done the following: Created a database role called NO_HR Added the tables to this role under Securables that should be ...
2
votes
1answer
431 views

Replacing a PHP loop with a MySQL Query

I have a MySQL database table where I store a user_id and a hash each time someone logs in. The hash is stored in a persistant cookie so it doesn't change as users log in and out of the site. The ...

15 30 50 per page