3
votes
1answer
1k views

Query taking long on table with low record count

I have an Oracle flat table that grew to just below 800MB. The table was truncated and new records are being inserted. Currently there are <40 records in the table but a select * takes >30secs. ...
2
votes
2answers
3k views

Advanced Replication vs Oracle Streams

I'd like to know what is advantages of Streams over Advanced Replication. I wanted to use updatable materialized views on my project, but on one forum I read comment that if we don't use very old ...
9
votes
3answers
3k views

Used Memory not freed up after a SQL BULK Insert / BCP Export

I have created a very basic SQL table as following CREATE TABLE [dbo].[TickData]( [Date] [varchar](12) NULL, [Time] [varchar](12) NOT NULL, [Symbol] [varchar](12) NOT NULL, [Side] [varchar](2) ...
2
votes
2answers
6k views

remove duplicate rows in mysql table that does not contain primary key

I have a table item having just one column name:- name ----- toys shirt mobile Shirt speaker Toys .... .... I am trying to delete duplicate rows except one duplicated record with the help of below ...
0
votes
2answers
3k views

Oracle database link to MySQL database on RedHat Linux

I have an Oracle 11g database on a RedHat server and also have MySQL database on another RedHat server. I want to create a link to the MySQL server from the Oracle which allows me to execute queries ...
2
votes
1answer
2k views

MySQL's “slow query” log: strange “Query_time”

I need some help understanding what's going on with my "slow query" log in MySQL. I have set set global long_query_time=3 and yet this is what I see in the slow query log: # Time: 120723 9:04:38 ...
2
votes
1answer
352 views

Problem with shortest distance calculation in PostGIS

While working with PostGIS pgrouting, for calculating the distance between two roads (lines) I'm using the shortest_path function. The logic is based on start_point(Start_id) and end_point(end_id) ...
-1
votes
1answer
491 views

Multi-Tenant Database Schema Creation [closed]

I need to create a Multi-tenant schema. I have searched a lot, but I haven't got any concrete solution to create one. Any example would be highly appreciated. I'm using SQL-SERVER 2008. I need to ...
5
votes
1answer
7k views

SQL Server has encountered 1 occurrence(s) of cachestore flush

On one of our production server log files, the following message is being observed on daily basis. What does it mean? Is it a serious issue? SQL Server has encountered 1 occurrence(s) of ...
0
votes
2answers
142 views

Import data problem in SQL Server 2008

I want to import data from one database to another. On the destination database, I don't have permission to restore a backup file to it, so I have only one option which is to import data. I used the ...
0
votes
3answers
466 views

Is adding rows better then adding columns in case their value is not consistent?

In my project I have a table of customers, each customer has his own special price for each product, It's a small business and there are currently about 5 products. The manager says there might be ...
5
votes
2answers
5k views

Need suggestions for best way to archive MySQL (InnoDB) tables

Problem: I have two fairly large tables. A 'wall' table for messages between users with 9 million rows at 2 GB and a 'chapter' table at 2 million rows and 18 GB. I want to keep the number of active ...
1
vote
1answer
580 views

Error in SQL syntax

SELECT CONCAT_WS(' ',child_fname,child_sname) AS 'Child Name' , child_gender AS 'Gender' , child_dob AS 'DoB' , COUNT activity_name AS 'Activities name' , CONCAT_WS(' ', ...
3
votes
2answers
8k views

Troubleshooting Oracle ORA-08103 - object no longer exists

I am getting this error from Oracle intermittently. A trigger is truncating a partition from a partitioned table while a long-running query is running against it. Since I'm truncating a different ...
9
votes
3answers
17k views

How to get the most out of MySQL on a QuadCore machine with 16 GB of RAM?

I'm running a MySQL 5.5 server on my workstation for scientific data analysis and wonder how to configure MySQL in order to get the most out of it performance-wise. The types of query that I typically ...
3
votes
1answer
438 views

ETA: translate Oracle SQL queries to MySQL

task: replace Oracle 11g with MySQL current setup: Oracle 11g SE One about 80 tables stored procedures, PL/SQL are in place but out of scope for this question client applications do not use a ...
2
votes
0answers
306 views

The time stamp counter of CPU on scheduler id 13 is not synchronized with other CPUs

On one of our production server, SQL Server log is continuously showing the following error: The time stamp counter of CPU on scheduler id 13 is not synchronized with other CPUs. What does it ...
2
votes
0answers
210 views

Can't access a specific database from phpMyAdmin

I've installed WAMP on a computer some months ago. Now I'm trying to use it and I was trying to surf the databases using phpMyAdmin. So I went to localhost/phpmyadmin and it showed me the databases. ...
3
votes
1answer
76 views

Merge queries into one

The following 2 queries are working as expected and they show the count. Is it possible to merge them into single query? I need sum_hits columns to be part of the rest of the column shown in the ...
2
votes
1answer
680 views

How to troubleshoot COPY FROM inserting less rows then expected?

I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to wc -l, which I want to import using COPY FROM. I removed the table's primary key, so it has no constraints. I ran COPY ...
5
votes
3answers
13k views

Understanding Oracle's ALL_TAB_COLUMNS

I'm new to Oracle and database administration in general. As context, I want to create a Java class that will give me the information I would get using DESC SOME_TABLE. I cannot find any specific ...
4
votes
1answer
475 views

NuoDB with Amazon S3

I think about developing my new mobile and web app against NuoDB. I believe in their technology. The thing that I care the most is backup and restore in case of data corruption and read / write speed ...
3
votes
1answer
2k views

Good articles for SQL Server Health Check specifically for Web Applications

I am searching for Database Health check articles specifically for a web application back-end server and SQL Server 2005/2008. My current checklist includes: - Index Fragmentation - SQL Server ...
5
votes
1answer
169 views

Security implications of guest account and database chaining on sql server?

I have another database Ydb accessing data in database Kdb. They both have the same owner. In order to allow cross database chaining, it seems I need the guest user to be enabled in Kdb. I did so ...
2
votes
2answers
134 views

CPU or Page Reads

While comparing query performance should i go for CPU values or Page Reads. On live server (with better hardware) a query is showing different CPU when i test it on my local machine. But Page Reads ...
5
votes
2answers
1k views

Log Reader replication agents are constantly restarting

I am recreating (push) transactional replication from a SQL 2000 instance to a SQL 2008 instance which I had to break in order to do a db migration. The 2008 instance is both the distributor and a ...
3
votes
1answer
276 views

Why are my queries getting really slow?

I own a WordPress installation, and Updated to 3.4.1. After the upgrade, I experienced a very strange slow-down. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
4
votes
1answer
3k views

Setting up replication for MyISAM tables?

Before setting up a replication within MySQL, the data first needs to be transferred to the slave. Since MyISAM tables can be copied as files. Would it be okay to copy MyISAM files, .myd .myi .frm, ...
5
votes
2answers
394 views

Databases entering “In recovery” mode on restore

I am facing an issue while restoring the database. I have many dump files in a folder and I try to restore them one by one to a database xyz, perform some update operation and continue my restore ...
6
votes
1answer
4k views

Downsides to using SQL 2012 Upgrade as opposed to a fresh install?

I currently have SQL Server 2008 R2 which I would like to upgrade to SQL 2012. I can either un-install SQL 2008 and install a new copy of SQL Server or run the Upgrade. The upgrade is less work but I ...
3
votes
0answers
413 views

need help finding the details of a deadlock

We are having issues with deadlocks and I am trying to isolate what database object is causing the problem. I found Deadlock error isn't returning the deadlock SQL to be very helpful and I read ...
4
votes
1answer
141 views

Where to place non clustered index

Execution plan clearly showing that one of my table used in query is useing Clustered Index Scan. From this node, how can i guess that which columns should be part of my non clustered index key and ...
4
votes
1answer
2k views

InnoDB : Deadlock from one reader and one writer

This sort of has me miffed. One query is doing a select that includes a table that is undergoing a heavy UPDATE, but that update takes under 1/2 a second, and there are no other writers to that ...
18
votes
2answers
3k views

Why do wildcards in GROUP BY statements not work?

I am trying to make the following SQL statement work, but I get a syntax error: SELECT A.*, COUNT(B.foo) FROM TABLE1 A LEFT JOIN TABLE2 B ON A.PKey = B.FKey GROUP BY A.* Here, A is a wide table ...
3
votes
2answers
943 views

Extract query fingerprints and tables from large log files using pt-query-digest

I tried to parse a large log file using pt-query-digest but it gives "Out of memory!" when I try to read the file. I have 3GB RAM, 40GB empty space on HDD, the file is 20GB. I did not found anything ...
11
votes
2answers
1k views

When do I need to backup the Service Master Key?

I'm reading some documentation and whitepaper about Transparent Data Encryption. Some documentation mention to backup the Service Master Key as well (For clarification I'm not talking about the ...
2
votes
1answer
1k views

ON DELETE cascade alternate

I am trying to create a database for 2 Tables like: Table1 : tb1-id(pk) | tb2-id | other Table2 : tb2-id(pk) | other FOREIGN KEY Table2(tb2-id) REFERENCES Table1(tb1-id) ON DELETE ...
14
votes
3answers
15k views

Why am I getting `Impossible WHERE noticed after reading const tables` in explain query?

I have a unique compound key like fr(fromid,toid) in the table, when I run the query with explain I get the following result: Impossible WHERE noticed after reading const tables` The query I ran: ...
1
vote
1answer
160 views

Reviewing all new MySql queries on staging environment

The problem I am trying to solve: It's well known that not all developers know what is EXPLAIN in MySql, and not every knows how to use it. Large part of them consider MySql as a black box, no matter ...
5
votes
1answer
159 views

Always being logged in as SA and not Windows account

First off i would like to appologise if i sound stupid as i do not have much knowladge of SQL Server. I have recently started a project working with SQL Server 2008 R2. I have access to the database ...
7
votes
1answer
669 views

What would be a good name for a job schedule?

I have encountered many different names for job schedules in SQL Server, ranging from the job name where it is used to a short recap of the schedule itself. I would like to give a clear, descriptive ...
3
votes
1answer
8k views

Is it possible to do a datapump import with a different user than did the export?

I have one db dump below is the log file for that dump Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
5
votes
1answer
10k views

InnoDB - High disk write I/O on ibdata1 file and ib_logfile0

Server Specification: VPS with following info model name : Intel(R) Xeon(R) CPU E5649 @ 2.53GHz MemTotal: 2058776 kB MemFree: 244436 kB We are running IP.Board from Invision ...
8
votes
1answer
446 views

What does duration measurement in sql server actually measure?

What precisely does the query duration measure when conducting a profiler trace? I have a stored procedure which performs data access (SELECT), and it is taking an average of around 30 seconds to ...
4
votes
1answer
539 views

Using indexes to create multiple relationships to a table in order to enforce data integrity and add meaning

I'm working on an inventory database that uses supertype/subtype model. My question regards creating multiple relationships with the same tables using the primary key and composite indexes that also ...
1
vote
1answer
65 views

What is really wrong with this query please? [closed]

SELECT CONCAT_WS(parent_title, parent_fname, parent_sname) AS 'Parent' CONCAT ('£1.50', sum(activity_price) AS Amount, COUNT(*) AS 'N.Activities' FROM Activities A, Parent P, Child C, Register R WHERE ...
4
votes
3answers
3k views

SQL Server 2005 Tools makes SQL Server 2008 Express install fail

When I tried installing SQL Server 2008 Express, the install failed due to this line. How can I circumvent this, or fix the issue?
7
votes
1answer
1k views

Service Broker: Queue Monitor is dropped after poison message

I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer. When I setup event ...
6
votes
2answers
4k views

Column definition for a SQL Server equivalent to Access BOOLEAN type

The BOOLEAN datatype in Access (ie, Jet/ACE) returns a -1 for True and 0 for False; the field is always required (i.e., it cannot be set to NULL). The SQL Server BIT type returns 1 for True and 0 for ...
4
votes
1answer
90 views

Is it possible to enlist a TSX to an MSX in a different domain?

In Domain1, I have an MSX with 75+ TSXes registered. Now I've been given some SQL Server instances in another domain. Is it possible to enlist Domain2 instances to an MSX in Domain1 ?

15 30 50 per page