5
votes
1answer
262 views

Can I attach a SQL 2008 R2 database to SQL 2008 that is not R2?

Can I attach a SQL 2008 R2 database to SQL 2008 that is not R2? I have a database that I am detaching from SQL 2008 (not R2) and can attach this to SQL 2008 R2. Can I then detatch the database from ...
1
vote
3answers
264 views

PostgreSQL and query planner

I have question about query planner in PostgreSQL. I know, that this planner is taking data from pg_statistics, but... Can anyone tell me on what basis this planner is taking those informations to ...
6
votes
1answer
13k views

Best way to setup master to multi master replication

ORIGINAL QUESTION: I have multiple servers that all need to act as masters, as if one fails the next server kicks in and takes over. I'm just wondering what the best way to replicate is. All servers ...
2
votes
2answers
2k views

Is there any prevalent logging packages in PL/SQL similar to java and .Net counterparts

Normally in java or C# , I would use a following construct when try and catch errors. Bad Exception Handling in C# and Java try { // do something } catch(Exception ex) { } Good Exception ...
1
vote
1answer
2k views

Can't restore database: A transport-level error has occurred when receiving results from the server

This is not a good day for me. I have a backup (master.bak) for SQL Server 2005 Express SP4 (v.9.0.500) that I want to restore to my master db instance. I am running SQL Server in single-user mode (...
1
vote
1answer
1k views

SQL Server 2008 - Cannot create index on Indexed View

I am attempting to create an index on a view. The view is contained in a different schema than the underlying table it's based on. When I attempt to create the view, I get the following error: Msg ...
2
votes
2answers
1k views

Which first: upgrade mysql version or convert storage engine?

I inherited a production mysql server at 5.0. It uses MyISAM exclusively. It is not a high volume database but it does have some large datasets. I am planning on: upgrading to 5.5 converting ...
2
votes
2answers
6k views

Primary Key on a View

While answering this question How to add a Primary Key on a Oracle view? A lot of questions popped in my mind. 1. Is it advisable to have primary key in a view. 2. Why anybody be intrested in ...
3
votes
2answers
6k views

Shared and IX locks causing deadlock (Sql server)

In my environment, I have 2 tables - Issue and IssuePropertyValues (which has foreign key reference to the Issue table). Now, we insert values into these 2 tables using the below 2 queries: INSERT ...
15
votes
2answers
2k views

Why did creating this new index improve performance so much when existing index included all columns in new index?

I have Log and LogItem tables; I'm writing a query to grab some data from both. There are thousands of Logs and each Log can have up to 125 LogItems The query in question is complicated so I'm ...
2
votes
2answers
4k views

database schema for a product with multiple categories and hierarchical categories

I need some opinion on whether I am going in the right direction with this. I am trying to build a e-commerce site (with MySQL backend) where a single product can belong to more one than category ...
2
votes
2answers
199 views

In SQL Server 2008R2 Will currently deployed applications still work if I turn on Mirroring without changing connection strings?

I've googled a great deal, and can't come up with an answer to this. In SQL Server 2008R2 will currently deployed applications (Asp.Net, .Net Smart Client) still work (with a connection string ...
1
vote
2answers
3k views

Where should I look for my.cnf?

I want to add innodb_file_per_table statement to my.cnf file. Where is my.cnf? Could I change this file when I have an online site?
1
vote
2answers
1k views

Is Using Execute Immediate Bad Practice in Oracle?

So, I've been writing a script which creates a sequence (if it doesn't exist) then copies some data including a value from that sequence before deleting the original source data. As the sequence can'...
6
votes
3answers
629 views

Combining InnoDB with MyISAM [duplicate]

Possible Duplicate: Is it common practice to mix InnoDB and MyISAM tables on same server? I have a movie clips and photos table in an application; these tables contain a tag column, which ...
8
votes
5answers
6k views

Oracle sort varchar2 column with special characters last

How can I sort in Oracle a Varchar2 or NVarchar2 column to be in my own custom defined order. Or are any existing options available that will put letters first, then numbers, then all special ...
3
votes
1answer
53 views

Is time to deliver data included in time measured for a Slow Query

I'm looking at some horrible numbers in a SLOW_QUERY_LOG (one example) Count: 2563 Time=23.21s (59498s) Lock=0.00s (1s) Rows=21.4 (54857) This is for a simple SELECT statement that runs for less ...
1
vote
1answer
1k views

SSAS / MDX Query - Add an extra dimension when using Order

I wish to add an extra dimension to this query, so that I'm able to see the total amount of an item sold, per month/year: SELECT NON EMPTY Order([Item].Children, Measures.[Total Line Value], ...
3
votes
3answers
943 views

What does “thread” mean in “thread checkpoints” context?

The following excerpt is from Oracle concepts. Maybe this is a stupid question, but I really need your help to understand it. My question is: What's does the thread mean in the context thread ...
2
votes
1answer
121 views

Do IOTs generate significantly more undo per block for deletes?

IOTs are an index-like structure. When deleting large contiguous chunks of data, how much undo is generated as compared to a similar contiguous delete from a heap?
1
vote
1answer
7k views

reindex database in sql server 2008

The best way to reindex 500GB database in SQL Server 2008 Is it by using Maintenance plan? Would I face performance problems while reindexing?
1
vote
1answer
127 views

Oracle SecureFile Compression

Where can I read database compression properties after the creation of an oracle database / tables? Is there a special view where the info is stored and can be retieved?
1
vote
1answer
3k views

Can I check if a Mirror database was synchronized when the principal died?

having 2 machines, one being the principal and the second one as a mirror in case of failure of the 1st one. without witness but in High Safety mode Is any way to check if the mirror DB was ...
1
vote
1answer
708 views

Using a sequence created in the same script in Oracle

SQL Server developer working on Oracle so apologies in advance if I'm fundamentally coming at this incorrectly from an Oracle perspective. I've got a script I've written which: Checks ALL_SEQUENCES ...
2
votes
2answers
642 views

Can I implement clustering with just 2 servers and one NAS?

I have the following architecture, it consists in only 2 servers, connected to a NAS. I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do ...
4
votes
2answers
3k views

Does Oracle cache queries when using a database link

Some vendor told us that we should not use database link between our database and theirs as the queries executed over a database link would not be cached, nor optimized. I can't find any information ...
8
votes
4answers
5k views

MySQL Cluster RAM requirement

From MySQL 5.1, the data doesn't need to be entirely in memory anymore. I've read that the indexed columns (I think the entire index structure) must still be in memory (MySQL High Availability, 2010, ...
7
votes
4answers
7k views

Do SQL Server stored procedures cache data results?

I have heard this from friends, but I never investigated whether this is true. Is it true that the data results of an executed query are stored in cache? I mean, if I have a stored procedure like : ...
7
votes
5answers
10k views

Importance of ER Diagrams

I am a student and I am developing several projects as a part of my academia. While developing the database for one of the projects, we came across a situation where we thought about whether ERD is ...
6
votes
3answers
7k views

PostgreSQL vs. Oracle High Availability solutions?

PostgreSQL has a matrix of different high availability options which represent many different ways of building replication into an RDBMS. Here is the PostgreSQL High Availability, Load Balancing, ...
3
votes
1answer
277 views

Accessing ORA_ROWSCN in the triggers body

Is it possible to access ORA_ROWSCN pseudo-column in the body of BEFORE triggers? I'm thinking about storing this value in the table itself to emulate SQLServer rowversion behaviour.
1
vote
2answers
303 views

SQL Server RandomNumbers Stored Procedure Error

I tried to create a stored procedure for generating random numbers but it doesn't work; the random numbers are identical in every record. CREATE PROCEDURE Update_Driver_Position @TempName VARCHAR(...
2
votes
2answers
256 views

Execution plan doesn't use clustered index!

I'm using "SQL*Plus: Release 10.2.0.1.0 - Production" and have a table foo with a field fooID. I have created a clustered B+tree index on the field foodID of my table foo. And I do the following: ...
6
votes
1answer
271 views

32-bit or 64-bit for development and deployment?

I'm creating a Windows desktop application and want to include a database. I've chosen SQL Server Compact 4 but when I download it there are two versions (32-bit and 64-bit). My development machine is ...
4
votes
1answer
2k views

How are bit fields sorted for an index?

I am building a compound index, and I'm not 100% sure which way to include a bit field that is part of the table. The index will be for something similar to a list of forum topics, where I want the ...
5
votes
1answer
2k views

How to keep long multiple of questions and answers in database?

I am planning my database design to have 3 sets of multiple questions for 3 types of different customers (at least 3 at the moment), each set of them contains approx. 100 questions and waiting for ...
4
votes
1answer
202 views

how much overhead an error in RDBMS has?

I have a class in my project. On the class I need to do two inner select, to know is there any duplication or not, but I think if I get duplication error and then manage that is better than to select. ...
4
votes
1answer
5k views

Mysql Master-Master Replication Topologies on >2 machines

I have 3 Mysql servers that I would like to replicate: two (including the main server) are local and one is remote. Let's call my main server A, the secondary server B, and a remote, development ...
3
votes
1answer
623 views

SQL Server 2008 R2 - Upgrade Default DB Instance (Express) to Developer Edition

I have just installed SQL Server 2008 R2 Developer edition (created a new instance for it: DEVEDITION). I previously had and the default instance (MSSQLSERVER) which was running SQL Server 2008 R2 ...
3
votes
1answer
1k views

SOA + Fusion + Weblogic + Oracle 11g - STUCK threads

This is sort of a last-ditch effort. We have Oracle SOA on Fusion, 11.1.1.5.0 (+ patches on a separate server) running, and nearing the point where we're taking it into production. I've posted on ...
1
vote
1answer
247 views

Can't find location of undo *.tuf file

I run SQL Server 2000. Database is in standby mode. I have multiple files with MyDb.tuf name on a different drives. How may I know which one is in use?
3
votes
1answer
6k views

MySQL Restore Large Dump

I have a dump file of a single table which is 7GB. I try to restore it using mysql -u root -p DB_NAME < .SQL FILE But I don't see any activities in task manager. CPU is 00 and RAM is 5,700 K. I ...
7
votes
1answer
192 views

On-the-fly query/command modification

I'm responsible for administrating an instance of SQL Server 200x which has the misfortune of serving as a backend to a turnkey application written with a disgusting performance problem. It repeatedly ...
3
votes
1answer
658 views

Can you set up mirroring for sql server reporting services?

I have mirroring set up for our SQL Server 2008 R2 Standard database server. Questions How do I ensure high availability for reporting services if the server goes down? Is there a kind of mirroring ...
2
votes
1answer
1k views

MS SQL: Can't connect to server with anything but 127.0.0.1 on the server machine

I'm not able to connect to sql server with anything but 127.0.0.1 on the server machine. If I try to connect via actual IP on the network it does not work locally or remotely. The environment is ...
191
votes
4answers
362k views

How do you mysqldump specific table(s)?

How can I dump a specific table or set of tables without including the rest of the db tables?
1
vote
2answers
2k views

how to verify that next sequence value can be used as a new primary key

I have many tables with a trigger attached like this BEFORE INSERT ON BRULES ...snip... if inserting and :new.ID is NULL then SELECT BRULES_SEQ.nextval into :new.ID FROM DUAL; end if; Due to ...
3
votes
5answers
4k views

Track deleted rows/records

A project has the requirement that it shall not be possible to lose data from certain tables. That is, if I "delete" a row, that row's information should somehow be preserved. Additional information ...
4
votes
3answers
9k views

Why so many logical reads?

I have a very simple query that is showing in Activity monitor and other statistics as having the most logical reads on my entire DB server. SELECT MAX(RESULT_DATE) FROM TABLEX mm WITH (NOLOCK) JOIN ...
4
votes
1answer
3k views

Drop auto increment hack w/o alter table?

I was looking around for a quick way to remove an auto increment from the definition of a primary key. As best I can tell the only way to do it is w/ an alter table or dumping all the data into a new ...

15 30 50 per page