0
votes
0answers
3 views

Can PostgreSQL with synchronous streaming replication get behind on the WAL logs?

I have 2 Postgres 9.4 servers running on 2 identical VMs that I am using to learn how to setup replication before it gets used in production. Hot standby isn't required but it would be preferred. I ...
0
votes
0answers
2 views

Running SSRS and SSAS from different server than the primary database instance(SQL Server Engine)

Right now both SSRS , SSAS and SQL Server Engine are on the same server. We are using 2008R2 Enterprise. We are thinking to upgrade to SQL Server 2012 or 2014. and We want put on separate serve the ...
0
votes
0answers
8 views

Excessive CPU use in vendor SQL Server DB

Background: I've got a SQL 2012 DB provided by a vendor so modification of queries and tables is limited. We do own the DB though, so we can add and maintain indexes. Indexes haven't been maintained ...
0
votes
1answer
5 views

Update query with error - 'The multi part identifier “customers.customer_name” could not be bound'

I'm trying to do a simple update query Update Suppliers Set City = (select s.city From suppliers AS s Where s.supplier_name = customers.customer_name) Where Exists (select c.city From ...
0
votes
2answers
13 views

Custom ORDER BY

Are there other ways to use ORDER on my results? 20150507094958A DISPOSED 2015-05-07 09:50:00.853 Samuel MONEY 20150507094958A DISPOSED 2015-05-22 09:25:00.000 Jeff AUTOMOBILES ...
0
votes
0answers
8 views

Can MySQL walk through the files of a directory?

Like the title says: can MySQL (alone, i.e. without C or Python) walk through the files of a directory? Or can you only do this through an API? Sorry for the dumb question. Total noob here and I ...
0
votes
2answers
19 views

Grouping Data Using Joined Tables with Certain Distinct Values

I am struggling to get my head around how to do this so please bare with me while I explain. We have an order system which records orders, order lines, items, users etc. What I am interested in in ...
0
votes
0answers
18 views

Optimizing Queries HAVING COUNT and INSERT…ON DUPLICATE KEY UPDATE

There are two main queries I'm tying to improve, one question is much more conceptual and learning about databases and another is much more straightforward. Both cases deal with the same table It has ...
1
vote
2answers
16 views

Query not recognize alias [duplicate]

I have the following query, the alias it's called DELAY, works fine, but when I try to run the first query adding AND DELAY < 0, the alias is not recognized. I tried to create the alias QUERY AS ...
2
votes
0answers
14 views

Upgrading SQL Server 2008 Standard to Enterprise

I'm trying to do the upgrade but when it asks me for the Product Key for the current version, I can't find it. When I go on the MSDN website for it, it says that a key is not necessary for this ...
0
votes
0answers
18 views

How to separate name string by the spaces in the name in T-SQL

I have a list of names, such as: Doe John James, Doe Jane and Doe Henry Albert Sr I need to split those out into the four component parts of the name (if the name has four parts) to put each of them ...
1
vote
1answer
13 views

How to grant access to IP range in Postgres?

I would like to configure my Postgres DB to be accessed by any IP 10.8.101.*. I know I have to create a rule in pg_hba.conf but I'm not sure what it should look like. My LAN IP is currently ...
0
votes
1answer
13 views

DB2 Trigger Error : An unexpected token “OR INSERT” was found following SQLCODE=-104, SQLSTATE=42601, DRIVER=3.68.61

I am getting an error while executing the following queries. As per the DB2 documentation, we can have both update and insert event in the same trigger, but when I am trying to do so I am getting an ...
2
votes
1answer
31 views

How do I import XML to a SQL Server table?

Can anyone help me work towards fixing my solution to import my XML data into a SQL Server Table? I have done my research, but this task has been very hard for me to accomplish. Everything I have ...
0
votes
1answer
16 views

Index design question

This query runs for 60 seconds: SELECT mychecklis0, .... FROM dbo.MyChecklistStatus mychecklis0_ WHERE mychecklis0_.AppFormSubSectionId=@P0 AND mychecklis0_.ProfileId=@P1 There is an index created ...
1
vote
1answer
19 views

Problem locating rows with dynamic SQL

I'm new at SQL in general, so I'm have a few problems with some of my stored procedures I'm designing. My procedure takes in 3 parameters. A location (or table name basically, a varchar), a room ...
0
votes
0answers
5 views

SSAS (Analysis Services) 2014 - Cumulative Update 1 for SP1

I just recently applied CU1 for SQL Server 2014 SP1 (http://support.microsoft.com/en-us/kb/3067839) to my development workstation and one PROD server. Analysis Services continues to report itself as ...
0
votes
0answers
8 views

Sparse matrix - key-value db?

I have a huge sparse matrix ( 10^9 rows, 10^6 cols, density < 0.03% ), where each row has at least one nonzero column, but some column may contain only zeros. The cells are decimal numbers > 0. I ...
0
votes
1answer
28 views

Unexpected gaps in IDENTITY column

I'm trying to generate unique purchase order numbers that start at 1 and increment by 1. I have a PONumber table created using this script: CREATE TABLE [dbo].[PONumbers] ( [PONumberPK] [int] ...
0
votes
1answer
13 views

How to create DBA user from oracle APEX 11gR2 XE

Please anyone tell me how to create DBA user from ORACLE Application express(http://127.0.0.1:8080/apex/apex_admin)? I installed Oracle 11gR2 XE on windows 8.1 PC and I am able to login to Oracle ...
1
vote
1answer
21 views

How to do a SELECT inside of a PIVOT

I am trying to SELECT values from a column in my database in order to perform a PIVOT on those values without hard-coding them. SELECT * FROM (SELECT ItemType, [Status] FROM ...
0
votes
0answers
20 views

Property error when linking SQL Servers

I'm running into an issue linking SQL servers. The servers I have are: Server A - SQL Server 2008 R2 Server B - SQL Server 2014 I can set B as a linked server on A with no problem, but setting up A ...
1
vote
0answers
19 views

SQL Server Log Shipping Randomly Stops Copying and Restoring

I'm fairly new to Log Shipping but have configured a few with no issues, however I have a server sitting on SQL 2008 R2 with 6 databases on there, all 6 of these are supposed to be log shipping. The ...
0
votes
1answer
16 views

SET sql_log_bin = 0 in RDS MYSQL 5.6

I have moved into RDS MYSQL 5.6. Now, I have a problem. I have 5 read replicas and a/z master. I am trying to perform an ALTER TABLE and want to change a column value and also on some tables I want ...
0
votes
1answer
28 views

Why do the queries slow down after a few minutes, when trying to build a DB?

First - I am a complete newb to DBA. Please be gentle. (And I am fairly new to python as well.) Oh, and I have no idea how to change any MySQL settings or the like, so all the MySQL DB settings are ...
1
vote
1answer
54 views

Missing Index Not Displaying In Execution Plan

I recently installed SQL Server Management Studio 2014 (Developer Edition), and I noticed that I am no longer seeing the missing index feature. What I have done: Ran the workload through Database ...
-1
votes
0answers
28 views

how can I delete records when my disk drive is full?

My data folder of SQL as filled up the space of my local drive. I have 150KB free space left in the drive. So I have to delete some records to regain space. But when I run the delete query it says ...
3
votes
0answers
14 views

How can I get a hierarchial json from the same table in postgres

I already posted it here but it was wrong place and the answer is for wrong version: http://stackoverflow.com/questions/31264334/how-can-i-get-a-hierarchial-json-from-the-same-table-in-postgres ...
0
votes
3answers
32 views

Installing SQL server 2008R2/2012 on windows server 2012 box

we are trying to install SQL2k8R2 and SQL server 2012(Standard edition) on the windows server 2012 box (Standard 64 Bit). For SQL 2k8r2, i used slipstream method so as to bring set up to atleast SP1 ...
-1
votes
0answers
12 views

concurrency control [on hold]

Question Which of the following is correct ? I. Two phase locking is an optimistic protocol. II. Two phase locking is pessimistic protocol III. Time stamping is an optimistic protocol. IV. Time ...
0
votes
0answers
2 views

Database engine installation failed

Being asked to implement an application for purchasing management, the database managing system which I have to install, is SQL Server 2008. I am having some issues while installing the main ...
0
votes
1answer
13 views

Create new server in SQL Server instance

In our office we have two servers (development and Test). I need to create a new server for practice purpose. How can do it?
1
vote
1answer
83 views

should we keep the log file or the data file on the fastest drive?

SSD = solid state drive We have a specific question about tempDB performance on server CRM01 (Marketing CRM server - running large queries): On CRM01, tempDB data and log files reside on the solid ...
2
votes
0answers
12 views

“ERROR:malformed array literal” when using json_to_record with a JSON array element in Postgres 9.4

This illustrates the issue nicely: When column b is of type text, and not an array, the following works: select * from json_to_record('{"a":1,"b":["hello", "There"],"c":"bar"}') as x(a int, b ...
0
votes
1answer
14 views

SQLDeveloper set default linesize

As per title, how to set Oracle SQL Developer default linesize so that I don't have to set it every time I open the program?
0
votes
0answers
9 views

Fill the 5th table with 3 other tables data in LibreOffice

I have 5 tables primary key foreign key felh(felh_id, felh_nev) gepek(gepid, felh_id, gep_nev) lic(lic_id, lic_k, lic_l, lic_db, gep_id) pr(pr_id, pr_n, pr_vr, lic_id) haszn(haszn_id, gep_id, pr_id, ...
3
votes
2answers
117 views

Does .bak file also contain backup of ldf file?

I am running MS SQL Server, which is holding mdf and ldf files of sizes 110 GB and 245 GB respectively. My question is, if I take .bak backup of said database, will it result in 355 GB (110+245) ...
0
votes
1answer
22 views

Service privileges for Patch Download? (Oracle 11gR2)

I first asked this question on stackoverflow, but someone pointed out that this might be the appropriate site. Hope I am doing this right. To perform tests in advance of an upgrade from Oracle 11gR2 ...
0
votes
0answers
13 views

Clob (Swift message) data in Oracle table

I have swift data in clob column and want to insert this data in multiple columns in different table. create table test_swift (id number , block4 clob ); insert into test_swift values (123, ...
0
votes
0answers
16 views

Managing tables in database

I am new to web development field and particularly very poor at database management. I am developing a web application which resembles Project Management System where new companies can add their ...
0
votes
2answers
27 views

How to optimize a large join to create a WHERE IN

The following sqlite database query takes about 40 seconds on my Core i7. SELECT t.a FROM titles t WHERE t.a IN ( SELECT e.id FROM erpubtbl e JOIN abstract_mesh am ON am.pmid = e.pmid ...
0
votes
0answers
9 views

LibreOffice Base randomly changes character limit in forms

I have to work with LibreOffice Base, and when I created a form to fill the table. It worked perfectly, but when I wanted to use agains it randomly changed the maximum type-able character limit. I ...
0
votes
0answers
6 views

Datetime to string in pentaho DI

I have a date value in the text file and Pentaho identify it as a date format like this, '2015-06-30 00:00:02'. I want to get string output to new field like this , '20150630'. Ho can I do this in ...
1
vote
0answers
36 views

MYSQL View with LEFT JOIN return all possible combinations

I am working on a view that joins multiple table. The data will be entered on separate table based on RepairID. The view will gather the data that is linking to the RepairID. My problem is after I ...
0
votes
1answer
25 views

How to print to console in SQL?

I'm using PostgreSQL And I want to print a message to the console. If I use plpythonu I use plpy.notice If I use plpgsql I use raise notice but how do I print when the function is pure SQL? using ...
2
votes
1answer
28 views

Database Dump/Backup but only to specific records?

This question is about MySQL Backup (or Dump) whereby i want to backup and store information from only information related to a person; SchoolA from the School Table in this example. So, I should not ...
-3
votes
0answers
15 views

IN RECOVERY MODE

I used sql server 2005.One of the databases is in recovery mode. This database size is 37GB. I changed to simple recovery and then I can use it that. When I do restart, this database auto change to in ...
0
votes
0answers
9 views

Cannot upgrade from SQL Server 2008 R2 SP2 standard edition to SQL Server 2014

When I run the upgrade wizard, it says "the specified edition upgrade is not supported". I have SQL Server 2008 R2 standard edition (SP2) and it has been added in the supported list on MSDN website. ...
2
votes
1answer
11 views

Why does an sqlite3 .dump and restore result in a smaller database file size?

I have a really naive question about database file sizes. I started out with a 1.2M SQLite database, dumped it to a SQL file, and then restored it to a new database. The restored database file was ...
1
vote
1answer
20 views

Have several rows, or one single row with a huge comma separated data?

I have many workers processes working at the same time. They grab an ID from a list called available_ids, work on that ID, and put that ID on a list, called used_ids. The list available_ids can have ...

15 30 50 per page