1
vote
2answers
604 views

Restoring SQL Server databases - tips and tricks?

Anyone have any tips and tricks when it comes to restoring SQL Server databases? I recently restored a .bak from one server/instance to another, using SQL Server 2005 on both, and have run into the ...
7
votes
1answer
4k views

What is the “Chaos” Isolation level and when should it be used?

ADO.NET documentation shows the possibility of setting the transaction level for a SQL transaction to Chaos. It sounds unpleasant, but if the feature is there, presumably it has some legitimate use. ...
2
votes
4answers
1k views

SQL Server 2008 transaction log growing since SP3 Installed

On our production db (~117gb) we quite a few tables being replicated. Historically our maintenance plan has kept the transaction log fairly small. Since we installed SP3, the transaction log is ...
6
votes
2answers
2k views

Why does MyISAM support FULLTEXT Searching and InnoDB does not?

I know the basic differences between the MyISAM and InnoDB engines. In MySQL 5.6 beta, InnoDB will support fulltext search. But, I wonder why previous versions of InnobDB didn't support FTS? My guess ...
5
votes
1answer
106 views

Possible pitfalls of condensing 2 SQL Server instances into 1

I currently have 2 SQL Server 2000 database instances (each running on a different physical server), each containing around 12 databases (not all are active). We are planning an upgrade to SQL Server ...
3
votes
1answer
1k views

MySQL 5.5 InnoDB = OFF?

We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine. However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF ...
3
votes
1answer
786 views

Webapp & MySQL: Row Level Security

I am trying to emulate row level security on a webapp I am developing using MySQL. Using this method: Creating a database with the the required tables where the data pertaining to all the users will ...
10
votes
2answers
15k views

SQL Server commands to clear caches before running a performance comparison

When comparing the execution time of two different queries, it's important to clear the cache to make sure that the execution of the first query does not alter the performance of the second. In a ...
1
vote
2answers
151 views

MySQL Records Turnover: How to do it?

I have a table of villas ordered by the UID as follow : UID, name, random_order: 4, villaA, 12 8, villaB, 5 9, villaC, 9 11, villaD, 2 I want to show my villas according to the random_order ...
2
votes
2answers
145 views

Want to know details and meaning about the trace of SQL Server

I referred to this article: sp_trace_setevent (Transact-SQL). And trace my SQL Server on production machine for months. EventId of most of the traces were: 10,12,14,17 The MSDN says: 10 ...
7
votes
3answers
2k views

Is there an Open Source Metadata Management Solution? [closed]

Is there an Open Source Metadata Management Solution? I'd like to create a Metadata Repository that will hold the details of the metadata of database schemas, tables and data items of hundreds of ...
2
votes
2answers
772 views

Role problem of PostgreSQL

I want to create a role named cp with some defined privileges, then we will create some other roles which will be granted with cp role. I know Oracle can do this job. For examle grant resources to ...
4
votes
1answer
5k views

Good video tutorials/series for learning Oracle? [closed]

I am a better learner with visual content. Therefore I actively seek video tutorials when I start learning a subject. For oracle below links are my finds. I would like some additions to these. ...
2
votes
1answer
419 views

Decision tables in the database: a valid solution?

I have to extend a .Net 4/C# case management application that uses Oracle 11g to handle legal cases. I have minimal budget, my experience with Oracle and a very junior C# developer to accomplish ...
7
votes
3answers
2k views

Performance issue with xpath in SQL Server 2008

I have a table with lots of large xml-documents. When I run xpath expressions to select data from those documents I run into a peculiar performance issue. My query is SELECT p.n.value('.', 'int') ...
2
votes
2answers
1k views

Reference a non primary key in another table in postgresql

I have a two columns should references two columns in another table. And those two columns are not primary key. I think I can't use foreign key, because it can only references primary keys.
2
votes
2answers
124 views

Database Files-Related Issue

I am using MySQL database and using Ubuntu linux machine. I noticed that my database, db_test, is under the path /var/lib/mysql/db_test There are files with the suffix .frm, .MYD, .MYI like the ...
1
vote
1answer
82 views

Back up and restore to main system

I have a software system running in my office with MS SQL Server in back end.I want to backup the database daily and delete all data from database so that only one-day data will be in the database at ...
7
votes
2answers
51k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

I have access to a ORACLE 11g server using the following listener.ora # listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora # Generated by ...
4
votes
3answers
828 views

Single versus Multiple databases

I am working on a hospital management system using DB2 with pureXML. Is better to use a single database for all the data (patient, doctor details, appointments, history, medicines, etc) or to use ...
2
votes
1answer
348 views

How to perform asynchronous cascade slave replication of PostgreSQL database?

This is a feasibility/architectural question (I am no database administrator). Let's imagine a PostgreSQL database running online (like those from Heroku for example). One would like to maintain a ...
1
vote
0answers
408 views

how to move a oracle datafile to another location [closed]

It was different if database is archivemode or not, There are two ways are posted below http://ozcan-yildirim.blogspot.com/2011/11/oracle-veritabaninda-datafile-nasil.html#more or ...
2
votes
1answer
275 views

When do you remove entries from a write-ahead log (WAL)?

If I understand correctly, when a user updates a database record and commits the transaction the commit() call will block until the following steps are done: Database documents the change in the ...
1
vote
2answers
350 views

Difference in Size of SQL Server 2008 R2 backup on Local disk and on Remote Network Share

I wanted to take backups of all SQL Server 2008 R2 databases on a network share, I already have a backup schedule for backup on local disk. I have tried two methods: using SQLBackupAndFTP Software ...
3
votes
1answer
784 views

Find out if two rows came from same transaction in Oracle

I am using Oracle 11.1 and would like to figure out if two rows in one table where inserted by the same transaction. Is there an easy sql statement to map a row to an transactions id? The table is an ...
3
votes
2answers
3k views

MySQL trigger: Compare value in another table

I have the following trigger (generated using PHP via mysqli)... DROP TRIGGER IF EXISTS post_queue_insert; CREATE TRIGGER post_queue_insert AFTER INSERT ON posts FOR EACH ROW BEGIN IF ...
5
votes
2answers
3k views

EXPLAIN output suggests that my index is not being used

I have set up my table with an index only on done_status(done_status = INT): When I use: EXPLAIN SELECT * FROM reminder WHERE done_status=2 I get this back: id select_type table type ...
1
vote
1answer
4k views

ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full

There is a SAN mounted 1TB partition for Mysql backups in our server with version 5.0.45-log. From two days, im seeing the log entries ERROR 1114 (HY000) at line 6308 in file & The table ...
1
vote
1answer
3k views

MySQL MyISAM Locking question

It was my understanding that MyISAM uses table locking during inserts and updates. To me that meant that read and write by other queries on that table is disallowed until the first insertion or update ...
1
vote
1answer
727 views

PostgreSQL 8.4 hangs on create table, reindex

I have a rather small database(200Mb) which was running on ubuntu 10.10/amazon ec2 fine for a year almost but today I ran into the following problem: When I create a table that references other table ...
3
votes
2answers
571 views

Can an article in Sql Server replication be based upon a query?

I am looking to replicate the results of a query, is that possible or do I need to rep the tables themselves?
3
votes
1answer
454 views

Maintaining replicated data in a staging-to-warehouse environment

I am trying to come up with a way to move metric data from the staging server to the data warehouse servers. I have a bunch of dimension tables that gets populated during the ETL process (on the ...
2
votes
1answer
268 views

Why are views not copied over when using SQL Server Log Shipping?

I have 2 Sql Servers (2008) with Log Shipping setup between them. The receiving server is configured to keep the database in Read-Only mode. When creating a view on the primary server, this view is ...
2
votes
1answer
69 views

Oracle 10g Administration

Redo log files are not multiplexed in our database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer ...
2
votes
2answers
388 views

Advanced search engine or server for relational database

In my current project we are storing big volume of data in relational database. One of the recent key requirements is to enrich application by adding some advanced search capabilities. In the Project ...
11
votes
2answers
9k views

Script out Oracle DDL in an automated fashion

Oracle SQL Developer is able to export DDL through Tools -> Database Export... This works very well, but requires manual intervention. I know of DBMS_METADATA.get_ddl(), but have found that the ...
1
vote
1answer
1k views

ORA-00449: background process 'MMAN' unexpectedly terminated with error 7446

One of our Oracle servers went down rather badly last night, and we have been unable to bring it online since. Attempting to startup each instance results in: SQL> Connected to an idle instance. ...
1
vote
0answers
230 views

Solve sudoku table by tsql [closed]

I am real fun of SUDOKU games, and I also have passion for solving problems writing TSQL queries. Just for fun ill love to try make code which is going to solve Sudoku puzzles. Basic idea is make ...
1
vote
1answer
46 views

building a view w/ fields that only contain a certain word

Trying to build a simple SQL query... I have a table filled with "Yes" and "No" I want a view that only shows me records that contain "No" SELECT PhysicalBuild.Name AS Name, PhysicalBuild.Labels ...
4
votes
2answers
2k views

The distribution agent failed to create temporary files

I'm testing transactional replication between 4 databases, 2 in one machine(Virtual) and 2 in other(also virtual). None of my virtual machines is running an anti-virus. It's all working as expected, ...
5
votes
1answer
5k views

Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)

my.cnf (5.5 and 5.1 is the same) : back_log=200 max_connections=512 max_connect_errors=999999 key_buffer=512M max_allowed_packet=8M table_cache=512 sort_buffer=8M read_buffer_size=8M thread_cache=8 ...
1
vote
0answers
1k views

Problems with cross forest authentication in SQL Reporting

We're currently running an SQL 2008 R2 Cluster with Reporting Services running, all for use with System Center Operations Manager 2007 R2 (RU3). Our users are on a different domains to the SCOM and ...
10
votes
4answers
9k views

SQL Server Max Memory not limiting use of RAM

I would like your input on this. I have a sql server 2008r2 Ent. Ed. 64bit with 16 cores and 64GB RAM. There is one instance of SQL server patched fully as of 20111014. The max ram is set to 60000MB. ...
2
votes
2answers
3k views

WITH using INDEX hint in Oracle

I have a fairly complicated query. I have written two different query to accomplish my goal. First one is using WITH, other one is using global temporary tables. First One: WITH A ( KNO .. ) , ...
1
vote
2answers
631 views

serial field issue

Q: I use a serial as a datatype for my primary keys in my tables. I insert a lot of data then truncate these data one after one many times to test the data entry. My question is: Is there any ...
5
votes
2answers
2k views

Compare Microsoft SQL server performance between virtual and dedicated server

I have a dedicated windows 2008 r2 server at the moment and I am thinking about migrating to a virtual server because of the costs. Now I know that SQL should be on a dedicated server, but the ...
3
votes
1answer
5k views

How to find out what caused the database(DB2) in a locking state

I know how to check the DB is in a lock state or not, but my question is how to find out which query caused the lock on table /db. IS there any log file getting created if something unexpected ...
5
votes
4answers
932 views

Making a column immutable in MySQL

I want to make a column in a relation unmodifyable for consistency reasons. The backstory is that I have a n:n relationship where the "connecting" relation has additional values. I don't want that ...
5
votes
3answers
4k views

MySQL general query log performance effects

One of our customers who has a somewhat problematic web application would like us to log all the queries for a period of 24 hours. I wouldn't know how much data it will actually write. The amount ...
4
votes
3answers
201 views

How to monitor how much data is transfered in a linked server?

I have a linked server to a remote computer and doing some insert, update and delete operations between local and remote databases. I want to know how much data is transfered when operation is doing. ...

15 30 50 per page