0
votes
2answers
567 views

Do I need to have enterprise server in order to have multiple data sources in SSRS

I am currently running a single server setup of SSRS on MSSQL Server 2008 R2 Standard Edition and would like to know if I can have multiple data sources in this type of setup. The reason I ask this ...
2
votes
1answer
404 views

DB2 users/ beginer questions

New to this. Looking at db2 schemas, which should be equal to OS system users, right ? Doh apparently not. Except for PC,DB2ADMIN beeing on my OS system How is it, that this select * from sysibm....
0
votes
2answers
113 views

How should I structure my time based index?

So I have this table in SQL Server 2008. Let's just say it's called TimeSheets. Now, that table has two columns I am concerned with. TimeSheetDate and UserCustomerKey. TimeSheetDate is a ...
0
votes
1answer
234 views

What does it mean to backup a database

What does it mean to backup a database? My impression is that you would simply dump everything that makes up the database into some format that can be stored externally and used to restore from when ...
2
votes
1answer
100 views

Formatting a float value

I am fetching data from MySQL using PHP. I know that most values stored in the database are float. Sometimes, the database outputs values like 3.9999E-5 and sometimes like 0.00104961904762 (14 digits)....
6
votes
3answers
13k views

How to export all the security-related information from a SQL Server database

As you guys probably know, SQL Server does not provide an out-of-the-box solution to export all the security related statements that are declared for each element in the database (both at the database ...
4
votes
2answers
4k views

PgPool 2 with HA Proxy

So, I'm looking to add high availability to a postgresql server. I've looked into some tutorials on the web but, haven't been able to find exactly what I'm looking for. E.g.: PostgreSQL ...
1
vote
1answer
508 views

How to set selinux permission for non-standard mysql bin log path?

By default, mysql bin log works in folder /var/log/mysql. but moving to any other share such /mylogs/mysql gives permission error. Below is the exact message: usr/sbin/mysqld: File '/mylogs/mysql/...
1
vote
1answer
2k views

DB2 - Not enough storage in the database heap error when trying to create database

So like the title says I'm trying to create a database using this script db2 -v -t "CREATE DATABASE %DBNAME% ON '%DBDRIVE%' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM CATALOG TABLESPACE ...
1
vote
1answer
37 views

How to fix SQL Server instances with different builds on same server?

I have a Windows 2008 box and there are 5 instances of SQL Server 2008 Standard installed. After that, SQL Server service pack patched. Weird thing is: the builds for those instance are different. ...
2
votes
0answers
87 views

Attaching Existing Oracle Home to fresh Windows Install

I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
8
votes
2answers
2k views

Data Warehouse design for reporting against data for many time zones

We are trying to optimize a data warehouse design that will support reporting against data for many time zones. For example, we might have a report for a month's worth of activity (millions of rows) ...
0
votes
2answers
182 views

Primary key for link/junction table with time-dependent data

I want to link two tables in such a way that for any given time period the relationship is one-to-one, but over time the relationship can change. As an minimal example, suppose I want to list the ...
0
votes
1answer
55 views

How to prevent crashes connected with dropped tables during mysql import?

I have made a mysql dump with mysqldump, tables are dropped and re-created with DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( However for a read-intensive database I sometimes get crashes ...
1
vote
0answers
475 views

Timeout while using table valued parameter

I'm trying to find the cause for this error while calling a stored proc with a table valued parameter: Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target ...
0
votes
2answers
1k views

mysql select query to select from single table with multiple WHERE clauses

i am new to database querying so apologies for this rudimentary query question. thank you in advance. table called "neuron" columns in "neuron" called "neuron_id", "neuron_name" + others (not ...
0
votes
1answer
721 views

Nested query not recognize external table

i need to a query that show week by week the total amount of imports of any company and in addition add a ranking position depending on that amount. I've made this query but the problem is the inner ...
1
vote
1answer
122 views

MySQL on Ubuntu 32bits vs 64bits

My web app server is running on Ubuntu 12.04 server 32bits. The mysql db is going to be installed on a different Ubuntu 12.04 server. Should I use 32 bits for the server on which mysql is or 64 bits? ...
0
votes
1answer
57 views

What is the best way to upgrade a MySQL version in a Linux Server

I have database around 14 GB running with 8 -15 GB ram(diffrent deployments) .At present MySQL version is 5.5 and I’m planning to move to 5.6 . I did similar activity in past for 5.1 to 5.5 upgrade . ...
1
vote
1answer
5k views

Check only prerequisites when running runInstaller in silent mode

I want to check just prerequisites and generate a log without installing Oracle database. When I run the following command: ./runInstaller -silentvalidate -responseFile /0/grid/response/...
1
vote
0answers
817 views

Postgres database zero down time production deployment

I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
3
votes
4answers
5k views

Why is Mongo stuck in STARTUP2?

I have a Mongo replica set with a few secondaries. A box, which hosts a secondary instance, crashed and lost the database. I started the secondary Mongo instance again and now it's stuck in STARTUP2 ...
2
votes
1answer
448 views

Get child record from specific root

I have two tables articles and topics and I am using MySQL 5.6 Articles id topic(fk on Topics.id) featured 1 1 1 2 2 0 3 3 ...
0
votes
2answers
2k views

Join two subquery in hql

How can I write this sql query in as hql: select count(distinct s.id) as prepaid, count(distinct ss.id) as postpaid from (select * from subscriber where subscriber.ispostpaid=0) s join (select * ...
1
vote
4answers
218 views

Backup from Server1 and restore it to Server2?

IF we have two Servers installed with SQL Server 2008 instances, Server1 has three drives C, D and E with 100, 500 and 500 GB respectively and Server2 has three drives C, D and E with 100, 300 and ...
1
vote
0answers
46 views

Find repeating tickets with more than one criteria

Lets say I have 2 tables: atms & tickets each atm has many tickets. ATM table: ID | NAME ------------------------- A0109 | ATM 1 A0227 | ATM 2 etc. | etc. Ticket table: ID | ATM | ...
0
votes
0answers
614 views

How to update local database data from an online database? [closed]

I have an online database and a local database. How can I update the local database data (only data and not the structure) from the online DB in my application ? The idea is to have an update data ...
0
votes
1answer
178 views

SQL Case Sensitive Query

I have two databases which return different results based on the case of the query. On the first database I run the query FROM [Temp].[Team].[CLASS] WHERE [TABLE_NAME] like '%Link%' and on ...
1
vote
3answers
141 views

Reset of root password not working?

Our previous DBA left and didn't note the root password down, and I've been pressganged into doing part of his job until we can hire someone. So I create a file : /root/mysql.password Inside that ...
0
votes
2answers
12k views

Finding all sql id, sql text, number of executions,execution time between two AWR snap ids in oracle

AWR report provide the SQL information for top 10-20 SQLs, is it possible to get information on SQLs that do not make it to the top list. How do we find all sql id, sql text, number of executions,...
4
votes
1answer
2k views

SQL Server CPU spikes - possibly non-query related - suggested indicators

I'm looking for suggestions for indicators I could monitor to discover what is causing these cpu "blunted spikes". Some known information: sqlserver.exe is confirmed as the process consuming the ...
1
vote
4answers
133 views

What does SQLCODE = -00942 signify?

I am very sorry if I am asking a very basic question, but I googled for this and found no useful info.. Please help me under what sql code -00942 stands for.. thanks in advance.
2
votes
1answer
600 views

row locking within ACID transaction innodb

I have a financial transaction that looks something like this (pseudo): begin select record for update update record(same record as selected) insert another record into another table ...
3
votes
1answer
63 views

Single statement or batched delete?

I need to delete 6.3 million records from 25 tables in production. I have the following two queries, but I don't know which one will be best: delete jc from Jtable jc join J1Table j on j.JobId = jc....
1
vote
0answers
917 views

Based on these DBCC SHOWCONTIG stats, should I index this table?

I have a SQL 2008 Standard server on full mirror (safety). I reorganize all indexes weekly. I am looking into rebuilding a few indexes to improve performance. I ran DBCC SHOWCONTIG on my largest, most ...
2
votes
1answer
32 views

How to use a table as a reference for another table in MySQL

I have code from generic SQL that I need to find out how to run in MySQL: CREATE TABLE firstTable ( freq int NULL, w1 int NULL, w2 int NULL, w3 int NULL ) CREATE TABLE secondTable ( [wID] [int] ...
1
vote
1answer
1k views

How do I access a old saved tablespace after reinstalling postgres?

So a lot of things might have gone wrong here. I first installed postgres 9.3 on mac 9.1 via homebrew to manage some data. I am using postgres.app. Turns out my harddrive was too small so I decided to ...
0
votes
1answer
252 views

Multiple source CASCADE DELETE behavior

I'm having trouble understanding Postgres's CASCADE DELETE behavior. If table_A REFERENCES table_B, and the column referenced could have multiple instances of the same value, will the table_A row be ...
3
votes
2answers
49 views

Is my Publisher database my actual source database or is it a new database?

I am setting up transactional replication for the first time and am working through my backup policies I need to set. Is my Publisher database my actual source database? Or is it a new database that ...
0
votes
0answers
90 views

How should I restructure a table that contains multiple columns that contain similar, but not same data?

I currently inherited an InnoDB table that describes a product. In the table there are a few columns that describe the maximum height at which the product may be mounted. These are the columns: ...
2
votes
1answer
477 views

Does Windows Server File Compression slow Oracle DB performance?

I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure. I can ...
0
votes
1answer
84 views

MySQL warm up time after restart because of lost connection

MySQL 5.6.10 on Windows 7. I'm cleaning up and paring down a large INNODB table. Its .ibd file is originally 22 gigs. While I was in the middle of an ALTER, dropping some columns, the mysqld.exe ...
1
vote
2answers
213 views

Database restore on new server and upgrade to SQL Server 2012

I have to move a 5 TB SQL Server 2008 database that has mirroring setup to a new server that will have SQL Server 2012 and always on AG setup. I am wondering if detach/attach would be faster or ...
0
votes
1answer
3k views

SQL Query: Join Tables using two partial string matches

Using MS Access, I have to combine two tables where two criteria must be met: Container = Container AND Booking = Booking. I have two tables where fields are missing a value: Table1 and Table2 have ...
0
votes
1answer
4k views

Subtract values from SELECT in SQL

I have the following 2 queries.: shipManagementInvoiceNetValue: SELECT IFNULL (SUM (shipManagementInvoice.netto ), 0) AS shipManagementInvoiceNetValue FROM tckopf AS shipManagementInvoice WHERE ...
0
votes
1answer
1k views

create a batch script on windows that periodically starts a sql function

I need to create a batch script on windows that periodically starts a sql function written in 'plpgsql'. I can use windows schedule task for creating a cron job but I don't know how to write the ...
4
votes
2answers
2k views

SQL Agent - PowerShell step “syntax error”

I have the following code setup in SQL Agent Job step that is not running. The message received is simply: Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed. ...
3
votes
1answer
1k views

Speed of Searching Text vs INT/BIGINT - SQL Server 2012

I am building an application that will need to handle extremely high amounts of traffic. The traffic will consist of incoming requests for information from a SQL Server 2012 database. When a request ...
1
vote
1answer
722 views

Different thread states in query execution

My MySQL 5.1 based Intranet system is facing very bad performance during high load. When observed through MonYog, I found below thread states: We can simply understand the different thread state by ...
1
vote
1answer
86 views

Return value formatted similar to if casted as money

My client's system is very outdated, and there is nothing I can do about it. What I'm trying to achieve is to extract values always with at least 2 decimal places. E.g. From 1826.5695600000 ...

15 30 50 per page