1
vote
1answer
27 views

Is it possible to restore a MySql database only using files from Data directory?

I have a mysql installed inside a windows virtual machine. The hard drive was crashed and the system is not able to restore all again. But I can have access to entire c: ROOT. So I went to ...
1
vote
1answer
41 views

SSRS Blocking Processes

We have a busy SSRS Reporting server (SQL Server 2008 R2) on which we see frequent blocking between the below processes: [dbo].[CheckSessionLock] [dbo].[WriteLockSession] We are aware that some ...
1
vote
2answers
154 views

Join two tables and return data and count in a single query

I have two tables in an SQL Server database, one with two columns and one with four: tbl_email_list email_list_id int (PK) email_list_name varchar tbl_email-details email_uniq_id int (PK) ...
0
votes
2answers
58 views

Write a query to create skill table. Please note that the field description can be NULL and the default value is NULL [on hold]

I wrote this query for this question. but it does not work create table skill ( id bigint(20), description varchar(255)DEFAULT NULL, name varchar(255), primary key(id) );
-1
votes
0answers
29 views

How can I install Oracle 11g on my laptop? [on hold]

I am a student and I am taking an introduction to database module this semester. The module requires us to work with the university's Oracle database server. Whenever I'm not in campus, I would VPN ...
1
vote
1answer
6 views

mysql dump import incredibly slow on my developer's machine

I have an SQL dump, it's pretty big (411 MB) and it took 10 minutes to import on server A, the same import on my workstation B has an estimate (pipeviewer) of 8 hours to import (it imported 31 MB in ...
2
votes
0answers
51 views

Query looks optimal but logical reads is huge

I run the following (really simple) query in SQL Server: SELECT MAX(PK_Field1) FROM MainTable kh WHERE kh.PK_Field1 >= '2014-12-01T00:00:00' AND kh.PK_Field2 = 1572 AND ...
0
votes
1answer
12 views

Numeric cell with 0 not null

I have the following query (in a Oracle Database): SELECT SUM (CANTITATE) FROM ANEXA2A_TABEL2_ROWS WHERE TIP_ACTIUNE = 'COLECTATE' AND TIP_AMB = ...
0
votes
0answers
17 views

How to clean DBMIRROR_EVENTS_QUEUE process on broken mirror?

We setup mirror (on SQL Server 2008 R2), but it fails during the setup. After that the mirror was moved on another server. My problem is that it left some process, because on that server I see active ...
1
vote
3answers
33 views

SQLSERVER Use only PRIMARY partition by default

My database has 2 partitions files: PRIMARY, DATABASE_ARCHIVED. A lot of tables have a column "archived". When archived is 1 row is in the DATABASE_ARCHIVED partition. When archived is 0 row is in the ...
1
vote
0answers
28 views

MySQL method for inserting data from JSON using Python Connector

I have been using Python to insert parsed data from a JSON server response into a MySQL database. The JSON data consists of around 10,000 responses, each holding around 40 nested pieces of ...
0
votes
2answers
17 views

How to deny connections to localhost and force to use FQDN instead

I have a server running Apache and MySQL. Connections to MySQL work fine when using localhost in the connection settings. Now I'd like to force our developers to use a FQDN instead of localhost. This ...
0
votes
1answer
16 views

Mysql's internal mysql database in replication

I searched around but the word game seems to delude any valid result and could not find anything relevant. Mysql (the RDBMS) has an internal database named mysql, this database has information about ...
0
votes
0answers
7 views

Restoring a Full Backup with innobackupex with “innobackupex: completed OK!” but do not start mysql 5.6 [on hold]

i am unable to start mysql, followed process given below Operating System: CentOS 6.6 (64 BIT) MySQL: Ver 14.14 Distrib 5.6.24 Percona: percona-xtrabackup.x86_64 (2.2.10-1.el6) mysql> CREATE USER ...
0
votes
0answers
11 views

Insert in PXC Cluster are not equally distributed

I have another query with regards to pxc cluster i have 4 nodes in pxc cluster all nodes have the same cnf file and one server as haproxy. Config File Detail [mysqld] datadir=/var/lib/mysql ...
0
votes
0answers
13 views

How to make an indexed search over a list (set)?

A follow-up question for How to most efficiently store possible combinations of categories? An answer pointed to SET datatype. As far as I know, the default search option for it, FIND_IN_SET, doesn't ...
2
votes
1answer
35 views

Where is SQLCMD.EXE in SQL Server 2014 LocalDB or how to install it?

On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find it anywhere. Is there a way how to install it separately? Unfortunately I am not local admin of ...
1
vote
2answers
23 views

What to do with WAL files for Postgres Slave reset

So last night our PG Slave ran out of space after a lot of reconfiguring of disk space, new drives etc its now reporting the following error: FATAL: could not receive data from WAL stream: FATAL: ...
1
vote
1answer
28 views

Manage max table storage space in case of excess data (size in GB)

My scenario is that I am using sql server 2008 r2 on my end. I have created a database named testDB. I have a lot of tables with some log tables in this. some tables have contain lakhs of records in ...
2
votes
0answers
42 views

I need the reason why we should not install SQL server on the domain controller

I am a system administrator for a small firm. Now we consider to rollout Windows Server 2008 R2 for the firm. We plan to implement Active Directory. We would also like to upgrade RDMS, from SQL server ...
0
votes
0answers
25 views

Load Large data set SSIS AWS EBS

We have configuration of SQL 2012 std edition hosted in Amazon cloud that has data disk of 3 TB, Index disk of 3 TB, Log disk of 500 gb all raid 0 stripped. Am trying to load a table that has 8 ...
0
votes
1answer
27 views

Grant Select on some columns for specific user

I have a windows group with 20 people and all 20 people in the group were revoked access for some columns in the table. Now I need to add the select permissions for 2 of the users in this windows ...
1
vote
0answers
32 views

Which method would be more secure and feasible in the long term?

The concern here is a confusion between two alternative methods for storing data. Our product migrates records from any service A to any service B. These services define their own records and the ...
0
votes
1answer
9 views

Wiki instance mirrored to another box

I've never really done anything like this before, but I have a wiki instance setup on my internal network. Since it is a support wiki, in the case that our internal network is inaccessable through our ...
2
votes
0answers
39 views

DB2 CASE statement faster with parentheses around entire WHEN

Trying to optimize slow queries, someone on my team come across this. Having this in our stored proc: CASE WHEN MYCOL BETWEEN @STARTNUM AND @ENDNUM AND RECTYPE = 'RO' THEN 1 ELSE 0 ...
1
vote
1answer
28 views

Ticket-like table and growing database

I manage a MySQL database through phpMyAdmin. I have a table for cinema cupouns tickets. I upload a bunch of tickets, and then I assign tickets to users. Each ticket contains, id -> ...
0
votes
0answers
15 views

Problem running SSIS package remotely using PoSH

For various reasons I'm trying to run an SSIS package remotely using Powershell. I've enabled remote scripts on my server using the following command. Set-PSSessionConfiguration -Name ...
1
vote
2answers
47 views

Running a T-SQL job under another user

I cant find my proxy user to "Run as" that user !? I am confused which kind of proxy user is appropriate to run a job with a simple T-SQL command. (I have created a credential and proxy but cant find ...
0
votes
1answer
9 views

Checking for duplicate entries for Column A - Table A based on user_id from Table B

I have two tables which have a 1 - 1 relationship. Table A - Skill_id Tabel A - Entry_id Table B - Entry_id Table B - Author_id The two entry_id columns are a primary key - foreign key. I need to ...
0
votes
1answer
30 views

auto_increment incremented on non-affecting queries

When performing the following query on 'sessions': INSERT IGNORE INTO sessions (user_id, archived) VALUES (3, 0) while: CREATE TABLE `sessions` ( `id` bigint(20) unsigned NOT NULL ...
0
votes
1answer
30 views

Oracle SQL Complications With Multiple Triggers

Hey all so I am creating a DB that is used going to be used for managing utilities of a system. My DB has 3 tables: Users, Utilites, and Files (leaving Files table out because question shouldn't ...
0
votes
0answers
8 views

How to connect Cassandra database with Chicago Boss Application?

My cassandra database is on a VMware server. The problem is that I don't find any database adapter which can help me in connecting my cassandra database with my chicago boss(a web framework in Erlang) ...
0
votes
1answer
10 views

Postgres 9.3: How to update row that has max value of a timestamp in addition to other selection criteria?

I want to allow users to cancel recurring subscriptions. The easiest way to do this given the other infrastructure I've got is to set the recurring field = 0 for the user's latest appointment ...
-3
votes
0answers
45 views

How to avoid Row cannot be located for updating error [on hold]

I'm giving support for an app that interacts with a MSSQL database and when trying to delete a record it gives me below error : Row cannot be located for updating. Some values may have been ...
0
votes
1answer
17 views

How can I limit a user to only be able to run procs in a schema, which access another db?

In a SQL Server 2012 SP2 Standard Edition instance I have a user in database A that needs to be able to run stored procedures in schema foo within that database. They shouldn't be able to do anything ...
-2
votes
0answers
30 views

database administrator interview as internie [on hold]

I have an interview for the internship of the role DBA I have just basic concepts of database design and a very little bit of experience in sql server what should I prepared to get this apportunity
0
votes
1answer
33 views

Storing small array of many possibilities

Let's say I need to store the text of a series of books, line per line in a database, and present them in a (CMS-based) website. I thought the correct setup would be: a 'library' table: containing ...
1
vote
2answers
23 views

Can I select data inserted in the same uncommited transaction?

Maybe this is a dumb beginner question, but I cannot find an answer anywhere. Everywhere I read about the Transaction Isolation which solves the visibility of data within the concurrent transactions. ...
0
votes
0answers
30 views

mdf files too big in SQL Server 2005 [on hold]

I hope someone can advise me on what to do here. I am running my database on SQL Server 2005. I had created a backup maintenance job myself using the SQL Server Management Studio, when using a ...
5
votes
1answer
65 views

Select all records, join with table A if join exists, table B if not

So here's my scenario: I'm working on Localization for a project of mine, and typically I would go about doing this in the C# code, however I want to do this in SQL a bit more since I am trying to ...
0
votes
1answer
25 views

How to run a mysqldump from a .txt or .sql file inside a command line window?

If I run the follow line directly in command line window it will works good. C:\xampp\mysql\bin>mysqldump -u root d3bi>C:\Users\me\Desktop\test\testDump.sql How can I run a .txt or .sql file ...
0
votes
1answer
13 views

manual transfer fails with table does not exist

I performed a manual transfer of data manually (zip up the dir and rsync'ed it over. I moved the members.ibd (the only .ibd file) to a save place, extracted and then replaced members.ibd with the ...
0
votes
0answers
14 views

Error when creating multiple tables at once

I'm using mysql through the CLI in OS X. The problem I'm having, is that when I create multiple (more than 3 in this case) tables, I receive errors, but if I enter the code, 3 tables at a time, I get ...
0
votes
1answer
16 views

Create a default value for session valid_until MySQL

Server version: 5.6.22 Homebrew The table: CREATE TABLE `sessions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `date_created` datetime ...
0
votes
2answers
41 views

Schema review for system to advertise cars

Ok, so I am carrying out a rather simple task as part of a job requiretement. Here is the task in a nutshell: Design a form for creating ad for selling car Form has 2 have: 2 drop downs: Car make ...
0
votes
1answer
10 views

Questions concerning performance/production resources where exporting / importing big data sets

I have a MS SQL Server database that contains data for many customers and I am working on a feature to export a single customers data. I have basically created a script that generates inserts for all ...
0
votes
1answer
37 views

is there a way to configure Azure SQL databases for high-insert scenarios?

I'm working on a legacy application that uses SQL Server as a backing store. There's a portion of the app that does a ridiculous amount of inserts to a single table. Re-architecting this portion of ...
0
votes
0answers
30 views

I have a table from which I can retrieve information but I cannot update or delete information

I can update and delete items via PhpMyAdmin. I changed the owner to mysql. My program is a clone of insert, update, and delete that is functioning for other tables within the database. I receive a ...
1
vote
2answers
46 views

Anything like a hash for Postgresql databases?

I have an export process I want to check. I want to verify that source and destination databases are equal. There are about 25000 rows, and schema is the same. Is there a way to somehow "hash" the ...
2
votes
2answers
70 views

Retrieve total available days in date range compared against multiple records

Given the following MySQL database structure for a booking system, how can I retrieve all available days between two user supplied dates? | ID | code | date_arrival | date_departure | 4 | APT01 | ...

15 30 50 per page