The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

1
vote
1answer
81 views

Will transactional replication break if there is a heavy update/delete query run on the publisher DB

For these specifications: Publisher: (prod OLTP DB server) SQL Server 2005, database size : 220 GB also acts as the distributor Subscriber (Prod reporting DB server): SQL Server 2005, DB gets ...
2
votes
1answer
47 views

For a software application, does every workstation need database drivers?

really a just a newb question. In the case of something like an enterprise system for a company, where end-users are executing continuous reads and writes to a database, it does not appear that in ...
1
vote
1answer
311 views

Create user to monitor database activity on Postgres

Postgres 9.3 Debian 7 I want to create a monitor user called monitor that the only permission is to run queries to monitor all the database activity. I created the user and it can select from ...
2
votes
0answers
71 views

Database Corruption - object in sys.parameters does not have a matching row in sys.objects

I'm using SQL Server 2008 R2 and I have a strange db corruption. I ran dbcc check db and the output is: Attribute (object_id=1096186) of row (object_id=1096186,parameter_id=1) in sys.parameters ...
33
votes
1answer
58k views

What is the best way to reduce the size of ibdata in mysql?

I have some Production servers whose ibdata files increases in size day by day. It has already consumed 290GB of space. The tables in the servers are mostly InnoDB and there are high read and write ...
2
votes
2answers
45 views

Mysql - Each mysql database with its own user?

I developed a web app in which each company that registers on the app gets its own database with its own mysql-user credentials. Is this approach fine OR can I use one master mysql-user account to ...
2
votes
1answer
184 views

“Unknown table engine 'innodb'” error after changing my.cnf

I am getting "Unknown table engine 'innodb'" for some query after changing my my.cnf. I have reverted the old my.cnf and restarted mysql and now I can see innodb. Could you please help me figure out ...
33
votes
2answers
15k views

What does a DBA have to know about SSAS?

I've seen a lot of material covering the business aspect of SSAS, but not really much about the important aspects of administration and management. From the point of view of administering an instance ...
3
votes
2answers
338 views

Database Schema for Blank Database is large. 20MB

Is it normal for blank databases with just schema to be large? Or is there a way that I can reduce the size of the initial database?
2
votes
1answer
182 views

Will a primary key be added as a clustered index?

I've inherited a database where no primary keys were defined on the tables. There are also no clustered indexes assigned to the tables. If I perform an alter table to assign a primary key will this ...
-1
votes
1answer
29 views

Help with some references [closed]

Kind help if anyone has detailed of what a amstrong database are and how are they useful any current important changes in this field or advice on where I may get info in which forum any link
0
votes
2answers
50 views

Replication : Delete from Master Database

Is it possible to delete certain data from Master Database and retain that data in the slave ? For, example I want to delete data of before 5 years from master. And I'm sure that data is not being ...
0
votes
0answers
31 views

How to clean up transaction logs in production database [duplicate]

My stored procedure when executed on server machine takes nearly 1hr but when executed in my local it takes 1 minute. So when I check the log file, its size was near to 65 GB. Guess these logs are ...
0
votes
0answers
14 views

Manage clone of Production MongoDB on UAT env

I have mongodb (v2.4.9) replication setup on AWS ec2. I have one primary and 2 secondary for Production environment. The db size is around 80 GB and i am maintaining a snapshot of primary db server ...
0
votes
0answers
110 views

how to recover everything from ibdata in mysql

I lost all my databases files after my hard disk was broken, In a way or another I got ibdata files the size for the file is 4GB.After replacing log files and files and type innodb_force_recovery=6 in ...
-1
votes
2answers
146 views

How to delete millions of records from table

I am using postgree 9.4 database and I have a table snapshots with 700+ million rows and I want to delete about 9 million rows. I have tried different queries to delete records, but no success. Query ...
3
votes
2answers
302 views

Database not able to startup showing control file is inconsistent with another

Our windows server 2008 R2 is shutdown due to power failure. When I am trying to startup Oracle 11g database its shows an error. SQL> startup ORA-01081: cannot start already-running ORACLE - shut ...
7
votes
2answers
207 views

DBCC CHECKIDENT ('table name', RESEED, 20000) not working

When I run the script DBCC CHECKIDENT ('table name', RESEED, 20000) the output of the message is Checking identity information: current identity value '200000', current column value ...
5
votes
1answer
34 views

Correcting French Characters in MySQL

I Have a huge MySQL table with a long list of charities. Some of the charities have French characters in them which appear incorrectly. For example I'm getting uppercase 'É' instead of 'é' in the ...
-2
votes
1answer
25 views

Account AppUser not able to access SQL Server Agent job “AppSQLAgentJob”

I have added appUser to SQLAgentUserRole and have granted him below permissions grant execute on dbo.sp_start_job to appuser ; When I am trying to run AppSQLAgentJob, I am getting following error ...
1
vote
1answer
201 views

I Don't have PFILE or SPFILE just have a backup of init.ora and database is down

I have lost PFILE and don't have backup also, just have a backup of init.ora and database is down and not starting up. Does init.ora backup is useful? If yes then how to use it to create pfile or to ...
1
vote
0answers
27 views

How to bucketize using Query optimal bucketization algorithm

I am trying to implement query optimal bucketization algorithm (QOB). The input of the algorithm is D=(V,F) where V is the value of the attribute and F is the frequency of occurrence. For EXAMPLE D ...
1
vote
2answers
146 views

Mysql 5.5.25 must be restarted to connect

We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
0
votes
1answer
52 views

what is the consequence of setting enableQueryTimeouts to FALSE?

MySQL Connector-J has a property enableQueryTimeouts which is TRUE by default. However, in the documentation it is mentioned as : When enabled, query timeouts set via Statement.setQueryTimeout() ...
1
vote
1answer
27 views

What are the consequences of enabling slow_query_log and flushing the cache on mysql?

I have a large database that is performing poorly recently. I want to enable the slow_query_log to investigate the queries and flushing the cache but I need to know what are the consequences of doing ...
0
votes
0answers
481 views

Oracle Error ORA-15042 when trying to mount a diskgroup

everybody. I am having some troubles mounting my DATA diskgroup. I am getting this error: Mounting Disk Group DATA failed with the following message: ORA-15032: not all alterations performed ...
4
votes
2answers
3k views

How to remove identity specification for multiple tables

I am having total 109 table in Database and now i am migrating to Amazon server with identity insert and now i want to remove auto increment column specification for all tables. How set auto increment ...
3
votes
4answers
323 views

What architecture is best to store a large 3 dimensional array in MySQL?

I am looking to create a large 3 dimensional database in MySQL. The structure will basically be a standard MySQL table, with a time component / dimension added. See the following analogy: { x, y, ...
3
votes
2answers
58 views

Replication DB move

I have 2TB of DB involved in SQL Server transactional replication. I want to move publisher DB files to a newer disk with minimum amount of downtime and without breaking replication. Please let me ...
1
vote
0answers
40 views

After disabling replication, should I disable binary logging?

I have a master-slave setup currently but am going to remove the replication DB server. The DBs are running on MySQL 5.6. I have a couple of questions about removing the replication: 1) I have read ...
0
votes
1answer
43 views

mySQL Data loading: Better to column map or INSERT SELECT INTO ETL?

I've got 125 csv files to upload into a database. The files are typically ~200K rows and 30 columns. In order to make the data more relational I was going to column map during LOAD DATA INFILE ...
0
votes
1answer
62 views

Movement of Standby database from one location to another location

Looking for help on below mentioned process We are planning to move the standby database from Location A to Location B. I need your help to move this database using lift and drop method, by ...
0
votes
1answer
95 views

How do you GRANT SELECT on hidden resource database mssqlsystemresource?

I get an error when I run this query: SELECT dependencies.referencing_id as object_id, dependencies.referencing_minor_id as column_id, dependencies.referenced_id AS ...
0
votes
1answer
22 views

Cannot access mysql in ec2 instance

mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I installed mysql server on a ec2 instance and started it. Seems like it started , but when I ...
0
votes
2answers
63 views

Missing rows in Visual DBA, exist when queried specifically

Greetings fellow DB Admins, I have an interesting issue on which Google has failed me. Background: I am working with medical records managed with Ingres SQL. The other day I wrote a simple query in ...
1
vote
1answer
754 views

Database gives “ORA-01109: Database not open” error when it IS open

Running Oracle Database 12c on Windows Server 2012 Whenever I attempt to do a log switch (alter system archive log current), I am given the error in the title. Searching online shows the simple ...
1
vote
2answers
4k views

DB2 - how to safely blow away database on linux?

I'm using (I believe) 10.1.2, on CentOS 6.5 (for sure). The underlying problem I have is that the database upgrade package prepared in house isn't working for me, in at least the sense that the ...
2
votes
1answer
106 views

Forums about getting SQL Server 2000 Administration help?

What I'm trying to accomplish is that I need to migrate the SQL Server 2000 installation into a SQL Server 2008 installation, and I would like to say that I am afraid that after this operation I will ...
6
votes
1answer
356 views

Role of Database Administrators

I am currently working as an application developer on a project which involves the creation of a new SQL Server database. I am actively working with a group of DBAs who will play some role in the ...
1
vote
3answers
197 views

What are the challenges of administrating an International stock trading database?

I am a student, and have a question for an assignment: What problems and challenges do database administrators face when designing systems to trade international stocks in real time and 24 hours a ...
2
votes
0answers
66 views

CPU utilization reached 100% after changing OS time on SQL Server with Mirroring configured for a database

We have configured mirroring on SQL database server. Suddenly principal database server reached 100% CPU, windows log events shows following 2 logs This event is generated when the system time ...
0
votes
1answer
52 views

how to build statistical database?

According to the book I am reading, a statistical database is a database that permits queries that derive aggregated information but not queries that derive individual information. At current time, is ...
0
votes
0answers
28 views

How can I find last access time for users or specific users to all databases in SQL Server

I have a SQL Server with more than 100 Databases and I should manage the server and it's space usage, users can restore and use backups they have on the server, I have a software for this server,if ...
1
vote
5answers
27k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
1
vote
1answer
37 views

How to restore a database, ignoring the free space within each file?

Using the following script I get all the disk space used by each file in my database: ;with radhe as ( SELECT DatabaseName = 'my Database', --DB_NAME(), a.FILEID, [FILE_SIZE_GB] = ...
1
vote
1answer
55 views

Stored Procedures execution permissions

So what I am trying to do is to limit the access to a stored procedure so that only another stored procedure may call it. Here is an example: create procedure Database_Deployment_Proc -- This ...
2
votes
1answer
35 views

Could Not Be Accessed Value Of The For Loop Counter In PL/SQL

I try to learn PL/SQL for loops in tutorials. I learn flow of control in a for loops. (And i saw that it is same with most of the other programming languages) Here is the flow of control in a for ...
2
votes
1answer
64 views

Is this table in my ERD redundant? (Image)

I am developing a research article database for a project. My professor approved this design but I feel like the Author's_University table is redundant and that University_ID could just be added to ...
0
votes
1answer
31 views

Set Default Maximum Rows for Export

I am more of a Vertica database user than admin, so I'm not even sure if what I'm asking is absurd, but here goes nothing... Could I, as an admin, put default restrictions on the number of rows that ...
0
votes
2answers
75 views

SELECT fields from table having some conditions

I have two tables 1. Named as t1 2. Named as t2 example of the tables are : t1 : id name 1 one 2 two 3 three t2 : id name 2 five I need to select all the data ...