The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

1
vote
0answers
39 views

Design of user database and basic authentication process [closed]

I want to know if somebody can give me very briefly information describing the design of a user database and the basic authentication process please? Thank you
1
vote
1answer
3k views

Oracle - ORA-01654: unable to extend index in tablespace

I referred to the below related question, but it was not helpful in my case: ORA-01654: unable to extend index <name of the index> by 128 in tablespace <name of the Index tablespace> I ...
0
votes
2answers
2k views

How to export Oracle database without data

I want export my Oracle database with its structure such as tables, schema, users, tablespaces, datafiles and everything but without the contained data.
0
votes
0answers
52 views

Chicken and egg problem with JOIN tables and memberships

So I'm having a problem where users are able to access certain models that depend on a join model that doesn't exist at the time of the access. Quick overview of the use case: Basic school ...
3
votes
0answers
68 views

PostgreSQL Streaming Replication Tools - Windows

Is there any clusterware available for PostgreSQL clusters running on Windows OS? I'm specifically interested in automatic failover and STONITH functionality. I've done a fairly extensive Google ...
4
votes
1answer
78 views

SQL Server 2008 R2 : LDF file size not increasing

I am using SQL Server 2008 R2. I have a table statDB of 100 GB in primary filegroup. I have created a secondary filegroup in same database (Lab1) and created a table copyStatDB. Now I start copy ...
3
votes
2answers
277 views

Historical dbcc checkdb results

Is there a better way of accessing historical dbcc checkdb result history (if output logging was not used at runtime) than xp_readErrorLog? EXEC xp_readErrorLog {0-20}, 1, N'CHECKDB'; SQL Server ...
2
votes
1answer
226 views

Best practice for when the ideal number of columns is unknown

I'm currently making a MySQL database to list products for an e-commerce site. Each product will have several sizes available which will each have their own dimensions and measurements (e.g. length, ...
3
votes
0answers
74 views

Need a way to prevent log shipping from kicking users out

We have SQL Server 2012. A service we use requires us to use log shipping, however we are tired of having users being kicked offline every 15 minutes. Are there any creative ways to get around this ...
0
votes
1answer
16 views

MySQL NDBcluster 7.3 limitation on Table Joining in a single SQL statement

I am a novice user of Mysql database and recently my company is evaluating MySQL Cluster for its shared nothing architecture and synchronised replication. However my colleagues informed me that the ...
3
votes
2answers
502 views

What is the difference between Used and Allocated space?

I am learning Database operations and I have found a couple of resources online that have given me a loose understanding, but I still couldn't explain the difference myself. Explain like I am five ...
2
votes
1answer
404 views

should we keep the log file or the data file on the fastest drive?

SSD = solid state drive We have a specific question about tempDB performance on server CRM01 (Marketing CRM server - running large queries): On CRM01, tempDB data and log files reside on the solid ...
0
votes
0answers
17 views

Fill the 5th table with 3 other tables data in LibreOffice

I have 5 tables primary key foreign key felh(felh_id, felh_nev) gepek(gepid, felh_id, gep_nev) lic(lic_id, lic_k, lic_l, lic_db, gep_id) pr(pr_id, pr_n, pr_vr, lic_id) haszn(haszn_id, gep_id, pr_id, ...
0
votes
0answers
11 views

Oracle OEM provisioning and patching

What is meant by Oracle provisioning and patching?, how can we do RAC cluster upgrades and patching using this in OEM ?
0
votes
0answers
71 views

Troubleshooting Memory-Pressure on SQL Server with 80+Gb RAM

I have a SQL Server cluster with 80+Gb of RAM and multiple production enterprise databases and applications running. We are encountering memory-pressure errors and are trying to troubleshoot what's ...
1
vote
1answer
63 views

Upgrade to SQL Server 2012 [closed]

We are currently running SQL Server 2008 Standard edition, 4 processors / 16-core and 32 GB RAM. In the last 3 months number of requests per week raised from 11.1 millions to 72.1 million and the ...
1
vote
0answers
10 views

Multiple datasets from multiple applications [closed]

I have been working with different application such as STATA, SPSS, Excel and R for data analyses of health population. Because each program has different features that I need, I'm looking for advice ...
3
votes
1answer
362 views

Unable to change database owner to a user that is already mapped as user

I ran into this problem. Trying to change a database owner to acct1; however, I get the following error message when doing so: The proposed new database owner is already a user in the database ...
2
votes
1answer
156 views

Migrating Oracle 9i database to MySql database on a different Windows Server

I need to migrate my Oracle 9i database with all its tables from windows server 2003 to MySql on another Windows Server 2012. The oracle database is connected to Visual Studio web project. I have ...
0
votes
1answer
137 views

Multi Source replication on single slave having multiple instances MySQL

i had 1 instance of mysql 5.6 on one server A (Slave S) 1 Mysql installed on server B ( Master M1) 1 MySql installed on server C ( Master M2 ) At Slave end : I have created one more instance by ...
3
votes
1answer
61 views

`chown -R` equivalent for PostgreSQL

We occasionally have the problem that, when upgrading some software and database, inexperienced (or overworked, not excluding myself) sysadmins (we don’t have separate DBAs except for Oracle) run the ...
1
vote
2answers
393 views

Understanding the usage of version store in tempdb

We are trying to analyze the growth of tempdb on one of our SQL server 2005 Ent SP4. I know tempdb would need the space depending upon the transactions, and how queries are designed to use it. We ...
1
vote
1answer
39 views

Root Remove Remote % host. My SQL

So i accidentally made it so root can be accessed anywhere remotely how do i revoke the % privilege. Using mysql. +-----------+ | host | +-----------+ | % | | 127.0.0.1 | | ::1 | | ...
3
votes
1answer
36 views

SQL Server 2012 - How to Remove Partition on Publisher but not Subscriber?

Is it possible to setup partitioning on a SQL Server 2012 publisher table, so that older data can be removed without affecting the same table on a subscriber table? Table exists on Database A (SQL ...
8
votes
3answers
820 views

Accidentally change database name (SQL Server 2008)

It didn't happen to me YET. But I was thinking about this. I was messing around with my training environment, and by mistake I clicked in the database name, and then I touched the letter A. Let's ...
1
vote
2answers
167 views

Auto incrementing a column based on another

I have an application which generates invoice_id's. These id's need to be unique. The issue is that a client can have more than one invoice depending on what plan they are on. It could be 2, 3 or 4. ...
1
vote
2answers
63 views

Looking for application which will provide to determine project database growth and cost per day or month

I am using SQL Server 2008 for product development Currently application is live with 20 users now if I want to check how my database is growing and how much it will grow in month or year projection ...
0
votes
2answers
66 views

Listener.ora Location

What is the location of the Listener.Ora file in Windows OS? I need to edit that file and I am not able to locate where it is.
1
vote
0answers
440 views

Linked Server vs. Ad Hoc (OpenRowset / OpenDatasource) Distributed Queries

I have an application which needs to grab data from different clients' databases that reside at the client's location. So alongside their normal details such as company name, address etc, I also store ...
6
votes
3answers
414 views

Sql Server Service Pack Update Notifications

Is there any option in Sql Server to enable notifications from Microsoft in a way that it sends us emails every time a new service pack is released? I have multiple servers with different versions of ...
1
vote
0answers
34 views

Managing logs generated by user

I am developing a web app for my client and there is a section which displays the changes made in the application by any of the user. This section is known as log.It basically stores and displays the ...
1
vote
1answer
94 views

With LocalAdmin become sysadmin SQL Server

I am a local Admin on my machine. Same old thing, my account wasnt added when SQL Server was installed, and I don't want to have to reinstall SQL Server. I went through this blog and it worked until ...
0
votes
2answers
98 views

'Use <database> ' statement not executing T-SQL

Okay, this seems funny for a simple script: but I really need this small piece to execute well. DECLARE @dbName NVARCHAR(50) SET @dbName = 'rx_lab' DECLARE @SQL02 NVARCHAR(MAX) SET @SQL02 = 'USE ['+ ...
3
votes
1answer
138 views

Create Database and LCK_M_S

We are experiencing issues when creating a database in the SSMS GUI in that sometimes it times out complaining that it could not get an exclusive lock on the Model database. Other times the database ...
0
votes
1answer
42 views

Feasibility of Automated and Continuous Performance Tuning in the future [closed]

First a quick background: I'm a software developer, not a DBA and have been developing for more than 10 years. Recently I had to optimize a stored procedure and had to run execution plans, ...
0
votes
0answers
60 views

Column based replication in mysql 5.6

I want to do column based replication which means: In my server, I have table T1 in which columns are A, B, C, D, E I want to replicate this table on different server in mysql 5.6 only, but with ...
0
votes
1answer
160 views

String to timestamp in datastage 9.1.2

Apologies for asking a question that I suppose is very basic. I'm just starting out with Streams. I'm trying to read a sequential files containing a timestamp field and a value field, like this: ...
1
vote
0answers
107 views

Data compression within Internal Tables in SQL server 2008R2

We are doing downgrade from enterprise to standard for couple of servers which are not using any enterprise features: For one of our TFS(Team foundation server) database TFS_resx, when we ran ...
0
votes
0answers
29 views

Accessing database from a number of servers

I have a few servers that access a database, and I was wondering what is the best way to handle access to the database. Is it secure that each server will be able to access the database, or should I ...
0
votes
1answer
67 views

Unable to start the services of SQL server after Downgrading from Enterprise to Standard

We are performing the downgrade activity from SQL server 2008 R2 Enterprise to Standard. After the uninstall and re-install the standard version, (once the saved system databases were copied to the ...
0
votes
1answer
271 views

Attaching Database Incorrect name in sys.master_files

I have been moving some databases from SQL 2008 to SQL 2012 using detach and attach method. I correctly map up all the files and the physical and logical names appear correctly in the properties of ...
0
votes
3answers
157 views

Merge MySQL tables without data repetition

My situation is this: I have several DIFFERENT tables in my MySQL database with the same name columns. Such tables can contain (or not) the same data. What I need to do is a kind of "merge" between ...
1
vote
1answer
95 views

SQL Server Failover Cluster Instance compatible with VMware HA?

Imaginary Setup: Microsoft SQL Server Failover Cluster Instance on virtual machine in an ESX-Cluster. Question: In case of a hardware failure, what will happen with both high availability ...
0
votes
1answer
33 views

Big Size Database and increasing number of users [closed]

Me and my colleagues are using quite big size normalized database. Basically it's used for warehouse management and daily minimum 100 of the user perform data manipulation operations. 80% of the ...
-1
votes
2answers
99 views

database Compatibility 90 to 100 changing causes any problem

We are planning to change Compatibility level of databases from 90 to 100. Would this cause any impact on application side? If yes then please guide me, what steps or measures we need to look upon ...
0
votes
0answers
54 views

IBM Data stage compiler error

I have installed InfoSphere Datastage 9.1.2 on Windows Server 2008 R2, and also installed C++, but when I try to compile a job show error in transform stage.
0
votes
1answer
35 views

DB Recommendation While Minimizing Size

I apologize if this question is too specific, if it is, please let me know! I have searched around both on here and the web on selecting the best project-specific engine to fit your needs, and have ...
0
votes
0answers
61 views

What is wrong with my ERD?

I am trying to create a reservation/booking ERD. Is their anything wrong with my current ERD? It must show a supertype and subtype, and it must identify attributes for regular, weak, and associative ...
5
votes
2answers
3k views

Transaction log is full due to 'CHECKPOINT' for DB in simple recovery model

For one of our DB's on SQL server 2012 RTM, We could not perform almost any troubleshooting step as the error says: " Transaction log is full due to 'CHECKPOINT" This being a dev database, its ...
0
votes
2answers
90 views

How can I find table name for each row result?

How can I find the table name for each row result in my query? I have tried ideas suggested on the stack network (overflow, dba) 1 How to make a table name an attribute in PostgreSQL? 2 ...