The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

1
vote
1answer
16 views

Visual Studio Database Project

I work in a company that is deeply ingrained in .Net programming. I am responsible for managing a couple SQL Servers, with about a dozen databases in total. Our programming manager recently ...
1
vote
0answers
13 views

How to Move a whole partition to another tabel on another database?

Database: Oracle 12c I want to take single partition, or a set of partitions, disconnect it from a Table, or set of tables on DB1 and move it to another table on another database. I would like to ...
1
vote
2answers
32 views

Execute stored procedure remotely using linked server

We have 3 SQL Server 2012 instances, 2 of them we're not db_owner. Some of our stored procedures use DMV and sys views and stored procedures that only work when executed locally. I'd like to ...
0
votes
0answers
30 views

SQL Retrieval Into Excel HELP! [on hold]

The picture shows the format of E1 to maybe help out visually. I'm an intern and I work for an engineering company. As a project, I want to streamline the document control [DC] process and save time. ...
0
votes
3answers
36 views

SQL Server 2012 SA Access by domain admin [on hold]

We recently installed our SQL Server, and now the domain admin is pushing to get an sa account. I don't trust them for a second, and they have no experience with SQL at all, so I said no. We handle ...
0
votes
0answers
10 views

AlwaysOn DR/BCP Test Plan

I have setup new environment of AlwaysON on SQL Server 2014 for application.Now I have to test the DR/BCP failover.May I know the process to be followed and what all steps do I need to take care while ...
0
votes
1answer
23 views

design a database which each invoice is made at the end of the month [closed]

Each customer has different item prices, so i've made 3 tables: CUSTOMER(*customerID, customerName) PRICE(*customerID, *itemID, price) ITEM(*itemID, itemName) But each customer will receive their ...
0
votes
0answers
15 views

Migrating SQL Blob to Server File System

I was given a MySQL database that was created by making a .sql dump file from an existing MS Access DB. During that migration I have an attachment column that was given a BLOB datatype and the ...
0
votes
0answers
48 views

Cannot execute code connecting to SQL Server 2008 R2 in SQL Server 2014 SSMS

I am not able to connect and execute a code in SQL Server 2008 R2 while connected to SQL Server 2014 SSMS. SQL Server 2008 R2 is on Windows 2008 R2 64 Bit SP2 (Stand Alone) SQL Server 2014 is on ...
-1
votes
0answers
12 views

how do we know if mysql server is overloaded [closed]

I am developing an application using PHP. Sometimes Mysql is overloaded. Is there anyway I can tell the user the database is overloaded & to come back later?
0
votes
1answer
27 views

Temporarily stop Log shipping [closed]

How can I temporarily stop log shipping --> Do the task --> Start the Log shipping ? Is it possible ?
0
votes
0answers
12 views

Add a new column with new values

I need to ADD A NEW COLUMN with VALUES 'ABC00001234' In this case, all values in the column will be 'ABC00001234' Will the SQL statement add these column&value in the actual DBF? or for just ...
3
votes
1answer
80 views

how to find out what process(es) caused the autogrowth of a database or a database file?

I have a process(es) hungry for tempdb, but I am struggling to identify this process. any ways I could achieve this? We have been alerted as Tempdb has now grown into the space you reclaimed ...
0
votes
1answer
27 views

Change the Hosts files on both SQL nodes to show 127.0.0.1 LocalHost

How to do this ? Change the Hosts files on both SQL nodes to show 127.0.0.1 LocalHost
0
votes
1answer
19 views

Creating oracle Database instace

We need to create a oracle database instance similar to customer environment. What are all the parameters needs to be considered other than similar version of software. Like Character set, Multibyte ...
0
votes
1answer
23 views

Filtering One column into Different Columns in one statement

I need to SELECT amount FROM table WHERE type='1' AND type='2' AND type'3' Depending on the types, I need them to be pulled into different columns. For example, IF type=1 THEN amount1 IF type=2 ...
0
votes
1answer
93 views

Delete missing database

Event Viewer, I can fins this event logged : 2016-07-10 11:45:01.83 Logon Error: 18456, Severity: 14, State: 38. 2016-07-10 11:45:01.83 Logon Login failed for user 'Domain\Username'....
1
vote
1answer
16 views

Does Couchbase/CouchDB allow me to move / skip the CRUD middle man from the server?

So currently this is a common setup: Client -> Ajax -> Server CRUD -> Database Does Couchbase allow me to do this? Client -> Ajax -> Database This might be more technically correct: ...
0
votes
1answer
28 views

Use system timestamp comparison in SELECT query

I have to backup some tables on a daily basis using the condition that the backup will be only for one previous day. I am planning to use copy to dump the records in to a csv file. I need help in ...
2
votes
2answers
30 views

SQL Server agent job dependency

We have a 4h datawarehouse job that runs every 4h on 4h schedule. We want to create a new 'daily' schedule and have some processes run out of hours. However, if when the daily job comes to run and ...
0
votes
3answers
32 views

How do I REPLACE values in column after querying

I have a column with numeric values I am querying SELECT column FROM table WHERE column='1' OR column='2' OR column='3' OR column='4' THEN REPLACE (column, "1", "ABC"); REPLACE (column, "2", "...
0
votes
0answers
9 views

Oracle 11g manually delete database

Using Windows Server 2012 here: I have a problem with two database instances that the Database Configuration Assistant tool didn't cleanly create. Specifically, it error'ed out trying to parse an ...
0
votes
1answer
31 views

Suppress a event from eventviewer [closed]

Is there any way to suppress an event logging in event viewer. I am getting below event id 10028 which is getting logged in eventvwr.I know the reason why it is getting logged. Can I know if any way ...
0
votes
1answer
41 views

Database design help. many-to-many relationship

I have four columns. All columns are varchar fields. Three of them are independent and distinct fields having many to many relation between them and the fourth one is dependent on the combination of ...
1
vote
0answers
24 views

Database design - many-to-many relationship between three columns [duplicate]

I'm noob in database. So don't mind if its a silly question.This is used in my application and is the first one. I need a database design for it. value 4 is dependent on the other value 1,2&3. ...
1
vote
1answer
26 views

Database - Remove Everything After

I am pretty new to modifying databases (running phpmyadmin for WooCommerce) and I am currently stuck at a problem. Basically I have around 400 items which have random SKUs (example). JCB-...
1
vote
1answer
40 views

Impact of OS timezone change on Postgres Database

I want change OS time zone to UTC. This will shift back time by 2h. Can this possibly damage data in any way (for example overwrite data)? What should I do to safely change the OS time zone?
1
vote
1answer
35 views

what is oracle universal installer in oracle database products

I am new to oracle database products. I am planning to install oracle 11g express edition in my PC,it looks like a standard installer.But in many of the oracle database installation tutorial mentions ...
3
votes
1answer
39 views

How to migrate windows login in from one sql server to another sql server on another domain

We have a SQL server that is located in domain 1(DMN1). We are migrating databases in domain 1 to our new SQL Server in domain 2(DMN2).Corporate states that there will be no trust established between ...
0
votes
2answers
41 views

What is effective way to delete duplicate records based on multiple columns in MySQL?

I have a table named users having approx 70 Million records, out of which I guess 10 Million is duplicate. How to remove those 10 Million records keeping one copy of that. Two records are said ...
0
votes
1answer
41 views

Oracle DB refresh on 11g using 10g Cold backup

I am a sql dba, I am having only a little knowledge on Oracle. looking for help regarding oracle db restore. I am having an Oracle 10g cold backup, i need to restore this on Oracle 11g setup, can you ...
1
vote
1answer
31 views

Restrict access to Edition- or instance-specific databases

I have the following issue with SQL Server. On my Windows Sever, SQL Server 2008 Express Edition is running. Now I have installed SQL Server 2008 Web Edition on the same server. My problem is, when ...
0
votes
2answers
21 views

Set Login User as database Onwer

What's the query to set a login user as db_owner during the creation of database. Following is the set of queries, which I'm using right now, Create database Test1; ALTER AUTHORIZATION ON DATABASE::...
-1
votes
0answers
30 views

SQL WHERE statements by Row Number

I have a Data Loader that will only let me upsert 1000 at a time. I have a DBF File that has about 5000+ records. I have a section where I can make WHERE statements for that particular upsert. ...
0
votes
1answer
22 views

Overwrote database with old mysql dump. How can I restore it with a more recent backup

Have a server with multiple databases. Imported wrong .sql from over the top of existing database. I Have a rsync copy of the up to date files for that database. What do I need to do to just ...
1
vote
1answer
37 views

Simple Database Design - Many to many? - First database (newbie)

This is my first database I am designing. However I am getting confused on the many to many relationships. I have a products table, each product can have inventories in many different warehouses. So ...
1
vote
1answer
47 views

How to restore MySQL databases from database files?

Our MySQL on Ubuntu 15.04 stopped working after we moved the computer to a new location and kept giving the missing socket file error. We couldn't really fix it after trying sudo apt-get install -f ...
1
vote
2answers
31 views

Routinely deleting aged postgresql rows via cron

I have a Django website with a postgresql 9.3.10 backend. The website contains dynamic user-generated content (think of it as a form of 9gag). There are some tables from which I routinely delete aged ...
2
votes
1answer
57 views

What is the cardinality of entity relationship between Employee and Department?

Recently, a friend of mine asked me this question about the cardinality between a Department and Employee entities, I replied many to many, then he, my friend, showed me drawings from the internet ...
0
votes
0answers
33 views

SQL Server Memory Configuration [duplicate]

My Server has Total RAM 200GB. I have set 80% of total RAM for SQL Server as it needs more memory. Just want to know if there is any fixed number or method to finalise amount of memory to be set for ...
0
votes
0answers
38 views

Temp DB configuration

My TempDB disk size is 100GB. Out of that I have made below split: 80GB/8 = 8 Data files. 15GB for Log file. Remaining 5GB I have left for autogrowth for last eight datafile and log file(...
1
vote
0answers
25 views

Check Postgres Listener is up/down?

I am using PostgreSQL LISTEN/NOTIFY functionality in Java. So I have made a ListenerBean which is run at Application startup. LISTENER class in java: @Singleton @Startup ...
1
vote
1answer
41 views

any better way for data archiving?

I'm in one security company and our history data grows fast, causing data archiving sqls run slower and slower. Say, for the sake of data real-time need, the scripts must run in a high frequency for ...
1
vote
0answers
24 views

LISTEN/NOTIFY pgconnection goes down java?

I am using PostgreSQL DB and applying it's LISTEN/NOTIFY functionality. So my listener is at my AS (Application Server) and I have triggers configured on my DB such that when CRUD operations are ...
0
votes
0answers
64 views

What are PDE files and how can I use them?

I've got a legacy DB which was given to me as a collection of PDE files. I've googled around and didn't come up with any useful information. Saw this question: Import .pde file on PL/SQL Developer .....
1
vote
1answer
24 views

Managing SQL Server logins and database users

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question about server logins and ...
1
vote
2answers
59 views

Log in as another SQL Server user via SSMS to check their permissions?

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question: Once I have given a set of ...
0
votes
0answers
17 views

Mix mode auth password,is it sa password?

During SQL Server 2014 Installation,I have set up Mixed Mode Authentication and given a password for it.My question is when I set Mix mode,did I set up password for SA login.So if want to use SQL ...
3
votes
1answer
310 views

SQL query failing because of commented part of T-SQL query

I am executing below query but I am facing issue. Note :SQL 2008 R2 and SQL 2014 running with two diff serv accounts on Win 2008 R2 and Win 2012 R2. TCP Ports, Firewall ports are all enabled along ...
0
votes
0answers
34 views

Does having a .ldf for a index file cause issues?

Interesting find today, I have a file group that is used for indexing. It has one file that has a .ldf extension, which as you know for SQL Server, is the extension for the transaction log files. My ...