0
votes
1answer
45 views

Updating Document in MongoDB without Alphabetically order

I am making one project on MongoDB and inserted some documents and now i am updating the documents by this code.. bson_init( query ); bson_append_string(query, "First", "A"); ...
3
votes
2answers
10k views

RMAN list archivelogs that are needed for to recover specified backup

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed. Now, I want to determine what archivelogs should I backup to be sure that my ...
1
vote
1answer
2k views

UPDATE a column by COUNT of another table

It might be a naive question, but what is the difference of these two queries and which is preferred? UPDATE table1, (SELECT id,COUNT(*) idcount FROM table2 GROUP BY id) AS B SET table1.Freq = ...
1
vote
0answers
48 views

Turn xact_Abort on for specific applications or user

We have a 3rd party application that requires xact_abort to be turned on, however we have other applications that require it to be turned off. The service that requires it turned on always logs in ...
0
votes
1answer
724 views

Benefits of using Staging Database while designing Data Warehouse [closed]

I am in process of designing a Data Warehouse Architecture. While exploring various options to Extract data from Production and putting into Data Warehouse, I came across many articles which mainly ...
2
votes
2answers
67 views

Unexpected Results with File Restore

I am practicing a file restore using the AdventureWorks database and I am not getting the restore I am expecting. I am sure there's some embarrassingly simple cause, but I have not found it yet. Here ...
0
votes
2answers
1k views

PostgreSQL - pgAdmin error creating a server

I have the latest versions of PostgreSQL and its GUI-frontend, pgAdmin, installed. When I try to register a new server a fatal error appears when pgAdmin tries to connect to the newly created server - ...
1
vote
1answer
275 views

Tool for identifying stored procs with deprecated syntax?

I have to move a DB running in compatibility mode 80 (SQL Server 2000) on a SQL Server 2005 to a SQL Server 2012. How can I scan it for stored procedures that might break due to deprecated or ...
1
vote
1answer
79 views

Is an explicit KEY redundant if it is covered by a UNIQUE KEY?

I am auditing an application which I've been developing over the course of several weeks. I've noticed this in CREATE TABLE: UNIQUE KEY `baz_3` (`baz`,`foo`,`bar`), KEY `baz` (`baz`), Is the ...
3
votes
1answer
99 views

Should I align my SQL Server file and growth sizes with the block sizes on my SAN?

It was brought to my attention that our (Hitachi) SAN handles data in 42MB blocks. It is tiered storage so each block is evaluated when the director makes decisions as to when it should promote/demote ...
4
votes
0answers
296 views

Replace a materialized view in Postgres

I have a materialized view in Postgres 9.3 that I'd like to update with new columns. Other materialized views also depend upon this view, but the error message indicates that dropping a view isn't ...
2
votes
1answer
275 views

SQL Server 2005, non-yielding scheduler Spinloop on Snapshot

I was running dbWarden's procedure for CheckFiles on my server. The job never ended and my logs started to fill up with message at a rate of 1 per minute: 2014-01-07 08:40:04.07 Server Process 58:0:0 ...
1
vote
0answers
264 views

SSRS Remote Database Connection Issue

I have installed SSRS 2008 R2 on Windows 2012 server. It is up and running. In the Configuration Manager, I have set it to point to remote Database on same network. Then on my own PC (also on ...
0
votes
1answer
2k views

Inventory Management DB Design

*strong text*I am putting together a small inventory management system and have some questions concerning the database design. What I was planning on doing was to have 3 tables, items, bins and ...
1
vote
1answer
353 views

New users not working on MySQL 5.6 in Amazon RDS

I'm using the CREATE USER and GRANT commands as mentioned here http://dev.n0ise.net/2012/09/amazon-rds-mysql-add-additional-users-with-limited-previledges/ When I try to connect I get this in MySQL ...
2
votes
1answer
141 views

How can I compare the server impact of transaction replication

We are developing a system that must extract data from an existing SQL Server 2008 R2 cluster. One of our design goals is to limit the performance impact on that cluster as much as is practical. ...
0
votes
1answer
203 views

Is ANALYZE useful immediately after creating an InnoDB index?

Let's create a new index on an existing table: CREATE INDEX `IDX_some_index` ON `some_table` (`a_column`, `another_column`); Is this useful? ANALYZE TABLE `some_table`; Can anyone point to ...
0
votes
0answers
92 views

how to stop all Oracle instances [closed]

Is there any way to stop(or restart) all Oracle instances? I can't control my Oracle service called "OracleServiceOrcl" so I need to stop all running Oracle instances.
2
votes
2answers
623 views

What port is used by SQL Server to write backups to a remote server?

I have a SQL Server 2008 R2 Standard instance in a "DMZ", so that it can be client-facing. I am trying to have it write its backups to a central location that is within the network. The engineers ...
0
votes
1answer
3k views

Export a SQL Server 2000 database to Server 2012

I have a production environment running Windows Server 2000 and a development environment using SQL Server 2012. I need to make updates to the DB and implement some new features using .ASP. Is there ...
1
vote
2answers
294 views

How to interpret the information spit out by innochecksum?

MySQL is using up a lot of the disk space. Running du -sh on the data directory shows a humongous ibdata1 file (around 1.7 terabytes). I found a very helpful article online and ran a modified version ...
1
vote
0answers
2k views

Oracle 12c Enterprise Manager Database Express Subsequent Installation von Windows Server 2012

I have an Oracle 12c database instance which was installed without the option for configuring the "Enterprise Manager (EM) Database Express" How can i install it subsequent for a running instance? ...
2
votes
2answers
898 views

SQL Server Replication breaks up after doing DBCC CheckDB with Allow data loss on Primary

We have one way transactional replication enabled on SQL Server 2008 databases. Due to some issues we had to run DBCC checkDB, bringing the database to single user mode. When we complete the DBCC ...
0
votes
0answers
366 views

Execution time vary for the same query

I have a query which looks like this: select * from ORDERDOC, ORDERPOSITION where ORDERDOC.id = ORDERPOSITION.orderId --some other conditions; Execution plan looks like this: 0 SELECT ...
1
vote
1answer
89 views

Query result set

I've 1 query written in our legacy system. (using MySQL 5.5) Now, with growing data - the below mentioned query taking huge time. In our system, we've somewhat 2,000,000,000 (2 billion rows) approx ...
0
votes
1answer
1k views

how to reduce the size of the datafiles of a oracle DB?

we use a oracle db (11g release2) and the undo tablespase exists of two datafiles and requires 48 GB. But we just need this size for the boot and the import. Currently we just use 10 % from the ...
3
votes
1answer
237 views

SQL Server Backup and Restore Incrementally

I am investigating a reporting solution for a production database. We currently have a production db which backs up fully at 01:00 each day. This backup is then copied using a Robocopy job to a ...
0
votes
0answers
1k views

Incorrect definition of table mysql.event after migrating database to mariadb

I did a mysqldump to dump all databases into a .sql file, then installed a mariadb server. There are no errors after the installation. But after restoring the databases, I started to observe the ...
-1
votes
2answers
11k views

Converting varbinary data to varchar in SQL (Just like converting bytearray to string using Encoding.Default.GetString in c#)

I need an urgent help to fix some data conversion issue in SQL server 2008. I got some requirement change on storing the data. Without much care I converted existing varbinary data to varchar in SQL ...
1
vote
1answer
86 views

Locks in SQL Server - Update/Select

I am new to SQL Server and am not sure about how the locking mechanism works here. Please help Issue: Need to delete close to 5 mil records in a table. A website pulls data from that table quite ...
0
votes
0answers
205 views

Is it possible to auto generate ALTER scripts for differences between existing DB and updated schema?

I built a internal web application for a client that manages applications to programmes for their employees. The system is Classic ASP on a set of clustered and load balanced Windows 2000 Servers ...
0
votes
1answer
659 views

Oracle ASM Failgroup

The Oracle 11gR2 Automatic Storage Managament Administrator's Guide says: When Oracle ASM allocates an extent for a mirrored file, Oracle ASM allocates a primary copy and a mirror copy. Oracle ...
2
votes
1answer
1k views

How to call stored procedure inside trigger?

I have made stored procedure that will update product quantity as per product id. That works fine for me. Following is code : DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE ...
1
vote
2answers
316 views

Automatic Failover in Availability Group

I have 2 nodes in my SQL server fail over cluster. I use SQL Server 2012 Availability Groups for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
1
vote
0answers
1k views

SQL Server 2012: Login failed for user. Reason: Failed to open the database configured in the login object

Every so often, my SQL Server 2012 throws the following errors: Error (likely related to the one below): Source: spid99 The client was unable to reuse a session with SPID 99, which had been ...
0
votes
1answer
197 views

Problems using “Excel PostgreSQL Import, Export & Convert Software”

I want to export data from Postgresql, and I tried many ways then find the tutorial of Excel PostgreSQL Import, Export & Convert Software on Youtube. I installed the software, but I could not ...
2
votes
1answer
43 views

Improve Connectivity To MySQL Databases Using Multiple Ports

I have a Ubuntu server with multiple websites, each website connects to its own MySQL database - each of my sites have a number of users accessing/updating the MySQL databases. Currently all my ...
0
votes
2answers
104 views

Mysql Windows Issues

I've been having allot of issues with my mysql databases on Windows dying on me. About once a week or so it will refuse to work and I'll spend all night poking at it & a few computer restarts ...
2
votes
3answers
102 views

Is it better to start with a smaller INT types and grow as needed?

I am designing a new SQL Database for my ASP.net web application and I can foresee that some of the ID columns will get very large in the feature need INT and BIGINT but that will not be for a few ...
0
votes
0answers
9 views

Multiple requests shut down MySQL [duplicate]

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
0
votes
1answer
99 views

multiple requests shut down mysql

I have some problems with my mysql database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems. Every day at the ...
1
vote
0answers
88 views

How to set a 'real' field to accept an out-of-scale value?

I have an SQL Server database and one particular field that is a real. The program that feeds it was modified and is now sending a value too small to be considered a real. Is there a setting for ...
7
votes
2answers
1k views

Migrate heroku database to Amazon RDS with minimum downtime

I have a heroku postgres database and want to migrate it to Amazon RDS to save cost. What's a way to do so with minimum downtime? Usually this involves replicating database in real time and then ...
0
votes
2answers
58 views

Is it safe for me to switch from an 8GB server to a 4GB server? (Stats inside)

We are looking to cut some of our server costs and the only place I think it might be possible is our db server. We're currently running an 8GB rackspace cloud that houses a mysql instance and I ...
1
vote
1answer
135 views

MySQL DB dynamic ranking or “static” separately saved

I have a table where I store the points with the connected categories and game-types of each user. There are different ways to get points. However everytime when the points need to get displayed in a ...
1
vote
1answer
256 views

Hot Swapping Sql Server Databases

I manage a database in SQL Server for a business's customer transaction. The data is updated four times daily from a very complex Oracle database. The SQL Server database is then connected to by a ...
1
vote
0answers
162 views

Meta Database for a multi-tenant multi-shard environment

I’ve spent quite a bit of time researching sharding of a multi-tenant database (for a SAAS application). I wasn’t able to find much information on handling the Meta Database, containing connections ...
0
votes
1answer
869 views

My database keeps crashing on startup how can i repair it without it running?

I've got some problems with my database. I hope somebody can help me out. Problem: The database keeps crashing on startup. In my log i see a couple off these errors: [ERROR] /usr/libexec/mysqld: ...
2
votes
1answer
440 views

SQL Server connection fails over VPN

I have an OpenVPN network consisting of VPN server (Linux), client (win8) and SQL Server (win 2008 server, SQL Server 2005), I'm trying to (of course) connect client to server. When I try to connect ...
0
votes
1answer
65 views

Comparing Environments [closed]

I am a SQL Server dba. I have been asked to compare our production environment to test from a number of different perspectives. These are windows patch level,sql service pack, to database size and ...

15 30 50 per page