1
vote
0answers
462 views

KPI Metrics Table Design [closed]

We are currently working on project to get KPI metrics from out account partners,We want to design a table and It will have 3 Major Business units 4 Business Verticals (Service Desk, Knowledge ...
0
votes
2answers
147 views

What does <> mean in Relational Calculus?

I saw a Tuple Relational Calculus formula, and it contained the symbol <> I couldn't find any reference to it anywhere - can anyone tell me what this means? (perhaps this question will be a ...
3
votes
1answer
1k views

Mysql database slow responding to connects when having only few concurrent connections

We have a database setup with in master/slave. It runs innodb and its on a 8 core with 32gb. When i run "ab" to do a load test on a website (4 frontend webservers) which does the query's with 10 ...
3
votes
1answer
1k views

LOAD DATA INFILE fatal error encountered

I use this query for loading sql data from my pc to localhost mysql database.(version 5.0.10 working witj XAMPP) The query is as below: cmd = new MySqlCommand("LOAD DATA LOCAL INFILE '" + filename + ...
0
votes
1answer
165 views

unique ID for multi tabel? (MySQL) [closed]

I have a table 'article' and each of these articles belongs to one of three different topics (topic_a, b and c). I also have a table for each of these topics with various fields. How can I connect ...
1
vote
1answer
245 views

How to manage users and collections in MongoDB? [duplicate]

Im triying to create users in a database in mongo, I want to lock the usage of te collections for some users, I'll give an example: Lets say that I actually have a db with 3 collections: Books, ...
1
vote
1answer
85 views

Create a runtime table in PostgreSQL

Suppose that I have two tables: tableA (id, name); tableB (id, name); I also have a textual file with a list of couples of ids: id1a, id2a id1b, id2b ... I would like to run the following query: ...
2
votes
1answer
1k views

View with parameters in Sybase SQL Anywhere

A view with Sybase engine cannot take parameters. Is there a way to do this?
0
votes
1answer
89 views

How to fix this error Idk?

how to fix it I am new in Oracle? I tried to connect RMAN and it showed me this error...
2
votes
1answer
176 views

Clustered Index / Index Oriented Table performance in join, worse than nonclustered?

Can a clustered index (or IOT in Oracle) be detrimental, when to be used on a very "broad" table, but only few columns are used? In this case, the "Product" table is used only like a junction table ...
4
votes
2answers
1k views

Should I add multiple secondary indexes to search

I have a search screen on my app where the users can use up to 4 parameters to search. I have written a stored procedure to facilitate the search. Select ID, FirstName, LastName, ...
1
vote
2answers
4k views

why archived log size is small but fast recovery area still has a lot free space

when recovery database I met a strange problem,my recovery script as follow: RUN { SET UNTIL TIME 'DEC 25 2013 09:00:00' ; RESTORE DATABASE; RECOVER DATABASE; } but rman report as ...
0
votes
2answers
425 views

How can I set columns for an entire table in one UPDATE based on the SUM of a join table column?

I have tables companies and employees: explain companies; +--------------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default |...
1
vote
1answer
3k views

Issues with Log Shipping

First time at posting a question on here, so please bear with me and I'll try and detail all the information. Currently, I'm log shipping from SQL 2012 Standard Edition (11.0.3000) (lets call it ...
0
votes
2answers
137 views

Copying a restoring database in SQL Server 2012

I've got two SQL Servers, one of these servers (Server A) is backing up transaction logs on some database and uploading them to the other (Server B). Unfortunately I have no access to Server A, I ...
2
votes
0answers
50 views

Identical query & instance but other execution plans & performance [duplicate]

I have 2 identical queries . One is executed with parameters, the other is executed with hardcoded values. Somehow sql server is creating 2 different execution plans for the 2 queries. The first one ...
0
votes
1answer
2k views

Why doesn't row data show up in SQL Developer?

I'm using Oracle database and I've created a test table "Table1" with a varchar column "column1". I ran the following loop to add some rows: BEGIN FOR i in 1..10 LOOP INSERT INTO TABLE1 (...
0
votes
0answers
76 views

SQL Server 2008R2 - Data Collection

I set up Data Collection for simple and basic monitoring of instances of SQL Server 2008 R2 (/2012) (is simple, accessible for and with very nice colors for my boss :-) But one of instances showing ...
0
votes
0answers
180 views

SQL Server grouping and merging rows in new columns

I have the following question i would appriciates your kind assistant to get the output mentioned below: I need to get new report that has the following data : Passengers traveling together in the ...
0
votes
2answers
2k views

Why can't an owner create a view?

There is a user as HRS. I am creating a view in HRS as CREATE VIEW HRS.RNS..... I am getting ORA-01031: insufficient privileges Edit As i remember, i only execute following commands for ...
10
votes
1answer
8k views

How to duplicate huge postgres table?

I have huge postgres table (10GB of data - 160M records). Table is static and there are no write operations on it performed. I want to duplicate it, perform writes, reindex it and then with single ...
1
vote
1answer
397 views

char vs varchar in mysql

I was reading the book MySQL high performance, it has mentioned that : CHAR is also better than VARCHAR for data that’s changed frequently, because a fixed-length row is not prone to ...
0
votes
2answers
43 views

Transactional Replication Update process

I need to create report using ssrs. for that i create the main table contains the values from nine other tables which is the Source tables. Now the new source tables which are used for main table are ...
1
vote
1answer
5k views

Difference between Clustered Index and Unique Clustered Index? [closed]

I got difference between clustered index and unique index here. But what is the exact difference between clustered index and unique-clustered index? AFAIK creating clustered index can be done for a ...
0
votes
1answer
478 views

How to restrict SQL server profiler to show my symmetric key password while executing query from C# code?

I used symmetric encryption to encrypt sensitive data in my application. I don't want anyone see my password for decrypting the data. But system admin can able to see symmetric password in SQL Server ...
1
vote
1answer
85 views

Query tuning - performance

Could you please help me tune this query. It takes over half an hour to run! I want to identify repeat bookings (can only be identified using an annoying varchar field - email) UPDATE #Repeats --a ...
1
vote
2answers
3k views

SQL Server 2012 error when exporting to Excel

Let me start off by saying I know little and less about SQL. I received a .bak file from a client earlier today and they want me to move it to a new database (not SQL). I've created a SQL Server 2012 ...
1
vote
0answers
151 views

Best practices for ranking records in flexible way

Suppose we have 10000 records of any product. User search on our website with his given criteria. so we output search results based on given criteria. Now Admin want to rank products in search. so ...
1
vote
1answer
136 views

How, when and why does implicit changing of transaction isolation level happen?

RCSI (Read Committed Snapshot Isolation) is the setting of a database changing the behavior of (the default) Read Committed isolation level in SQL Server. This is, as I understand, the context of ...
2
votes
1answer
748 views

Should I save “document ID” as a String or Number in MongoDB

So I'm importing about a 100,000 documents into mondoDB. MongoDB already generates an Object hash but the data has a documentID that was used to identify records in the previous database. The IDs ...
0
votes
1answer
1k views

Mysql Alias IF statement

How do you query something like if parent = 0 then alias is network_id else alias is group_id Is this possible with only queries?
1
vote
1answer
37 views

Choosing the correct database type for single type of entry

So I'm building an application which constantly gets data from an API, basically the API outputs data through JSON which shows a certain speed for different hosts. What I want to here is query the app ...
0
votes
0answers
344 views

How to move SQL server transaction replication from one server to another server [closed]

Currently we have SQL Server 2005 as a publisher and SQL 2008 R2 as subscriber for one of our database (about 350 GB in size). I want to move the replication to our different server (Which also has ...
0
votes
2answers
271 views

SQL Server - Server name same as the instance name and most common use for instances?

Is the server name the same thing as an instance name? I have looked around and am not sure; I think they are but I don't just want to guess. Also, what is the most common use for SQL instances? I ...
2
votes
1answer
390 views

MySQL cluster DataMemory and DiskPageBufferMemory parameters

I want to setup a MySQL cluster. The amount of data is more than double the amount of RAM. I have 3 Data Nodes each with 8GB RAM. QUESTIONS What is a good rule for the DataMemory and ...
1
vote
1answer
990 views

~2 Billion row fact table in star schema on Oracle. Advisable? [closed]

Let me start with: I am not a DBA; I am a backend developer. It has been suggested that, for a report schema, I implement a star schema where-in the fact table can have ~2B rows before being archived....
0
votes
1answer
308 views

SQL Server Stored Procedure - Does Raiserror affect performance

Does RAISERROR in a SQL Server stored procedure affect performance? Would I be better off just having a try-catch wrapper around the whole procedure and just catch the errors in the database access ...
2
votes
1answer
35 views

How to restore a database from the SQL 2008R2 log? [duplicate]

Today, for a great oversight, did a deal with a big mistake, which I forgot to put the WHERE keyword in the UPDATE statement... I searched in the google, I found a lot of things of how to restore the ...
0
votes
1answer
652 views

Can oracle use more memory than memory_max_target?

My system has 34 GB RAM, however, I have set memory_max_target = 3GB, memory_target = 3 GB and I use AMM (Automatic Memory Management). Even though thats the case when I check the current usage of ...
0
votes
1answer
162 views

Mysql replication dump without down time? empty sql file

I try to create dump as replication master data and use followed command to create dump, but sql file only contains paramters and there is no data and structure. The command is : mysqldump --skip-...
0
votes
1answer
3k views

Importing Oracle database from dump where source db filesystem has changed

I'm migrating a database from one server to other. In the migration process we changed the filesystem structure from : /appli2/oradata05/HISTO/ /appli2/oradata06/HISTO/ /appli2/oraredolog01/HISTO/ /...
13
votes
2answers
12k views

What is the optimal way to upgrade production RDS instance?

I have MySQL small RDS instance as part of my production system and I want to upgrade it to medium instance with provided IOPS. As old-school DBA I'm aware about "add slave; promote to master; ...
1
vote
1answer
418 views

How to use the dbms_sql to get the analyze for insert into statement

declare v_cursor number; stmt varchar2(2000); s varchar2(40); cursor cc1 is select voc.SQL_ID from v$open_cursor voc left join v$sql vs on voc.SQL_ID=vs.SQL_ID where voc.SID in(select sid from v$...
4
votes
5answers
276 views

Does DBA need (a read) access to virtualization infrastructure? And why?

I am in charge of monitoring, troubleshooting, tuning and optimizing a few dozens production SQL Servers 2008 R2/2012 in my company that are being run inside VMWare virtual machines. I've requested ...
0
votes
0answers
178 views

Recover deleted records from filestream-enabled table

I have a SQL Server database that I wrongly executed a delete script on it that removed an important records from a filestream-enabled table called Images. after the execution immediately I created a ...
2
votes
2answers
6k views

Mysql match on two columns and get count

How do I get a count of? +---------+-------------+ | col1 | col2 | +---------+-------------+ | Joe | April | | Fred | May | | Sam | April | | Joe | ...
1
vote
1answer
235 views

Retrieve title from rows with a maximum count in other columns

Given the following table archived: CREATE TABLE archived ( sid serial -- row id showurl text -- can be: btg, tmwwt, gcaf, emda title text reference text -- title id ...
0
votes
0answers
84 views

How big of the parameter “shared_buffers” setting on postgresql [closed]

According the document from http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server. Even on a modern Linux system, the stock kernel will likely not allow setting shared_buffers to over 32MB ...
2
votes
1answer
261 views

Looking for an efficient way to clone tens of millions of database records

A laboratory I work in is attempting to clone the open, biochemical database managed by PubChem found here. (Please don't ask why, I am not in charge of this project, I am simply tasked with the ...
2
votes
1answer
113 views

Better way to manage data integrity, without having too many composite FK's

I have following tables: class_table (class_id = Auto Incremented Primary Key (AIPK) of this table) user_table (class_id, user_id (AIPK of this table)) course_table(class_id, course_id (AIPK of this ...

15 30 50 per page