The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

1
vote
3answers
4k views

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
0
votes
0answers
23 views

CPU utilization for a particular query in Postgres [duplicate]

Is there any way to know how much CPU particular query is utilizing in PostgreSQL?
19
votes
7answers
760 views

Where can I find some guidance on index strategies?

Most of us will probably agree that using database indexes is good. Too many indexes and performance can actually be degraded. As a general rule, which fields should be indexed? Which fields should ...
1
vote
1answer
166 views

Is this a good case for multiple SQL Server instances on a VM?

We have a suite of applications utilizing SQL Server have the following characteristics: Users create/destroy DBs via a UI, so DBs appear/disappear without DBA assistance. DBs of the same name can ...
0
votes
1answer
58 views

Searching between dates on a CHAR type field

I have a table that has a field in which dates are stored, the problem is that the field type is CHAR(10) and I'm being asked to query for data between certain dates. I don't want to change the field ...
0
votes
0answers
34 views

Integrating Postgres/GIS data in a SQL Server environment without generating 'data islands'

Currently I'm facing a scenario in which a GIS expert is planning on starting to integrate mapping services for several departments within the organization I work for. I handle around 40 mid-sized ...
0
votes
0answers
25 views

Procedure Security Layer

I want discuss an idea with you and get your opinions what you think about it. From database (SQL Server 2008 R2) administration view and general security, its good practice to create DB roles and set ...
0
votes
2answers
63 views

Database logs growing during maintenance plan

I have read several threads and sites about SQL logs but I don't feel I have found the answer. Or if I did I did not understand it enough to address my issues. My issue: When I run my SQL maintenance ...
1
vote
1answer
70 views

Database backup issue in SQL Server

For security reason I always took back up of my database. I took full backup in each month. And differential in each week. I used to save each back up file in different name. I lost my latest full ...
-4
votes
2answers
629 views

Incremental backup in SQL Server [closed]

I got a task for backing up my clients data through internet. Client has about 50 GB of data there. So I need to back up the data and pass through internet, but it takes about 8 to 9 hours for this ...
1
vote
1answer
28 views

Trigger to apply user mapping to logins on database creation [closed]

Does anyone have any example triggers that apply user mapping on database creation?
3
votes
2answers
126 views

query to find all dblink()

Besides manually searching for all the dblink() used in triggers/functions/stored procedures is there a way to query for this information? Example: There is a dblink inside of a trigger, can I select ...
5
votes
2answers
938 views

When was a Database taken Offline

I am trying to find a way to figure out when was couple of my sql databases were taken offline. I checked the the logs but could not find any such info and moreover there is no default trace enabled. ...
2
votes
1answer
4k views

Cannot browse for Backup files using SSMS [duplicate]

I'm facing a strange problem. When I try to backup or restore any database using a SQL Server user (not sa) that belongs only to "public" server role, i have the following error when i click the ...
0
votes
1answer
50 views

How to directly query other user tables

I am trying to learn Oracle database and I am having difficulties on importing a backup file with impdp command. I googled deeply but couldn't find answers to my problems. What have I done until now ...
0
votes
2answers
130 views

Is there any other way that we can take auto backup in oracle 11g apart from RMAN?

I have tried with RMAN. But is there any other possible way that we can backup database and tables. backup using queries or stored procedures is possible?
1
vote
0answers
82 views

How does SQL Server know it was abnormally shutdown last time [closed]

I am doing background reading on this. Would like to know how does SQL Server know it was abnormally shutdown last time?
0
votes
0answers
69 views

Import non-partitioned table into an existing range partitioned table - ORACLE

I have export non-partitioned table1 on disk with some records, then I create same new table2 in my schema (different name) but with range partitioning, I'm talking about Oracle database. So my ...
-4
votes
1answer
31 views

ExecuteNonQuery () not fungsional and database failed [closed]

Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim SumberDb As String = "Data Source=c:\users\ogieuntung\documents\visual studio ...
0
votes
0answers
186 views

RapidMiner Not Connecting To SQL Server Database Connection

I recently installed RapidMiner and tried connecting the application to my MS SQL database connection via the Manage Database Connections feature. I have followed video tutorials on integrating SQL ...
1
vote
0answers
16 views

DB2 Change Journal Receiver Size

We are running DB2 on our iSeries, and there is a journal + journal receiver created. The current size of the journal receiver is 200MB (found using the DSPJRNRCVA command). Is there a way to change ...
1
vote
0answers
84 views

Reducing the size of a PostgreSQL Database, utilizing a process other than full VACUUM

We have a Postgres 8.4 installation which hosts both our Defect tracking and Code management (Surround) systems. We are looking at converting and migrating Surround to MSSQL on another server. Our ...
1
vote
0answers
1k views

How to debug problems with SQL Server multiserver (Master and Target server) administration?

I've tried to set Mater and Target Servers on various cobinations of SQL Servers 2012 R2 on Window Server 2008 R2 and Windows 7 machines but always getting one or 2 of the following errors during ...
0
votes
2answers
53 views

MySQL Image Queries

I have table employees in MySql database with Id, Name, Gender, HireDate, Photo. Photo field is blob. Now when I run this query: SELECT id FROM employees WHERE Photo IS NULL ; it takes forever to ...
1
vote
2answers
77 views

How to Permanently solve MySQL error 2002 (HY000)

I have a problem on my cloud server with 2GB of RAM and 40GB Hard Disk that's hosting a Wordpress website that receives around 1000-2000 hits a day. My problem is that MySQL is always crashing and my ...
0
votes
1answer
39 views

What is different between fixed-size disk pages and disk-based?

As per my knowledge, i understand fixed page size as size of page which used for read and write data but i am not able to understand what does mean of disk based ? I read these words from this paper ...
1
vote
1answer
639 views

Optimizing Amazon RDS - MySQLTuner Recommendations / Feedback & Suggestions

I'm currently trying to optimize a database I've inherited for speed. The server is an Amazon RDS db.m3.large instance: 2 VCPUs 7.5 GB Memory 500 GB HDD My current strategy is to do the ...
2
votes
1answer
422 views

Is there any way MySQL can list relationship cardinality between two entities?

I am working on the project where I have to analyse the MySQL schema. As a part of schema information, I want to list down relationship cardinality between different relations. Does MySQL stores ...
0
votes
3answers
845 views

Should login id and password be stored in separate table

I am working on my academic project. I have a table for employee records which have employee id, joining date, designation and other fields. I am trying to implement a scheme in which when record of ...
1
vote
2answers
110 views

Quickly clone a database in SQL Server Management Studio

For testing purposes, I often have to clone databases (onto the same server). Currently I do this by creating a backup and restoring it as a new database. I would love to have such a functionality ...
1
vote
2answers
116 views

How can I perform this database backup/sanitization task?

I have a 3-node MariaDB/Galera cluster. I need to do two things: Back up the database regularly (multiple gigs in size) for a normal, in-case-everything-crashes-I-can-restore-from-this backup. Have ...
1
vote
2answers
56 views

Is there an easy way to update connection strings to a database moved to a different instance

I have created a new instance of SQL Server 2008 r2 and exported my database to the new instance. Then I realized that the connection string for all of my datasets still point to the original ...
4
votes
1answer
284 views

Sql Server - Running a Job on Multiple servers

I am using SqlServer 2008. I have a Sql Server Job that checks Disk Space and emails admins if the space is less than 15% Instead of adding that Job to all servers is it Possible to run the Job on ...
2
votes
2answers
395 views

MySQL user without SUPER privilege

This may be a simple question and may not be the right place to ask but I couldn't find any useful information from Google. Here is my question. When creating users in mysql using grant all ...
1
vote
1answer
91 views

Incorrect unit allocation size. error comes when Tuning the Database

Here I am Using the SQL IDERA tool for checking the Index and performance of the Database, then i found below error, can any one tell what is it talking about. Incorrect unit allocation size. ...
11
votes
2answers
9k views

Why doesn't DELETE + REORG free diskspace (DB2)?

In DB2 I have a table containing large binary data. Now i purged the whole table and ran runstats, reorg, runstats, but the amount of disk space taken does not change. What could be wrong here? The ...
1
vote
0answers
66 views

Severity 20 Error upon disconnecting Dedicated Administrator Connection

Starting working with Dedicated Administrator Connections on SQL Server 2008 R2 servers. All is working fine (once port 1434 was opened), but am getting severity 20 errors when I disconnect the admin ...
4
votes
2answers
758 views

How to change default database to all logins?

I'm bit new to SQL Server and I'm trying to script out Microsoft SQL Server (2005-2014) post installation activities and I got bit stuck on altering logins. Corporate policy states that none login ...
0
votes
1answer
82 views

What is the best design for storing courses subscription data?

Building an app that will manage lessons, students, courses. Each lesson belongs to a certain course. A student can subscribe to a single lesson or to a whole course. So it seems straightforward that ...
0
votes
2answers
49 views

Initial Discovery process

I am looking to better my knowledge without actually being in the field, I was wondering what initial steps you take when you are assuming the responsibility of a server with SQL-Server installed on ...
1
vote
1answer
61 views

DataBase Back Up - with a Not Null Column [closed]

Can I include a default value to be entered in the Not Null columns when I do database back ups ? If so How can I do that?
0
votes
1answer
522 views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
0
votes
0answers
94 views

MySQL Dynamic columns duplicate value workaround

As the title suggests i have the following code which transposes certain row values into field names, however the problem im having is that the values "closed" & "reopened" may appear in several ...
0
votes
0answers
51 views

Performance/Maintenance Implications of a Write Heavy Table In An Otherwise Normal “CRUD” Database

We have a small-ish (<100,000 rows) MySQL database (on Amazon RDS). Its supporting a fairly simple read heavy CRUD web application. Currently we're building out a web analytics system. It will ...
2
votes
2answers
99 views

How should I (re) index the table while keeping the transaction log small?

I have a 170 GB table in a database. It has 70% fragmentation on its index (index has multiple columns in it). The last time I tried DBCC REINDEX the transaction log blew up in the hundreds of GBs. ...
0
votes
0answers
16 views

When importing with sqlite3, will the resulting database always be bitwise identical?

If I import a large set of data using the sqlite3 command-line utility on to different computers, will I get bitwise identical databases? For example - if I run a cryptographic hash against them, will ...
0
votes
1answer
116 views

What is the strategy of query evaluation in DBMS when Limit is used in query?

I have following tables in database post(post_id , user_id , post_text , parsed_text) ; Comment(comment_id , post_id , user_id , comment_text) ; friend(id , user_id , friend_id ) ; group (id , ...
1
vote
1answer
1k 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
2answers
2k views

MySQL - HOWTO speed up slave replication on large database / Quickly spawn slave?

We have a large mysql database (about 100GB on disk) that we would like to spawn a slave for. Our typical process for creating a slave is: Create a slave server Load in a mysql dump of the master ...
0
votes
0answers
54 views

Help with Joins - Cartesian Product

I have 5 regions that each contain 1 store and 1 warehouse. I have a table that contains the regions and corresponding stores and warehouses. I also have a table that lists the inventories of both ...