1
vote
2answers
2k views

Agent Xps getting disabled automatically

In one of SQL Server 2012 server, agent Xps is getting disabled automatically. There is no set pattern for the same and the issue started all of a sudden. Through profiler it was found that ...
1
vote
2answers
823 views

To normalize or not to normalize for few distinct values

Assuming in a Postgres database, you have a table called party, which can have less than 5 well-defined party_types such as 'Person' or 'Organization'. Would you store the party_type in the party ...
0
votes
1answer
45 views

Couldn't connect to databasee

I have a dedicated webserver and a dedicated database server Often , i got errors connecting to database server couldn't connect to database Here is my current /etc/my.cnf configuration file [...
0
votes
0answers
359 views

Partly rotated table with pivot/dynamic SQL without aggregation

Using MS SQL 2008, I have created a table that I want to display in horizontal direction instead of vertical direction. Because I do not now how many query results I will get returned I think I have ...
0
votes
0answers
549 views

Issues with mysqldump after upgrade 5.5 -> 5.6

A few months ago I updated a MySQL setup from 5.5 to 5.6. Since then I've been having problems with a script that I use to dump the various databases so that I can back them up. The script is a short ...
0
votes
1answer
65 views

About transactions on mongodb

To what extent can the atomic storage of MongoDB leave your database unsafe after inserts or updates on my data? In other words: What are the possibilities of my data not been (inserted or updated) ...
1
vote
1answer
1k views

InnoDB to MyISAM Conversion Problem

I have a dedicated server based on CentOS 5 OS , mysql 5 and phpmyadmin I was trying to convert all database tables from InnoDB to MYISAM. I tried to do it by setting in /etc/my.cnf file the value ...
2
votes
1answer
7k views

select based on sum of rows compared to another field value

I have a table of invoice items. A single transaction may result in multiple debit items and multiple credit items sharing the same invoice_set_id, I need to compare the sum of the debit items against ...
3
votes
1answer
163 views

view corrupted when viewed using design feature

All, I had a very strange thing happen last Friday. We have a table that is updated on a daily basis using a job that fires a proc that utilizes a view. The columns were being transposed from the view ...
2
votes
2answers
6k views

Store output of sp_who2 in a table

I am looking for something like this, where I could store the output of sp_who2 in a table, without having to first create the table: create table test as exec sp_who2
1
vote
1answer
47 views

Upgrading the SQL Server version

My SQL Server version at home is 661 and at my school's is 655, so every time I try to open my web's SQL Server database at school it says there is an error: So I thought that uploading the SQL ...
1
vote
1answer
3k views

Compressing Base64 Encoded Image in Database Field. Table Size too Large

Database Info Database Type - Percona MySQL. Table engine - InnoDB. I have a database table that is currently using 17GB at 400,000 rows. This size is mainly because I'm storing a 40kb base64 ...
0
votes
1answer
2k views

Best Isolation Level to avoid deadlocks in Sql Server [duplicate]

I need execute un update statement over an sql server table, this table is used by another process at the same time. because that sometimes deadlocks ocurs. wich Isolation Level do you recomend for L1 ...
2
votes
1answer
650 views

Performance of dynamic SQL Server reporting queries?

I have to build an application that allows the end user to select what columns they want in their report. For this I build a dynamic T-SQL stored procedure. However, there are up to 60 columns ...
0
votes
0answers
469 views

Oracle data obfuscation on specific columns with set field sizes

Would like to obfuscate data held in Oracle tables, but: Requirements only apply to specific columns e.g. personal data obfuscated value should not be longer then column size possibly only ...
1
vote
1answer
757 views

Large Table handling [closed]

We are having table that contains 6,616,711 (6.6 million) records in it. I want to know, How to manage this table? If there is SO question similar to this please give me link. Having following concern,...
2
votes
2answers
474 views

UPDATE table with another table data

I want to update the table car_check field fencing.(total 40 rows).I also use postgis function. I think it's a little difficult.Any suggestions? The code is the first carid example. UPDATE car_check ...
0
votes
2answers
87 views

General table name for Person Inf

I was in a meeting with my boss and technical support leader and they asked me for a database model to a very simple application. That application requires: employees information, some location data, ...
4
votes
1answer
11k views

MySQL: Migrating database with utf8 collation and charset but latin1 data to new full UTF-8 database

With my current situation I have mysql database with collation and character sets on database and tables set to utf8, but all data is still latin1. This is due to server being configured (my.cnf) with:...
4
votes
3answers
354 views

Is matriculation number a good primary key?

I am trying to design a grade assignment database and i am facing the following dilemma. I have a student table which has the following characteristics: matriculation number which i know for a fact ...
4
votes
1answer
3k views

Confused about load balancing and horizontal scaling in postgresql [closed]

Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, ...
1
vote
1answer
93 views

PostgresSQL authentication error

I recently forgot my PostgreSQL 9.1 password on my windows 8 and it asks for password on pgAdmin III console. Can I retrieve the password or reset it?
0
votes
0answers
52 views

TempDB causing high IO writes - dependent on server's max memory setting [duplicate]

I have a mirrored SQL Server 2012 database. The first server has a hugh tempdb write IO load when the maximum memory limit is set above 8192 mb. These 8192 where the original setting for both the ...
1
vote
2answers
843 views

How can I repair a TokuDB table?

I have a TokuDB table that works fine for most queries, but segfaults on others. I did a CHECK TABLE which indicated that the table had errors. However, TokuDB doesn't support REPAIR TABLE. How can I ...
3
votes
1answer
616 views

Tempdb data file disappearing

I recently moved my Temp database files onto a separate drive (I had two data files and one log file). However, after restarting the server, my second data file disappeared both from the file list on ...
0
votes
1answer
264 views

How to track IOPS statistics?

Is there a way to access statistics about IO operations per second in DB2 9.7? I am not interested in the buffer pool hit ratio, just IOPS.
2
votes
1answer
120 views

SQL Server 2012 database 3 mirroring questions

I've been looking for the answer to these three questions but just cant find a straight answer.. When mirroring with a witness, does all three SQL Server editions have to have the same name? I.E at ...
0
votes
1answer
40 views

Select permission to each table

I have three schemas Production, HRecourse and Sales,tables in every week create and drop , I have six Users P_User1, P_User2, HR_User1, HR_User2 and S_User1 and S_User2. I have to grant then how i ...
3
votes
1answer
624 views

SQL Server DMV to show if database is used

What is the best indicator in finding out whether a database is utilized or accessed? I tried index statistics and based on I/O utilization but none seem to be a good indicator. Problem: I have a ...
1
vote
0answers
267 views

Combine a running balance SQL statement as a column

I have two Select Statements which are collecting data from 1 table, one is a totals select statement. Could anyone assist me with combining them into 1 statement? Any assistance is appreciated ...
0
votes
1answer
498 views

Case of irrecoverable error in transaction

According to an exam question,which may lead to an irrecoverable error: 1.A transaction writes a data item after it is read by an uncommitted transaction. 2.A transaction a data item after it is ...
2
votes
0answers
706 views

Lossy Decomposition meaning

Suppose I have a relation R=(A,B,C,D) and I decompose it into: R1=(A,B,C) R2=(A,D) then if it is said that the decomposition is lossy,then what is the meaning of that statement?I have an ...
3
votes
1answer
5k views

Multiple “root” users in MySQL

Mysql is showing 5 root users: | root | % | | root | 127.0.0.1 | | root | ::1 | | root | localhost | | root | mysrverhostname | What are these 5 for? Are there some I can ...
0
votes
1answer
526 views

CHROOT install after I already installed Mysql 5.6

I installed some time ago Mysql 5.6 on Ubuntu server 12.04 and now I'd like to enhance security by putting mysql into a CHROOT environment on that same Ubuntu server. Is this possible without re-...
5
votes
1answer
69 views

How to see amount of reusable space for a table

I had a huge table(about 300mil rows). After massive DELETE and VACCUUM table files have stopped to grow. That's exactly what I expected. But is there any way to see how much space became reusable?
0
votes
1answer
101 views

RAID0 vs multiple files in file group

I have a server that gets updated and backed up once a day and processes queries the rest of the day (selects). I'm trying to improve performance of the update process and the selects. I'm not worried ...
0
votes
0answers
246 views

EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware

I am trying to install Oracle 11gR2 on Windows Server 2008 guested on VMware Workstation 10 but I am getting this error on Enterprise Manager Configuration. I also tried to login to the database ...
1
vote
1answer
5k views

Startup NOMOUNT and Startup MOUNT on dataguard oracle

I have a question here about Oracle data guard. After performing a switchover, we shutdown the new standby database and startup it. At this stage, sometimes I find DBA performance in 2 different ...
8
votes
1answer
3k views

Free space of mdf and ldf does not match with database free space

In SSMS I saw file size related properties and found below details for one database. Here values does not match with other properties. Here size of the mdf, ldf and total size matches with other ...
0
votes
1answer
1k views

DB2 - How to estimate proper BUFFERPOOL size?

DB2 9.7. 8GB RAM on server. Currently BP has 500 MB (number of pages*pagesize) Database has issue with increased IOPS. So we think maybe BP should be increased. How to estimate needed size for BP? Is ...
0
votes
1answer
613 views

pgpool2 not working on my Ubuntu i686 athlon i386 GNU/Linux

I am trying to implement replication and load balancing on my Ubuntu i686 athlon i386 GNU/Linux.for creating database clustures I have installed postgresql contrib 9.1.11 having initially database ...
15
votes
3answers
37k views

How to make MySQL table name case insensitive in Ubuntu?

I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default. Now, I want to make MySQL work as case ...
4
votes
1answer
183 views

Non-overlapping rectangles constrained to a boundary

I am trying to model placement of parts on a circuit board. Without any meaningful constraints, my basic schema looks like this: create table part ( part_id bigserial primary key, name text ...
0
votes
0answers
13 views

MySQL: Updating a column referenced by two foreign keys in the same table leads to foreign key constraint failure [duplicate]

MySQL 5.5 I have a simple InnoDB table: CREATE TABLE `T` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `deleted` bigint(20) unsigned NOT NULL DEFAULT '0', `other` varchar(32) DEFAULT ...
0
votes
1answer
76 views

Implement a deduplication trigger in Oracle

I am new in Oracle DB. We are using Toad for Oracle. I need to implement a deduplication trigger for our table. It's an alarms table and a third party vendor will be sending alarms to our database. ...
2
votes
2answers
450 views

Order of returned record with IN statement postgres

I know that the order of returned records is not guaranteed with the IN statement for Pstgres. For example if I do this: SELECT "users"."id" FROM "users" WHERE "users"."id" IN (13589, 16674, 13588) ...
1
vote
2answers
467 views

MYSQL Master-Slave replication not working with PHP

My data gets replicated from the master database when I do it manually but when it gets inserted from PHP into the master database it doesn't get replicated to the slave database. My Master database -...
0
votes
0answers
3k views

MariaDB MySQL server does not start

My MariaDB mysql server doesn't start with error 1067 This is the error log: 140222 0:43:44 InnoDB: The InnoDB memory heap is disabled 140222 0:43:44 InnoDB: Mutexes and rw_locks use ...
2
votes
1answer
431 views

Is it possible to replicate wide table in MS SQL?

The reason of me using sparse columns is to overcome limit of 1024 columns in a table (I know that generally it's not a good reason and there are downsides, but in my situation it's good option ...
3
votes
1answer
370 views

Postgresql 9.2.6 ignoring archive_command

I'm attempting to set up a 3-server chain by leveraging WAL-E. I've done this in the past with replication/wal segments and I'm attempting the exact same method, just with using WAL-E in between. My ...

15 30 50 per page