1
vote
0answers
3 views

How do I check the status of an SSAS Cube that is currently processing?

When you process a cube through SSMS by right-clicking and selecting "process" it will display a window with the current status of each of your processing objects. In my current project I am using a ...
0
votes
0answers
2 views

SendObject Command

So I have sorted out alot of the problems with query etc. Is it possible to have a DoCommand Send object to send a report to the emails in the query. I need the report to be the one referenced in the ...
0
votes
0answers
7 views

How do I troubleshoot error 26: “Error Locating Server/Instance Specified”

I'm trying to configure TCP access to my SQL Server named instance (named SQL2012). I use management studio to connect to the database engine. I type in the server name: "tcp:localhost\SQL2012" and I ...
1
vote
1answer
9 views

SELECT all rows when a variable is null

How do you select all values when @Troop is NULL. And if there's a better way to do this all together then what would that be? WHERE DateModified BETWEEN @BeginDate AND @EndDate AND ...
1
vote
1answer
7 views

Alter of stored procedure and execution performance

Like to understand how an alter of a stored procedure without modifications can impact performance. Had a situation where a production environment had DB schema updated and particular stored ...
0
votes
0answers
3 views

ALTER SESSION from a Control File

I am using a Control File to import data from a CSV file into a table, using sqlldr to import the data, where a large number of fields are numeric values with integer and decimal part separated by ...
0
votes
0answers
4 views

how to convert a master cluster to a slave cluster?

I am learning about Postgresql streaming replication and so far I have learned how to create a slave cluster using : pg_basebackup -x -R -D main -h host -p port also I have learned that I can ...
3
votes
1answer
35 views

SQL Server DB become unusable overnight

Yesterday, my SQL server database was fine. Today it is almost unusable - it's slowed down by a factor of between five to twenty, depending on when I hit it. Some data was added to the server in an ...
0
votes
0answers
14 views

CALL Procedure(Function) = Trigger?

I have discovered some strange behavior in Oracle 11g, and I'm wondering if anyone has an explanation for it. The gist is that when I use a function that contains a commit/rollback/savepoint within a ...
0
votes
0answers
11 views

When does pg_dump not export CREATE EXTENSION?

I have a production database that I am trying to dump then load (in plain text format) locally. The problem is, the database being dumped uses the hstore extension in several tables, and contrary to ...
-2
votes
0answers
13 views

Informatica vs datastage? Wich is better for a beginner? [on hold]

first of all sorry for my english. Im a web developer, i want to change my career ,i want to be an etl developer. I have a good understanding of database and i have been using mssql for the past year, ...
0
votes
0answers
14 views

mysql replication and innodb_file_per_table

Is it possible for the master (5.1) to have innodb_file_per_table = 0 and for the slave (5.1 or 5.5) to have innodb_file_per_table = 1 ?
0
votes
0answers
13 views

Getting TEXT data from postgres throught linked server to MSSQL

I'm using MSSQL 2008 R2 with linked server to postgres 9.4. My problem is: when I select column with data type text it shows me only XXX first chars and adds (...) on the end. select description from ...
1
vote
2answers
29 views

Rollback Committed transaction in SQL Server

Is it possible to rollback a committed transaction? I have deleted all the data in a table. The delete statement is inside Begin Transaction and I have committed the transaction with a commit ...
1
vote
1answer
5 views

Check if encrpytion key is valid in DB2

I have a DB2 table where one of the columns is encrypted using the two parameter variant of ENCRYPT (so the password is supplied in the SQL itself). Unfortunately due to an ETL issue the column got ...
0
votes
0answers
13 views

PostgreSQL becomes very slow after heavy utilization

I have built a Python web application and I am hosting it in a 2GB RAM Debian Server. My application uses PostgeSQL 9.1 with PostGIS. One of my tasks involves importing data from big csv files. ...
0
votes
1answer
14 views

Oracle 11.2.0.3 to 11.2.0.4

I'm planning to upgrade 3 instances of Oracle (all same Oracle Home) from 11.2.0.3 to 11.2.0.4. I'm going through the installer and I get to the question about Upgrade or install just the database ...
0
votes
0answers
15 views

What software can I use to create a web-based data-flow diagram with selectable layers? [migrated]

I want to create a simplified data flow diagram that can be accessed via a web browser and allows users to select the layers they want to display. So for example, if I receive datasets for apples, ...
-2
votes
1answer
31 views

Recursive cte addition in SQL

I need to add the total value to the parent nodes.(totaling the total value to base to top levels). 118 records are there and 1-8 levels. Root ACCCODE='00001' Root ACCPARENTCODE='0' Eg: adding ...
2
votes
4answers
29 views

RAM utilization

We are using SQL Server 2014 on Windows server 2008 Web edition (64 bit). Total RAM of OS is 8 GB .When we check high physical memory usage in the task manager it shows nearly 90 to 95 % full but I ...
-1
votes
2answers
10 views

How to reduce database log file size frequently? [duplicate]

I want to reduce the transaction log file size of my Database frequently. If I use transactional log backup frequently for example every 1 hour will it reduce the database log size or not? Does ...
1
vote
0answers
23 views

Can I create a trigger in mysql and update the same to oracle database? [on hold]

I am trying to replicate data from mysql to oracle db. Is that possible by creating triggers in mysql?
1
vote
0answers
20 views

Is there a way to determine if a postgres function depends on a user-defined type?

I am writing a Ruby script to handle functions and user-defined types in Postgres. I want to make sure, that before a function is created in the database, if it uses a user-defined type, than this ...
1
vote
1answer
32 views

Oracle - Using index on unique constraint, what the deal?

Using Druid to generate SQL script for Oracle, I have seen a difference between the version 3.10 and 3.13 and I would like to understand what going on. SQL generated by Druid 3.10 : CREATE TABLE ...
1
vote
1answer
26 views

How do I create/publish a report in SQL Server 2014? [on hold]

I installed SQL Server 2014 with Reporting Services but I don't how understand how to create and publish a report so that users can run it on the report server on IIS. These are the programs that ...
0
votes
0answers
17 views

Optimization for query n increase performance

I am executing the following query: select count(inspection_result) from table where (inspection_time between "2015-06-28" and "2015-07-04") and inspection_result= 1 and part_type = "39000048" and ...
1
vote
1answer
7 views

In MDX what is the ParallelPeriod of UnknownMember?

Lets say I have a time dimension with the levels all, year, quarter, month, day. I have some sales per month and a calculated measere [sales last year] WITH MEMBER [Measures].[sales last year] AS ...
2
votes
1answer
31 views

Locking issues under transaction on Postgres

I recently got a "Out of shared memory - You might need to increase max_locks_per_transaction" error. This is a long running process where I import a bunch of CSV files after proper processing. I ...
4
votes
4answers
468 views

SQL query to find player with maximum runs

I have the following tables with me : Table 1 Title : Runs +------------+---------+ | P_ID | Runs | +------------+---------+ ...
3
votes
1answer
49 views

How can I get the last inserted id from an specific table from a given stored procedure?

I know about the existence of LAST_INSERT_ID() function... Though I am not quite sure about its behaviour... Does it take the last inserted id from the current user into account? Or uses all the ...
1
vote
1answer
30 views

How to set Persian calendar,currency,numbers,date and time and text in oracle database?

I have installed oracle database 12c on my laptop. I want to be able to store text,numbers,calendar,currency,... in my local language (Persian) in database tables and also show contents in Persian ...
2
votes
1answer
8 views

Neo4j service won't start with an imported database on Debian

I've been playing around with neo4j recently on my Debian 7.8 install. It's awesome! Today I imported around 100000 nodes and 75000 relationships using neo4j-import tool. I stopped the neo4j service ...
9
votes
1answer
972 views

What's the difference between “expression <=1.” and “expression <= 1”?

Reviewing code and a case statement has expression <= 1. as opposed to <= 1 I'm not sure what the purpose of the 1. is. Any thoughts?
-1
votes
1answer
31 views

Sending an automated email through a nightly job

I had the following SQL query: select substring(PostOfficeBox,1,4) as 'Postcode' , COUNT(CASE WHEN New_accounttype = 1 THEN New_AccountType ELSE NULL END) as 'New Connections' , COUNT(CASE WHEN ...
2
votes
1answer
19 views

table structure for events

Got a bit stuck, need a hand. I need to store events at the database, and events may happen at different location multiple locations at the same time so these are my tables CREATE TABLE ...
2
votes
1answer
15 views

Searching SSIS packages for the use of specific tables

I have a number of SSIS packages, how can I search them to find the use of specific tables? I need to make tables changes and I am trying to assess the impact of these.
1
vote
3answers
60 views

Multi-table optimal database design

I'm a bit new to the database design. Thus this question to people who may have more experience. I need to design a database that needs to store statistical data for many systems. The data is ...
0
votes
0answers
4 views

Adding postgis geometry with rake task

I have a postgres table test with a geometry column: Column | Type | Modifiers ...
1
vote
2answers
17 views

Select data where column value exists in seperate rows for same reference id

This is on a MySQL database. Locations have services. What I want is to get all results where service_id is 2 AND 3, not OR so using IN is out I believe. Database ---------------------------- | ...
0
votes
1answer
20 views

Copying CSV file to temp table with dynamic number of columns?

I am wondering if there is a way to copy a csv file into a temp table where the number of columns is unknown in the csv file. The DB software I'm using is PgAdmin III. I figured out that if I do know ...
0
votes
2answers
24 views

How do I determine the appropriate size for my tablespace when importing a .dmp file?

I have a 14g DMP file. How large should I size my tablespace to import it into an Oracle 11g database?
1
vote
0answers
11 views

Whitespace Trimming on Before Trigger in PL/SQL [on hold]

I'm looking to create a simple trigger that trims the whitespace on a piece of data prior to it writing to the table. I'm using PL/SQL with Oracle 11g. I am receiving the following error: ...
0
votes
1answer
26 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
3
votes
1answer
42 views

Any reason not to add 'rowversion' column?

The TechNet article, "Optimizing Microsoft Office Access Applications Linked to SQL Server", recommends adding a rowversion column to SQL Server tables linked from MS Access. From the Supporting ...
0
votes
1answer
32 views

Why is my PL/SQL procedure so slow?

I have this sub-procedure in a fairly large program, and it is taking hundreds of times longer than comparable sub-procedures. Is there any way I could improve efficiency here? None of this ...
-4
votes
0answers
25 views

How to filter a column of type DATE THE MAXIMUM RECORD DATE IN OBIEE [on hold]

How to filter a column of type DATE THE MAXIMUM RECORD DATE
-5
votes
0answers
32 views

Why isn't my query returning the correct results? [on hold]

I am trying to get information from several tables that I need in order to produce a report of all the stopped services on our critical servers. This query for some reason works if you switch the ...
0
votes
1answer
25 views

How to test mysql for changes

I'm OCD person, I think I accidentally dropped something in my mysql. Problem is I've around 50 databases, and I cannot manually check everything :( Is there a way to check for these kind of ...
1
vote
1answer
27 views

Variable Substitution

I am working in TOAD for Oracle and am trying to use variable substitution in my coding. I have been able to get variable substitution to work in the code body pressing F5: Define Value = '1.5' ...
-4
votes
0answers
17 views

SQLPLUS QUERY HELP

Please help to create what might be a simple query for you; very tricky for me. Maybe a nested query?... or maybe a "For Loop". Thank you! Table name: WO_OPERATION Relevant Columns: ...

15 30 50 per page