The discipline of Operational and Architectural Management of Database Systems.
1
vote
1answer
218 views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
9
votes
3answers
183 views
How to tackle a large undocumented database
I recently got hired as the only IT Guy in a certain Company X and I am tasked to fix their applications, and in my opinion, the best way to start is by understanding the database.
Their current ...
0
votes
0answers
14 views
what happens when closing berkeley db?
I have a program using berkeley db as data store, and when the program finishes its job and exits, it triggers berkeley db to close.
Ok, here is the problem. Nine times out of ten, my Linux system ...
2
votes
1answer
224 views
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
I have 3 simple tables with polls, users and votes. I'd like to show all polls ordered by clean count of votes (sometimes either poll_id or user_id don't get inserted).
Furthermore I'd like to show ...
2
votes
1answer
243 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
votes
1answer
130 views
How to calculate some specific things about a disk? [closed]
I have this situation where I need to calculate some things. I have following things with me,
Disk characteristics: number of cylinders;
number of heads;
# sectors/track;
...
2
votes
1answer
82 views
How can I rename a table, but also all FK etc. references to that table?
I would like to e.g. rename my Applicant table to ApplicantProfile, as applicant is an abstract entity that has a profile. The profile is not the applicant.
Simply renaming the table is hopelessly ...
0
votes
2answers
147 views
How to identify the db orphan mdf and ldf files
I want to identify the orphan mdf and ldf files on the disk and remove them. After searching on the internet, found the script below on MSDN forum. But when I run the script it returns many ...
0
votes
0answers
19 views
is there any strategy for back up the SharePoint Portal Server Farm?
We have many servers in our farm with SharePoint Portal Server and VSTS and Project Server. now we have up-to 100 DBs and back it up with STSADM.exe in schedule task.
But several of time this batch ...
3
votes
1answer
105 views
Easiest Way to Move 100 Databases
I need to move about 150 databases from one server to another server.
SQL Server 2008 Web Edition
SQL Server 2012 Preview (in a different datacenter - East Coast Azure)
I was planning on moving ...
2
votes
2answers
208 views
Perl vs Ksh for Unix Database Administration
I realize this is a somewhat more subjective question, but I am looking to the community for guidance.
Our company is fairly new to having DBAs. We used to use DB2 for i on the IBM's iSeries servers, ...
2
votes
2answers
135 views
How to login in database if we have lost password? [duplicate]
Possible Duplicate:
gain admin access to sql express 2008
Is there any idea if we lost our password to login in database using sql express management studio?
Is there any place where ...
1
vote
1answer
290 views
listener does not currently know of SID given in connect descriptor in oracle 10g and solaris 10 env
I have a oracle 10g database in solaris 10 system. The SID=OTRS, I can connect to oracle database from local server itself. But I can not able connect from another client. It is returning an error ...
1
vote
1answer
204 views
ERROR: database “dbname” does not exist
According to the documentation, so long as I'm not connected to a database, I can either delete a database in the console using:
DROP DATABASE dbname;
Or I can drop it using the wrapper tool ...
0
votes
1answer
37 views
PostgresSQL: Cannot get to console under different user name
I normally get to the console in UBUNTU by typing:
sudo -u postgres psql
But I need to delete a database owned by a different user.
When I type:
sudo -u username psql
It tells me "database ...
1
vote
1answer
278 views
Is there a progress indicator for OPTIMIZE TABLE progress?
MySQL 5.1.4x (Windows) | Innodb
I recently purged data from a mySQL DB (a few hundred thousand rows) and I'm planning to use
OPTIMIZE TABLE LOGTABLEFOO1,LOGTABLEFOO2,LOGTABLEFOO3;
to reduce the ...
4
votes
1answer
75 views
Expanding a partitioned table
I have a table that holds four years of data, where for each month I have a partition that is based on a filegroup with two files. Unexpectedly, I received eight more years of data and prepared the ...
2
votes
1answer
56 views
Searching transaction logs for changes
I currently have a database with an attached CMS. The CMS has about 50+ people with various permission levels that can log in etc... I would like to know if there is a way I can look at the ...
3
votes
2answers
155 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
442 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. ...
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 ...
2
votes
2answers
115 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
304 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 ...
2
votes
2answers
285 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
147 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 ...
-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
614 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 ...
3
votes
1answer
273 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
148 views
Can I check what the allocation unit size is on my drives via a query?
Assuming that I do not have access to windows server, can I run a script from SSMS that would allow me to check whether allocation unit size is formatted with 64K?
3
votes
1answer
817 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
145 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
100 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 ...
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 ...
2
votes
1answer
479 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 ...
15
votes
7answers
12k views
How can I tell if a SQL Server database is still being used?
We're looking to decommission a SQL Server instance which has a couple databases still remaining on it.
How can I tell if they are still being used by users or a web application?
I found a forum ...
1
vote
1answer
91 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 ...
3
votes
3answers
126 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
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
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 ...
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
1answer
144 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
0answers
159 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 ...
0
votes
0answers
438 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
103 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
693 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
2answers
606 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
144 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 ...
