Stackexchange - dba.stackexchange.com - Recent Questions - Database Administrators Stack Exchange
General Information:
Latest News:
Getting the employee history of Sales department from HR database in Oracle 27 Aug 2013 | 08:26 pm
I am currently using the 'hr' database with Oracle 10g. You can view the schema diagram over here: http://docs.oracle.com/cd/B13789_01/server.101/b10771/diagrams001.htm#sthref63 What I would like is ...
MySQL InnoDB slow inserts 27 Aug 2013 | 08:26 pm
I'm currently struggling with an MySQL Community Server 5.5.27 when inserting large numbers of rows into a table. We're running a 24 core Intel Xeon machine with an SSD software raid array. I did some...
Junior DBA hopes for advice [on hold] 27 Aug 2013 | 08:16 pm
This is the 7th month of my DBA career, and I just graduated as a master, no experience before. My daily work for now is pretty much about backup/restoring databases in different environments (DEV/QA/...
What other databases support 'Service Broker' type of functionality? 27 Aug 2013 | 08:14 pm
Does anyone know what other databases support 'Service Broker' like functionality? I saw one post that mentioned Oracle provides a similar functionality with Advance Queuing. I was curious if any open...
MySQL: mysqld_safe options 27 Aug 2013 | 07:59 pm
Is there a way to specify these options in configuration file? I've tried to add them into [mysqld_safe] section but it doesn't work: - Please note that I'm using Percona server.
How force specific table to not logging (for all DML)? 27 Aug 2013 | 06:49 pm
We using Oracle 9i . I'm still learn about admin Oracle (I'm DBA but other vendor). We implement manually at our databases a trigger over LOGON and LOGOFF to save some information about our users ses...
How to setup SSL in MSSQL Server 2012 with own certificate? 27 Aug 2013 | 04:32 pm
Environment: Windows 7 Professional x64 in a domain, running MS SQL Server 2012. I have lokal Admin rights, so messing up the system is easy. My SQL Server 'names' are 'SQLEXPRESS' and 'MSSQLSERVER'....
How to call Oracle's stored procedure from DB2 stored procedure? 27 Aug 2013 | 04:06 pm
I am new to writing stored procedures and wondering if it's possible to call a Oralce' stored procedure from DB2 stored procedure. I have a scenario where a trigger on a DB2 table will invoke a DB2 s...
T-SQL Gurus, I need help optimising these queries for performance 27 Aug 2013 | 03:42 pm
I would like to have suggestions on improving the performance of some queries. These will be run on SQL Server 2008 R2 against a single table called dbo.bids In a production environment the table is ...
Does TRIGGER improve the performance? 27 Aug 2013 | 02:46 pm
I understand that TRIGGERs are useful, as they take care of subsequent queries, but does they have an advantage from performance point of view too? Replacing two or three queries as with a trigger-b...
