0
votes
0answers
4 views

Will MyISAM prevent multiple users inserting data at the same time?

I am using a MyISAM database to store user data because I am using full text searching. I have looked in to options like Sphinx but cannot install this on my shared hosting plan which uses MySQL ...
0
votes
0answers
8 views

Discrepancy between system catalog view and sp_change_users_login?

I want to check for orphaned users on a database. To that end, I use the following query on my SQL Server 2005 instance to get all users and their accompanying logins for a specific database (say ...
1
vote
0answers
13 views

Oracle Data Pump Import with running advanced replication

In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the ...
0
votes
1answer
23 views

InnoDB inserts 100 times slower than SQL Server inserts

I have a simple table with two columns: id (autonumber) and name (char(255). When I use C# to insert 100 records in a loop it takes about 30 milliseconds per insert. This is way too slow. So I ...
0
votes
0answers
15 views

Stored Procedure count and list the occurrence using like from another table

Actually this is my first procedure apart from basic "Hello world" procedure. I have two tables like this: cars users ------------------------- ...
0
votes
1answer
28 views

SELECT with lots of left join is very slow in SQL Server 2014

I've got a query with, more or less, this structure: SELECT MAINTABLE_ID FROM MAINTABLE WITH (NOLOCK) LEFT JOIN TABLE_1 WITH (NOLOCK) ON TABLE_1_FK_MAINTABLE_ID = MAINTABLE_ID LEFT JOIN ...
0
votes
0answers
4 views

Application running slow when querying against SQL Server 2008R2

I'm having an application that is starting to run really slow when inserting and querying data from a SQL server. The db is on a dedicated virtual box with 10 GB ram, AMD Operon 6134 processor (4 ...
0
votes
0answers
12 views

Cannot connect to PostgreSQL database as 'localhost'

I am developing an Android application and I'm using PostgreSQL bundled with PostGIS. I want to use a local database for that but connecting via 'localhost' doesn't work, I have tried the alternative ...
0
votes
0answers
11 views

SSRS using select from (Select)

I want to report a script which contains a Select from (Select), when I just run the second select I have no problem but when I put the whole script it loads and nothing happens. Here's my code : ...
0
votes
0answers
9 views

How to create a “match result” data type?

I'm building a football match table which contains one column "match result", which should consist of data like "3-1","0-0"... I'm wondering what kind of data type is best appropriate for it, varchar ...
0
votes
1answer
6 views

MongoDB replicaset number of connections too high

I'm using a 3 node replicaset with 2 data nodes(version 2.6.1 and 2.6.3) and 1 arbiter node. I get frequent alerts on number of connections >1000, whereas total databases are about 400 and also I'm ...
0
votes
1answer
29 views

Why is casting a string to DATETIME not accurate to the ms?

Why does SELECT CAST('2014-11-28 15:06:02.165' AS DATETIME) return: 2014-11-28 15:06:02.167
0
votes
0answers
8 views

How to calculate total amount of time to load CSV file in SSIS

In current, I have one C# application and it is calling SSIS package (.dtxs) to load one CSV file(about large than 100MB). I would like to calculate estimation of time to load this file into my ...
0
votes
0answers
16 views

How to find what is causing large transaction log backups in MS SQL Server? [duplicate]

Most questions, including Why Does the Transaction Log Keep Growing or Run Out of Space? and other articles deal with people who have a transaction log file that keeps growing, usually due to them ...
1
vote
0answers
11 views

PostgreSQL 9.4 analysis, performance of normal column, indexed column and jsonb key

If I have a table containing: CREATE TABLE test( id SERIAL PRIMARY KEY, name VARCHAR(200), age INT, data JSONB ); and data column populated with {"name": xxx, "age": yyy}, sometimes ...
0
votes
1answer
13 views

SSIS cannot access the file

I have a SSIS package which performs a few tasks using SQL Server Agent. First it executes a script task, then accesses Excel files, executes a SQL query and moves files to another directory. The ...
1
vote
0answers
14 views

Why index is not used?

I've been asked a question in interview which i could not able to answer as i'm not much into mysql. I would like to know explanation about scenario. There is a table with colomns like id, day & ...
-1
votes
0answers
8 views

Error while running a job

Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the necessary space by dropping objects in the filegroup, adding additional files ...
0
votes
0answers
6 views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
1
vote
1answer
11 views

check the progress of table upload-mysql

I have a dataset of around 200GB. The sample is shown below: Posted a new song: "Ensaio Don`t back anger & imagine- Stone Rocks " http://t.co/i9TqakT38t #music 460523675293196289 ...
0
votes
0answers
5 views

Converting Timestamp datatype to Datetime datatype

I have a Timestamp datatype variable in my SQL Server 2008 database. An example of such variabel is "0x00000000CA346EDC". As for as I know its not possible to Convert a timestamp Datatype to datetime ...
0
votes
0answers
11 views

Best way to store a function map

I am building a site where data gets filtered through user defined functions to create an output. It is a requirement that the functions are represented in the database as formulas. For example a ...
0
votes
0answers
7 views

MYSQL Group Replication

I have setup a Master-Master-Slave replication where say A B and C, I want to replicate data from A to B (which is working) and B to C (also working) and from A to C which is not working with two ...
1
vote
1answer
17 views

Should I put common fields in each specific tables or one common table then join when data selecting?

Assuming there are a few categories: blog, video, gallery. Each of them contains post data like id, title, content, author, create_at, but different category have few more specific field: video will ...
0
votes
0answers
3 views

issue granting privileges in a hierarchical user configuration

as SYS: grant execute on sys.dbms_reputil to system with grant option; grant select any dictionary to system; grant dba to system; -> ok. Then, as SYSTEM: GRANT EXECUTE ON sys.dbms_reputil TO ...
1
vote
1answer
15 views

Using Aerospike without SSD

Is there a drawback for using Aerospike when used in non-SSD server?
0
votes
0answers
3 views

Tempdb tables, table in database or even cte for usp for reporting

I am about to start a project for SSRs report base on a USP. The procedure will have to use two cursors to compare orders v stock position (similar to a mrp run ): I am thinking of storing the data ...
0
votes
0answers
11 views

PostgreSQL: Store hierarchial data and return a recursive result with full path data

Background: I am considering whether to use LTREE or Recursive CTE with Materialized Path. For storing data, I am deciding between HSTORE or JSON. Objective: I need to store a hierarchial data. Each ...
0
votes
0answers
13 views

How can I copy a database from Sql Server to Azure Sql Database?

The local database has settings that Azure will not accept and that we must keep in the local copy. I tried using SSDT and with that I could publish to a new database on my local Sql Server a schema ...
2
votes
0answers
23 views

select on table slows done during update on same table

I have a weird problem with mysql. During a transaction which runs from 10-30s around 270 statements are performed, some of which are updating and inserting a few rows on a table. If a select is ...
1
vote
1answer
61 views

SQL Server doesn't use expected index

I have the following query (simplified from an Entity Framework query, I don't have direct control of the SQL): SELECT TOP 15 HouseHoldingRuns.Id, ( SELECT TOP 1 ManCoId FROM ( SELECT TOP ...
0
votes
1answer
10 views

my.ini configuration for a huge server

I have developed a web based app in PHP MySQL and Flash Builder. It was running fine until a few days ago when the client began to connect a lot of users. Then the app started to freeze and sent ...
0
votes
0answers
13 views

Data load architecture advice? [on hold]

imagine you have several isolated mysql database servers each responsible for capturing their local data, and you want to upload diffs of data (could be any DML) to a central server which holds ...
1
vote
0answers
17 views

Exporting to excel from OPENROWSET with cell formatting

I am trying to generate a report from SSMS to Excel, using OpenRowSet. All is working fine, still I have to export a specific column with a barcode font. I already have the column calculated from ...
0
votes
0answers
19 views

Can Graph Databases be used for an Availability and Scheduled Calendar based application?

Let's say you run a Barber Shop. You have 1 chair available and you want a Calendar to show up on your website that shows all the available time slots, so people can self book a hair cut. In my mind, ...
2
votes
1answer
31 views

What means Command column in sp_who2 and text column in sys.dm_exec_sql_text?

I have a script that shows commands being fired in SQL Server 2008 database as follows: --shows who is active and executed commands declare @SPID int=null, @Status varchar(max) = null, @LOGIN ...
0
votes
0answers
11 views

Cassandra CL quorum giving inconsistent values

How is this even possible? cqlsh:keyspace> consistency Current consistency level is QUORUM. select * from email_idx where email='xxx@yyy.com'; email------------------- | user_id ...
3
votes
1answer
312 views

One foreign key for two columns

I have two tables, Results and Teams Teams has the following columns: team_id team_name Results has the following columns: match_id home_team (foreign key references teams [team_id]) away_team ...
-5
votes
0answers
41 views

i want to create one generic query for all database like Oracle,Mysql,Mssql

I have to create different query for different database like Oracle,Mysql,Mssql .but i want to create only one generic query which runs or should works on all different database like ...
2
votes
1answer
28 views

MySQL: Sum if rows are equal

I have a table with 4 columns: Client , thickness , material and amount. I want to make a SQL select-query to select everything, but when the client, thickness and material are the same their value ...
1
vote
1answer
26 views

PostgeSQL 9.3: What is the difference between text and pg_catalog.text?

I have a classic 3-environments setting (dev, staging and production), each with its own RDS PostgreSQL 9.3. The client/server versions are psql (9.3.5, server 9.3.3). In order to keep the schemas ...
1
vote
2answers
35 views

SQL Server 2005 - Adding around 200 rows in a table grows size of the table by 400kb where avg row size is 0.2KB

We are running into an issue where if we look at the avg row size (0.2kb) x number of rows (200) inserted in one of our table, the size should grow by around 40 KB. However the total used space has ...
1
vote
1answer
28 views

How can I speed up an sql query that round trips between two tables

I first posted this question on stackoverflow, and now I see this site, seems more relevant. These tables are not that big, but the time taken to process this query is long. What can I do with the ...
0
votes
1answer
27 views

PostgreSQL, UPDATE CASE statement uses huge amount of space

I am running a CASE statement on one of my tables and it consumes a huge amount of hard drive space that is never freed up even when i run VACUUM ANALYZE. Autovacuum is ON as well. I am using ...
0
votes
0answers
38 views

ERROR: relation “name” does not exist

I am trying to import a postgresql database table sent to me in phpPgAdmin, I am following the instruction from this import database But after doing so, several error appear, I also tried to import ...
-4
votes
0answers
16 views

How do I convert the quantities exported into millions Single Strength Equivalent gallons (millions SSE Gallons) [on hold]

I am new here and I need expert help :-) I have a college assignment and I can't figure it out. I will copy and paste the problem along with 2 images. Thank you for your assistance: I am not sure if ...
1
vote
1answer
33 views

Need to Send a formatted HTML Email via Database Mail in Sql Server 2008 R2

My requirement is to create the automated email as ( A formatted HTML Email via Database Mail) The basic requirement has been completed where when the Job is triggered it inserts the data into a Table ...
0
votes
0answers
23 views

MySQL Multi Count and Filter

Table: Event ============== ID OldUserID NewUserID Date Table: User ============== ID Forename Lastname .... How can i filter by date column like so... this code is pseudo... SELECT ...
1
vote
1answer
13 views

Get trigger query using query analyzer

I have a server in which there is no SSMS installation, and only query analyzer is available. And all I need to do is find the trigger information (basically trying to find out what that trigger ...
0
votes
0answers
7 views

When is the time that Couchbase write documents to disk?

As the title said, when is the time that Couchbase write documents to disk? every 60 seconds? every 1 seconds? every 100 ms? or everytime there are read command to that document?

15 30 50 per page