0
votes
1answer
555 views

Cannot select features to install from SQL Server 2005 SP4 installation process [closed]

The issue: I cannot select MSSQLSERVER from the feature list I want to update as part of the SQL Server 2005 x64 Service Pack 4 installation process. Please note exe file is being raised from C:\ ...
2
votes
2answers
75 views

Database recovery procedure

I recovered a database with last full backup, all differentials after the full, and then all log backups after the last differential. Can I trust the database is right or do I have to do it again the ...
2
votes
1answer
148 views

Join more than 3 tables in one single query, with many comparisons and no IDs

I use an overlycomplex and poorly designed software at my work, and now I need to produce a report of invoices issued between a period of time. Invoices are held at table ENTR2012, which uses the ...
1
vote
0answers
151 views

How to send MySQL query results to outfile and standard output at the same time?

I "normally" query MySQL with SELECT col1, col2 FROM tablename LIMIT 10; and sometimes instead send the output to a file with SELECT col1, col2 FROM tablename LIMIT 10 INTO OUTFILE ...
1
vote
1answer
307 views

How to manually set Code Page and Collation for my SSAS Cube?

When I try to Process my SSAS2012 Olap Cube I get a lot of erros like this Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_ART' ,Column: ...
1
vote
1answer
80 views

How to insert multiple returns of the select statement?

I have 3 tables. ClassList, Student & Faculty. I'm trying to assign the faculty to a specific class, e.g. I'm assigning "John Doe" to the section "Section1" where this "Section1" exists in the ...
1
vote
2answers
164 views

Why is restoration from binary logs so slow?

We have a MySQL 5.5 server with binary logging enabled and a backup script that collects the binary logs and, once a day, generates a complete database dump with mysqldump. In testing database ...
1
vote
1answer
2k views

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
2
votes
1answer
917 views

Can I backup (Full) the Log-Shipping Secondary Database?

I have a Highly pressured Production Environment with Database name DB1. And I want to run a weekly DBCC CHECKDB process on one of the databases there. (You can understand,I can't do it on my ...
0
votes
3answers
1k views

TNSNAMES.ORA is located in Windows 2012 Server

Can you please any one help me for the following TNSNAMES.ORA is located in Windows 2012 Server? Can you please give the correct path for the same.
1
vote
1answer
96 views

Why SELECT is so slow

I have the following table CREATE TABLE words ( id bigint(20) NOT NULL, `text` int(11) NOT NULL, w1 int(11) NOT NULL, w2 int(11) NOT NULL, w3 int(11) NOT NULL, w4 int(11) NOT NULL, ...
1
vote
1answer
280 views

Soft delete to improve performance: all wrong?

A few years back I read soft delete would improve performance of deletion, because instead of actually removing the item and impact the clustered (and all other) indices, it would just change a value. ...
1
vote
0answers
43 views

Suggestion for SQL distributed transactions via MSDTC

Currently we do not use MSDTC in our company. Our developers would like to start using MSDTC for Distributed Transactions within their applications. Questions: Is it okay to use MSDTC for SQL ...
1
vote
1answer
33 views

Postgres knowing which where column returned positive result

Assuming we have a query like: select * from table where a=1 or b=2 or c=3 and the where conditions met are a=1 and c=3 Would it be possible to know in the query (in the output) that a and c are ...
2
votes
1answer
4k views

Backup/Restore Users/Passwords/Privileges

I am moving from one server to another and I want to backup all databases + users/privileges/passwords from my MySQL Server. I found to backup a database using mysqldump, but I cannot figure out, how ...
1
vote
1answer
874 views

Transactional replication between SQL Server 2014 (Publisher) and SQL Server 2012 (subscriber)

We need to set up transactional replication between two servers A and B, configs listed below: Server A (Publisher) Microsoft SQL Server 2014 - 12.0.2254.0 (X64) Enterprise Edition (64-bit) ...
0
votes
0answers
120 views

Incoming Tabular Data Stream Error

I created a SQL Server Agent Job with two different schedules. One is at 6 AM, the other is at 11 AM. When it runs at 11AM, it works fine; but at 6 AM it fails and gives this error message; The ...
0
votes
0answers
44 views

Can't start MSSQLSERVER service [closed]

The SQL Server (MSSQLSERVER) service terminated with this message: service-specific error WARNING: You have until SQL Server (MSSQLSERVER) to logoff. If you have not logged off at this time, ...
1
vote
1answer
182 views

Why Update trigger makes Insertion slow in mysql?

I had create one table, that Table contain Log of meters. Name of that table is "paramgraph_ems" This table contain 1M rows, and insertion per minute is 350 rows. 10 Min takes for inserting 3500 rows. ...
0
votes
1answer
34 views

Transfer data to New Laptop [closed]

I am completely new to PostgreSQL My data is in the directory c:\postgres.......data and the database name is GXPGRAN. I need to copy this to a new laptop. Can somebody please give me all the steps ...
2
votes
1answer
451 views

I keep getting an error 10060 trying to connect object explorer in Visual Studio 2013 to an Azure Database

Using Win 7, Visual Studio 2013, (or Sql management tool 2014) This is for a class and its all software on the trial period. In Visual Studio server explorer - I can connect to the Azure Server I ...
0
votes
1answer
241 views

In MySQL why is the first batch executed through client-side prepared statement slower?

I have around a million lines to be inserted into a MySQL (InnoDB) database, so to speed things up I turned to batch/multi-line insert. To be specific, I connect to the database (I'm using Java, so ...
2
votes
0answers
321 views

Why can't we have multiple cascade paths?

You can see that many questions have being asked about multiple cascade paths. For example: http://stackoverflow.com/questions/851625/foreign-key-constraint-may-cause-cycles-or-multiple-cascade-paths ...
0
votes
1answer
83 views

Logic Value of Assignment Expression

I'm doing the leetcode SQL problems and kind of confused with the code below: select distinct Num from ( select Num, case when @prevNum = Num then @count := @count + 1 ...
2
votes
1answer
41 views

How do I change the config path for mysqld?

I want to change configuration file path from C:\ to E:\, but I can't find the way to do this. Alternatively, is there a way to start a new instance with the config file I want? I've done something ...
1
vote
1answer
220 views

Group by maximum consecutive row

I have data like the following: id | src_ip | dst_ip | port | ----|----------------|--------------|------| 256 | 192.168.61.200 | 10.75.64.222 | 80 | 257 | 192.168.61.200 | ...
2
votes
1answer
112 views

Slow PostgreSQL query

I'm building a search interface for a web site that currently searches through approximately 2 million pieces of real estate with approximately 60 million attributes (address, city, state, ZIP, beds, ...
1
vote
1answer
349 views

MySQL/InnoDB - Clustering Index with UUID

In MS SQL Server it is possible to cluster an index on a non-primary, non-unique key. For example, if I wanted to create a clustered index on the insert date to prevent page splits and fragmentation ...
2
votes
1answer
296 views

BACKUP AND RESTORE FileGroup (PRIMARY) - WHY after restore I still see Other FileGroups?

/********************************** CREATE DATABASE PiecemealDB *************************************/ use [master] go if exists (select * from sys.databases where database_id = DB_ID('PiecemealDB')) ...
2
votes
1answer
147 views

Why is this select statement not returning what I've provided?

I have 3 tables in my SQL Server I am wondering why is my select statement not working or giving the result with my condition in the where clause. I learned back there to use this kind of method.. ...
0
votes
1answer
20 views

Handling of Topic Drill Downs in Databases

I have a requirement wherein I have to set up a drill down feature. For example: There is a tab in a shopping website "Men". Now if we click on Men we will get more topics like "Clothing", ...
0
votes
1answer
66 views

1 to N relationship on a product shop database design

imagine this scenario: I want to run a database that keeps track of all the purchases that every customer makes. So i'll have a purchases table along a customers table and a prodcuts table. The thing ...
2
votes
2answers
81 views

Mysql slow slave

Background: We have our main databases at a data centre which are all working fine. I wanted to add a slave server at our office for backup purposes. I have copied all of the data from an existing ...
1
vote
0answers
40 views

Make a backup file or save a DB in PostgreSQL

I have deployed for my data base in production a new groups of users; An admin user with full access to the DB ; A read only user ; A super admin user to manage all the DBs ; The matter is for ...
0
votes
1answer
124 views

INTERSECT query rewrite as JOIN?

I have two queries written in PHP against a Microsoft SQL Server database (I know this is weird). I'm querying one table. I want the records shared by both results sets ONLY. Here is query #1: ...
2
votes
1answer
62 views

Is there any point in specifying the precision and scale of a number for a foreign key?

I am running Oracle 11gR2 11.2.0.3. I have two tables: table1 contains a column named SUBJECT_ID, whose datatype is NUMBER(7,0) (numbers range from 13 to 48480) table2 contains a a column named ...
2
votes
1answer
416 views

Too many mysql instances. How to kill?

I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which is indeed not seeing HUGE amounts of traffic, should not be this overloaded. Mysql is having ...
0
votes
0answers
42 views

User with more than enough permission, cannot query collection

I'm in mongo shell. I'm authenticated as a user with way beyond enough permission to simply query a collection. Yet I cannot. Here is the user permissions... What am I doing wrong and/or missing? ...
1
vote
1answer
85 views

MongoDb replica set: How do I verify data replication on other servers?

I have a 3 member replica set running. It's geo-located on 3 separate VPSs. On primary I can do rs.status() and see it's working. I can't execute any mongo shell commands on the secondaries. How do I ...
7
votes
1answer
211 views

Low PLE on NUMA node 000, high on 001

I'm looking at PLE (Page Life Expectancy) across NUMA nodes on our SQL Servers, and came across a rather weird distribution. NUMA node 000 has a very low PLE compared to 001. I'm unsure why this is. ...
0
votes
1answer
1k views

how do I configure postgresql to find the pg_controldata command [closed]

I am trying to execute the pg_controldata command, I got the error command not found. Then I checked: ls -l /usr/lib/postgresql/9.4/bin/ | grep "control" -rwxr-xr-x 1 root root 25960 feb 5 18:24 ...
1
vote
2answers
144 views

How to know how long my server is started

I am working with postgresql-9.4 and for support and monitoring tasks I need to know how long my server is started? Is there any function or way to know this? Is there an sql way to know it? I ...
1
vote
1answer
237 views

postmaster.opts in postgresql 9.3?

I am using PostgreSQL 9.3, but the book I am reading "Beginning Databases with PostgreSQL From Novice to Professional" is using PostgreSQL 8. It mentions there is a postmaster.opts file which passes ...
1
vote
2answers
711 views

Mysql causing high load average with large amount of server resources left

I've have 2 servers running a application and the server that runs the mysql sgbd is with the load average around 3 times more than the webserver. I think that is something wrong because i have a lot ...
1
vote
0answers
311 views

Can I export a PostgreSQL database from Heroku and Import as a PostGIS database in Digital Ocean?

Disclaimer: This may be a dumb question. This is honestly way over my head... one of the pitfalls of using Heroku for too long. I have a PostgreSQL database on Heroku. Now I'm migrating to Digital ...
2
votes
2answers
1k views

SELECT and UPDATE in a single query while updating selective fields of duplicate records only

I have a MySQL table named Contacts_table with, say, the following contents: ID NUMBER NAME CITY 001 2222222222 John Doe Los Angeles 002 ...
1
vote
1answer
117 views

Extract column definitions from an IXF file of unknown origin

Suppose someone exported the table PROPERTIES using the command: CALL SYSPROC.ADMIN_CMD( 'EXPORT TO /tmp/properties.ixf OF IXF MESSAGES ON SERVER select * from properties' ); Since then the ...
1
vote
1answer
1k views

Query with group by having count 0

I am working on application for managing football league as my homework. I want filter list of players by number of matches they have played in league. For example user can enter count > 0 and count ...
0
votes
1answer
25 views

Remote connection to DB instance from fresh formatted system?

I have 1 win7prof fresh system. Now I want to connect to a DB instance remotely via sqlcmd/any other way. My req is to connect and execute select query? is there any method/software needed to be ...
0
votes
1answer
45 views

Inbound Outbound Shipping Database

should we combine both inbound and outbound shipping into a single table (then create an additional column to identify the direction) or to split them into separate table? What's the pros and cons?

15 30 50 per page