All Questions

0
votes
2answers
35 views

Unable to mount database: error reading control file

I have an installation of an Oracle XE on Windows 7 (Home Premium). The database worked fine until yesterday when the database could not be started. It reports ORA-01033: oracle initialization or ...
1
vote
1answer
57 views

SSRS pivot dynamic columns

I've tried to port this from a similar post, SQL query to return a column per date in date range? however I haven't been able to quite get it to do what I need... Please find some example code below : ...
0
votes
1answer
13 views

How to set delayed replication with MariaDB 10.0.11

Is it possible to set delayed replication on MariaDB 10.0.11? I tried the following command: CHANGE MASTER TO MASTER_DELAY = N; It returns the following error: You have an error in your SQL ...
0
votes
3answers
38 views

How to enable windows authentication on server that is not part of domain

We have an SQL server instance running on a standalone server (not part of the organizations domain network). Is there any way that we can use windows authentication to logon to sql server without ...
0
votes
0answers
39 views

select random tuples but prefer old dates

With this table: CREATE TABLE T_TEST ( id int identity, somevalue varchar(256), lastupdate smalldatetime ); i want to select n random tuples which age is older than x days but prefer old tuples ...
0
votes
1answer
36 views

what is so special about MongoDB indexing?

I was reading the MongoDB documentation, where it lists Indexing as an special feature. But after reading the doc, I still can't see what it is that makes MongoDB index special. Anyone can explain?
1
vote
1answer
52 views

Delete from table where two of the three keys in another select

I have tableA which has 4 columns: IDA (bigint), IDB (int), IDC (varchar(255)) and comment (varchar(255)). The primary key is (IDA, IDB, IDC). I'm required to delete the records where the count of ...
0
votes
1answer
28 views

Installing Oracle 10g on Oracle Enterprise Linux 4 [on hold]

I'm installing Oracle 10g manually on OEL4. I have installed Oracle 10G software only. Then I was trying to go to the $ORACLE_HOME/dbs location to set parameter file parameters. I have done something ...
-3
votes
0answers
14 views

Can I add a column graphical in mysql workbench in an existing table [on hold]

I can add a column by command but not in graphical, so please find the solution.
0
votes
1answer
16 views

set right permission to get connection ip for a user mapped to login

I have a problem with properly settings the rights permissions for my user to get access to connections ips. I know that, to get the conn ip I must set the VIEW SERVER STATE to the login that I use ...
-1
votes
0answers
23 views

inserting information into database tables created using wamp server [on hold]

I am doing an online registration system for students. I have created a database named "library" and database tables using phpMyAdmin on my wamp server. My question is: How do I insert information ...
0
votes
1answer
31 views

TYPE_SYM syntax error when running the mysql command to create or replace type

Here is my command: CREATE or REPLACE TYPE DRIVINGSCHED_TYPE AS OBJECT ( vehicle VARCHAR2(20), datesched DATE, starttime DATE, endtime DATE ); ERROR: Line 1: syntax error, unexpected TYPE_SYM, ...
0
votes
0answers
28 views

Using Cloud Oracle server in .Net application (ASP.Net web site) [on hold]

I need to be able to use a cloud Oracle server from my .Net application. Does ODP.Net support cloud Oracle server? Is there a quick "Hello world" example that includes connecting to a cloud Oracle ...
0
votes
1answer
19 views

Search result from two collections

I'm new to MongoDB. Lets say I have a collection of blog post, and a collection of authors. I want to search for posts e.g. by topic, and language. But I only want results by certain authors, e.g. by ...
0
votes
0answers
22 views

Can't install sample MySQL employees DB

I'm unable to install sample MySQL employees DB. I'm on OS X 10.10 with MAMP Pro(3.0.7.2). When I try to install it, I get the following errors. [ERROR in query 15] You have an error in your SQL ...
0
votes
0answers
29 views

while installing sql server 2008 on windows 8 setup support files window silently disappear [on hold]

I am trying to install SQL Server 2008 on Windows 8. After accepting license , setup support files window disappear silently. Please reply me fast I am trying it from two days. or guide me for ...
0
votes
1answer
24 views

Transform it into 3NF [on hold]

Consider the relation LEASE, where a person can live in only one building, and a building can charge only one rental rate: RELATION = LEASE (PersonID, BuildingID, Rent), Primary Key = {PersonID} I ...
0
votes
1answer
37 views

How can I determine the edition an Oracle session is using?

We are using the Edition Based Redefinition feature in some software and as a DBA, I want to be able to determine which edition each given connection is using. This way, we can be sure all ...
0
votes
0answers
13 views

MySQL - Pending flush list, aio write, and the innodb_use_native_aio parameter

I'm running an Amazon RDS instance with MySQL 5.5. The applications using that are very write intensive, and there's over 1TB of data. Everything was fine until a recent minor version upgrade and ...
0
votes
2answers
59 views

SQL - Cannot Add Foreign Key Constraint

Can anyone tell me why there are errors such as : Cannot Add Foreign Key Constraint And am i on the right track ? DROP DATABASE technology_university_hospital; CREATE DATABASE ...
0
votes
3answers
62 views

Confused about Primary Keys, and Foreign Keys

Im brand new to database design and, I'm slightly confused about Primary Keys, and Foreign Keys and my database design. Context: I'm working on a database of museums and Categories will be one way ...
0
votes
1answer
28 views

Best Innodb Buffer Pool Size for 8GB RAM?

I found out that my MySQL server is configured with only 128MB for innodb_buffer_pool_size. That is not enough considering that I have a 8GB RAM server. It hosts MySQL server and an Apache/Catalina ...
1
vote
1answer
40 views

Moving a large MySql database(Over 15 GB) from server to server mysqldump

I need to move a mysql database that is about 17 GB that is on a Cpanel/Centos based server that I do not have root access, to a Centos server that I have full root access. I do have limited SSH on ...
0
votes
1answer
28 views

Most used tables in MySQL database server

Can somebody please help me with a query that lists the most used tables in a MySQL database? Or how can i find out the most used tables in the database? Thanks
0
votes
1answer
15 views

Working out validity of table relationship

Question Background: In a quest to improve my skill set with TSQL programming I'm designing a 'simple' database schema for a zoo. In all I currently have 4 tables but am having an issue working out ...
0
votes
0answers
16 views

Using mysql cursor data to do something for each row

I have a table incoming_sms and another table subscribers_register and another table test_subject. Some of the subscribers in the table subscribers_register have sent in some sms and the messages are ...
0
votes
0answers
38 views

Benchmarking MyISAM vs InnoDB using Sysbench on MariaDB-10.0.14

I performed a "read" benchmark on MariaDB-10.0.14 db server using sysbench to compare performance between InnoDB and MyISAM on a single. Below are the sysbench commands i used: Create test table in ...
4
votes
2answers
51 views

Partial db dump/restore

A part of my database (PostgreSQL 9.3) relies on extra tables (ex. County, City, Town, ... ). I don't manage these tables, they are updated regularly by a third party. Each time I get a new full dump, ...
0
votes
1answer
119 views

What is fragmenting my index on a table with stable traffic?

I am using Ola Hallengren's solution for optimizing indexes. I run it on Sunday every week. The index has had low fragmentation for the last 6 months and it hasn't needed reorganization. The way it's ...
1
vote
2answers
35 views

PostgreSQL procedural languages overhead (plpython / plsql / pllua…)

I'm trying to find information about PostgreSQL user defined functions in procedural languages performance for real time tasks. How does they compare to builtin functions? Is there any difference ...
0
votes
1answer
50 views

Trying to map postal codes to their respective cities, but running into some issues

The Problem I am creating a database of Countries, Regions, Cities and Postal Codes. Here's an example to give an idea of the database structure as it is now: Now, let's take Tuskegee University ...
1
vote
0answers
64 views

MDF/TempDB Growth, SQL Server 2005 Enterprise

Here's my scenario: SQL Server 2005 Enterprise Records from Database A being added to Database B Size of Database A MDF file: 3.15 GB I have separate drives for Data, Logs, and System. I ran a ...
0
votes
0answers
26 views

how can I track down the source of “Internal connection fatal error”?

I'm working on a 6-700 line SQL script today. I'm running it from SSMS. Pointing at a SQL 11.0 db. About half the time I run it, I get: An error occurred while executing batch. Error message is: ...
0
votes
1answer
19 views

updating millions of rows in multiple tables sql server 2005

I have a situation where I am going to need to update millions of rows in 11 different tables. I only have to update 1 column in each of the tables but I was wondering what would be the most efficient ...
1
vote
1answer
39 views

Sql Server 2008 R2 - Failed to send an environment change notification to a log shipping partner node

Login failed for user '*****'. Reason: Failed to send an environment change notification to a log shipping partner node while revalidating the login. I'm seeing a bunch of these errors on my ...
2
votes
1answer
26 views

Effects of renaming FC and using its original name for AG network name

We have a Failover Cluster, named MainSQL consisting of MainSQL01 and MailSQL02 which are default named instances and we can connect to whichever is the active node with just simply MainSQL. If we ...
-2
votes
0answers
29 views

Hi is there any to check that database table contains MULTIVALUE Columns [closed]

In my project i want to check that whether the database is in the 1st normal form. TO check that i need to check whether there is any multivalued column in any table.
0
votes
1answer
30 views

Database design: Which will perform better, auto incremented column or a composite key for appointments

The schema of table is : appointment(date,time,patientID,...) pateint(patientID,PName,age,...) PS: two or more patient can came at the same time . The number of appointments per day up to 500 . ...
2
votes
4answers
177 views

Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'

I am wondering if it would be possible to use over (partition by...) clause in order to avoid using a sub-select in the example below: declare @t table ( id int ,code char(2) ...
1
vote
2answers
64 views

script task sssis file extension is missing?

Hi I have problem with script task C# I create I have to prefix log file with date but my problem is not adding file extension log file is log_yyyy_MM_dd without extension I want ti extension log ...
-3
votes
0answers
29 views

What softwares are found in DB systems [closed]

I am new to database concept and application. I want to know what softwares exist in a whole database system?
-1
votes
0answers
33 views

Getting error creating database in SQL Server 2005 [closed]

I'm an error message when trying to create a database in SQL Server 2005: An exception occurred while executing a Transact-SQL statement or batch. Service Broker message delivery is not enabled in ...
0
votes
0answers
16 views

Mysql connections not closing

I have a web application running on Tomcat7 that connects to MySQL 5.5. I have two servers running the identical code: Ubuntu Red Hat The Ubuntu one runs fine maintaining a steady 8-16 ...
1
vote
1answer
22 views

MySQL wait_timeout setting ignored

I have a MySQL 5.5 instance running on a RedHat distro. I have edited my.cnf with the following setting: wait_timeout=30 However, client connections are sleeping and never getting killed. The ...
1
vote
1answer
19 views

DB2 Commands — Different ways of stopping database

I'm hoping to get a more in-depth explanation of the following DB2 commands, which all relate to stopping the database in some way, and how they differ from each other. How do DBAs think about these ...
0
votes
1answer
16 views

Array column vs another table when the relationship is quite small

The Data I am creating a table of cities and their zip codes for the United States. Some zip codes have a list of acceptable cities, as designated by the USPS. For example, the zip code 36613 is ...
0
votes
0answers
21 views

Local SQL database settings to better mimic SQL Azure

I am developing a new application and use SQL Server 2012 installed locally for development. Then it is being deployed to Azure and running against their SQL Azure Standard S2 service. When running ...
0
votes
0answers
15 views

MySQL,- changing collation causes big problems

For one of my tables I have changed the collation from latin1_swedish_ci to utf8-unicode_ci. Then one of my queries, run from a synchronization script, ran amok. It cause sessions to lockup and not be ...
0
votes
2answers
48 views

ORA-01410 Error

I am getting ORA-01410 and ORA-06512 for the following block of code in a trigger im firing for deletion of a record in my table. Are the calls correct ? getlong ('xxx', 'YYY', :OLD.ROWID), getlong ...
0
votes
3answers
24 views

Case when not return more than one value

I try this, but the SwitchCase can not return more than one value. WHERE CP.NumIntAut IN ( CASE WHEN @NumIntAut IS NOT NULL THEN (@NumIntAut) ELSE (SELECT NumIntAut FROM ...

15 30 50 per page