0
votes
1answer
17 views

Best storage engine for huge tables with mostly update operations (74 million records, MyISAM table size 7.6G)

What will be the best storage engine for table with 74 million records, currently stored as MyISAM table size 7.6G. Operations are mostly select and update. DDL operations (ALTER ADD COLUMN) are ...
0
votes
1answer
13 views

Strict mode not working mongo Shell

I was test in process of testing the strict mode of mongo shell queries. This the link i am referring. Sample document looks like - { "_id" : ObjectId("19876"), "ip" : "127.0.0.1", "...
0
votes
0answers
15 views

Data Cleansing Using DQS

My question is regarding the installation of DQS server. I have a production server and a data warehouse server, both are synced. Is it the best practice to cleanse the data in production using the ...
0
votes
2answers
69 views

How to resolve Geospatial Data over linked server causing error?

Update of the issue. The exact error is Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131022. You may fix the problem and try again later. The error is happening ...
-3
votes
1answer
43 views

Finding the mismatch column names

I have two datasets, both having same column names and just one row. I want to display the column names for which there is a mismatch of column values. Could anyone please suggest how this can be done....
0
votes
0answers
5 views

TPC-H query-18 takes too much of time

TPC-H query-18 takes too much of time. How do i optimize it. No MY.CNF settings have been changed and no indexes have been applied . Please suggest on how to get better results on MYSQL 5.6
1
vote
0answers
19 views

How can I get the actual SSAS error when processing a cube from a SQL Agent job?

I have a SASS cube on one server and a SSIS package on another server that triggers processing the cube. The SSIS package is executed via a scheduled SQL Agent job. I have enabled error reporting for ...
0
votes
1answer
28 views

Mysql Inner join performance

I have performance problem! I searched for Inner Join, tried optimize table but still the same. I have Users, Entries, Tags and tag_user tables. This code works perfectly : select * from `entries` ...
0
votes
0answers
16 views

Can SSMS or SSDT validate and insert security objects? [on hold]

Can Sql Server Management Studio validate and insert security objects (roles, schemas, asymmetric keys, certificates, users, and so on) both at the server and DB level?
1
vote
1answer
18 views

Permissions for Cluster service account in SQL server

Recently i faced an issue where the SQL server 2012 being hosted in a 2 node failover cluster failed to start. And since the cluster and windows event log didn't help much, i started checking the SQL ...
0
votes
1answer
19 views

How convert database from SQL Server 2012 TO SQL Server 2005 [duplicate]

I have SQL Server 2012 database which I need to use. But I can't install SQL Server 2012 on my PC. I use SQL Server 2005 only. How can I change the database SQL Server 2012 To SQL Server 2005 OR ...
0
votes
1answer
17 views

Mysql : Aborted connection …/… (Got an error reading communication packets)

This error message had submitted many times in this forum. I have tried the following without success. Context This is a Symfony1/Doctrine1 web application. The error appear on my computer and on ...
0
votes
0answers
5 views

many clients (sometimes offline), one master database; how to synchronize

I have a similar question like this one from dba Sync many client database to one central database but with a slightly different approach. I do have many data aggregators and these devices are not ...
0
votes
0answers
11 views

Understanding PostgreSQL autovacuum cost and duration from logs

I've configured autovacuum with cost-delay based parameters and have entries such as this one in the logs: Jul 24 03:31:24 srv postgres[23181]: [6-1] 2016-07-24 03:31:24 EDT [23181]: [2-1] user=,db= ...
0
votes
0answers
15 views

Confusion of Time Stamping Protocol and Two Phase Locking Protocol in schedule

I'm wondering if someone helps me. Actually, I have a little confusion in Concurrency Control Time stamping protocol and Two-Phase locking protocol in a transaction schedule. I have found this ...
0
votes
0answers
8 views

Where has postgresql plv8_95 gone?

I just upgraded to Fedora 24. Before that, there used to be a plv8_95 package in the postgresql main repo. This made adding plv8 very easy by just running "dnf install plv8_95". However, that's ...
0
votes
0answers
17 views

login failure for sa to unspecified DB

I have a pair of SQL Server 2008 R2 DB mirrored and I'm seeing a login failure approximately every one minute. [417593] MSSQLSERVER Type: FAILURE AUDIT Computer: EVS-DBSERVER-2 Time: ...
0
votes
0answers
13 views

Things we can optimize when runnung TPC-H benchmark

I am a Graduate student running TPC-H benchmark on MYSQL 5.6 . I have EC2 instance M3 large instance with a Intel Xeon E5-2670 v2 , 7.5 GB memory and 2 vCPU. Can someone please suggest me what are ...
1
vote
1answer
27 views

Sql get results only containing all keywords

Let's say I have mysql table called SONGS, with columns: Artist | Featuredartist | Songname | Year What I need is to get Artist and Songname, only containing my keywords (and no matter how they are ...
0
votes
0answers
37 views

MySQL - Harmonize multiple time ranges

I have the following problem with harmonizing multiple time ranges. Let's say I have the following data: |range_object_id | start_time | end_time | |-------------------+---...
0
votes
2answers
38 views

Financial Statement table

I want to ask about database design for financial statement. I want to combine balance sheet, profit loss, cash flow,and ratio into one big table since each statement is dependent each other. Here ...
0
votes
0answers
17 views

How to restore MySql DB from previous version files

My wamp server crashed a few days ago and I couldn't save the DB from phpMyAdmin. So I saved the folder bin/mysql/mysql5.6.13. Then I installed a new wamp version which comes with myslq5.7.11. I've ...
0
votes
1answer
23 views

SELECT Query is slow when run remotely in MySQL

When I connect MySQL from remote server and run below query then the results are very slow(Sometime even faced lost connection Issue). However when I run the same SQL query on the local machine then ...
2
votes
1answer
16 views

Howto implement correctly Businness Logic in database

I'm searching about how to disable triggers, and seems like it's not possible under MariaDB. My problem is, how to manage then, when you import data. I have a database where almost all business logic ...
0
votes
0answers
16 views

I want to make a website similar to Udacity, Coursera e.t.c. for online courses. Which technology should I use for storing the course information? [on hold]

I am mainly confused between storing the information of a certain course in an SQL Database A JSON / XML file for each course which will then be stored in a file storage system and can be retrieved ...
1
vote
1answer
30 views

Replication from Enterprise to Standard edition

Can I define transactional replication while the Publisher and Distributor are both Enterprise Edition and the Subscriber is Standard Edition? What do I need to consider in case it is possible (given ...
0
votes
0answers
8 views

Is it possible to migrate a postgresql database without downtime?

I have a Postgresql Database on my Centos, I use barman to backup my database, my question is that is it possible to migrate my database to another server without downtime? I know some solutions with ...
1
vote
0answers
25 views

What might be the cause of regular periodic slow transactions on an OLTP system?

I have a two node Oracle RAC cluster with that runs an oltp application against it. I have both a production and a duplicate test environment with the same setup. Upon running stress tests on the ...
1
vote
0answers
13 views

Is it possible to change pgAdmin SQL completion shortcut?

In pgAdmin SQL query editor, the default SQL code completion shortcut is ctrl-space; however, my native language is not English, we use ctrl-space to switch input method. Is it possible to change ...
1
vote
1answer
62 views

Joining Tables in the FROM vs. the WHERE clause [duplicate]

First time caller here. I have a question regarding best practices when joining tables. For example, both of the following queries return the same results: SELECT i.id, p.first_name, p.last_name ...
0
votes
1answer
31 views

AlwaysON AG synchronous commit mode disconnected transaction log effect and mitigation

I have an AlwaysON AG with one primary and one secondary replica in synchronous commit mode. The databases in the AG all have autogrowth disabled (standard policy within organisation). There is ...
0
votes
2answers
18 views

How to transfer DDL changes between different stages?

What technical solutions are available to track DDL changes and transfer them between different stages (e.g. DEV -> QA -> PROD) on postgreSQL databases? Is there a common mechanism to do that?
1
vote
1answer
16 views

best way for creating Index in mysql (multi-column/table)?

i have a big problem with my database.. I need a very fast query over 2 tables. 1. table: (node) ~42.500.000 entrys 2. table: (waynode ~51.200.000 entrys The following query is much to slow: ...
0
votes
0answers
8 views

News website in PostgreSQL -> how to best import the news (featured) images into wordpress? [on hold]

some time ago I have posted a migration request topic: PostgreSQL to MySQL migration to use database for WordPress site - how to's? as I wanted to migrate PostgreSQL database to MySQL. The ...
-1
votes
1answer
19 views

How can I create a church attendance report system?

Please am pretty new to php and mysql. I have an assignment to create a church attendance system for our weekly services. The system would be able to know how many males and females came to church ...
3
votes
1answer
24 views

Can SSDT deploy SQL server service broker objects?

Can SQL Server Data Tools (SSDT) deploy sql server broker objects? (So contacts, message types, services, queues and so on.)
1
vote
1answer
23 views

Multiple SELECT With Multiple WHERE

I am stumped and need your help. I am trying to select three columns from my table where one of them is a VARCHAR and the other two are either "Y" or "N". SELECT CurrencyPair, Count(Accepted) As ...
1
vote
0answers
13 views

Replication prioroty

I have two MongoDB instances running on two servers (instance1 and instance2) and they are configured as a replica set. Instance1 is the primary and instance2 is the secondary. When instance1 was ...
-1
votes
0answers
10 views

INNER JOIN WHERE user id

I have 2 tables Table name: "as_users" Col 1: user_id Col 2: uid Col 3: email Col 4: username And Table name: "user_images" Col 1: uid Col 2: username Col 3: image The following code shows ...
0
votes
1answer
24 views

Sending an async notification to another database in PostgreSQL

Is there any way I can send a NOTIFY to a database other than the one that my connection has specified? [CLARIFICATION] Consider we have two databases within one instance of PostgreSQL. If you are ...
0
votes
0answers
9 views

downgrade mysql from 5.6 to 5.3/5.4

We have an issue in our server when we try to connect from A server using php v 5.6 to B server mysql 5.5 it throws an error saying " Failed to connect to MySQL: The server requested authentication ...
0
votes
1answer
17 views

Modeling Optional Column

I've got an optional column (residential) in one of my tables that is giving me trouble. If a Licensee intends to work w/ residential customers, they need to take an additional course (...
0
votes
1answer
50 views

Database design considerations for unused columns with every table has same schema

I am a web developer so I don't know a lot about databases. The company I joined recently has a very mature Desktop ERP built in .NET and SQL Server, they are providing services to huge corporate ...
2
votes
0answers
35 views

Implementing faceted search in PostgreSQL

I'm trying to figure out if it is possible to implement a faceted search (like the ones popular in online shops like Amazon) in a reasonably sane and efficient way in PostgreSQL. A faceted search ...
0
votes
0answers
13 views

Postgres: Refer to several other id's in a certain row

I am a postgres newbie, I struggle to execute this: I have a table of artists and their info (birth, death, style, etc..) Each row has a unique id_name varchar column has values like jones or adams ...
1
vote
1answer
10 views

What's the advantage of the inet datatype in Cassandra vs a plain text string?

What is the inet datatype really for? The documentation refers to its usage having something to do with Python but I'm not much of a Python guy so that aspect is beyond me. Is there any advantage to ...
2
votes
2answers
33 views

SUM and Group By Optimization

I use this query: SELECT logdate, SUM(bytes)/1024/1024/1024 as traffic, customer FROM `Logdata` WHERE customer is not null AND logdate >= "2016-07-01" AND ...
0
votes
0answers
10 views

Java Library to Dump MySQL Database to File [on hold]

I am looking for a Java library to embed into a Java web application to enable backup of a MySQL database to a zip file. The first question would be why not use MySQL dump, this is an option that we ...
1
vote
2answers
31 views

SSMS clean output window with sql instruction

How can i clean output window in SSMS using t-sql syntax? Is it possible ? Do you know any workarounds ?
0
votes
0answers
13 views

Issue with Linked Server query

I have a job which fetches data from an Oracle 12c database and inserts into a SQL Server 2012 database, via a linked server from the SQL side. It's a simple Select * statement and just pulls in any ...

15 30 50 per page