-2
votes
0answers
27 views

Creating Mview in Oracle is throwing error

I keep on getting error when I try to create a fast refresh materialized view. Not sure what is the cause of getting the error. ---PREBUILT TABLE--- Create table k_dim_mvw( id NUMBER(10), time ...
0
votes
0answers
15 views

Excel connecting to SQL Server Database and editing tables [on hold]

I would need to connect from within Excel to a SQl Server table and to be able to edit and update the table rows using that excel. Is there a simple way of doing this without having to write ...
1
vote
1answer
48 views

MySQL Index Creation Internals

Right now there are two ways to build an index of a table in MySQL: Create the table structure first, then import the data and add indexes later. Create the table structure with indexes and then ...
0
votes
1answer
21 views

How to remove data from multiple tables with different foreign keys without using ON DELETE CASCADE?

I have the following SELECT statement: SELECT * FROM "Users" u INNER JOIN "Calendars" c ON (u."UserId" = c."UserId") INNER JOIN "Actions" a ON (c."CalendarId" = a."Calendar_CalendarId") WHERE ...
1
vote
0answers
37 views

MySQL bulk deletions

I am currently looking at how to most efficiently delete rows from a table in bulk. The database I'm using is MySQL with innodb. The table I want to delete from can be any size, but will usually be ...
0
votes
0answers
7 views

Cassandra - save file

I'm new with Cassandra, and even more - I never have such task for habitual RDMS systems, like MariaDB or Oracle. So, how can I store file in to Cassandra's table? Preferably using Python-driver, but ...
7
votes
1answer
363 views

Why is SELECT * much faster than selecting all columns (in a different column order) by name?

On a table with columns a,b,c,d,e,f,g,h,i,j,k I get: select * from misty order by a limit 25; Time: 302.068 ms And: select c,b,j,k,a,d,i,g,f,e,h from misty order by a limit 25; Time: 1258.451 ms ...
0
votes
1answer
15 views

Cannot overwrite file: /var/lib/mysql/ibdata1 when using Percona xtrabackup

I am receiving an error when I am trying to restore from a percona backup to my local mysql server. Cannot overwrite file: /var/lib/mysql/ibdata1 at /usr/bin/innobackupex line 2128. sudo ...
-3
votes
0answers
20 views

best software to run Oracle code [on hold]

what kind of software is best to download on PC with Windows OS to practice in writing and running code in Oracle (let's say at school or for preparing for certification)?
1
vote
0answers
18 views

Certification Test 70-461 [on hold]

I am a student at University of Houston-Downtown and looking to take the Database Administrator certification test sometime in October. I am hoping that someone has been recently been certified or ...
2
votes
1answer
15 views

'sp_releaseschemalock' causing me a blocking issue?

why 'sp_releaseschemalock' causing me a blocking issue? what proccess that must execute sp_releaseschemalock or what function of sp_releaseschemalock? I have searched various forums or blogs about ...
1
vote
0answers
31 views

Postgres not using the index even when rows returned is 5% of the table

I have a postgres table with the following structure: +---------+-------------+-------------+----------+---------+---------+ | id | timestamp | numvalues | text1 | text2 | text3 | ...
0
votes
0answers
17 views

Got an error from unknown thread, /pb2/build/sb_0-13157587-1410170252.03/rpm/BUILD/mysql-5.5.40/mysql-5.5.40/storage/myisam/mi_write.c:226

I am using mysql 5.5.40-log and my default storage engine is Innodb, I found this error in my error log "[ERROR] Got an error from unknown thread, ...
1
vote
1answer
49 views

Why does MS SQL Server return a result for empty string check when Unicode string is not empty

select * from (select N'ግዜ ' as t) as t2 where t= '' the string 'ግዜ ' matches the above check, why is this?
0
votes
0answers
10 views

Database design question for sorta rookies [on hold]

Are there any books or Github examples of how to design a database for use with an android app. Specifically the user will be logging into the app via mobile device or Web browser. I imagine aside ...
0
votes
0answers
12 views

how to do a backup and restore for a single database with mysql enterprise backup

I am Chinese, the documentation of mysql enterprise backup is hard to understand for me, and now I need to finish my job quickly, I wonder is that possible to backup a single database and restore it ...
-1
votes
2answers
17 views

psql: could not connect to server and socket /var/run/postgresql/.s.PGSQL.5432

I have installed postgresql 9.4 and I removed postgresql 9.3 from my computer. Now when I try to run: foo@bar:~$ psql I get the error psql: could not connect to server: No such file or directory ...
0
votes
1answer
14 views

SQL Server Express 2012 Repair

I have a copy of SQL server Express 2012 database which may be corrupt. When I tried to run a repair on it I was asked for the original installation media. The Options were for an MSI or ISO image. ...
0
votes
0answers
7 views

Unable to import database through osm2pgrouting

I am very frustrated by the following errors while trying to import NewDelhi by osm2pgrouting tool: osm2pgrouting -file "/home/user/Downloads/new-delhi_india.osm" -conf ...
0
votes
0answers
5 views

Cannot access MS Access DB with non-Admin users

I have created several users in a MS Access database using "User-Level Security Wizard" in Access 2013. The problem: I am only able to log in with users belonging to Admins group. Other users ...
0
votes
0answers
18 views

could not open log file “/var/log/postgresql-2015-05-24_181212.log”: Permission denied

I installed postgresql from source on Ubuntu 14.04 (I also installed from repositories too before, I just want to get a feel for both of them right now, as I will heavily rely on this database). So ...
0
votes
0answers
12 views

How to create a procedure by using the existing procedure in oracle 11g? [on hold]

Can anyone please tell me? How to create a procedure by using the existing procedure? ( SQL DEVELOPER ) Thanks! Arunkumar.
0
votes
0answers
17 views

MySQL Cluster - Adding more storage space

I have spent a few days looking into different MySQL Cluster options, such as Percona and MariaDB Galera, however from what I understand neither of them can do what I would like it to do. What I am ...
0
votes
1answer
26 views

Multiple database directories with postgresql

I installed postgresql from source on Ubuntu 14.0.4. It is located in /usr/local/pgsql. At first, I created a data directory at /usr/local/pgsql/data and then ran initdb -D /usr/local/pgsql/data I ...
0
votes
1answer
20 views

JDBC local MSSQL Server connection string

I have installed open source database management tool "dbeaver" and want to use it instead of Sql Server Management Studio. But there is a problem. I searched from the internet but somehow I could not ...
3
votes
1answer
65 views

How to check foreign keys related to a table

How to see foreign keys related to a table in MySql? Background : I wanted to drop a table in MySql which has a foreign key constraint. When I do it I get this: Error Code: 1217. Cannot delete or ...
-1
votes
2answers
27 views

Double entry bookkeeping database design

I'm doing an accounting software and I need to enforce double entry bookkeeping system and I have the classical problem of 1 row per transaction versus 2 rows. Lets take an example and see how it ...
2
votes
1answer
42 views

How to archive a whole database?

I have a database that is not going to be used anymore but that needs to be kept around for a long time. I'd like to remove it from the production system. My goal is to save storage space when ...
1
vote
1answer
56 views

When Should You Shrink Your Database

I have read conflicting articles about shrinking a databases. Basically, our database grew 100% overnight from 150 gigs to 300 gigs b/c I believe it was with staging tables I put in. However, all the ...
0
votes
0answers
15 views

hashed password retrieval in mysql

here I am again with the next question! I hash a password as follows: mysalt=os.urandom(12).encode('hex') passhash =mysalt + pw hash =str( pbkdf2_sha256.encrypt(passhash)) How can I verify this ...
0
votes
0answers
18 views

SQL Server hangs during backup on EC2

Once and then our SQL Server will "hang" during its weekly full backup. When this happens, external connections start to timeout. The symptoms are: Connections timeout The sqlservr.exe process sits ...
0
votes
0answers
12 views

What could cause 300+ connections from a simple query in MySQL?

I am retrieving results from a table in MySQL 5.5. When I run even a basic query on this table hundreds of connections are shown in the Server Status screen in MySQL Workbench. Even for a simple query ...
1
vote
0answers
23 views

Uninstalling MS sql server 2012 issues

I'm trying to uninstall ms sql server 2012. But when I click Microsoft SQL Server 2012(64 bit) and choose remove option it shows like this. Then how can I remove the MS SQL Server 2012? Please help. ...
0
votes
0answers
7 views

Post categories model for a user submission wedbsite

I'm building an user submission site where users can make posts to content_types: Blog, Movies, Photos, Forums. Since these content types only have slight variances I would like to keep them in one ...
1
vote
1answer
29 views

Oracle: Recover source code/table structures from “utterly wiped out” development database

Given an Oracle 11.1 database used for development, running in NOARCHIVELOG mode, where all datafiles (including undo) have been wiped out; and only SYSTEM and SYSAUX datafiles and control file remain ...
1
vote
1answer
113 views

Dealing with Difficult DBAs [on hold]

At one point, test database deployments within my department were handled directly by the database developers. The typical process was that the developer would unit test their changes in the ...
0
votes
0answers
18 views

Filesort when using view

I am sorry for asking, but I can't figure what i am doing wrong and filesort appears in my explain. The id column that I use for sorting in the following examples is a primary key... If I create ...
3
votes
1answer
57 views

How is encoding done in SQL database tables for pattern matching?

Are strings in table columns represented as bit patterns or Unicode? Does the database engine bring them into memory in a different representation character set from the disk-persisted ...
2
votes
1answer
34 views

Deferrable Foreign Key Constraints

What are the consequences of making a foreign key constraint DEFERRABLE INITIALLY IMMEDIATE instead of NONDEFERRABLE? This answer on StackOverflow mentions the performance impact that comes with no ...
0
votes
0answers
13 views

Working on a blog creation website; should I be creating a new table for each blog, or keep everything on the same table?

So I'm working on this blog creation website as a side project. I don't actually expect it to become anything, but I want to make it as efficient as possible, even if just for practice. The idea is ...
0
votes
1answer
35 views

How to execute two transactions concurrently in PostgreSQL?

I want to execute two transactions concurrently in pgAdmin: --The first transaction should modify the age of Paul BEGIN; DECLARE newage INTEGER; --the original age of Paul is 32 newage := Select age ...
-1
votes
1answer
49 views

Grouping based on the status, then count its product and the total based on its category ID

I have a table with product ID, category ID and status of the product. +---------+-------------+-------------+ | id | cat_id | status | +---------+-------------+-------------+ | 1 ...
1
vote
1answer
22 views

Creating a global temp table in a SQL Agent job

I want to create a global temp table in a SQL Server Agent Job. Here is the code: CREATE TABLE ##TestEmployee(Id int, EmployeeName nvarchar(50)) When I execute in SSMS, all is well. I then put ...
0
votes
1answer
11 views

PostgreSQL ODBC and Microsoft Access date/time in aggregate functions

I am trying to replace our MS Access 2003 databases with PostgreSQL 9.3. The first step is to use our MS Access front end to the upsized databases in PostgreSQL. Everything seems to work very well ...
0
votes
0answers
28 views

Performance impact of IF @@TRANCOUNT > 0 COMMIT TRAN

I'm dealing with some performance issues on SQL Server 2012. The client application indicates that the SQL time to load a page is over 2.5 seconds with a total loading time of more than 3 seconds. For ...
-1
votes
0answers
21 views

TCP Provider: The semaphore timeout period has expired

In Sql Server2008 R2 and Windows Server 2008R2, when I start Replication I have this error: TCP Provider: The semaphore timeout period has expired Please help me to solve it... Thanks!
0
votes
0answers
19 views

For any SQL query, do there exists a unique translation into relation algebra

I have been studying databases and I understand that for each query that a database user type, the DBMS translate them into relational algebra operations before applying them to the database. My worry ...
0
votes
2answers
23 views

understanding mysqldump auto-backup performance issues and inner functionality

Is there a performance issue, if I run a cronjob in background with mysqldump --single-transaction with a 60 seconds interval? Will my original database keep functioning without an issue while the ...
1
vote
0answers
35 views

SQL Server 2008R2 to SQL Server 2012 Install

I'm trying to upgrade one of my SQL servers from 2008R2 to 2012 and I'm getting an error popup within a couple of seconds from starting the setup The Error is TITLE: SQL Server Setup failure. ...
1
vote
0answers
26 views

Compatibility Level

I have a Database from SQL Server 2008 R2 which I recently updated to SQL Server 2012, since I migrated the SQL Database from 2008R2 to 2012, our application connected to it became slower. What I'm ...

15 30 50 per page