0
votes
0answers
4 views

SQL Server 2008 Patch Installer shows incorrect information

When running the SQL 2008 SP3CU16, on one of our instances, the install seems to run through the wizard OK. However, the Setup Bootstrap log reports "The patch installer has failed to update the ...
0
votes
0answers
2 views

The database manager failed to allocate shared memory because an operating system kernel memory limit has been reached

I have installed IBM DB2 10.5.5 and I want to create a new database there. When I entered command db2 create database test1 I am getting a error saying SQL1084C The database manager failed to ...
0
votes
0answers
2 views

Syncing writes and not deletes - mongoDB

Is it possible to have a secondary instance of mongoDB which syncs all the write operations to the database and not the delete operation? I'm looking for this solution so that I have a backup even if ...
0
votes
0answers
8 views

Database Design - Voting System

I'm creating a website in which people can submit there own lists, and then essentially others Up/Down Vote the items within the list. I'd like the list (If the submitter allows "votes") to be ordered ...
0
votes
1answer
12 views

Query XML without namespace

I can query XML, which has defined xmlns tag with common table expression DECLARE @XML XML SET @XML = '<NodeA xmlns="https://XYZ.xsd"> <NodeB verzePis=""> <NodeC1 attrA="Hello" ...
0
votes
0answers
8 views

Source of error on psql data load

Upon importing a file derived from rails establishment, psql is hitting the error of foreign key constraints: ERROR: insert or update on table "documents" violates foreign key constraint ...
0
votes
0answers
2 views

How can I cache queries in sqlalchemy just like I do it in mysql by using SQL_CACHE keyword?

I want to cache sqlalchemy,i have discovered that using keyword SQL_CACHE in mysql can be helpful in caching queries on demand. But how do i do it in sqlalchemy ? Is it possible ?
0
votes
1answer
15 views

Ordering in subqueries

This is my query: select locid,tlid,locdescription from ( select locid, tlid, locdescription from trip_log left join trip_log_det on tlid=tldtripid left join locations on tldlocation=locid ...
0
votes
0answers
3 views

what are the options for the psql \copy command?

I was looking at the psql documentation: \copy { table [ ( column_list ) ] | ( query ) } { from | to } { 'filename' | program 'command' | stdin | stdout | pstdin | pstdout } [ [ with ] ( ...
0
votes
0answers
13 views

Issue with fetching data from mysql according to recent timestamp ASC ordering

I am having trouble with mysql query to fetch the data according to the recent timestamp in ASC order. it means the recent updated one record will be first shown. The Query is grouping with the ...
0
votes
0answers
3 views

How can I avoid this deadlock in MariaDB?

I saw that I got a deadlock in a MariaDB cluster. I have 3 cluster database. What should I do to avoid that? 160211 16:29:02 *** (1) TRANSACTION: TRANSACTION 75AB6B17, ACTIVE 0 sec starting index ...
4
votes
1answer
24 views

Cost Threshold for Parallelism with Maxdop = 1

Been debating with my company's app vendor regarding parallelism. They have maintained that Maxdop = 1 has significant performance improvements for the app/db but they have provided absolutely no ...
0
votes
2answers
16 views

Need Script to find SP Invoked in SQL

I'm unable to track a stored procedure that is executing every morning 7 AM. Is there is any script to check that which job invokes that particular SP?
0
votes
1answer
9 views

Could I use the SQL statement, SELECT * from sysobjects, with C# MySQL Connector - .NET?

I would like to port a SQL statement, SELECT * from sysobjects, written for Microsoft SQL Server to MySQL version 5.6. Could I use the SQL statement, SELECT * from sysobjects, with C# MySQL ...
1
vote
1answer
11 views

How do I recover my database after losing a tablespace with indexes?

I'm thinking of moving all the indexes in my PostgreSQL 9.3 database to a tablespace on an SSD for improved performance. This SSD is not in a RAID array and I need to consider a scenario where it ...
0
votes
0answers
8 views

SQL Server transactional replication distributor

If I have a SQL Server 2012, with two databases, both publishers, replicating to a bunch of subscribers. Can each database go through a different distributor? Is the publisher the server or the ...
1
vote
0answers
21 views

How to optimize query on MYSQL with multiple group by clause

I have a web application where users can view data of performance. There will be around 200 to 250 users. Each user will have like 100,000 rows of data per day. It is only table and here is ...
-2
votes
0answers
23 views

Data retention and purge process [on hold]

how can i verify that purge process is working in database. Pls help any links or any information on it will be appreciated. I have SQL server 2012 database
0
votes
1answer
22 views

Filter created_at and count distinct minutes

I have this query to get records from a database: SELECT camera_id, count(*) AS snapshot_count FROM snapshots WHERE created_at >= timestamp 'yesterday' AND created_at < timestamp 'today' ...
3
votes
1answer
26 views

How to create a view with added rows for missing dates?

I'm not sure how to accurately phrase this question. Essentially, say I have a bunch of salespeople on different sales teams. Like, the Blue Region, the Orange Region, the Red Region, whatever. Now, ...
0
votes
0answers
12 views

Restrict connection to SQL Server By IP [duplicate]

On a QA server I need to give access to specific login from just one IP to log to this server. I wrote This login trigger Create TRIGGER tr_CheckIP ON ALL SERVER FOR LOGON AS BEGIN ...
0
votes
0answers
7 views

Relationship between data independence and database schema

What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
0
votes
0answers
26 views

MariaDB: inner join searching for 1 in TINYINT column not working

Since yesterday I've been trying to make a query work. I have two tables: image where I store information about images and imagehit where I store information about how many times those images are ...
0
votes
1answer
30 views

Get data type by ID

I was looking at this answer for checking the data type of a value. It's quite handy and spits out something that looks kind of like this: Typ=1 Len=12: 48,48,48,48,48,48,49,49,49,49,49,49 The part ...
2
votes
1answer
36 views

Explaining the problem with a column of values from a non-mutually exclusive domain

I'm trying to convince the powers-that-be that their current database design is risky and inefficient. I'd like to verify whether my assumptions are correct, and I'd like help in finding technical ...
0
votes
1answer
14 views

Design - duplicating properties vs not allowing delete

I'm designing a database for a mobile app CMS that contains user data. These objects are Address and Job (a job can have 1 address and an address can have many jobs). The first version of a similar ...
0
votes
0answers
19 views

SQL Server service automatically stops after starting I cant lo in to sql database engine [on hold]

It worked fine until now. I can't get it working because SQL Server service automatically stops immediately after I start it. I'm trying to start it from Sql Server Configuration Manager. When I open ...
0
votes
0answers
9 views

Question on comparing two fields in Access

I'm not sure if the title is fitting as I am not 100% sure if what I am doing is correct but here goes. Here is my enrolment table, I have added a field called pass/fail as you can see which is ...
0
votes
0answers
7 views

How can I make microsoft Access update fields that are linked in several tables?

I am working on a database for clinical observations in cancer mouse models. Usually, the animal care staff reports an observation that the vet checks. Sometimes, we have false positives that I need ...
0
votes
0answers
15 views

SQL-Server Full-Text Index Auto-Population Stops Working

From time to time auto population stops working (SQL Server 2014 11.0.6518). I have to use ALTER FULLTEXT INDEX ON [table] RESUME POPULATION to make it work again. In the SQLFT*.LOG there is no ...
0
votes
0answers
8 views

SQL Job No Longer Executes According to Schedule After an Error

I have many SQL jobs scheduled to run at various times. I've noticed that sometimes, not always, if the job aborts on an error, it will not execute its next scheduled execution. In fact, it won't ...
0
votes
0answers
17 views

Better configuration for a In-Memory MySQL database?

I have a local MySQL database for the only purpose of execute some PHP tests. To improve the speed of the execution, I created the database in memory using the ENGINE=InnoDB statement in every table ...
0
votes
0answers
6 views

pg_dump FATAL error - PostgreSQL 9.2

Running a pg_dump command from a TEST server. Copying from a Slave server. DB size is 1.7 TB. Command: ssh postgres@slaveserver "/usr/pgsql-9.2/bin/pg_dump --exclude-table-data='junk.*' ...
0
votes
4answers
35 views

Selecting data from another table using a foreign key

I have two tables A & B. Table A id | name | num Table B id | date | roll id in table B is a foreign key which relates to the id in table A. I want to get the contents of table B where id ...
0
votes
1answer
31 views

Query that compares dates

I'm trying to create a query that shows if students are mature or not, based on their date of birth. However when the query is executed it returns all students as not mature. Any students that are ...
0
votes
1answer
9 views

Incremental column depening on column value

I would like to have a column which has an incremental integer depending on the column value after sorting the table. E.g. after sorting by state: Nr | State | Counter ...
3
votes
1answer
40 views

Debug query on big table that is sometimes slow

I have a web API that is backed by a Postgres database, and the performance is generally very good. I monitor the performance of both the database and the application as a whole. Most of my queries ...
0
votes
0answers
5 views

Changing global variables in MySQL RDS instance

I have a MySQL RDS instance that I created. I need to set the net_write_timeout variable in the instance so it is available globally. Can this be done ?
0
votes
0answers
12 views

How to pass parameters to a cmd.exe using Servcice Broker External Activator

I am trying to use SQL Server Broker External Activator to launch C:\Windows\System32\cmd.exe application and pass commands to it. For example: echo Hello World x 2 >C:\Test\cmd1executed.txt To do ...
0
votes
0answers
24 views

simple math with SELECT - no resulting row

Simple math with SQL don't give a result. There is written 1 row in set, but I don't see the result/row. MariaDB [(none)]> select 5242880 / 1024 / 1024 as current; 1 row in set (0.01 sec) ...
2
votes
1answer
34 views

How can I create a role to create,update,delete stored procedures and views

what permissions do I need to give in order to achieve the above task to get users the capacity to create,update,delete stored procedures and views to a database role.
0
votes
1answer
21 views

Unique identifiers for the same type of object in the same request

This question is about your opinion and common approach for relational databases. So please, do not vote me down. I really need to solve this problem.. I remove this question once I meet the answer. ...
1
vote
1answer
16 views

Can we create Fail over clustering for sql server 2012 standard edition on amazon EC2?

We are planing to move on amazon's EC2 services. So my question is that can we create fail over clustering on amazon EC2 using sql server 2012 standard edition ?
1
vote
0answers
17 views

SSIS: Trying to configure branching logic in Foreach loop

Full disclosure: I posted this on SQL Server Central yesterday but got no answers. I hope someone here can assist me. I'm working on importing flat files into a database. I have used a Foreach loop ...
0
votes
0answers
13 views

Why does OpenQuery hang for hours before raising Query timeout expired when query timeout on Linked Server is set much shorter?

In production have two SQL 2012 instances on separate servers, with a Linked Server set up between them. No problems there. In development, I have the databases for both in one 2012 instance, and have ...
0
votes
0answers
20 views

Issues with the @query parameter in sp_send_dbmail

When I use the following: select * from table A where repID in ( select repID from table B where id = 5 ) as the string I'm assigning to the @Query parameter. ...
0
votes
1answer
24 views

How can I optimize my SQL Query

I try to optimize a Sybase SQL Anywhere Query for Performance but with no luck. LetzterPreis & LetzterBeleg slow it down. Any suggestions how I can optimize it? :( Here is the query: SELECT ...
0
votes
0answers
13 views

Is it safe to sync MySQL binlogs?

I am working on a strategy to replicate my MySQL binlogs to Amazon s3. I have looked into mysqlbinlog --remote-server but it seems like adding a file watcher on /var/log/mysql which triggers an aws ...
0
votes
0answers
23 views

Resource Governor - user in classifier function using NULL pool rather than stated pool

I have a problem with transaction log backups for an AlwaysOn HA database causing latch contention. It's not a problem when we run backups on the replica but we're not licensed for that, so I'd like ...
0
votes
0answers
10 views

Retrieve data from corrupted hard drive [migrated]

I've installed Fedora on Vmware. Recently my hard drive is corrupted and can't be read. Could someone please help me out, how to extract the data I've in that virtual machine. The host OS: Windows ...

15 30 50 per page