3
votes
0answers
12 views

Which timeout(s) are causing my linked server query to time out?

We have two databases on linked SQL Servers that are partially synchronized. Occasionally, one side goes down for an upgrade, then the other goes down for an upgrade, and then we re-synchronize. ...
4
votes
1answer
34 views

Why would SQL Server remain unresponsive after a slow query completes?

I've just finished debugging a problematic SQL Server 2012 table-valued function. It was declared to use a unique column in the table: CREATE FUNCTION [dbo].[myApp_getUserIdsFromXml] ( ...
0
votes
0answers
3 views

MariaDB/InnoDB: Temp file write failure

When attempting to alter a table to enable compression by modifying the KEY_BLOCK_SIZE I received the error: ERROR 1296 (HY000): Got error 64 'Temp file write failure' from InnoDB The command ...
0
votes
1answer
8 views

Oracle RAC VIP issue

I have a two node RAC setup where my scan ips are registered in DNS and my public Ips are also registered in the dns. Now while connecting from my windows machine through oracle client in sql ...
0
votes
1answer
20 views

How is a hierarchical database made? [on hold]

I've never used a hierarchical database but am curious about how it works. A relational database uses primary and foreign keys and allows many to many relationships where as a hierarchical database ...
0
votes
1answer
7 views

Mysql datetime field partial match

Currently I am designing a mysql table structure that will hold a couple of million rows. I want to search in it on datetime field by date year and so on but the date will be entered by user so it ...
0
votes
0answers
6 views

MATLAB® export double numbers into PostgreSQL by `datainsert` (of Database Toolbox)

How is it possible to pass double numers into numeric postgreSQL columns from MATLAB? Here the list of matlab data: var1 197x1 cell var2 197x1 double var3 197x2 double var4 197x2 double ...
0
votes
0answers
4 views

MongoDb performance with large data

Is there any bench-marking figure available for MongoDB with a very large data volume ? I intent to find a solution for an existing application where the main bottleneck being the database ( RDBMS at ...
-3
votes
0answers
12 views

PRODUCTION DATABASE HANDLING PROBLEMS [on hold]

I am working in watch company here in UAE. We source watch parts from different vendors operating in china. Most of the watches contains 8-10 components & each component is purchased by different ...
1
vote
1answer
10 views

Recording history of ranks

Once per day, this is being executed to rank everyone in the database based on points. SET @r=0; UPDATE ranks SET previousRank=rank, rank= @r:= (@r+1) ORDER BY points DESC; The field ...
2
votes
1answer
13 views

Storing prices with price history and different specificity (global, user group, single user) in MySQL database

I need to store prices with their history. A price can have different specificity. It can refer to a single user (most specific), group (less specific) and product price (global - least specific). ...
0
votes
1answer
20 views

Unique clustered index on indexed view fails because of aggregates

I want to create an indexed view similar to this (slightly simplified): Create VIEW dbo._v1 WITH SCHEMABINDING AS SELECT COUNT_BIG(*) as CB ,[ID] ,TITLE] ...
0
votes
0answers
4 views

Would it be a good idea to create a system using MS Access as a front end and MySQL as a backend?

I've recently been working on a MS Access project. I had to re structure the DB as almost nothing was normalized and some issues were encountered. After finishing the DB ...
0
votes
0answers
4 views

Oracle 12c 2-node RAC, after first reboot CRS is hanging/stuck on octssd on the second node

My issue is with the Cluster Time Sync Service on the second node of an Oracle 12c RAC 2-node cluster on Oracle Linux. After the first reboot the second node is stuck on the octssd.bin process. I ...
1
vote
0answers
3 views

Generate tables from entities with hibernate

I'm using postgresql with a spring/hibernate to create a multi-tenant application where every company will have its own seperate schema and tables in the database. So when the super administrator ...
2
votes
0answers
9 views

Slow fulltext search for terms with high occurence

I have a table that contains data that is extracted from text documents. The data is stored in a column called CONTENT for which I have created this index using GIN: CREATE INDEX "File_contentIndex" ...
3
votes
0answers
14 views

Mysql suddenly crashing after several months

I'm away on leave and mysql on an EC2 (m3.medium general purpose) based server I have The displeasure of managing has suddenly started crashing. I have very intermittent internet connectivity through ...
0
votes
0answers
10 views

Impact of adjusting Time of Mongodb server?

Using Ubuntu 14.04 and mongodb 2.6.10 I have time difference between a replica machine and primary , my secondary isn't configured with NTP what are the implications of adjusting time on the ...
-2
votes
1answer
42 views

Retrieve result for all the users

I have one query which returns particular user total hours for a month. I want to return for all the users in an org. UserRegistration table contains UserID. My code for particular user is, SELECT ...
0
votes
0answers
8 views

What exactly are secondary members acknowledging in replicasets with MongoDB?

I try to understand the mechanics and behavior of MongoDB's replica-features better. I hope to get some insightful information from someone who is familiar with mongo's internals and behaviour. My aim ...
0
votes
0answers
12 views

List of role permissions including other roles - how can I find out the roles that belong to other roles?

I can see the permissions of a role in a database using the scripts in List all permissions for a given role? However, It does not show me when the role belongs to a another role. For ...
0
votes
2answers
15 views

select where column with a %

How can I select all records with a % in? Goes code below works? SELECT * FROM table WHERE column LIKE '%%%' first and last % for zero, one or more chars second % for the percent skinn If not ...
0
votes
0answers
9 views

db2audit on a table in a db2 database

I have a table in my database from where records are getting archived continuously. We have come across a solution of configuring db2audit. I have the below understanding on this: Describe the ...
1
vote
2answers
42 views

Partition of a table - how to minimize the time offline? How to check if all the statistics were updated?

As you ca see on the picture, I have a table called "tblsapdispatch" that has 55,707,259 records. Last sunday 30-aug-2015 they run a big update on this table, and I can see that the statistics were ...
0
votes
0answers
23 views

How come MySQL LIKE is faster then FULLTEXT?

So, I was trying to optimize my MySQL queries, but found out that i'm actually doing this wrong. I've changed my query from using SELECT * FROM test WHERE tst_title LIKE '1%' To: SELECT * FROM ...
-2
votes
0answers
24 views

How to make a procedure Loops on all Rows

Hey there i have created a table as in the attachments ... and i have created a procedure that works on a specified columns of the table to serve this purpose: update score depend on random number R ...
-1
votes
3answers
52 views

Joins in Stored Procedure

Below is my code, which returns billable and non billable total hours for their projects. I want to show in single row, but i am getting two result sets like below. DECLARE @UserName NVARCHAR(50); ...
0
votes
0answers
9 views

postGIS dump size seems strange

I have this table on postGIS 2.1.5 (postgres 9.4.3). A pg_relation_size shows a size of 300MB. However when I try to dump the schema containing this table (and only this table), I end up with a 27GB ...
1
vote
0answers
18 views

Table replication with extra TIMESTAMP column on slave

I have a table on master and same table on slave with an extra column like InsertTime timestamp DEFAULT CURRENT_TIMESTAMP I want to keep record of time when there is update on slave. Replication ...
1
vote
0answers
27 views

Duplicate Same Table for Multiple locations

We have an "appointments" table with following schema. appointments(app_id,.....,app_type,location_id) app_type - type of appointment location_id - keeping the location for multiple location setup. ...
0
votes
1answer
20 views

Importing MySQL tables from other database in live site with mysqldump can cause trouble?

Scenario: I want to replicate MySQL tables from one database to other database. Possible best solution: May be to use MySQL Replication feature. Current solution on what I'm working as workaround ...
3
votes
1answer
49 views

Can't restore SQL Server db from full backup, log processing fails, database in 'restoring' state

I am trying to set up a database for development purposes on my PC's local SQL Server Developer Edition 12.0.2000.8. I've got a full database backup and separate transaction-log-only backup files ...
0
votes
0answers
7 views

I have created a user with 'role':read but I can write also

db.getUsers()[ { "_id" : "test.root", "user" : "root", "db" : "test", "roles" : [ { "role" : "read", "db" : "test" } ] } ] I have two ...
0
votes
2answers
22 views

Making sense of these business rules

My scenario is a shop/warehouse and I have a Product table which contains basic product details including it's name, price, quantity on hand etc. I have a Customer table that has the shops customers ...
0
votes
1answer
16 views

FullTextSearch indexing/searching words with special characters

I'm trying to query FullTextSearch indexed column for hashtags SELECT Bio FROM Users WHERE CONTAINS (Bio,'promoter') SELECT Bio FROM Users WHERE CONTAINS (Bio,'#promoter') both results returns the ...
2
votes
1answer
27 views

One SQL different Results by using SQLOLEDB or MSDASQL

I'm using VB6 with SQLOLEDB and MSDASQL. By switching the Provider i've notice, that i'm getting different Results with one query. My Query Checks some Server Settings and Execute Backup SQL 1 or ...
0
votes
1answer
25 views

How to prevent insert row duplicate value in a column and equal the any value

I have table TABLE1( id number (primary key), IDAccount number, status char(10)) Table can have 2 row duplicate (IDAccount, status) with status=disable as well as id IDAccount status 1 ...
-1
votes
1answer
27 views

Upgrade Database From 2008 to 2008 R2 [on hold]

I 've upgrade my database from SQL Server 2008 to 2008 R2 ,version of SQL Server on other server 10.50.1600.1 , version of my SQL Server is 10.50.1600.1, when restore database from server to my ...
0
votes
0answers
30 views

Same SQL stall on server but work on local ( on slower machine )

I have this strange issue that because of my limited knowledge about Mysql I cannot understand, I will really appreciate if somebody can enlighten me and point me to how to debug the issue. ...
0
votes
0answers
20 views

How to implement a query insert into BEFORE INSERT trigger syntax

I want to insert data using trigger into 2 tables. I want to implement my query insert to a before insert trigger. Since I was newbie for using MYSQL, I'm confused how to implement it. insert into ...
1
vote
1answer
130 views

SELECT COUNT(*) to html table

This may be a very simple but its still not clear to me. I'm writing a SQL Agent job to generate output in html format. I need to get results of a query SELECT COUNT(*) FROM TABLE_NAME. I'm able to ...
3
votes
2answers
29 views

What flavor of SQL is used inside Microsoft Access?

I don't have much Access experience, and I took on a new Access project. I can use SQL to query the Access databases. What SQL specification/flavor is used inside Access? Is it the same as SQL ...
-6
votes
0answers
26 views

i want to join the sum but different LIKE CONDITION [on hold]

Below is my table this is fill on the training_transaction table
0
votes
0answers
4 views

How restore a specific database from backup using mongorestore command

I created a backup of my all database using mongodump command. Now I want to restore a specific database using mongorestore command. How is this possible, I use this command: --db option then mongodb ...
0
votes
1answer
3 views

mongod 2.6 corruption (Assertion failure isOk() src/mongo/db/storage/extent.h 80)

I have been using mongo 2.6.0 for some time on 64-bit centos (with journaling enabled). One fine day when we were testing to insert a document to one of the collections, we started seeing data ...
0
votes
1answer
60 views

Is there a way to run this query in all databases ? ( SQL Server 2008 R2 )

How can I use this query for each database? I can easily use sp_msforeachdb but it breaks the results for every database. So I tried to insert the results in a temp table, but it's giving me syntax ...
1
vote
0answers
32 views

3 tables joins performance issue

DB: Postgres 9.4 schema: table a: id, score table ab: a_id, b_id, b_type table b: id, name, type I am trying to get top 10 result in the following format: name, count(group by name), ...
0
votes
0answers
23 views

Fullbackup + Differential/Copy-only

We have a PROD full backups copied over to support envs daily and we restore to support environments to triage some issues, as the DB is growing big we would want to run the full backup copy only on ...
1
vote
0answers
17 views

Log shipping restore delay of a minute between iterations

On a test database running Log Shipping jobs the initial Restores to catch up performed the first time I run the Restore job seem to have a 1 minute or so Wait time built in. I would have expected ...
1
vote
1answer
29 views

PostgreSQL, how to extract all the possible couples of a primary key in a table?

I would like to find out a PostgreSQL command that reads the content of a table, and returns all the possible couplings of the primary key of the table. Something like this: input_table (ID is the ...

15 30 50 per page