16
votes
2answers
29k views

How to view data in pgAdmin III

I can't believe they make it this hard. I am at a loss about how to view the data in my database. Is there an easy way to see what data is in my tables with pgAdmin III? Alternatively, is there a ...
1
vote
1answer
3k views

Simple Car Rental database

I am trying to learn SQL development using SQL Server 2008 R2 Database Management Studio. I was trying to model a car rental company, where clients can rent cars, and I have to know which client has ...
10
votes
0answers
3k views

Deploying dacpac application to SQL Server 2008 R2 [closed]

I cannot get dacpac working on my installation of MS SQL Server 2008 R2. I am using Visual Studio 2010 Shell with MS SQL Server Data Tools to build a project into a dacpac file. However, when I try to ...
2
votes
1answer
551 views

Configure sp_send_dbmail to send emails ONLY to certain recipients

For our environment test we need to configure sp_send_dbmail to send emails only to certain recipients. Let's say a stored procedure executes the following code: EXEC msdb.dbo.sp_send_dbmail @...
2
votes
2answers
893 views

Out of memory mysql was aborted

I am using windows 2003 server, with 8G of RAM and MySQL was installed on It. I am getting error as follows out of memory.[ERROR] mysqld: Out of memory (Needed 523712 bytes). The configuration ...
4
votes
1answer
2k views

Oracle Database Enterprise Users & Roles with Microsoft Active Directory?

We have a legacy application and we have full access to source code and platform running it, so virtually any change can be implemented if required. The application is a Java Swing heavy-weight GUI (...
1
vote
1answer
98 views

Transfering data from one MongoDB server to another while eliminating users/authentication

I am transferring MongoDB databases from one server to another. The servers cannot talk to each other, so I must use mongodump/mongorestore. The 'from' server used authentication for the databases. ...
1
vote
2answers
10k views

Changing TimeZone of an Oracle Database

I am looking to change the timezone in a quite large Oracle database. What are some of the issues I might run into when trying to change the timezone in this way? I don't want to 'trash' the ...
1
vote
1answer
204 views

How to prepare a date and double for a mysql replace statement?

I have a MySql table with three columns: CU VARCHAR(3) DA DATETIME VA DOUBLE I need to execute several REPLACE into mytable (CU, DA, VA) values("ABC", mydate, myval) statements from Java. mydate is ...
1
vote
1answer
243 views

In a simple table with no complex indexes, does a large number of existing rows slow down an INSERT?

I have this small, simple table: CREATE TABLE `ads_tracker` ( `id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, `type` smallint unsigned NOT NULL, `reference` smallint unsigned NOT NULL, ...
2
votes
3answers
4k views

Recover lost data from .LDF file

Background: Using Business Contacts Manager 2010 with SQL 2008. Master database is hosted through SQL and each computer connects. When the connection is stopped, each computer switches to local copy ...
9
votes
4answers
7k views

How costly is opening and closing of a DB connection?

How CPU intensive is opening and closing of a DB connection (for a web app) in MySQL ... when the DB software is on localhost? ... when the DB software is on another machine?
2
votes
1answer
1k views

innodb_flush settings on Amazon RDS

Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent ...
6
votes
3answers
802 views

Single query sending and retreiving duplicate data on MS SQL Server?

Very odd thing happening. It would appear that all queries against a particular database in our system are periodically "running slow". Ie "normal speed" for 5 minutes then slow for 5 minutes (roughly)...
2
votes
2answers
2k views

Does it ever make sense to use RAM Disk to force RAM allocation for tempdb with SQL Server 2008

If I give all RAM to SQL Server, it will use it's own pattern to determine what RAM to allocate for what. If I allocate portion of RAM as RAM Disk and put tempdb into that disk it will force RAM ...
5
votes
1answer
96 views

Database Design: Linking 'vague' entries to associations?

Experienced developer, inexperienced DBA here. I'm currently working on a project that lets users input the names of freight vehicles for particular packages. Eg: Company: White Star Line Vehicle: ...
1
vote
1answer
1k views

Oracle Client vs Oracle Instant Client on Linux!

to have the following setup on a Linux box: SQLPlus client library (oci.dll)!!!! ORACLE_HOME is set for users is Oracle Instant Client enough or I need to have the Oracle Client installed on the ...
7
votes
2answers
4k views

A good SQL sniffer

Can anyone point me to a good SQL sniffer where I can watch the SQL commands that run against my database in real time? If it's free, that would be great.
1
vote
2answers
1k views

sqlplus not working on opensuse

take a look at this: > cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$...
7
votes
2answers
1k views

Investigate peak in MySQL throughput

Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the ...
2
votes
1answer
867 views

MySQL: Show full processlist has empty Host name. Why?

I am executing SHOW FULL PROCESSLIST and from the response I get the "Host" field is empty. Quoting from the docs here Host The host name of the client issuing the statement (except for ...
0
votes
1answer
3k views

MySql 5.5 in ubuntu repository

Sorry for duplicate question. I am looking for the best way to install mysql 5.5 on ubuntu. So far, there are few options: Installing from tar.gz Installing from PPA. Alien on RPM. All of them ...
4
votes
3answers
5k views

PageIOLatch_Sh waits noticed after tuning an index

Lately, a lot of queries to the database are timing out. While investigating I found that queries are in the suspended state with wait_type as PageIOLatch_Sh. I have not noticed so many queries being ...
1
vote
1answer
370 views

What can cause an UPDATE statement to execute endless? [closed]

I have a stored-procedure which is executed at 7 o'clock in the morning that updates the database because new records were imported at night. Today it started but never endet. So i've tried to run ...
1
vote
1answer
464 views

MySQL Character set and Collation Issue.?

I Have a table when i select from the table i got the invalid data as mysql> select budgetID,StartDate,modifiedBy from Table_name order by budgetID desc limit 10; +----------+---------------------+...
2
votes
1answer
176 views

Is a year-to-date dimension the same as a time dimension?

If I have a table such as...: YYMM | Sales ------------ 1201 | 10 1202 | 20 1203 | 30 1204 | 40 ... then I might describe this as having a time dimension. If I wanted to calculate a year-to-date ...
-2
votes
1answer
332 views

Important distinctions between DBMSs [closed]

DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
6
votes
1answer
22k views

Cannot output MySQL data to file

I am trying to output the data from an MySQL table to a file but getting permission errors: $ pwd /home/dotancohen $ mkdir in $ chmod 777 in/ $ mysql -ugs -p mysql> USE someDatabase; mysql> ...
2
votes
1answer
1k views

Mysterious disappearing consistency errors in SharePoint DBs

We have a pre-production SharePoint SQL server which threw an 824 error yesterday evening on the Content DB. As part of my investigation today, I ran DBCC CHECKDB on this DB and it came up clean. ...
1
vote
1answer
2k views

Executing a stored procedure on remote database

I have 2 databases on the same server. DB-A and DB-B. DB-B has a user that has read and write access to database B. I would like to grant the user in DB-B execute permissions to 2 stored procedures in ...
1
vote
1answer
168 views

Rename cell based on duplicate compound key in MS Access

I'm using MS Access (I know, I know...), and I'm trying to rename a cell when there are duplicates of mutliple columns. Here's an example: Col_1 Col_2 Col_3 Note A1 B1 C1 A1 ...
1
vote
1answer
21k views

Why does DBMS_JOB.SUBMIT execute immediately when NEXT_DATE is in the future?

I wanted to create a job that will run tomorrow at noon and recur every day at noon, so I executed this script: DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what =&...
6
votes
1answer
2k views

What factors contribute to lock-percentage with MongoDB

We're attempting to better optimize how we're using our MongoDB instance. We seem to be routinely getting high lock-percentages, and are looking to help minimize that. Here is some mongostat output: ...
5
votes
2answers
307 views

Does Restore “From database” restore from the most recent backup of the database or the actual live database?

In SSMS 2005, I want to use the GUI to copy a database by restoring in to a new database. I was using the "From database" radio button for the source, but then the databases in the list disappeared ...
2
votes
2answers
616 views

pull records that are inactive

I need help with this query. I have records in customer table Main table - M +---------+---------+----------+ | company | Account | Active | +---------+---------+----------+ | A | A123 | ...
3
votes
1answer
2k views

Rotate a table in PostgreSQL

Problem description I need to rotate (with DROP and CREATE) a table which is heavily used by other clients. At present, I have a program which replaces (DROP + CREATE) this table. Sometimes, just ...
2
votes
1answer
785 views

unreachable SQL Server for a group of computers

I'm deploying SQL Server 2008 Express in my company. I already installed, did a application, tested, gave permission to user. All desktop users run the program without any problem. But the notebook ...
2
votes
1answer
1k views

Dropping indexes doesn't seem to release space to the OS. Can it?

I'm running PostgreSQL 9.1. I have noticed really alarmingly bad indexes are taking up a lot of space on my server, e.g: evlampts=# SELECT pg_size_pretty(pg_relation_size('mcdata_2011_07')) AS ...
3
votes
2answers
4k views

How do I limit Oracle to use specific ports?

I've built a new Oracle 9iR2 instance on a Windows 2003 32-bit cluster. Of course, it's version 9i for reasons out of my control. Several application servers connect to this instance, and each opens ...
1
vote
0answers
57 views

Diskless Oracle and persistent filesystems

I'm putting together a diskless Oracle database SLES image. What will need to be kept stateful? For example, what filesystems need to persist? Right now, the easy ones I know of are /home, /perf ...
9
votes
3answers
3k views

Referencing database programmatically via T-SQL

I am writing a stored procedure that takes a database name as an argument and returns a table of that database's indexes and their fragmentation level. This stored procedure will live in our DBA ...
1
vote
1answer
262 views

MySQL not returning successful results on statement - query looks like it's hanging but is successful

So we have a script(s) that runs in succession. Randomly this task would halt/freeze and error out simply because it did not see a returned response from the MySQL server saying the statement ran ...
5
votes
2answers
874 views

Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?

In this query: select count(*) from largetable; a secondary index is chosen: mysql> explain select count(*) from largetable; +----+-------------+------------+-------+---------------+------+-----...
1
vote
1answer
2k views

Why do my ON UPDATE/ON DELETE rules disappear?

I'm trying to connect a couple of Mysql tables with foreign keys and ON UPDATE/DELETE rules. My rules are working on all tables except the last one (OrderContains). Why aren't my rules working? I am ...
0
votes
1answer
655 views

Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored

I'm uploading data to a db (mysql 5.1.42) from a dump file using mysql command line and get duplicate key error. This is the format I use: /mnt/temp# mysql -u username -p -h url_of_db_master -D ...
4
votes
1answer
227 views

Can the table spool operator be parallelised?

Is there something inherently unparallelisable about the table spool operator in SQL Server? I've got several queries that use parallel operators throughout due to the size of the tables, but by ...
24
votes
2answers
4k views

As a DBA, how would I go about transitioning from Oracle to SQL Server?

I'm an Oracle DBA that also has Sybase experience. What are the major architectural and conceptual differences between the two RDBMS platforms? An answer similar to the SQl Server->Oracle question ...
0
votes
1answer
131 views

Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication

I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber. http://blogs.msdn.com/b/repltalk/archive/2010/03/...
1
vote
1answer
425 views

Analyzing TCB Index Status for DB2

The Following is the TCB index that I could get using a command for my DB2 database. I don't know how to analyze it. Which columns are important? What do they mean? TCB Index Stats: Address ...
3
votes
1answer
684 views

Is it possible to configure Oracle's CONNECT THROUGH based on roles?

I don't have too much administrative experience with Oracle DBs, so forgive me if I make a fool out of myself. In our current setup, each of our clients has a database user on our Oracle database. ...

15 30 50 per page