-2
votes
0answers
19 views

I want query postgresql group by month and type [on hold]

I want query postgresql group by month and type like this, please help me.
0
votes
0answers
13 views

how to install a database cluster in postgresql

I am trying to install POSTGRESQL, I have completed the installation and at the end point i got an error stating POSTGRESQL CLUSTER INITIALIZATION is not succeed and this if i install outside the ...
0
votes
0answers
10 views

Translating duplicated data entries into Domain Relational Calculus

Given a following table named BOOKING, which contains three columns, guest_name, room_number and booking_date, how do I find the all the guest_name that have the same room_number and booking_date? I ...
0
votes
1answer
65 views

Most efficient way to set up a database handling millions of links?

I'm looking at making a site that will potentially have up to a million users, and each user will have hundreds/thousands of links connected to a set of sites, as well as other info. I'm using mysql ...
1
vote
1answer
21 views

What to do when Sql Server Agent refuses to run a Job Step that references a missing database snapshot

I have a SQL Server Agent Job creating a snapshot of my main database every minute: -- delete snapshot if it exists if exists (select * from sys.databases where name = 'mydb_snapshot' ) begin ...
0
votes
1answer
33 views

Is there any way to trace the optimizer's work in Oracle?

Just like the MEMO structure in SQL Server which is kind of a "paper trail" of steps the optimizer takes in optimizing the query, is there anything in Oracle through which I can see what are the ...
1
vote
1answer
25 views

Is there any way to trace optimizer's work in DB2?

Just like the MEMO structure in SQL Server which is kind of a "paper trail" of steps the optimizer takes in optimizing the query, is there anything in DB2 through which I can get the information like, ...
1
vote
0answers
22 views

SQL Server 2014: missing replication option

This article details exact steps to set up basic database replication with SQL Server 2014. It starts with this: Right-click the Replication folder, and then click Configure Distribution. ...
2
votes
0answers
8 views

Manual Failover with AlwaysOn availability group

We are planning to upgrade our SQL 2012 to SQL 2014. We currently use a mirror for our production databases but are planning to move to availability groups. We are going to be running 2 SQL Servers on ...
0
votes
0answers
13 views

Does MySQL Backup Restore affect Master-Master Replication

Hello I got some problems with a MySQL shemas and it seems that the schemas got deleted for an unknown reason. I try to find in the binlog for more information of this but I didn't find the way to see ...
0
votes
0answers
10 views

Control locking behavior for Snapshot Replication

I want to have snapshot replication of several databases into single one for reporting purposes. I choose replication because i need to publish just certain columns. I don't need transnational ...
-2
votes
0answers
14 views

Best possible way to use SSDs on R720 SQL Server [on hold]

Whats the best possible way to use the SSDs on SQL Server? Will that differ a lot with type\make-model of SSDs? I have Dell R720 . Read multiple articles and ended up confusing whether to use them for ...
0
votes
2answers
23 views

Slow database drop in mysql

Just installed a new 24 core server and it is noticeably slower when doing truncates and drops. Example: $ mysql -u root lmcdental_test2 Reading table information for completion of table and column ...
0
votes
0answers
8 views

Query to get the values of a field from all tables

I have an Access database with several tables. Some tables have a column called Action. For some of my records, the Action is blank, others have text in it. How can I make a list of all records in ...
0
votes
1answer
15 views

I have a DB that is locking up from numerous updates to a table: Should I convert it from MyISAM to InnoDB?

FYI: I don't believe this is a duplicate question, I've looked and most are general questions with vague answers. See more specifics below: Currently a database I am in charge of locks up every once ...
0
votes
1answer
35 views

Processors: E5-4620 v2 vs E5-2620 v3 [on hold]

We're debating between: R820 - E5-4620 v2 - 2.6GHz - 8 cores, 20MB Cache, 1333MHz max memory speed - max of 768GB ram - 8 core R730 - E5-2620 v3 - 2.4GHz - 6 cores, 15MB Cache, 1866MHz max memory ...
6
votes
2answers
65 views

What is an Oracle ASSEMBLY?

What is an Oracle ASSEMBLY, in the context of Oracle SQL? It's listed in GV$SQLCOMMAND. Although GV$SQLCOMMAND is not a perfect guide to "real" SQL statements - for example it has UPSERT instead of ...
2
votes
2answers
46 views

How to query readonly replica in Always On cluster

We have an Always On "cluster" that consists of 2 servers (there will be more), so one is PRIMARY and other(s) is(are) SECONDARY. The idea was to dedicate SECONDARY as a readonly replica, so it would ...
0
votes
1answer
18 views

Scheduled Database Backup job fails due to lack of disk space

Two of my scheduled SQL Server backups failed over the weekend because of a lack of space. The C: drive has 25.3 GB of free space out of 400 GB. The primary space taker is SQL. 149.9 GB C:\Program ...
0
votes
2answers
26 views

High Availability using SQL Server 2012 requires how many licenses [on hold]

For on premise solution, is it possible to implement high availability for SQL Server 2012 using a single license, or, one needs to buy extra licenses? Also, for high availability with SQL Server, ...
0
votes
0answers
26 views

SQL Server Function For Calculating Average Excluding Outliers

I'm looking for a function that will let me take an average and exclude outliers. Basically something where: 1, 2, 1, 2, 7 Would average out to 1.5. I'm going to implement this in a financial ...
0
votes
0answers
21 views

Estimating file growth when compressing tables

I have some databases that I will compress these days with the compression feature in SQL Server. I did this in a local environment with a 1GB database, and the MDF file grows 10%. In the production ...
0
votes
1answer
32 views

Maximum possible memory usage: 23.6G (785% of installed RAM)

I have a virtualized 32bits Server for Mysql (RAM : 115 Go). I am trying to optimize with mysqltuner and I get this : >> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net> >> Bug ...
0
votes
0answers
14 views

How should I store image, text type files in mysql?

I came across some answers mentioning the "disasters" of storing files outside database and saving the path inside database. I've also noticed dozens of answers about storing images- which suggest to ...
0
votes
0answers
8 views

MS Access Subform with Associative tables

I have a 2 table design with an associative table between the two. One of the tables will have prepopulated values in it. The problem is that I cannot create a workable form/subform combo that will ...
0
votes
0answers
7 views

A transaction has been utilizing the version store for X minutes

For one of our servers we are getting below critical alert from Idera Diagnostic manager saying: A transaction has been utilizing the version store for 93 minutes on ABCKP1. The current version ...
0
votes
1answer
31 views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 ...
1
vote
1answer
40 views

Alias of Subquery not working

I have been trying to get an order by to work correctly with an aggregate function. i.e. order by (bp + points) I also try adding these as a total amount from the following query however. If I try ...
0
votes
0answers
38 views

Percona Master-Master lag issues

I have 2 servers with master-master replication using Percona MySQL 5.6 and I am having replication lag in the second server: db-02, however db-01 never had a lag situation. What could be causing ...
1
vote
1answer
110 views

How to return values from “upsert” query in case when UPDATE has been performed?

WITH upsert AS (UPDATE tbl SET a = 2 WHERE a = 1 RETURNING tbl.*) INSERT INTO tbl (a) SELECT 1 WHERE NOT EXISTS( SELECT * FROM upsert ) RETURNING * This "upsert" statement works however I would like ...
0
votes
1answer
36 views

Maximum Partitioning PostgreSQL

I have 400,000 records I need to partition. The records will increase 100,000 per year and those new records might need to have 1000 new partitions added. Here are some of my concerns: How many ...
0
votes
0answers
9 views

Join two tables and count a column using mdx

I am trying to join the two tables as below Table1 --------------------------- Product| StoreType| Store --------------------------- 1 | 10 | X ...
0
votes
0answers
18 views

Oracle user in DBA_USERS_WITH_DEFPWD but not user tables/views [on hold]

Oracle documentation says that "DBA_USERS_WITH_DEFPWD displays all users in the database that are still using their default passwords." So what does it mean if there is a user listed in the ...
0
votes
0answers
5 views

Does “mysqladmin shutdown” need to connect to the database?

How is implemented mysqladmin shutdown? Does it need to connect to the database in such a way that if the number of max_connections (+1 "SUPER" connection) is reached, it will fail to shutdown the ...
0
votes
1answer
14 views

Clustering MySQL with InnoDB engine

I have a MySQL single server setup with all tables using the InnoDB engine (because I need support for foreign keys). As response times are getting longer, I now believe I need to create a cluster of ...
0
votes
1answer
37 views

CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE

My Table has 25 Million rows total and 6 million rows satisfying below where clause. Select 1: select max(stamp) from Table where type = "string" LOCK IN SHARE MODE ; 6000+ seconds Select 2: ...
0
votes
0answers
18 views

outer join more than 2 tables in access [migrated]

After following this thread. I am getting an error as "Syntax Error in JOIN Operation" Here Is my query SELECT StudentMaster.Student_id, ExamDetails.Subject_id, ...
0
votes
1answer
44 views

SQL query to return a columns with given range

I have a table tblItems with records having the same UniqueID and Description but with different dates and amount. Now I want to show the records by grouping them together using the UniqueIDs and ...
0
votes
0answers
4 views

Modeling Graph Data in Cassandra DB

I want to use Apache Cassandra to store a large amount of graph data according to a property graph model. The model contains the following entities: Vertices: Contains a map of key/value pairs ...
0
votes
1answer
30 views

Why/when does the SQL Server query optimizer use EQ_ROWS?

I'm trying to understand how exactly the statistics work. I've got a clustered index on my date. I can see a convert_implicit is executed when I run the following query. Don't know why it's doing ...
0
votes
1answer
18 views

Sql Server audit could not write to the security log

I am following the training kit for 70-462(Administering Microsoft SQL Server 2012 Databases), and stuck on Auditing SQL Server instances lesson. I have created new user in domain controller, assign ...
1
vote
2answers
182 views

Is it a good idea to include a value column (e.g. from measurements) in an index?

Is it a good idea to include a value column into an index for a table which has many million rows? For example a measurement table which looks kind of like this: CREATE TABLE measurements ( id ...
0
votes
2answers
51 views

Regarding Reindexing [on hold]

Can we find the performance stats pre and post reindexing, if yes, how? And does reindexing affect database size? If so how and why? We're using SQL Server 2008 R2.
0
votes
1answer
18 views

Are there any risks in running 'flush hosts'?

Due to an error in my code I got my PC blocked from an active production DB (too many connection errors). The error calls for me to use 'flush hosts' in order to reset the host cache. Are there any ...
0
votes
0answers
24 views

Why do I need to reset user mapping always after restarting PC?

I have created a user using SQL Server 2014 management studio, I have mapped user to a couple of tables as db_owner. But after restarting my PC the mapping again cleared for the user and I need to set ...
0
votes
0answers
23 views

How to get mysql view definitions?

Show create view viewName does not display correctly formatted text. How can I get the correctly-formatted SQL? For example, I created a view like create view v1 as select * from mysql.uer, but it ...
0
votes
1answer
48 views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
1
vote
0answers
19 views

Replication throw an error after failover mirror partner is down in SQL Server

Received an error mentioned below after failover when mirror partner is down. Error : to fail over to a database which is not configured for database mirroring. code: 22037, text: 'Invalid ...
1
vote
1answer
10 views

Create Views Quickstart

I have setup a few buckets and now I’d like to create a view but I’m not sure where to start. I have logged in to the web console but the views I have created to not return any results. Also, is it ...
0
votes
1answer
13 views

Will 'sleeping' connections open files other than the socket in MySQL?

Recently, in our MySQL replication setup, the replication slave crashed due to 'too many open files' error. We brought it backup, but trying to figure out what caused the unexpected hike in the number ...

15 30 50 per page