0
votes
0answers
5 views

DB2 removing white spaces in field values

In a table I have a column called column_xml defined as CLOB(1000000). The fields in the column contain XML formatted information. My problem is that there are lots of white spaces in these fields ...
1
vote
0answers
14 views

Profiling parameters

I was trying to fine the parameters of a query I suspect to be causing unnecessary logical read and eventually captured it in profiler, however parameters @p3 and @p4 are not listed. Is anyone able ...
0
votes
0answers
3 views

Many temporary tables created on disk since mysql 5.6 upgrade

I recently upgraded MySql (from 5.5 to 5.6) on a Debian Wheezy server. Drupal 7 and a PunBB board are installed on this server (Drupal 7 database size: 54 M / board database size < 800 M). These ...
0
votes
0answers
27 views

Avoid transaction rollback when Deadlock is encountered (mysql)

I'm currently trying to handle concurrent inserts correctly using MySQL, I'm basically doing the following: CREATE TABLE foo (id INT NOT NULL PRIMARY KEY) ENGINE=INNODB; CREATE TABLE bar (id INT NOT ...
0
votes
1answer
11 views

How to decide whether to enable MySQL query cache using InnoDB

How should the decision to enable / disable the MySQL query cache be made, on a server that uses just InnoDB tables. Say for example, if the cache is enabled, then how should the output of: SHOW ...
0
votes
0answers
13 views

MySQL CPU high usage

My MySQL service started to using a lot of CPU recently. Few second after restart it takes 100% CPU's. I tried already changing my.cnf file to optimize cache/buffers. I have no idea what causing that ...
3
votes
1answer
25 views

sql indexing and performance

I am using mysql5.1, i have table which has about 15 lakh (1.5 million) records.This table has records for different entities i.e child records for all master entities. There are 8 columns in this ...
-2
votes
0answers
24 views

Is it possible to get the queries executed in the past? [on hold]

Is it possible to get the queries executed in the past? the server is restarted.
0
votes
2answers
23 views

MYSQL: Join with many to many

I'm trying to create a view and trying to see what can be done, I have a main table a table I wanna join to and also a junction table. Event table (it's very big so it's just dummy data): ...
0
votes
3answers
37 views

Advanced design question related to compound primary keys

As a database design expert, I had a discussion with an academic person about database design and I need some arguments on why some design is bad or not normalized or bad practice. As we cannot ...
0
votes
0answers
7 views

Are mongodb bulk inserts really increase server perfomance (and faster)?

Bulk inserts always are faster in client side because of saving round-trips, but at the server-side is there any sensible performance improve? It seems the code for bulk inserts, just loops over ...
0
votes
0answers
9 views

How to grant super privilege to the user?

I have created a user and given privileges to the user1. `grant all privileges on db1.* to user1@'%' with grant option; Am using mysql workbench to import dumps to my database. While importing ...
0
votes
0answers
3 views

Best design of mongo replica set for DB read/write speed

I'm building a Node app that uses MongoDB. Whilst it would probably be fine to have node and mongo sitting on the same VPS, I want to ensure that the MongoDB is backed up and maintain high ...
0
votes
0answers
39 views

A rollback on a production server that's been running too long

I have a problem with a production server that is causing considerable locking and performance degradation. It all started the night of Tuesday into Wednesday with a procedure that inserts data into ...
0
votes
0answers
21 views

what values to set for the folowing PostgreSQL Variable [on hold]

I need to optimize my DB, in order to fine tune, what values to provide for the following variables, please advise, thanks. PgSQLIdleQuery PgSQLXclLock PgSQLConnections PgSQLMaxTTime PgSQLMaxQTime ...
-1
votes
0answers
21 views

the environment variables configuration for ORACLE EXPRESS 11g / windows7 32Bit

I can't connect in Oracle Express 11g (windows7 32-bit) and I think the problem comes from the environment variable ORACLE_SID & ORACLE_HOME , how can I get the database instance to do the right ...
1
vote
0answers
19 views

Using #temp to work around Reporting Services blocking issue

Having utterly failed to resolve why a perfectly acceptable but admitidly large stored procedure was suffering the blocking process lck_m_s when called via a report in SQL Reporting Services I have ...
1
vote
0answers
14 views

MySQL database stops working after log enabled

I have this strange issue. I have MySql workbench, which I use to make querries to mysql database (xampp 3.2.1). Everything works fine, but recently I found myself having to profile the querries my ...
0
votes
0answers
23 views

How to design a database structure for different groups of contacts?

I've been looking around for a while how systems manage their contacts. Most I encounter is creating a people or party table including a type to define the type of people/party. These types are either ...
0
votes
0answers
11 views

Amazon rds MySql -> concurrent connections deadlocks

I normally hang around in StackOverflow but I think this issue is better suited here. I've built an application in C#.NET that uses MySql as a database. My application inserts and updates data in the ...
0
votes
1answer
14 views

SqlServer Permission [duplicate]

I installed SQL server, I deleted my windows user account, Now I'm trying to access sql server using administrator account but it could not be connect. It throws error like this(The database TEST is ...
1
vote
0answers
22 views

Database design: Normalizing a “(many-to-many)-to-many” relationship

Short version I have to add a fixed number of additional properties to each pair in an existing many-to-many join. Skipping to the diagrams below, which of Options 1-4 is the best way, in terms of ...
0
votes
1answer
9 views

Why is the OCR&Vote disk group servicing SCAN name

I have installed 11g R2 Grid Infrastructure followed by database software only installation. I have not created any database yet. When I open asmca->diskgroup, I can see the diskgroup which I have ...
0
votes
0answers
12 views

MySQL - How to grant read access to all tables, write access to a few, to one user for multiple databases?

Ubuntu Server 11.04 - a testing server with at least 10 copies of the production code. Each copy has its own database. And there are two sets of database prefixes in operation. There is an add-on ...
1
vote
1answer
19 views

How to make MYSQL smart enough to understand when it should take into account stop word and when it shouldn't?

Ok, here is the problem. I have a table Text text nature .... text2 nature .... a lot of nature ... rows here.. .... go with nature with nature her go it Now, i select: select * From MyFullText ...
1
vote
0answers
26 views

Any idea why this seemingly-simple query is really slow?

Here's the query SELECT count(*) FROM registration r LEFT JOIN registration r2 ON r.baggage_group_id = r2.baggage_group_id AND r2.team_id IS NULL WHERE r.event_id = "102577"; It seems pretty ...
2
votes
2answers
38 views

Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats

I'm trying to troubleshoot some intermittent CPU spikes that we're witnessing on one of our production SQL Servers. We're running SQL Server 2008 R2 Standard Edition with 28 GB RAM and 4 CPU cores. ...
0
votes
1answer
22 views

Can't force mysql to use index

There are many similar questions about force index but mine is something different because i successfully use index at local dev server but can't on production server. I have a table with more than ...
0
votes
0answers
16 views

How can I find which records of `Data Warehouse` must be updated according to CDC captured changes?

I use SQL Server 2012 for OLTP Database and created a Data Warehouse in SQL Server 2012. I design Facts and Dimensions inside Data Warehouse with several Views. Some of my Fact table are made by ...
0
votes
0answers
6 views

Azure database copy seems stuck in a loop

I am attempting to refresh a database using CREATE DATBASE name AS COPY OF server.name. After executing the copy statements, I run the following to track the progress: DECLARE @yup INTEGER PRINT ...
0
votes
0answers
6 views

Can't Add Databases through PHPMyAdmin

EDIT (should've mentioned this sooner): I'm using a Mac, running OS X 10.9.2 Being fairly new to PHPMyAdmin, I thought I was removing settings/privileges for one single user through PHPMyAdmin, but ...
0
votes
1answer
23 views

How do I use a temporary table to generate a template of results and then fill it?

So let's say I have a table, call it 'orders' that looks like this: fields: customer|order_type|price data: "Bob" |"Delivery"|100 "Nancy" |"Delivery"|200 Where customer can be any name, ...
0
votes
0answers
10 views

Azure Copy Database Failed

We have four different environments: DEVINT, TEST, STAGE, and PROD, each on their own Azure SQL Database server. I can copy a database between any two of these, using the command CREATE DATABASE mine ...
1
vote
2answers
54 views

Latitude and Longtitude Distance Calculation

I'm using MySQL and I am trying to calculate the distance in meters between two different longitude, latitude coordinates. I wrote a stored function in MySQL but it calculates just 1 for each row in ...
2
votes
2answers
41 views

Creating Clustered Index uses all my tempdb space. Why?

Table size = 44GB (no clustered index) Row Count = 122016576 Disk space allocated to tempdb = 200MB I wanted to create a clustered index for the table due to slow query times so I ran the ...
0
votes
1answer
15 views

How can I apply heuristics to optimise an expression tree?

I've converted the following SQL query: SELECT name FROM dog d, works_at w WHERE (d.owner_name = w.person_name) AND (w.kennal_name = "Breeders"); into the following expression tree: My main ...
3
votes
0answers
36 views

Restoring differential backup creates DEFUNCT log file?

Here is my problem. I'm trying to move a database to a new server via a full restore, then cutover with a quick differential backup/restore. I can do a full restore without a problem, but when ...
0
votes
1answer
9 views

Oprhaned entries in msdb..sysjobactivity

In this question: http://stackoverflow.com/questions/18445825/how-to-know-status-of-currently-running-jobs This answer was proposed: SELECT sj.name , sja.* FROM msdb.dbo.sysjobactivity AS sja ...
-1
votes
0answers
18 views

?deactivate facebook for multi-site forcing reactivation site-wide? [on hold]

I am connecting to a remote mysql database of my wordpress-website using SSH and mysql-workbench, and have found "key 32228 - facebook activated - wp_databasetab3_changes_tracker". Can I deactivate ...
0
votes
0answers
14 views

ODBC Crash try add a DSN System connection

I get the following error: odbc administrator a problem caused the program to stop working correctly. The windows will close the program and notifies you if there is a possible solution I get ...
1
vote
1answer
34 views

How Automatic Failover Works (AlwaysOn)

I'm going to use AlwaysOn technology on my servers, but it's some unclear points in the documentation: Automatic failover looks like Primary replica (A) unaccessable Secondary replica (B) becomes ...
1
vote
1answer
28 views

Reasons for db2 foreign key error (-667) despite all rows appearing sane?

I have some csv formatted table dumps and loaded those into a new database with the tables defined by a DDL script from the source database (both acquired by somebody else so I cannot have a look at ...
-2
votes
2answers
42 views

Index is not used with same Query on two Servers

I have two notebooks with same specs (same model, only ram is 24GB/32GB, same ssd) and exact same database and same sql server version. SQLIO is 3300 and 3600. Now I run a query on one notebook and ...
0
votes
1answer
13 views

Why can't I access IIS Manager on my server with Reporting Services installed?

I have a Windows Server 2008 Server running SQL Server 2012 (including SSRS). I've noticed that the site is intermittently slow on first run, and found this blog post about the cause and how to fix ...
1
vote
1answer
24 views

Optimistic Paging and separate query for COUNT?

I am using SQL SERVER 2012 FETCH/OFFSET after searching a lot that this will give me the best performance. But for paging to work, I need a Total count. There are 2 ways to achieve this. 1) Paging ...
0
votes
1answer
22 views

Check for table corruption

I monitor MySQL databases by querying various things remotely. I recently came across an issue where by a table had become corrupted but I did not know about it until the daily mysqldump failed. Is ...
0
votes
1answer
57 views

Problem with mysqldump and view

When using mysqldump to backup MySQL, I got following error. mysqldump --all-databases --routines >> all.sql mysqldump: Couldn't execute 'show table status like 'hdkien'': SELECT command denied ...
1
vote
2answers
35 views

Order of maintenance plan tasks

Please could you tell me the correct order of maintenance plan operations in SQL Server? Check integrity Update statistics Rebuild indexes Is correct this order?
1
vote
2answers
42 views

Casting fails on subquery result

I'm in a bit of a pickle, I have to perform a query on a database with rather poor data quality. I am trying to evaluate a field which contains a date, but which was defined as a nvarchar. I thought I ...
0
votes
0answers
5 views

Slony-I creation scripts not available; only joining possible

I try to start Slony replication. I have PostgreSQL 9.3.4, PgAdmin III 1.18.1 and Slony-I 2.2.0-1. I have set the path to Slony to D:\GIS\PostgreSQL\9.3\share where I have the Slony files. Whenever I ...

15 30 50 per page