0
votes
1answer
9 views

Alternative when IN clause is inputed A LOT of values (postgreSQL)

I'm using the IN clause to retrieve places that contains certain tags. For that I simply use select .. FROM table WHERE tags IN (...) For now the number of tags I provide in the IN clause is around ...
0
votes
0answers
6 views

Unable to browse to folder on SSRS 2012 through report url

I have installed SSRS 2012 in native mode on windows server 2012 r2 and deployed reports to the server successfully. I am having difficult browsing to any report folder through the report URL. I can ...
2
votes
0answers
8 views

Track entity updates (by who and when)

I need some advice on how to store information about who created/updated an "entity". I keep going back and forth between Option1, 2 and 3 (see below): Background This is a legacy system and there ...
2
votes
0answers
4 views

Remove a shard in MongoDB

I have a MongoDB cluster, I accidentally hosed a shard, I don't have a backup. It's pretty easy to recover the data, but after issuing the removeShard command, it says it's draining. However, the ...
0
votes
0answers
11 views

Adding order by to a query is slowing down the query even after Indexing

While joining columns with huge data even after indexing the column order by is slowing down the query. Without order by query is executing within 2 secs. But with order by query is taking 145 secs. ...
2
votes
2answers
113 views

Why these characters are all equal in SQL Server?

I just don't get it. See this SQL query: select nchar(65217) -- ﻁ select nchar(65218) -- ﻂ select nchar(65219) -- ﻃ select nchar(65220) -- ﻄ if nchar(65217) = nchar(65218) print 'equal' if ...
1
vote
0answers
11 views

how to get a sum total of each column and row - postgresql [Crosstab or Case]

I have to count the records according to the criterion, they are much more filters but I have summarized. I could use either of two ways. 1# SELECT * FROM crosstab('SELECT dim_espacio.desc_estab, ...
0
votes
0answers
8 views

Deadlock occur during multiple insert on Single database?

I have multiple windows services thread that insert values into database. But when parallel insertion happens it gives error After show innodb engine status gives Deadlock issue.
-4
votes
0answers
18 views

Query to update datetime field with yesterday's date [duplicate]

Can you tell me the sql query to convert the datetime field from which current date to be updated to previous date and time part as 21:00:00:000 adjusted to GMT
1
vote
1answer
15 views

How do I reduce SharePoint 2010 SQL server log files?

I have a work place portal built on SharePoint 2010 and the SQL Server drive space is full. I am using SQL Server 2008 R2. Of the 800 GB disk space, the log files have taken approximately 730 GB. ...
0
votes
0answers
2 views

How to define partition according to Date?

I am currently MySql 5.6 is used. In database contain log table that is paramlog_ems.In that log table contain 2M of row. I want make partition according to Date. Following is the table structure. ...
-3
votes
0answers
22 views

I want to update certain rows of datetime field to previous date and time by default 21:00:00:000 [on hold]

For certain rows the current date should be updated as yesterday's date and time to be set as '21:00:00:000"
2
votes
0answers
19 views

Postgres Streaming Replication: How to re-sync data in master (with standby) after failover

I am absolutely new to postgres 9.1 replication mechanisms. I have managed to set up streaming replication between a master and standby postgres (Both have x number of records). At one point when ...
-4
votes
0answers
25 views

Estimated and actual execution plan for a Parallel Query [on hold]

for a parallel query, there is a big difference between estimated and actual execution plan. Does anyone know the reason?
-1
votes
0answers
23 views

Getting error ORA-01034: ORACLE not available [on hold]

I am getting this error while connecting my database in oracle sql developer. ORA-01034: ORACLE not available. ORA-27101:Shared memory Linux Error:2:No such file or directoy
1
vote
1answer
37 views

Why is it that when I drop a field in table it says `#1050 - Table already exist`

I want to drop some fields of a table but it returns an error. the query is.. ALTER TABLE `tbl_incoming_bub` DROP `approved_date`, DROP `approved_by`, DROP `incoming_date`, DROP `incoming_by`, DROP ...
0
votes
1answer
23 views

Database Design For Social Network apps

I'm going to build a social network app. Each user will have photos, videos, details, posts etc. My question is when a new user registers, should I generate many new tables for that user or have one ...
0
votes
0answers
13 views

Moving Database SQL Server 2012 to 2008/R2 [duplicate]

I'm planning to move a Large Database from SQL Server 2012 to 2008/R2. I tried the scripting thing, it works on a small-medium type of database but not on Large database w/c is about a hundred MB. Any ...
3
votes
1answer
23 views

How to tell if a backup file contains CDC?

Using SQL Server 2008 through to 2014, I know how to backup and restore a database with Change Data Capture enabled (CDC), but what I am looking for is a way to query a full backup file to determine ...
0
votes
2answers
12 views

Inconsistencies with ADD CONSTRAINT index_name in MySQL

I created this example table CREATE DATABASE foobar; USE foobar; CREATE TABLE foos ( id INT(11) AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, ...
0
votes
0answers
6 views

ASE 12.5 - Local variable in stored proc - performance issues

I've been told many times that using a local variable inside a stored procedure (ASE 12.5) will degrade performance because it prevents indexes from being utilized. I've searched allover for more ...
0
votes
0answers
13 views

How can I improve this data model for a water billing system? [on hold]

Basically, I would like help to improve this data model. Is this model a good one, or can it be improved?
0
votes
0answers
5 views

Implementing json_object_agg() in Postgres 9.3

I feel like I need the json_object_agg() function of Postgres 9.4 but I will not be able to upgrade from 9.3 right now. Is there a way to do what I want in 9.3? Here's my scenario. I have a table ...
1
vote
1answer
37 views

Having issues with a CTE in a Nested Join [on hold]

I'm unfortunately dealing with someone else's code here, but needing a little push. What I have happening is that I have a CTE that is needed to run in a nested join. ...Start of CTE INNER JOIN ( ...
3
votes
2answers
33 views

Is copy/rename a good way to improve temp table performance?

An application I am working with contains this sequence of queries at the end of constructing a large temp table; I believe it is an attempt to improve performance by pruning dead tuples - create ...
0
votes
1answer
16 views

How to update both the source and the target using MERGE?

I have two tables that I want to merge. Each has row contains the last time it was modified. I want to merge the tables such that the newest value is assigned to both tables. This is the code I want ...
1
vote
0answers
10 views

pg_dump does not honor -n

I'm using pg_dump (9.2 database), to extract one schema and load this into another database (9.4). well, here's the command: pg_dump -f file.sql -F plain --inserts -n schema database Ok. My ...
0
votes
0answers
9 views

where does ASE stores values when we enable option “full logging for all” for any database

i've enabled option "full logging for all" on a database, however unlike other options there is no change in status columns in sysdatabase. I just want to know how ASE determines if full logging is ...
0
votes
0answers
7 views

Couchbase data modeling

I come from the RDB world, and I'm getting started with NoSQL. So please consider that when answering. I have two Buckets: Apps and Users. A user may be subscribed to N applications, and every app ...
0
votes
0answers
5 views

How do create a common databae for several local databases which are the same databases and are usedexact the copy of same application? [on hold]

How do create a common databae for several local databases which are the same databases an
0
votes
0answers
12 views

Can we Audit Synonym Usage in Oracle?

When Auditing is enabled in Oracle, is there a way to differentiate Private Synonyms access from actual object access? For example If I have Table: S1.My_TABLE Private Synonym: S2.My_TABLE ...
0
votes
0answers
19 views

Adding a constraint to both tables independantly in join [migrated]

I am trying to create a SELECT statement from two different tables, where I use to send messages, I don't want to send a message to someone for 1 wk after they join, however if I have already sent ...
0
votes
0answers
11 views

ERROR 1644 (HY000) at line 1852: Unexpected content found in the performance_schema database

I was upgrading MySQL from 5.1 to MySQL 5.6 on a Linux server installed with RHEL6. I already have 5.1 installed and running with about 300GB of database data, so I want to do a in-place upgrade to ...
2
votes
0answers
9 views

Postgres to Postgres foreign data wrapper, for tables based on queries

I have a db with sensitive data in a secure server, and a set of anonymization queries that I'd like to create foreign tables based on in a less secure server. The Postgres native wrapper only ...
0
votes
0answers
12 views

How to store user defined scoring formulas?

First post, so apologize if I have not chosen the best spot for it: If I had table of values, let's say corresponding to a question number and its corresponding answer, what is the correct way to ...
0
votes
1answer
18 views

MongoDB service not working after upgrade to Ubuntu 15.04

I have recently upgraded my Ubuntu from 14.10 to 15.04. All features seems to be working fine except MongoDB. It is not controllable from service as we do normally in Ubuntu. sudo service mongodb ...
0
votes
0answers
21 views

Transactional replication of stored proc execution and stored proc parameters

I'm trying to design how we might go about setting up replication of just the execution of a stored procedure. If the stored procedure on the source takes one or more parameters, will those same ...
1
vote
1answer
31 views

How to perform a pivot on multiple columns

I have a list of data that includes values and the time those values were recorded. I would like to pivot this data so that i have as columns the individual types of observations and the date/time ...
0
votes
0answers
17 views

Maxing out the shared pool's memory by executing many UPDATE statements (ORA-04031)

I was executing a bunch of UPDATE statement. Around ~32.8K got executed and committed, then got the error: cx_Oracle.DatabaseError: ORA-04031: unable to allocate 3896 bytes of shared memory ...
0
votes
0answers
12 views

can't connect to remote postgresql database

I'm trying to connect to a remote psql database. Before I added the pg_hba.conf entry with the client's IP address, I was getting an error message : xdev@xdevbox:~$ psql -U postgres testdb -h ...
0
votes
1answer
34 views

SA login history in sql

Is there any PowerShell script to get the SA log in history? I need to do an audit on SA login.
0
votes
1answer
15 views

How to peer to a new domain?

How do I peer to a new domain? I'm using NuoDB on MacOS http://dev.nuodb.com/download-nuodb/request/download
1
vote
2answers
37 views

Can SQL Server Transactional Replication do this?

We have a production server and a reporting server, with transactional replication in place to move all inserts/updates/deletes from production to reporting. We're using SQL Server 2008 R2. We have ...
1
vote
2answers
47 views

Can I configure the PostgreSQL locale so that it ignores umlauts in ILIKE queries?

I'm using PostgreSQL to look for city names matching a user-entered string. I'd like to be able to match a row with the name "München" (German for "Munich") if the user types "Munchen". In other ...
-2
votes
1answer
26 views

ODBC Problem ORA-1089 cause ORA-3114 [on hold]

I have a program (I don't manage the code) that uses an ODBC connection to send data to an ORACLE 11G database. Everething works fine but when the DBA uses the command SHUTDOWN INMEDIATE, the ...
0
votes
1answer
16 views

Cannot select features to install from SQL Server 2005 SP4 installation process [on hold]

The issue: I cannot select MSSQLSERVER from the feature list I want to update as part of the SQL Server 2005 x64 Service Pack 4 installation process. Please note exe file is being raised from C:\ ...
2
votes
2answers
39 views

Database recovery procedure

I recovered a database with last full backup, all differentials after the full, and then all log backups after the last differential. Can I trust the database is right or do I have to do it again the ...
2
votes
1answer
35 views

Join more than 3 tables in one single query, with many comparisons and no IDs

I use an overlycomplex and poorly designed software at my work, and now I need to produce a report of invoices issued between a period of time. Invoices are held at table ENTR2012, which uses the ...
0
votes
1answer
22 views

Pgsql Function to create multiple child tables inherited from parent tables

I need help with pgsql function to create multiple child tables concatenated with date. Inherited from parent tables. I am using the following queries -- Setting date range SELECT CAST( ...
0
votes
0answers
9 views

MongoDb permissions error makes no sense, look at this screen shot

Please look this screen shot. How is this possible? What am I missing?... Edit 1: Ignore the db.posts.find vs. db.post.find typo above. I re-auth'd and tried the latter and get exact same denial. ...

15 30 50 per page