The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

2
votes
1answer
29 views

SQL Server 2008 R2 services not coming online

I am working for a critical account and yesterday I got a weird issue after applying cumulative update package 14 on top of SQL Server 2008 R2 Standard edition. Before applying CU-14 package on the ...
1
vote
1answer
17 views

get number of events per day from profiler trace

I am trying to do something that I thought would be simple but turns out it is not (for me). I have 5 days of profiler trace files that I have imported to a single table. I want to query the table and ...
0
votes
0answers
17 views

Storing information in an online database securely whilst being able to access it through applications [on hold]

I am looking into making just a simple game for experience reasons, to learn about databases and storing the data online. However, how would I store the data in an database that is encrypted without ...
0
votes
0answers
29 views

Can we update mysql database table through .csv file And pls update not loading data from .csv [closed]

I have a mysql database table and I am updating few elements of an attribute of the table trying to do this by importing .csv and then what should be the approach as the csv file contains the updated ...
-2
votes
0answers
11 views

What is the difference between Failover Clustering and AlwaysOn Availability Groups in SQL Server 2012 [duplicate]

I would like to know the differences between Failover Clustering and AlwaysOn Availability Groups in SQL Server 2012
-2
votes
0answers
16 views

Students Results Online Checking [closed]

Good day all. Please I want to create an online database portal which we enable my students check there results online, I simply mean : I would like to create an online portal that will enable the ...
0
votes
1answer
20 views

Unstructured to Structured Data

This is highly a research based question about converting the unstructured textual data to structured data. Are there any systems or tools perform automated process of converting the unstructured data ...
2
votes
0answers
28 views

Create File,secondary FileGroup then move a table and restore database with 'Primary'

i created secondary FileGroup , linked a File then moved a table there and restore database with 'Primary' however the table name still there and when I use the select statement I got an error that it ...
0
votes
0answers
11 views

How can i delete or clear log files in sql? [duplicate]

I would like to clear the space occupied by log files how to do that in an sql server
2
votes
0answers
72 views

Is there a recommended for the database-to-DBA ratio? [closed]

We are now in a process of justifying the hiring of more staff for our DBA team. We have about 246 database instances. Not all of them are Oracle instances, some of them are PostgreSQL databases in ...
0
votes
1answer
23 views

How to get capacity specifications for a particular Oracle release?

How to get capacity specifications for new Oracle release(Oracle 11.2.0.4)? ie, information like How much schema we can create?, How much tables a schema can accommodate? How much rows total ...
0
votes
1answer
36 views

If my Data, Log and Tempdb drives are on the same LUN, are they using 1 physical drive?

My SQL Server Data, Log and TempDB resides on different logical drives. But when I check the drive properties under Hardware tab, their location are located on the same Port, Bus, Target ID and LUN. ...
0
votes
2answers
37 views

System Databases Integrity Check & Full Backup

I have an SQL Server 2008 and for maintenance solutions I use Ola Hallengren scripts. Recently, out of 15 databases I have on this server, I made two changes in three of them (not system databases, ...
-1
votes
0answers
32 views

Get the sum of Total Churn_MTD(Current+2015+<2015) [duplicate]

how to declare 8 variables and get the total Sum,as you can see from the picture i created the 3 store procedures but dont know how to do the ...
2
votes
1answer
25 views

Can't access MySQL database with created user through dll

I have a web service that connects to a MySQL database from a dll, both of them are on the same machine. If I use the root user and password it will connect no problem but if I use a user that I ...
0
votes
2answers
65 views

Insufficient Privileges When Connect to SYS and SYSTEM [on hold]

I have installed EBS VISION instance on my virtual machine. After installation from my windows machine I am able to connect to schemas such as APPS, HR, however, unable to connect to SYS and SYSTEM ...
0
votes
0answers
20 views

Phpmyadmin not displaying table data

I have a table named "log", which basically stores error log for my php application. My application has database running on rds, and recently i had to delete logs from this table, so i downloaded a ...
0
votes
1answer
38 views

Query other database's INFORMATION_SCHEMA tables

I have a shared database that stores procedures for all the other databases on the same server. This helps maintain one instance of a procedure rather than copying it across all databases. As long as ...
0
votes
1answer
42 views

pgbouncer 1.7 with TLS/SSL client and server connections

With settings borrowed from a similar server running Postgres 9.4.1 & pgbouncer 1.6.1, I have multiple users connecting to the database through pgbouncer on port 6543. I also have a second server ...
0
votes
2answers
53 views

Can Oracle databases start automatically when Windows machine is booted/rebooted?

In one of my client machines every time Windows starts we have to start the Oracle database manually. Is there a solution/ command to start the database automatically when the machine is ...
1
vote
1answer
45 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
42 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 ...
2
votes
0answers
39 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 ...
1
vote
1answer
131 views

Slow query - Optimize - PostgreSQL

I've got a slow query here... could you please help me to optimize it? Query: SELECT concat(company, ' ', customer_name_first, ' ', customer_name_last) AS customer, sum(revenue) AS revenue, ...
3
votes
2answers
39 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 ...
0
votes
1answer
27 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
33 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
12 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
30 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
51 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
89 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 ...
-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 ...
7
votes
2answers
80 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 ...
4
votes
1answer
24 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 ...
3
votes
2answers
67 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 ...
6
votes
0answers
83 views

How to reload a linked server?

I am using Microsoft SQL Server 2014 - Enterprise Edition, a problem occurs with the linked servers where it is necessary to restart the server or to stop the MSSQLSERVER services. When the server is ...
1
vote
0answers
20 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
1answer
31 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
25 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
55 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 ...
1
vote
0answers
27 views

IBM Bluemix SQL Database service data store management

I'm working on IBM Bluemix SQL Database service with premium plan. According to our application the sql service can have many schemas. Is there any way to seperate data storage of each schema to ...
1
vote
0answers
24 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 ...
3
votes
2answers
47 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 ...
0
votes
1answer
36 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
50 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
27 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 ...
4
votes
1answer
100 views

Getting a proxy account to backup to a share using Ola Hallengrens backup script

I have a SQL Server 2012 Standard install where the Engine and Agent are running under the default NT Service accounts Engine - NT Service\MSSQLSERVER Agent - NT Service\SQLSERVERAGENT I am trying ...
0
votes
1answer
15 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 ...
2
votes
0answers
47 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
2answers
53 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 ...