The discipline of Operational and Architectural Management of Database Systems.
2
votes
1answer
246 views
Solve conflict between affinity mask and I/O affinity mask?
I executed this on one of our SQL Server machines:
EXEC sp_configure 'show advanced options', 1
And then executed RECONFIGURE. This presented me with the following error message:
The affinity ...
1
vote
0answers
81 views
Database instance keeps restarting
From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
4
votes
1answer
465 views
Appending backups while overwriting expired sets
I've been reading up on this, but the online documentation is a bit difficult to understand and seems awkwardly written. For example the INIT, NOINIT. One says it will try to overwrite everything. ...
2
votes
2answers
429 views
Take individual MySQL database offline
MySQL does not have any SQL commands or internal mechanisms for
making an individual database unavailable / offline
moving an individual database
Thtis being the case, how can you take an ...
2
votes
2answers
116 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
0
votes
1answer
312 views
Achieve log transfer to standby (Data Guard)
I am not able to transfer my archive logs from primary to standby. I executed the following query:
archive log list
Database log mode Archive ...
3
votes
2answers
160 views
How can I organize my tables?
My database contains more than 200 tables. When I want to modify or insert a table, I find it difficult to find it among all those tables.
Is there any way to collect related tables in a folder ...
-4
votes
1answer
97 views
Advice for designing a complex/multipart application [closed]
I'm designing a software application for my medical carrier.
It is very complicated, with many parts and many small details.
Some experts advised me to divide it to parts, then design the database ...
0
votes
1answer
624 views
DBF file exist while user has been dropped?
I am new to Oracle. I have dropped some users from my database using:
DROP USER username cascade;
The issue is that the .dbf file still exists in the $ORACLE_HOME/dbs/oradata/ directory, which is ...
2
votes
2answers
287 views
Standby controlfile error
I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
4
votes
2answers
149 views
Isolation Level for a Data Warehouse
We are building out a data warehouse (and also some data marts as well) in our organization. My DBA skills have mostly been on OLTP type applications, but I am moving into supporting OLAP for our ...
3
votes
1answer
286 views
Moving postgresql data to different drive
I am using AWS as my cloud environment. I installed PostgreSQL on the same drive as my root instance volume. I have attached and mounted the second drive to my instance. Now I want to move all my ...
3
votes
1answer
853 views
How to connect multiple users/schemas in Oracle 11g?
I'm almost new user to databases, so I think I'm doing something wrong.
I have the database created.
I created 3 users, 1 it's an Admin, 2 are just users.
I created 2 roles, 1 for the Admin and 2 ...
1
vote
1answer
148 views
mysql session logging tables
I've been building a session logging system for our sites. We get around ~15m hits a year and at the moment we're really only interested in stats about people who logon to our sites.
Our table ...
1
vote
1answer
124 views
Upgrade production database during software development lifecycle
Background
Using Oracle, there are a number of tools that help with migrating and applying development changes into the production environment (such as Embarcadero Change Manager). These tools can be ...
0
votes
2answers
66 views
what is the best choice from those two tables?
what is the best choice from those tables??
table A : keep DB simple with lower number of tables ... but i will find difficulties if i wanted to extract certain data from column of doses coz it's ...
1
vote
3answers
237 views
Instance Startup Modes & Shutdown Modes
So, I know that there are 3 modes of startup modes available for the instance which is NOMOUNT, MOUNT, and OPEN.
What I want to know is in NOMOUNT mode it is stated that the instance started but still ...
2
votes
1answer
488 views
Recover database until cancel without prompt?
The statement:
RECOVER DATABASE UNTIL CANCEL
prompts once to select the archive log file. Is there a way to pre specify the value so as to be able to use it in a script without prompt?
I have ...
1
vote
1answer
101 views
a question in tables relations
Table A is linked to Table B , and Table B is linked to Table C using primary and foreign keys
My questions:
Should i link Table A to Table C too?? Or Table B can act as intermediate link between ...
1
vote
1answer
69 views
Tables of a huge database
When I work on a huge database, and after following normalization rules, I found that I have many tables for each part of my huge database. That makes me worry about the final number of tables, it ...
0
votes
3answers
137 views
How do I enable READ-only (passive) mode in a particular RDBMS?
As most of you have noticed all StackExchange sites have been under maintenance/recovery a few days ago so they switched on READ-only mode. From their blog I know they used to use MS SQL Server 2008, ...
0
votes
1answer
145 views
Difference between chained and migrated rows
What is the difference between chained and migrated rows? Also what query should be used to display these rows? (I'm using Oracle 11gR2 database)
-1
votes
1answer
69 views
Can I make that connection?
If I have a column with data type varchar(max) in a table that contains a big piece of text, can I make a connection between a word or a sentence in that text with another word or a sentence in ...
0
votes
1answer
104 views
Patients profiles database
I am making software for patients in hospitals. I want to make an option that if a doctor has prescribed a drug that interacts with another drug that the patient already uses, a warning will appear ...
0
votes
0answers
163 views
Error connecting to DB
In regards to:
http://serverfault.com/questions/442218/remounting-mysql-under-a-new-mount-point
Everything is running. MySQL started but for websites they can not connect to the mysql database at ...
2
votes
3answers
1k views
Unable to start SQL Server Instance 2008 R2 - DB file corrupt
I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is
" The log scan number passed to log scan in database ‘master’ is not valid. This ...
1
vote
1answer
286 views
Data dictionary best practices in SQL Server 2008 r2 [closed]
We are interested in sharing the meta data and data dictionary among the team. I know that we can use the Extended Properties for this purpose, but based on my experience I've seen it gets out of date ...
0
votes
0answers
440 views
oracle database project ideas [closed]
I have to prepare three project ideas for my final year undergraduate project module. I like to work with databases and i want any challenging database design and implementation with various ...
0
votes
1answer
105 views
TSQL query for viewing start/end of all SQL Agent jobs yesterday
See this related query: What's a good tool for visualizing SQL Agent jobs?
I'm not after a visual tool however, since I am looking to build my own visualisation. This is my starting point, but ...
2
votes
1answer
715 views
What is the best database design for multi-language data?
I am designing a multi-language database for a piece of software with the following features:
data used in every country differs from other countries
data used in every country will be in 2 ...
3
votes
1answer
85 views
How can I copy specific tables into one SQL Server Table into a separate table automatically?
I'm not sure if this is possible. Looking for some help with a specific issue. I am building an iPhone application with a data layer written in Ruby that will connect to SQL Server 2008. For various ...
1
vote
1answer
92 views
Regularly import tab-seperated log file to MySQL
I'm looking to keep arpwatch entries in a MySQL database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
1
vote
2answers
627 views
The best way to rename the tables after development completed
What is the easiest and most reliable approach to rename the database tables and columns in SQL Server 2008 r2?
We have finished development and for some reasons, we are required to rename some ...
0
votes
1answer
88 views
How are transactions logs inserted?
I have an ms-access database at work that has a table that's a transaction log.
The table contains the following fields:
Date - The date the transaction took place.
Table_Name - Name of the ...
2
votes
3answers
145 views
Merging tables with a 1 to 1 relationship in a database
Is it a good idea to merge two tables that have a 1..1 relationship together?
I have inherited a database with too many tables linked together in a 1..1 relationship. I'd like to evaluate the ...
3
votes
3answers
128 views
What is a good guideline for sampling for statistics updates
Scope: A billion record table that is indexed in 10 ways. Rate of change per day is 1/2 a percent.
Some of the indexes are monotonously increasing (datetime/timestamp), yet the common queries most ...
0
votes
0answers
68 views
Connecting PCs with APEX
I am working on a Project using APEX.
I want to connect my friend to APEX so we can do work and assign tasks to each other.
Our PCs are connected to the same LAN and I can PING both PCs, however I ...
2
votes
1answer
271 views
When dedicated server process model should be used instead of shared process model?
It looks like Oracle shared server process model is better than dedicated server process model. In a shared server configuration, client user processes connect to a dispatcher and it can support ...
2
votes
2answers
977 views
Disabling Checking of Schema On Function/Stored Procedure Creation
I'm trying to automate the process that executes changes to the SQL Server 2008 R2 database. The process I put in place drops and recreates my stored procedures and functions, as well as run scripts ...
5
votes
1answer
326 views
Does dropping a Primary Key constraint from a Partitioned Table break the partition?
We have a table partitioned on a date column. The Primary Key for the table is a composite key of this date column and 4 other columns.
We are thinking about dropping the Primary Key constraint from ...
0
votes
1answer
56 views
Is Index Used for This Query
If so, which one?
How do we know?
I have 3 indexes in a query. Actually only the first 2 should be useful
{
"v": NumberInt(1),
"key": {
"LongitudeLatitude": "2d",
"Prominent"▼: ...
0
votes
1answer
543 views
How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I´m new to SQL Server administration.
I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary).
Is there some way ...
5
votes
1answer
1k views
Is it possible to synchronize two ms access db?
We have a flower store where we use MS Access and a client program to work with the database. But this program can work only with one database.
We are going to open a new store, so now we have to ...
0
votes
1answer
370 views
WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
The scenario
Two systems(not server) running PHP and PostgreSQL with the following versions
Fedora 15:
PHP
PHP 5.3.13 (cli) (built: May 9 2012 14:38:35)
Copyright (c) 1997-2012 The ...
2
votes
2answers
487 views
Why database diagrams are not working when domain account is attached to database owner?
I was trying to use Database diagrams is SQL Server and got following error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first ...
0
votes
1answer
142 views
Data storage in innodb
I am new to mysql administration and I came to know about the data storage in myisam is through .frm, .myd and .myi. I could not find the data storage mechanism in InnoDB rather than its storage in ...
3
votes
2answers
101 views
What are sensible/rational character limits in a database e.g. for a persons name
This is a general question about database admin.
Is there some kind of standardization for character limits on fields in a DB? It makes sense to specify character limits on the database end for ...
3
votes
2answers
632 views
Rebuilding index has impact on mdf/ldf files SQL Server 2008
While rebuilding index have used option 'SORT_IN_TEMPDB = ON' in order to avoid unnecessary growing your user database files.
What does it exactly means?
Is complete process done on TempDB and does ...
3
votes
3answers
114 views
Is this database fine for calculation?
I am doing an application called as Invoice Application.For that I have my database is like this.
Now my problem comes when I am taking the tax part in my database.As I have made tax as an option ...
4
votes
4answers
186 views
Recommendation for free event monitoring software
I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough.
There are some interesting suggestions in this ...
