-2
votes
0answers
12 views

What does “schema” mean?

In a relational model, a schema specifies the name and data type of each field. The word "schema" is also used in "conceptual schema", "physical schema" and "external schema". What do "schema" mean ...
0
votes
2answers
13 views

How to query from a linked server via a linked server in sql server?

I have the following set-up: SQL Server 1 ----linked----> SQL Server 2 ----linked---> SQL Server 3 The question is can I query SQL Server 3 from SQL Server 1 via SQL Server 2 without openquery? The ...
0
votes
0answers
4 views

what are the best practice to standalone database and concerting data for reporting

Hello I'm new as database developer. I'm currently using SQL Server 2008 R2. So, my team leader asked me about a way to make a part our centralized database as standalone database (decentralized ...
0
votes
2answers
17 views

Can I perform a MAX over a pair of columns?

I would like to execute the following: SELECT person, MAX( (date, priority) ) FROM table GROUP BY person; It would return a person, date and priority row for each distinct value in the person ...
0
votes
1answer
9 views

MySQL slave doesn't disconnect quickly from prior HA master after failover

I have an AWS-external MySQL bare-metal server that is replicating as a slave of an RDS Multi-AZ (failover-capable/HA) endpoint. All MySQL servers involved are running 5.6.19. I've configured the ...
0
votes
0answers
7 views

SQL Server 2012 Replication Subsystem Increase Number of Working Threads

I am trying to create Transaction Replication (Push) between two servers, using a distribution database on a3rd server. Server 1 is SQL Server 2008, Server 2 is SQL Server 2012. The Distribution ...
0
votes
0answers
8 views

sql server minus one day

I have a server with SQL Server 2008 R2 installed in it. This server is used as a D -1 Database, in other words, the database it is one day behind from production server. The problem is that my ...
0
votes
1answer
11 views

Problem with Oracle Rollback Segment Session

I am facing a problem in Oracle, which after performing a procedure that performs INSERT or UPDATE with a millions amount of record in a table, not the next procedure "sees" the data in the table ...
0
votes
1answer
15 views

How do you capture the output message from a successful MERGE statement when using it in a procedure?

Sorry if this sounds like a rather simple question.. When using the console, normally the statement outputs something similar to X records merged How do I capture this output into an out variable ...
0
votes
0answers
11 views

SQL server - copying tables, constraints and indexes from one database server to another server [duplicate]

An accidental DBA, We have sql server 2012 on both of our payroll production server and development server. We have to copy few tables and indexes and constraints from the production database to the ...
0
votes
1answer
3 views

Optimisation and Performance Mysql , Zend Framework 2 and Doctrine 2?

i'm facing some problem with performance in an application using zend framework2 and doctrine 2. i would like to optimis it but i don't know from where to start , i read some many questions/ answers ...
0
votes
1answer
19 views

split string for calculations

I'm doing some basic statistical calculations on the results of a survey. A survey consists of several sections and each section has some questions in it. The answers to each question in each section ...
0
votes
2answers
36 views

How to set host_name() value in a Sql Server Stored Procedure?

We have existing triggers which read the workstation id property of the connection string using host_name(). There are existing PowerBuilder client applications connecting to the database directly ...
0
votes
1answer
14 views

Do threads in cache still use memory?

I was studying about how and how much memory allocated to each connection thread and found below MySQL tutorial: http://dev.mysql.com/doc/refman/5.1/en/memory-use.html There is a point mentioned as ...
0
votes
0answers
13 views

Intermittent errors when calling stored procedures with linked server references from SQL Agent jobs

Environment: Windows Server 2008 Standard without Hyper-V Service Pack 2 - 64 bit SQL Server Enterprise 2008 R2 SP2 - 10.50.4000.0 - 64 bit Problem: I am receiving intermittent failures from ...
1
vote
2answers
25 views

Slow querys on billions-rows-table // index used

Since I'm a young developer and not realy skiled in using databases (PostgreSQL 9.3) i ran into some problems with a project, where i realy need help with. My project is about collecting data of ...
1
vote
1answer
22 views

I have this two models, which one is better?

what is a better design?? Model 1: +------+ +--------+ | type |-|--+ | Data | +------+ | +--------+ | id | | | Mach ID| | type | | | Time | | len | ...
0
votes
0answers
4 views

Creation of insert and update trigger accross database on same server

I have 2 websites and both are hosted on same server with different database and I wanted to create insert and update triggers between tow tables of different database. Example if we consider ...
0
votes
1answer
41 views

READ_COMMITTED_SNAPSHOT locking on Non-Clustered Index

I'm in big trouble with one database instance of SQL Server 2008 R2. I have this structure that I've created it to simulate my real problem: USE [sor] GO ALTER DATABASE [sor] SET ...
1
vote
0answers
18 views

How To Log Select Statements from 1 User On 1 Table Into a Permanent Log Table

We have a centralized authentication library that 100+ applications use to authenticate users. That library has its own DB credentials. It would be extremely useful to log every time that library/user ...
0
votes
0answers
15 views

Insert table column data into another table column in mysql [on hold]

I have to table with category and subcategory. I want to insert category table id into subcategory that have foreign key(category id)using a stored procedure. category table cat_id primary key ...
0
votes
1answer
43 views

How Can I restore a database to a point of time without Old backup? [duplicate]

I have a database in full recovery mode with five tables. I accidentally deleted one table. I don't have any old backups. Can I restore the database with five tables?
2
votes
1answer
28 views

3 minutes to import 327Mo database

We do database import a lot of times per day on a server with those specs : Xeon E5-1620v2 4c/8t @ 3,8Ghz 32 Go DDR3 ECC 1600MHz Hard Drive 2x 3 To SATA3 MariaDB 10.14 with XtraDB Given a 327Mb ...
0
votes
1answer
11 views

how to make for each user, documents start in this order 1,2,3… mysql database [on hold]

I need to make database for users and every user have documents which will line up in this order for user1(document1 have id 1, documnet2 have id 2, documnet3 have id 3, etc...) user2(document1 have ...
2
votes
1answer
13 views

PL/pgSQL - Indexes vs Collation vs Pattern Ops

I'm using PostgreSQL 9.3. Having already read articles and answers on DBA stackexchange: Why would you index text pattern ops on a text column PostgreSQL documentation: Indexes - Opclass Pattern ...
1
vote
0answers
26 views

SQL Server report based on stored procedure not showing columns

I'm working in SQL Server 2008 R2. Created a stored procedure (EXEC dynamic SQL with CASE THEN ELSE ) on server with parameters works ok. But Report Builder on insert table is not showing columns for ...
1
vote
2answers
23 views

mysql service takes too much memory

i have a mysql 5.6.19 on linux server, and it takes about 8 Gb of memory. That is much more than i expect. There are about 150 db, each with 700 tables. All of them are innodb. We do not care about ...
1
vote
1answer
33 views

Remote linked servers

I have a SQL Server 2008R2, and I want to connect remotely to a SQL Server 2012SP1, for which I am given: IP: 12.34.56.78 Login: john Password: pw1 Database: TESTDB Table: test_table The remote ...
1
vote
1answer
24 views

Simple query hangs on a specific column condition

I have two servers, and I a dumped the database of the first to restore it on the second. Everything works great, except that on the second server, I can't do any selection based on a specific column ...
1
vote
0answers
37 views

Non clustered index on multiple columns

I have a table which has around 50 columns. But there are only 6 columns on which we perform regular search. When I am trying to create a non clustered index on it I am getting the warning of 900 ...
2
votes
0answers
14 views

Checking for multiple identical values in a Posgresql array

I have a simple table in Postgresql: CREATE TABLE data (id integer, values integer[]); INSERT INTO data VALUES (1, '{1,2,3,4,5}'); INSERT INTO data VALUES (2, '{1,1,2,3,4,5}'); INSERT INTO data ...
0
votes
1answer
31 views

How can I log the way in which a job was started?

Using SQL Server Agent, I've created a Job that runs some SQL. This SQL does some work on one database, then adds a row to a logging table on a separate database. The Job is run on a couple of ...
1
vote
1answer
19 views

Problem with LISTEN - NOTIFY mechanism in PostgreSQL

I'm struggling with PostgreSQL LISTEN - NOTIFY mechanism. I open two consoles and connect to my database using psql client: psql -U postgres test_db In the first console I subscribe to some ...
1
vote
1answer
29 views

how to group data against more than one conditions

I have a table named Employees with below two columns. ================== Employees 1- EmpId (auto incremental id) 2- EmpName (varchar) There is another table named 'LateDays' with below five ...
3
votes
0answers
19 views

PostgreSQL server problem in Windows XP

2014-10-01 09:22:49 IST LOG: database system was interrupted; last known up at 2014-09-30 18:30:24 IST 2014-10-01 09:22:49 IST FATAL: the database system is starting up 2014-10-01 09:22:49 IST LOG: ...
0
votes
1answer
24 views

Is it possible to create this type of database for a massive forum? [on hold]

Kind of like how craigslist you select a state, then a city, and you're in that community. How do I make my forum website's home page have 2 drop menus for a state and city, then it would bring the ...
1
vote
1answer
15 views

Shut Down MySQL during InnoDB rollback after crash

I am puzzled once again. We had a server crash last night during some huge queries. Upon restart in the morning MySQL went into recovery mode. I needed to shut down the MySQL service and it is ...
1
vote
2answers
37 views

Overhead of decomposing complex query into multiple simple queries?

What kind of overhead should I expect when replacing a single complex query with multiple simple queries? My goal is to improve the readability and portability of all SQL code so I will be favoring ...
0
votes
0answers
11 views

Handle a Search on 2 Big Tables

Hello i want to realize a exchange system with 2 tables. 1 Table for "the user is looking for" 1 Table for "the user has to share" the Tables are very simple id bigint user_id bigint object_id ...
1
vote
2answers
20 views

MongoDB replica sets and data duplication

I am new to MongoDB and trying to understand replica sets. Specifically, I am trying to understand how MongoDB would handle the following situation: A record is written to a table with a unique ...
1
vote
1answer
41 views

Oracle - WHY do an ORDER BY for INSERTs AS SELECT?

I have an application that was migrated from MSSQL to Oracle 11G. It needs re-design but that's outside the scope of the project. In short, the application gets legacy data, builds a parent table ...
0
votes
0answers
5 views

slave with binlog with performance issues [on hold]

With some production servers which target to run as HA service, we worry about performance issues which don't appear in a reliable or reproducible way. Sometimes on regular and sometimes on high load, ...
0
votes
0answers
15 views

How to use BI solutions? [on hold]

I was searching for BI solutions and what they are couse by now i don't get how to use them.I know theory like: Business Intelligence is often a completely separate sect from Database ...
0
votes
0answers
20 views

MySQL 5.6: explicit_defaults_for_timestamp

I have the following replication topology: DB1 (MySQL 5.5) -> DB2 (MySQL 5.6, explicit_defaults_for_timestamp = 1) -> DB3 (MySQL 5.6, explicit_defaults_for_timestamp = 1) - "date" field: ...
1
vote
1answer
23 views

Unable to view SQL Server services

Whenever I enter SQL Server Configuration Manager and choose SQL Server Services I would always get the following error message: "The remote Procedure call failed. [0x800706be]" everything else works ...
0
votes
0answers
8 views

Assigning Parent Node Value using IDs

I am using iReport to build a report and I am trying to find the parent node "group_name" value based on a parent_id given, and return the value the parent, as the child's value. For example: Table: ...
0
votes
0answers
24 views

Export data tables from SQLPlus

Is there any way to export data from an Oracle SQLPlus console, without using the exp or expdp commands? I don't have sysdba privileges. I'm not a real Oracle guru so I'm using Navicat to export but ...
0
votes
0answers
8 views

What is the recommended pgpool mode?

I'm trying to determine which pgpool mode to use (http://www.pgpool.net/docs/latest/pgpool-en.html#config). In order of importance my requirements are: All nodes accessible via shared public ...
0
votes
1answer
33 views

copying 1.2 GB mdb from pc to network [on hold]

When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I'm not able to tell by looking at the size of the file. Does anyone have an experience ...
0
votes
0answers
7 views

Linked Server in SSMS 2014 - Shared Memory Provider, error: 0 - The pipe has been ended

I'm trying to connect to Mongo database from Microsoft SQL Server Management Studio through Linked Servers using Mongo ODBC Driver. Right now I'm testing Easysoft ODBC Driver. I can connect to the ...

15 30 50 per page