1
vote
1answer
174 views

mysql replication missed quite a lot SQL statement

I have set up a master/slave with mysql-5.1.73 The master's binlog format is "statement". The master and slave seemed running very well with slave status: Slave_IO_Running: Yes ...
1
vote
1answer
66 views

Oracle DB client request process

Can any body please explain how Oracle DB handles the client request ? is it creates new user process for every connection to db ? I had look in oracle docs, seems there is concept 'Dedicated and ...
1
vote
1answer
962 views

MongoDB Keys and casting between types

This is more of a theoretical question: Let's say I have a collection of documents, my_collection: { "_id": ObjectId("52c679ac7a23e6225b62c51f"), "date": ISODate("2014-01-06T03:48:30.737Z") ...
1
vote
0answers
55 views

SQL Server 2008 upgrade and clean

After upgrading a SQL Server 2008 instance to SQL Server 2012 (in-place upgrade), there appears to be numerous 2008 instance components (namely the 2008 SSMS in start menu, in add/remove programs ...
18
votes
2answers
448 views

Is there a complete list of Online operations for each SQL Server version?

As we are about to change some of the large tables in our 5TB database I found myself needing a list of the operations that can be performed online and the which require full locks to be held while ...
0
votes
1answer
67 views

how to select rows matching a condition with a default

I have a table id | title | lng | vi_id -------------------------------------------------------- 1 | 'IX#001323' | 1 | 12 2 | 'IX#001323 heb' | ...
0
votes
1answer
59 views

why should use MongoDB [closed]

In which types of projects, MongoDB is the best suited? Can we use MongoDB in large applications? Why Open Source CMS and framework doesn't have support for MongoDB? How it is different than other ...
5
votes
2answers
890 views

Oracle partition by interval using persian calendar

Oracle supports Persian (Jalali) calendar in DDL queries, I can easily say: select to_char(register_date, 'YYYY-MM-DD', 'nls_calendar=persian') from my_table; I created a table as: create ...
9
votes
2answers
35k views

SQL server databases stuck in restoring state

I have a Sharepoint server. I guess our network administrator has miss configured his back up tool (I guess he uses Symantec backup exec) and now some of my databases are stuck in restoring state! ...
3
votes
2answers
3k views

Select every n-th row, don't pull the entire table

In light of the Meta discussion on allowing basic SQL questions on dba.SE I present an issue that I'm having now, for which the answer on Stack Overflow is inadequate and naive. I hope that there is a ...
0
votes
0answers
19 views

Junction table for peer entities and uniqueness for a link [duplicate]

In my database I have two tables: for peer entities (e.g. Persons) and for links between them (e.g. Friendship). Obviously, the latter table contains at least two references to the former table (e.g. ...
0
votes
1answer
2k views

Archival strategy for a table with 25 million records in SQL Server 2008 R2 Enterprise [duplicate]

I have a table that stores some audit information and currently has 25 million records. There is a process that inserts to this table every 30 minutes. This is historical data and is not used for any ...
0
votes
1answer
4k views

MYSQL - Problem with foreign keys on same table

In Mysql 5.5, I have a table, in which I store some informations about "events".. In order to have a chronological order, I made two columns that reference to the previous and to the next event. So I ...
3
votes
2answers
2k views

What can cause slow queries with low resource usage?

I am writing an application which builds a database on a SQL server. The application loads data into some staging tables, then executes a series of stored procedures which merge the staging tables ...
1
vote
1answer
1k views

PostGIS “could not open extension control file” when creating extension

I've followed the instructions here to install PostGIS http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt but when I went to create the extension I got the following error. I'm ...
0
votes
1answer
66 views

Simple yet multilingual flashcards - proper database design

I'm making a simple flashcards app for personal use. I've thought about having such table: CREATE TABLE flashcards ( translation VARCHAR(50), entry VARCHAR(50), lang ...
14
votes
3answers
753 views

Oracle is not using a unique index for a long key

I have a table with 250K rows in my test database. (There are a few hundred millions in production, we can observe the same issue there.) The table has an nvarchar2(50) string identifier, not null, ...
2
votes
3answers
1k views

how to dump MS-SQL DB using PHP with MS-SQL-SRV.? [closed]

I had created a MySQL database dump in php successfully using this below code. $dbuser='root'; $dbname='Student'; $dbtable='StudentDetails'; $dbhost='localhost'; $dbpass='root'; ...
2
votes
2answers
2k views

Master - Master replication Duplicate entry

I've got a Master - Master replication setup and it worked fine for a couple of days but I keep getting: Duplicate entry errors after a few days... My setup is as follow: One server in The ...
0
votes
1answer
73 views

Mysql query in Database

How to get all the tables from database with all values in tables using single query.. I tried using $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); $arrayCount = 0 while ($row = ...
7
votes
2answers
436 views

Where to start with Oracle?

This question only needs one answer: a list of great resources for getting started with Oracle, including Database Administration, PL/SQL and SQL. You may find your question has been closed as a ...
-1
votes
2answers
364 views

Mysql - Change name of Information_schema [closed]

I want to change the "Information_schema" database name to "some_thing_else". Is this possible? If so, how can I do so? As a developer knows about structure and a hacker also. How can we protect ...
1
vote
1answer
771 views

Package deployed in SSIS 2012 catalog fails with timeout error

I created an SSIS package in Visual Studio 2008 and deployed it to SQL Server 2012 by using Integration Services Catalogs. When I run the package from BIDS it completes successfully. When I schedule ...
0
votes
3answers
1k views

MongoDB doesnt start normally?

I want to start mongo on terminal but it gives connection error like: MongoDB shell version: 2.4.5 connecting to: test Sat Jan 4 10:18:16.779 JavaScript execution failed: Error: couldn't connect to ...
1
vote
1answer
120 views

How does this database design look?

This is my first official design after having read a coursebook in preparation for the upcoming semester. The goal is to have a user-based form creation/publication and submission web application. ...
2
votes
1answer
165 views

How to know if logreader agent already exists?

I'm creating a script to recreate a database for test purposes, and the database has some publications. In order to create or not the logreader agent I need to know if the current database already ...
0
votes
4answers
590 views

Can migration from MS Access to SQL Server or … make database faster? [closed]

A company asked me to migrate their database from MS Access to SQL Server or MySQL because they think that on those engines their database will run faster. But I wonder if their problem isn't because ...
0
votes
2answers
96 views

Why its failed on linux server?

I tried to mark disk and got Fail!!! [root@oradbserver3 Server]# /etc/init.d/oracleasm createdisk DISK1 /dev/sda2 Marking disk "DISK1" as an ASM disk: [FAILED]
0
votes
1answer
129 views

How can it take longer to replay a captured trace than to capture it

I am attempting to use trace captures to determine how much of a performance issue was database related and how much was code related. However, the trace is taking longer to replay that it took to ...
2
votes
1answer
786 views

How does MongoDB store data in RAM?

I'm trying to sift through the remains of an event that was causing us a lot troubles. Aside from report to management about what happened, I'm trying to gain a much better understanding of how this ...
2
votes
2answers
696 views

Speed up bulkinsert on sql server

We're doing some testing and this involves adding 10.000 rows every 10seconds in a table that has 4 int columns and one of them is clustered index. When we run the app the first bulkcopy takes around ...
2
votes
2answers
2k views

How to get all roles that a user is a member of (including inherited roles)?

Let's say I have two Postgresql database groups, "authors" and "editors", and two users, "maxwell" and "ernest". create role authors; create role editors; create user maxwell; create user ernest; ...
0
votes
1answer
232 views

databasename_indx.ndf file not referenced but can't delete

I have a SQL Server 2000 Express database for a legacy app I'm ditching soon. Until then, I'm at my 2 GB limit. According to sp_helpfile the database has one .mdf (900 MB) and one log file, but the ...
3
votes
1answer
53 views

Standard ways to return SQL Server database to a specific state

What are the most efficient ways to save the exact state of a SQL server database and then be able to bring it back to that state at will? I am testing code performance against a database and each ...
0
votes
1answer
330 views

Where does mysql write temporary tables?

MySQL 5.1.x | Windows Server 2008 Data Directory is on a different partition. I have an innodb database (innodb_file_per_table is set) that I'm trying to optimize and I don't appear to have enough ...
1
vote
1answer
1k views

How to get MySQL to iterate a subquery in an aggregate select?

Because the vocabulary describing what I'd like to do can be so disparate, I haven't had any luck figuring out why MySQL 5.6 is doing what it does. Consider the following two simple queries: #1 ...
1
vote
1answer
269 views

UUID in mysql database

I have a problem, I have two servers where I have to save my data. For persistent data I run mySql inno DB. I have a lot of entries, so I need fast (CRUD operations). For indexing I was thinking to ...
1
vote
1answer
507 views

Error installing Clustering with SQL Server 2012 on Windows Server 2012

We are installing SQL Server 2012 on Windows Server 2012 and trying to accomplish clustering. We've setup all the core functionality on the servers: advanced cluster preparation on all nodes and ...
0
votes
1answer
679 views

Why “.my.cnf” file is empty?

I want to edit some of InnoDB variables ,I go to the .my.cnf which is located in home/.my.cnf I found the file just empty. And when I check SHOW VARIABLES in MySQL it gives me all the variables and ...
0
votes
1answer
563 views

Get the job scripts out of a MSDB Backup [duplicate]

Long Story Short... my Database server died a month ago. I restored everything but the MSDB as the tape backup failed. I reconstructed some jobs but some essential ones are missing. I finally found ...
1
vote
4answers
121 views

Amount of data in a database table

I am trying to run an alter query on a table, and its giving me a Lost connection to MySQL server during query MySQL server has gone away. The query that I am running is alter table table_name ...
5
votes
1answer
3k views

Slow InnoDB INSERT/UPDATE/DELETE

Background A couple of weeks ago all of my INSERT's/UPDATE's/DELETE's became overall slow (not SELECT's). Before that, everything was normal (mysql statements executed in <0,01 seconds). Now a ...
0
votes
2answers
128 views

Big table size in PostgreSQL while number of rows is small

Tables' size in the PostgreSQL DB are big while the number of rows is relatively small (less then 500K rows). Vacuum of the specific table did not solve the problem. Only by deleting and importing the ...
2
votes
0answers
865 views

Postgres Case statement not return else value in this query

I'm creating a SQL query with a some nested queries and I'm trying to use the CASE statement but it is behaving weirdly. I've been at it for at least 6 hours without any luck... This is my query at ...
2
votes
1answer
243 views

Does creating View cause an overhead to DB?

As my subject suggests, I would like to know does creating views cause an overhead to DB in terms of space, storage, performance?
1
vote
1answer
44 views

Accessing Data after importing from file

I'm going to preface this with saying I'm a complete newbie at this database stuff before the rolling of the eyes happens, so please be patient with me. I have an sql dump that I am trying to import ...
1
vote
0answers
60 views

mysql vs mongodb cache/load balancing

I have a system where users can 'like' content. There will likely be many hundreds of these likes going on at once. I'd like it to be AJAX driven so you get an immediate response. At the moment I ...
0
votes
0answers
111 views

What are the steps to change tables engines from MyISAM to InnoDB?

I have a Datebase with 10MB size . The Tables' engines were MyISAM (table-lock level). So I deiced to change them to InnoDB (row-lock level). I used the sql query for each table : ALTER TABLE t ...
-1
votes
1answer
94 views

Oracle 11g database server password rollbacks

Hi everyone, I installed oracle 11g Database server in windows 2003 server. I changed the password. It works very well when I start at first. After restarting, the password is not at all ...
5
votes
2answers
435 views

Any relation between SQL Server Service Name and Instance Name?

My SQL Server's instance name is SQLEXPRESS and SQL Server Service Name looks like MSSQL$SQLEXPRESS. Is there any relation between instance name and service name? I'm trying to check SQL Server ...

15 30 50 per page