0
votes
0answers
5 views
Properly index magento mysql tables to improve specific query performance
I am running magento community edition and its db performance is horrible. I have the following query:
SELECT `width_idx`.`value`, COUNT(DISTINCT width_idx.entity_id) AS `count` FROM ...
-2
votes
1answer
18 views
Oracle database and data has been corrupted. Is there a way to get it back?
The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
1
vote
1answer
23 views
checksum(newid()) as primary key - what happens if a collision occurs?
Inspecting a rather critical database that is used by some software on my system, I found that one of the tables had a primary key on the column Id, where Id is calculated using checksum(newid()). ...
2
votes
1answer
14 views
Best strategies to have a backup of an RDS MySQL database
I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited.
I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup.
I know ...
1
vote
0answers
24 views
Merging two Access tables into one
I have mostly identical tables, however there are slightly differences like missing columns in older ones. I want to merge 5 tables into one. Is there any easy way to do this?
7
votes
2answers
82 views
Is there any way to prevent the memo structure from being pruned?
We know that the memo structure is pruned and some expensive alternative plans are discarded during optimization. I was wondering if there is any way to prevent this and let the optimizer just ...
3
votes
1answer
27 views
How to dive into the PostgreSQL's optimizer and trace each step it takes to optimize the query?
Just like the MEMO structure in SQL Server which is kind of a "paper trail" of steps the optimizer takes in optimizing the query. Does PostgreSQL have the similar structure which records steps the ...
0
votes
1answer
28 views
MySQL Workbench - question about creating FK relationships
Forgive me a little new at databases and I came across something while working with Workbench that I have a question on.
In a very simple testing database, with three tables: Company, Department, ...
1
vote
2answers
46 views
Update my local db based on scripts executed in my server database
I need to create an solution that update my local db version based on changes that was made on my server database.
First, I need to check the differences that has exists between these databases and ...
1
vote
2answers
16 views
Restore database created in SQL Server 2008 R2 to SQL Server 2008 R2 SP2
I have a .bak file created by some other user in (I think) SQL Server 2008 R2 (10.50) and I need to restore it in SQL Server R2 SP2 (10.52). I used a hex viewer to look into the .bak file and found ...
1
vote
0answers
20 views
pg_restore and psql asks password for restoring dump file
This will be probably extreme novice question but I want to restore a .backup dump file. I have tried the following command:
pg_restore -i -h localhost -p 5432 -U postgres -d old_db -v ...
1
vote
0answers
18 views
PowerPivot doesn't install in SharePoint mode on an Active/Passive Cluster
We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration ...
-2
votes
0answers
14 views
How to fix error: Connection is busy with results for another hstmt (SQL-HY000) [closed]
Connection is busy with results for another hstmt (SQL-HY000)
2
votes
1answer
40 views
Start service error code 3417 with SQL Server 2012
I cannot start the SQL Server 2012 service. The event log says the service-specific error code is 3417.
In the Event Viewer:
The SQL Server (MSSQLSERVER) service terminated with the following ...
2
votes
1answer
17 views
Will creating a view on a MySQL replication slave break the replication?
We need to run some very ugly queries on a MySQL replication cluster.
Does anyone know if creating a view directly on the slave will break the replication of the other, otherwise untouched data ...
0
votes
0answers
7 views
Postgres backup and WAL to S3
We are looking for a solution for the following problem:
We have set up streaming replication so we have a master DB and a slave DB, we want to have basebackups and WAL files sent to our S3 storage ...
3
votes
1answer
27 views
SP with Encryption Read/Writes Stats
If a stored procedure in SQL Server 2005 is created with the syntax "WITH ENCRYPTION" ,are the reads and writes of the encrypted stored procedure recorded in the sys.dm_db_index_usage_stats? I am ...
0
votes
1answer
27 views
SQL Server TDE - add master key and certificate [closed]
I want to add multiple master database encryption keys and certificates.
Can I do that?
2
votes
2answers
22 views
MySQL many to many relation
Sorry is this seems a stupid question, but I have a table of server addresses and a second table with a list of hardware devices which use the addresses, it is possible for multiple devices to use the ...
1
vote
2answers
34 views
Approaches for deleting unnecessary records from tables
We have a database which stores the temperatures of 20 thermometer every 7 seconds. We want to delete all records in the way that every minute holds just one tempereature instead of 8 which are older ...
2
votes
1answer
13 views
Percona Node fails to join: Operation not permitted
Joining a new Percona node fails with:
130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
1
vote
2answers
40 views
Need an Oracle query to get the Oracle Home directory for a particular instance
I am searching for a query to get the Oracle Home for a particular instance name, say Eagle (if there are more than one instance on the host).
3
votes
3answers
62 views
One filegroup, multiple datafiles, how to get list of tables in each file
In one of my production databases, I have a filegroup with 3 data files sitting on 3 different disks. There are over 50 tables on this filegroup.
How do I identify the location of each of the 50 ...
2
votes
1answer
16 views
Why does postgres use more space for a time with timezone than a timestamp with timezone?
The documentation on date/time data types state that timestamp with timezone takes 8 bytes, while time with timezone takes 12 bytes. They both have the same resolution (1 microsecond), and on the face ...
3
votes
0answers
18 views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
0
votes
0answers
22 views
Oracle 11gR2 DBCA installation failing with TNS Lost contact
I am getting below errors while running DBCA with silent install using response file
ORA-12547: TNS:lost contact
PRCR-1079 : Failed to start resource ora.ocl.db
It's a fresh installation and not ...
1
vote
1answer
20 views
How to restore IBM DB2 database from AIX to Windows?
I had made backup from remote IBM DB2 server in AIX using this command:
./db2 backup database DBEMP to /home/dbemp/backup
Then I grab the backup file using FTP Client from my Windows.
I run this ...
2
votes
0answers
27 views
Server permissions of an activation stored procedure of a Server Broker queue
I have a stored procedure that queries the sys.dm_exec_requests view. In the stored procedure the view only returns one row, while the stored procedure needs to see all of them. The MSDN article on ...
0
votes
1answer
45 views
Creating oracle database physical files from migrated DB
I migrated a database from SQL Server to Oracle 11g and there doesn't seem to be any physical files created after migration.
The client requires that they receive a copy of the database so they can ...
-1
votes
1answer
26 views
Why does fn_my_permissions return empty rowset? [closed]
If I run this query:
select * From fn_my_permissions(NULL, 'SERVER')
This is what I'm getting:
entity_name subentity_name permission_name
------------- --------------- ...
2
votes
1answer
35 views
Is this a good strategy for importing a large amount of data and decomposing as an ETL?
I have a set of five tables (a highly decomposed schema for an ETL if I understand the nomenclature) that I'm going to load via bulk import, then run some inserts from those five tables into a SLEW of ...
4
votes
1answer
63 views
Is it “legal” TSQL to CREATE TABLE #SomeTable and then DROP TABLE #SomeTable repeatedly in a script?
Is it "legal" TSQL to CREATE TABLE #SomeTable and then DROP TABLE #SomeTable repeatedly in a script?
I've got my code sort of segregated as "coherent blocks" that I can insert into a longer ...
0
votes
1answer
18 views
ERROR 13 (HY000) When Creating Database
I'm trying to create a database and when I type in CREATE DATABASE epik; I get the error ERROR 13 (HY000): Can't get stat of './epik' (Errcode: 13) I am running kubuntu 13.04 with mysql 5.5.31.
6
votes
1answer
43 views
Dropping Hypothetical Indexes
In the past I thought I'd deleted hypothetical indexes using either a DROP INDEX statement for clustered indexes and DROP STATISTICS statement for non-clustered indexes.
I have a database that is ...
-2
votes
0answers
27 views
INNER JOIN for DAX [closed]
If I have two tables to make a inner join (many to many), is it possible to do it by using DAX?
Please remember that duplicate of data row exist in these two tables.
1
vote
0answers
22 views
Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?
I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server.
The backup was done two days ago and the restore database command was working on the same ...
3
votes
1answer
44 views
Convert SQL Server 2012 SSIS package to 2008
I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state.
Is there a way to convert the 2012 packages to ...
2
votes
1answer
17 views
can rman backup a subset of a table
I have been asked to make incremental backups of a table based on the value of one of the fields in the table (called groupid). They want a separate incremental backup for groupid=1, groupid=2, ...
1
vote
2answers
38 views
Replicating schema changes between production and development databases [duplicate]
Not too sure if this would be a good and proper way to go about things, so I apologize if I'm kind of far off.
Currently running Microsoft SQL Server 2005, and in this we have a database for a ...
3
votes
3answers
83 views
Backup very large table
I'm deeply sorry if this is an amateurish question, but I have to update certain values of a large table (for the sake of a presumed example, it is called 'Resource' and it is over 5M rows) and thus I ...
2
votes
4answers
34 views
Backup very large table in SQL Server
everyone.
I'm deeply sorry if this is an amateurish question, but I have to update certain values of a large table (for the sake of a presumed example, it is called 'Resource' and it is over 5M rows) ...
2
votes
1answer
11 views
How to schedule PostgreSQL replication?
I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen.
I'll be using postgres internal replication solution but as far as I ...
-2
votes
0answers
24 views
Connecting To Oracle with D2K & PHP [closed]
I've D2K installed on Windows XP [client] and Oracle 9i on the server. How to connect to the database using PHP ? Installing Oracle on the client is not an option !
0
votes
0answers
29 views
Do certain string patterns affect query performance on a VARCHAR column?
I am a beginner on MySQL Administration and performance problems. Now this is confusing me.
I have a VARCHAR column identity, the string in it is consisted of a Class type and an id, like note:123, ...
1
vote
1answer
16 views
Finding oracle physical database files
I'm using oracle 11g and I need to find the database files to copied to another server. The database was created from migrating from SQL Server 2008 to 11g. There doesn't seem to be a counterpart for ...
1
vote
1answer
18 views
MySQL Workbench connect to MS Access
I have a .mdb file on my computer that I would like to convert into a MySQL Schema and I have found that there is a migration tool within Workbench. However it doesn't seem to allow you to connect to ...
1
vote
6answers
44 views
Best practices with large amount of data
I'm building a solution and I have a question.
All my data is currently stored in a unique table. Each row of data is associated with a type.
My question is, what's the best practice for defining a ...
2
votes
0answers
28 views
Failover only working for Classic ASP, not ASP.net
Setup:
All machines run Windows Server 2008 Enterprise
SQL Server 2012 Standard (Primary)
SQL Server 2012 Standard (Mirror)
SQL Server 2012 Express (Witness)
Root issue: Our ASP.NET application is ...
6
votes
2answers
59 views
Is there any way to trace optimizer's work in MySQL?
Just like the MEMO structure in SQL Server which is kind of a "paper trail" of steps the optimizer takes in optimizing the query. Is there anything in MySQL through which I can get the information ...
-1
votes
1answer
63 views
Query returns no data [closed]
I am running a query to show LastName and Hire_Date and my results display the columns but do not include any data. This is an assignment for an online class and I have been waiting for my instructor ...
