0
votes
1answer
126 views

SSRS ReportServer_XXX.log is giving incorrect CPU count

I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
2
votes
0answers
126 views

2 versions of Postgis installed

For some reason I manage to have 2 versions of postgis installed at the same time due to a wrong update. I can see this as by issuing a select postgis_full_version() i get back version 2.1.0 ...
2
votes
0answers
107 views

How to distribute a given database between multiple DBMS on a LAN? [closed]

Given a Database D, i need to distribute it over different DBMS in a LAN. D will be split into tables, and each DBMS will store a given table. Here is a sketch of what i need to do : I also need to ...
3
votes
2answers
130 views

SQL Server Master Data Services database history by snapshots

I'm involved in a project where there is SQL Server 2012 Master Data Services used. There's a requirement to save a version of the database contents in certain point of time, say, every month or a ...
0
votes
1answer
350 views

How to make up sqlplus login automatically execute a script for Oracle in Linux? [closed]

Some script is invoked automatically want up sqlplus login, don't know what good method.
1
vote
1answer
52 views

one to one relationship

This is my database structure: Users {user_id, username} Profiles {profile_id, user_id, user_views} My question is: If I do it the way mentioned above, should I to set user_id as primary key or ...
1
vote
0answers
197 views

Need advice to improve current RDS

Currently I am running a m3.medium SQL Server RDS(20GB storage without IOPS). CPU utilization is under 50% for most of the time(~90%). However, during peak hours(~10%) CPU utilization will hit 100% ...
1
vote
2answers
1k views

Linux command to kill all MySQL sessions from a specific User?

How can i kill all sessions from a user in mysql using a linux command line command? I have a user that is using all on my database connections and insted of killing one by one i want to make a ...
2
votes
1answer
2k views

How do I access a result set from a StoredProcedure… in another StoredProcedure

I have a non-trivial SELECT statement and I don't want to write it twice (standard SW development considerations). I want to use the results in two stored procedures. I am imagining something like ...
1
vote
2answers
1k views

How can i fix the Oracle Enerprise Manager error - Agent is blocked?

I have installed OEM 12c and after restarting my oms the agents got the following error: Heartbeat Status : Agent is blocked Blocked Reason : Plugin mismatch found between agent and repository. I ...
3
votes
1answer
102 views

Storing Tlogs and data files on the same drive

I'm looking for some clarification of various things I've read. I understand it to be best practice to store your transaction logs on a separate drive (spindle) than where you MDFs and NDFs are ...
4
votes
2answers
3k views

Query across multiple schemas, unknown until execution time

I have multiple schemas that I need to query across. The schemas are not known in advance, for example: U111 U222 U333 I need to select across these three schemas from a specific table in each of ...
1
vote
0answers
48 views

Is there a program I can use to redistribute DB files across multiple volumes efficiently?

I'm working with a VLDB instance with over 60 DBs and close to 200 DB files, allocated over nearly 20 volumes. The instance is a Dev server getting periodic restores from a production instance with a ...
0
votes
1answer
322 views

How should I config the my.ini(or my.cnf) file for mysql?

Thanks for taking your time to look at my question, and I hope that you can help me with this. I have a Windows Server 2012 server, it has: Memory : 3840MB Ram Processor: Intel(R) Xeon(R) CPU ...
1
vote
1answer
2k views

MySQL: NOT EXISTS vs LEFT OUTER JOIN…IS NULL

Is NOT EXISTS or LEFT OUTER JOIN...IS NULL more efficient for finding records in one table that aren't in another? Specifically, I'm trying to figure out which of the two queries below is better: ...
2
votes
2answers
541 views

How to do WHERE x IN (val1, val2,…) in plpgsql

I would like to update a selection of rows in a table; this works... UPDATE t1 SET col1 = 'newvalue' WHERE col0 in (2, 4, 5); But how can I do the same in a plpgsql function? The following gives a ...
1
vote
0answers
50 views

1 SQL Instance on 1 box with multiple databases or multiple SQL instances on 1 box [closed]

I am a new DBA working for a charity and I have project to consolidate the multiple databases scattered across the organisation. I have identified the main databases that are mission critical to the ...
1
vote
1answer
903 views

How to know what index is set on the table with command line in informix?

I'm using the Informix DB. I want to detect what index the table has using command line. I used dbschema -d dbName -t tableName | grep index to detect the index. What's my problem is that the ...
1
vote
0answers
705 views

automating oracle database installation on windows

I'm trying to install oracle 12c database on windows using the silent install with a response file as: setup.exe -silent -responseFile file.res where I generate the response file using the gui and ...
1
vote
1answer
859 views

Moving SQL server 2008 to a new Server with all DBs, replication and Jobs

We have to move our Production SQL server 2008 to a new Server (with latest SKU and more RAM). So we need to move all DBs, replications setup (publisher) and all jobs, means everything :). Also we ...
1
vote
1answer
431 views

Oracle temporary table usage with XA

I'm confused about the compatibility of Oracle XA with global temporary tables. I've read several places on the internet and in the oracle documentation that say "Distributed transactions are not ...
0
votes
2answers
138 views

How to drop table with all reference to this table

I want to drop a table, and this table has be many table's foreign key. So I want to drop all those reference (just refernece, not other table) within the drop table process. Is there any simple ...
0
votes
2answers
729 views

Can I have Oracle primary 11.2.0.1 and standby 11.2.0.3?

Can I have data guard system like: Primary: 11.2.0.1 Standby: 11.2.0.3 In logical standby ? In physical standby versions(releases) must be the same?
2
votes
0answers
2k views

MySQL - high CPU usage (MyISAM tables)

We have a server running LAMP stack on CentOS release 5.6 (Final) MySQL is having high CPU usage constantly which causes server to lag as shown top - 13:50:47 up 80 days, 13:53, 1 user, load ...
1
vote
2answers
2k views

Alternatives to joins using Linked Server and OPENQUERY

In my environment, we have a server that stores sales data and another server that stores our HR data. For some reports, we need to combine sales data with employee data. Our sales server contains ...
1
vote
0answers
825 views

How to use the result of regexp_split_to_array() in stored procedure [closed]

I'm trying to write a function used by an trigger BEFORE INSERT on a table; the function should convert a raw GPS string to useable columns in a different table. The point where I get stuck is the ...
4
votes
0answers
73 views

sql server spatial index performance

I have a table with around 2 million records in it. I created a spatial index, using the defaults other than the bounding box. I've been noticing that some queries are extremely fast, and some are ...
1
vote
2answers
106 views

Confusion with Foreign Keys

I've been tasked to build a somewhat basic Prisoner database and I've run into a situation where I don't know what the appropriate route to take is. I have a Prisoner table, that looks like the ...
0
votes
3answers
330 views

How to mirror the privileges of an user to another in Oracle Database? [duplicate]

I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB'). Is there such an Oracle command (11.2.0.3.0)?
3
votes
3answers
274 views

Get SSMS to show the time a query completed at?

I'm using Sql Server Management Studio 2012, and I'm wondering if there is a way to have a query show me at what time it was run and/or completed at. Basically just some kind of timestamp so that I ...
0
votes
1answer
124 views

How to know my DB user?

I use the PL-SQL developer tool. I log in by using Prodcollops as user name to access the database. How can I find out if my DB user is Prodcollops, too, or if it is just a login name?
0
votes
1answer
379 views

Role-Schema Permission issue (Management studio)

When designing a new database I organized the table under different schemas. I've also created a new role that should have select/insert/update/delete rights on one schema and only select on another ...
0
votes
1answer
57 views

Design for hierarchical embedded database

The goal is to construct a hierarchical database of Objects having the following format: TypeA -> ObjectA [values, contains ObjectB*, ObjectC*, etc.] TypeB -> ObjectB [values, contains ...
0
votes
1answer
345 views

SQL Server sp_addrolemember in stored procedure for different database

I have a stored procedure to restore the latest backup of a prod database to an acceptance database. Once it's restored I need to grant a user read access to the database. Use statements are not ...
1
vote
1answer
903 views

Create Standby database using SE

We are on 11.2.0.1.I have been trying to create a Manual Standby database using Standard Edition. Although at this point its more like an incomplete recovery. This is wat i did Create Standby ...
1
vote
1answer
78 views

Can a large number of schemas be an issue?

Can a large number of schemas present a problem in some ways (performance, maintenance)? By large I mean a few thousands, and schemas will mostly contain views, fetching data from shared tables.
0
votes
4answers
117 views

T-SQL: Complete Database in one table

at a relational data model every logical relation is a single table with values and so on. I know someone who is this too much work and he wants to create only one table which contains all. This could ...
1
vote
1answer
63 views

How to transform this result set?

I have the result set above that I stuffing into a table variable @ApptTemp, and trying to transform it into something similar to the one below. Note that of the 4 rows that have a description of ...
1
vote
1answer
183 views

Aliases with correlated subqueries

I am looking at an example of correlated subquery with aliases from a PostgreSQL book: bpsimple=# SELECT * FROM orderinfo o, bpsimple=# (SELECT * FROM customer c WHERE town = 'Bingham') c bpsimple=# ...
-1
votes
1answer
174 views

How to repair .mdf file? [closed]

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
2
votes
1answer
66 views

Is there a way to make an OOo form for PostgreSQL updateable view?

I have a PostgreSQL database, with data from some 8 tables (not counting enums implemented as a table referenced by foreign key) summarized in a view. I made an INSTEAD OF trigger, so the view is in ...
0
votes
1answer
87 views

How do I “link” two or more rows of the same table with a unique “link” id?

I am looking for a better way to create a link between two or more rows of the same table, but the link itself must have a unique ID. What I am currently doing seems rather convoluted. I have a ...
2
votes
1answer
585 views

Azure Database Size Same Before and After Deleting Most of the Rows

I have a database hosted on Azure which is showing as nearly full, it is at 1017MB/1024MB. The table contained around 27000 rows, I have deleted 20000 of those rows to try and free up space, however ...
0
votes
1answer
191 views

Is it safe, and how can I delete mysql.sock before mysqld start?

I have CentOS running on virtual machine on my desktop. When my desktop unexpectedly restarts (blue screen, power failure, restart after updates), virtual machine faces the same problem - unexpected ...
1
vote
1answer
294 views

MySQL 5.1: Upgrade innodb plugin

My application is running on MySQL 5.1.58 community edition. As I studied on SO websites that After acquisition by Oracle, new InnoDB plugin has been released and MySQL 5.1 with InnoDB plugin is the ...
4
votes
1answer
938 views

Side effects of using updlock lock hint?

I was just exploring UPDLOCK hint in SQL-Server 2008 and I found it is very useful in avoiding certain deadlock scenarios. There are always some side effects when using these types of lock hints but I ...
0
votes
3answers
11k views

How to open SQL Server 2008 R2 Configuration manager in Windows 8.1

In Windows 8.1, i can't find Configuration manager of SQL Server 2008R2. I have already followed the steps as specified in this question. But Configuration manager is not showing up even after ...
2
votes
2answers
255 views

how to upgrade and migrate postgres dbs to new server machine?

my production databases run on a centos 5.5 virtual machine. This server has 2 postgres 8.4 clusters installed on 2 different partitions; now my idea is to upgrade both db version and server os ...
1
vote
2answers
492 views

Permissions required for running extended events

I've found this link: Changes to Extended Events Permission Requirements in SQL Server 2012 that mentions the need of CONTROL SERVER permission for using extended events on SQL Server 2008. I want to ...
0
votes
0answers
65 views

How to config Enterprisedb work with PostgresXC ?

Util now, I created a cluster (PostgreSQL database + Postgres-XC) with 5 server: 1 GTM, 1 Coordinator, 3 Data Nodes. I intend to create a Enterprisedb (Postgres Plus Advanced Server, link: EDB's home ...

15 30 50 per page