The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

0
votes
0answers
53 views

Create replication sql server for DWH [closed]

I have a DWH and I need to make an update once a day from STG Database to DWH I need use replication in SQL SERVER, How I do this?
0
votes
1answer
1k views

SQL Server 2012 T-SQL Health Check Script / Stored Proc [closed]

I'm hoping not to re-invent the wheel. I was looking for a routine server side health check script(s) / Stored Proc(s) for SQL Server 2008+ hoping they work on 2012 that provide information in ...
1
vote
0answers
698 views

Truncating Table Partitions Containing Data and Global Indexes

I have to truncate a partition (392,000 records) of a table with 20.000.000 records. At the moment, I'm making a truncate table and rebuilding indexes. But the table has 37 indexes and it takes 20 ...
0
votes
1answer
173 views

How to scatter/arrange all the tables in database model (workbench)?

I have around 71 tables and if i open them for creating a model in workbench all overlap as below If i use the auto layout under arrange section then max i can get is as below How to auto arrange ...
0
votes
0answers
53 views

Every 30 minutes mysql stuck for 20-30 seconds [closed]

I have very strong mysql 5.5 computer (Windows server / AWS) . My CPU ~8% ,Disk IO - 0.5% , ~Connection - 800 binlog_format=MIXED, innodb_read_io_threads=64, innodb_write_io_threads=64, ...
7
votes
1answer
10k views

What exactly is binding in DB2?

I recently crossed over from being a Java developer to an actual DBA in our company. I am learning the ropes, so to speak, about being a DBA (which is actually somewhat of a new position for our ...
0
votes
3answers
434 views

MySQL Large DELETE with JOINs

I have a large table players with ~20MM rows which joins to a table stats with ~300MM rows, among others (photos, ...). I want to DELETE all records for players that were born_on before 1950. I ...
0
votes
2answers
162 views

Is it possible to know how many times a user connected to an Oracle database?

Is it possible to know how many times a user connected to an Oracle database? If possible where we can find this information?
2
votes
3answers
2k views

What are the risks of copying MDF/LDF files without detaching the DB first?

Where DB backups are not available, our support team has been trained to restore using the following steps: Get a copy of the MDF/LDF from a file system backup. Stop the instance. Overwrite the ...
1
vote
1answer
85 views

Difference between sql agent account logged in as NTLM and UPN?

Can someone please tell the difference between a sql agent account logged in as NTLM and UPN? What is the difference if the sql agent account is logged in as: domain\username and username@domain.com? ...
0
votes
0answers
52 views

MySQL grant select not working properly 5.1.73-log

I have created new users with GRANTS SELECT but this is not applied and still user have full privileges and can still DELETE, DROP, INSERT. SHOW GRANTS for dbreader; GRANT SELECT ON *.* TO ...
1
vote
2answers
2k views

Optimize a MySQL Database using MySQL Workbench

I actually have a few issues. First, I found this information about optimizing: MySQL OPTIMIZE all tables? The problem is, I don't seem to have a mysqlcheck program anywhere. I'm using MySQL ...
0
votes
1answer
253 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.
0
votes
4answers
103 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 ...
3
votes
2answers
603 views

What's the point in SQL Server Central Management Server?

Online MSDN article "Execute Statements Against Multiple Servers Simultaneously (SQL Server Management Studio)" (SQL Server 2012) states: "Note Before you execute the following procedures, ...
0
votes
1answer
324 views

Where to install Oracle client software on SharePoint 2010 Server

We have our ASP.net web application hosted on a SharePoint Server 2010. Our application uses oracle database to save and retrieve data.For our application to work on SharePoint server we need to ...
0
votes
0answers
27 views

How to recover data in a MySQL DB?

Log file says: Recently disk space on my VPS got filled up. Now my DB looks corrupted, MySQL error log says: 140319 01:28:57 mysqld started 140319 1:28:57 InnoDB: Started; log sequence number 0 ...
0
votes
4answers
212 views

SQL Server 2005 - 2 sets of backups - 2 maintenance plans?

I did my best to search for an answer to this question and couldn't find a scenario quite like this. I'm a fairly new DBA in the sense that I haven't had a ton of training, I basically took the job ...
4
votes
1answer
3k 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 ...
4
votes
2answers
562 views

Update Statement takes forever to complete [closed]

I have table around 1250000 records, and 80 columns Table Structure CREATE TABLE [dbo].[Table] ( [Column1] [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL, [Column2] [int] NULL, [Column3] [int] ...
1
vote
5answers
758 views

How to determine why a MySQL server has become slow and requests sometimes time out?

I'm working on my first project that makes heavy use of a MySQL database and am struggling to understand performance issues I'm having. Most of the time, responses are returned quickly from the ...
1
vote
1answer
39 views

Why Database use Buffer pool for write operation? [closed]

In this case, first we write data in RAM,then same data write in database? Why we need do write operation two time?
0
votes
0answers
82 views

Oracle Merge performance

I've a question about the merge performance in oracle. I work in the business intelligence area of a big company and its quite common to have to move millions of records one side to other. The other ...
0
votes
2answers
165 views

Recovering mysql innodb table from table.ibd backup file

Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server). Now for a scenario, where some how a table has been ...
1
vote
2answers
127 views

Triggers After Insert and After Update - Good Practice

It is a good practice to have a separate trigger for After Insert and another one for After Update or there is no problem in having both in the same logic? Also from a perspective of performance it ...
-2
votes
6answers
761 views

Missing import function in SQL Developer like MS Access has

At my work we used to use MS Access now we are forced to use SQL developer to create queries and export the data. Details: We can only query to the database We cannot create a new database We use ...
1
vote
3answers
2k views

Proper MySQL database maintenance

I hope this isn't too broad of a question. I'm certain it'll be able to help me and any future dba noobs that stumble upon it. I'm a systems admin that got put into the roll of DBA (because I helped ...
5
votes
3answers
275 views

Bad use of Oracle Tablespaces

I have a doubt about the use of oracle tablespaces. I've decided to define for each schema of the datababase two different tablespaces (one for data, and another one for indexes). The problem is that ...
0
votes
1answer
164 views

can't connect to postgresql with md5 [closed]

I can connect to db with trust, but it is not letting me to connect with md5. It says : "password authentication failed for user "postgres"" Here what I have in pg_hba.config host all all ...
0
votes
0answers
71 views

how to archive old entries from mysql on rds

I have an AWS RDS MySQL DB. I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest. I'm still new at this so I'm not really sure what to do. What ...
0
votes
0answers
16 views

ASE 15.03 mixed data and log segements [duplicate]

I have a DB with mixed data & log segments. I also have some log on data device & the other way too.. The target is to have the data & log segments aligned properly , please guide me how ...
0
votes
1answer
825 views

I have mistakenly deleted Datafiles.

In my production server I have mistakenly deleted datafiles. When I am trying to open the database I am getting an error. The files are not important but the database is not opening up. SQL> ...
38
votes
12answers
4k views

How could DBAs be more 'programmer friendly'?

The answers and comments on the dba.se version and programmers.se version of the question "What are the arguments against or for putting application logic in the database layer?" are very revealing ...
0
votes
0answers
45 views

MySQL beginner in troubles

My MySQL knowledge isn't really good. However, I tried to move my websites media folder to an other location and afterwards wanted to update the links in my database: UPDATE wp_posts SET ...
0
votes
0answers
415 views

Firebird-Time Interval- between 2 Dates

I try to select the period of employment for the members in a Company. Example: Date of join: 01.01.2001 Today: 27.02.2014 Now, I want this: 13 years, 1 month and 27 days I have a Statement which ...
1
vote
1answer
1k views

How to grant rights for a user in DB2 Express?

I have installed DB2 Express on a PC. My user is not an administrator user, however as far as i know, it is possible to grant a user rights, so he can create/delete/modify a database. I have ...
3
votes
1answer
955 views

Confused about load balancing and horizontal scaling in postgresql [closed]

Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, ...
0
votes
0answers
12 views

Tables not created in default tablespace postgresql

I have create a database with default tablespace 'TEST1' instead of pg_default. the owner of the database and the tablespace is postgres. I log in to the database with postgres -d test create a table ...
0
votes
2answers
82 views

How to store a database table in multiple disks with assigned ratio?

I am going to deploy database tables to multiple disks. My database layout would be like following example: There are 3 tables (Customer, Order, Product) and 4 disks (disk_A, B, C, D). Customer: 5% ...
3
votes
2answers
6k views

db2 database alias not listed via list database directory but still unable to create that database

I am trying to create a database by logging on to the linux server on which the db2 server is installed, as the instance owner db2 => list database directory System Database Directory Number ...
0
votes
1answer
272 views

What is a bucket in database? [closed]

I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example? Thanks!
0
votes
1answer
263 views

replication breaks after upgrading master

I have a set up of replication with master 5.1.30 and slave 5.5.16 and the replication is working good Now i have upgraded mysql master to 5.1.47 As far as i know we have to turn off the log bin ...
1
vote
1answer
285 views

ORA-12541 error while connecting to oracle express edition 11g

My oracle express edition was working some months earlier. I dont know what i changed in the system, now I could not connect to it. I tried logging in from sqlplus as sysdba and altered the accounts ...
1
vote
2answers
347 views

Move a huge databases from one SQL Server to another

I have customers databases located on my SQL Server 2008 machine. The size of these databases are around 300 GB. I would like to move them all to another SQL Server 2008. Is there a way to shrink ...
0
votes
1answer
67 views

Database Designing Issue

I have a database having Millions of records in three tables. Now i want to split these three tables in multiple tables to reduce redundancy and data duplication. A lot of records(Persons) have ...
0
votes
1answer
231 views

Which MongoDB administration UIs offer a table view (OS X)?

The only admin UI we found that offers a table view is MongoVue, which is only available on Windows. We're on Macs with OS X. Do any exist?
0
votes
2answers
2k views

Restore the latest backup on the database

We have a stored proc which takes the backup from a database to the specified location. Sometimes the backup process runs more than once. It causes having more than one backup set on the same file ...
0
votes
0answers
62 views

SQL Server A network-related or instance-specific error

I have a windows service that performs a lot of hits to database. Sometimes the database connection is down and I got exception "A network-related or instance-specific error". I got this behavior on ...
0
votes
0answers
65 views

InnoDB crashes frequently

My Innodb Engine is getting crashed frequently. I could not find the reason behind this. This is the error log: 140129 9:22:49 [Note] Plugin 'FEDERATED' is disabled. 140129 9:22:49 InnoDB: The ...
3
votes
2answers
4k views

SQL Server Connectivity Issues

I am getting the below error on occasion. Maybe every 30mins or so. I am not sure how to track what is causing the issue. I think it could be a Network problem as there are disk backups running as ...