0
votes
0answers
2 views

How To Merge Database Projects on Visual Studio 2013

Can I have multiple database projects to the same SQL Server database? Like, one main project referencing multiple subprojects. I have an application which multiple modules and each modules has it's ...
0
votes
1answer
8 views

queries for hierarchical data

This table is a questions and answers CMS and i want to know how data is fetched from these tables. +------+----------+-------+ | id | parentid | type | +------+----------+-------+ | 1 | 0 ...
1
vote
1answer
13 views

SQLDriverConnect fails when attempting to connect to Failover_Partner

SQLDriverConnect fails when attempting to connect to Failover_Partner. Connection string being used: Driver={SQL Native Client};Failover_Partner=tcp:dby;Server=tcp:dbx; ...
1
vote
0answers
4 views

No results from traceid from sys.nf_trace_getinfo(0);

SELECT DISTINCT(eventid) FROM sys.fn_trace_geteventinfo(#); The above command returns no results. There should be a bunch of trace event id being traced.
0
votes
1answer
13 views

PL/SQL operating system call

I'm trying to lauch a system call from Oracle Apex, directly or indirectly. It seems to only accept PL/SQL procedures, so I iterated towards this: begin :p3_request_id := sequence.nextval; ...
0
votes
1answer
7 views

Type of an id field that references another id field

I'm on postgresql. I have a table user (id serial not null) and another table client(id) i need to create a : foreign key client(id) references user(id). What the client(id) type should be? Int or ...
9
votes
0answers
13 views

How to calculate/store Top 10 in a tabular model?

We have recently created an SSAS tabular model so our users can access it via PowerView. We have a measure on one of our fact tables to get the TotalActiveItems using a formula: ...
3
votes
2answers
26 views

Avamar SQL Agent running against live SQL Server databases

We use a large company as our service provider. The tech people from that service company are pushing very hard to install something called the Avamar SQL Agent which purportedly will be used to ...
0
votes
0answers
22 views

SQL Server Data access does not connect unless we provide the port number

I have configured SQL Server 2008 R2 named instance on Windows Server 2008 R2 to listen to only one IP,1433. Some Office 2010 clients are trying to connect using the external data to SQL Server using ...
0
votes
1answer
33 views

deleting a table referenced by many foreign keys

I have a table that I want to drop and create again, because I want to add the IDENTITY property to a column, wich is not possible directly. The problem is that I can't drop it, because my column is ...
1
vote
1answer
18 views

Adding foreign keys constraint on databases used

We have a server with about 20 databases, all duplicates of the same original db, and we just noticed the original is missing all the foreign keys constraint for some unknown reason. So of course all ...
0
votes
0answers
27 views

sql query cant group this table's data according to first column

WITH t2 AS (SELECT Tarih , [0-20000] = COUNT(CASE WHEN Yük= 20000 and Yük= 21000 and Yük= 22000 and Yük= 23000 and Yük= 24000 and Yük= 25000 and Yük= 26000 and Yük= 27000 and Yük= 28000 and Yük= ...
0
votes
2answers
37 views

Check Constraint with Case Statement

I want to add a check constraint on a column if entered value for column is greater than 3 than it should be saved as 1 else entered value. For that scenario I am using below query but on insertion of ...
0
votes
0answers
21 views

Update existing (old) rows vs delete and insert when needed

I'm building a database system that needs to store login tokens for a system that validates if a users login token is valid or outdated. The table is pretty simple UserID int Primary Key LoginToken ...
2
votes
1answer
26 views

Multiple Table Pivot

I have a few tables that need to be converted into a single new table. I'm positive (un)pivot is the solution to the problem. However, I'm uncertain what the best way is to unpivot data from ...
3
votes
0answers
60 views

Why are simple SELECTs on InnoDB 100x slower than on MyISAM?

I have quite an annoying problem. I want to use INNODB as my main database engine and give up on MyISAM as I need the former for using galera-cluster for redundancy. I copied (description follows) ...
2
votes
1answer
96 views

How to find number of days since beginning of fiscal month?

This relates to my question How to find XXth day of previous month in SQL server? The fiscal month starts on 26th of each month. I need to find out from any date: The date of the start of the ...
0
votes
0answers
46 views

Technical documentation for Replication [on hold]

My boss wants me to write a technical paper on replication, I don't know where to start or what to write about. We held a discussion and he talked about: Managed Code (we use VB.NET) Triggers ...
0
votes
2answers
57 views

Speed up a MySQL BETWEEN query

SELECT dateToFind FROM table1 INNER JOIN table2 ON dateToFind BETWEEN dateFrom AND dateTo I need to improve the performance of this kind of query. I added BTREE indexes on dateToFind, dateFrom, ...
0
votes
2answers
29 views

MySQL Replication: Seconds Behind Master super high

I've set up a slave db server for my production database, but when I checked the show slave status, I noticed a super big number in seconds behind master. This is the output: ...
0
votes
1answer
10 views

postgresql cannot drop a table when autovacuum holds lock on it

Autovacuuming process holds RowExclusiveLock and ShareUpdateExclusiveLock on the table, which I want to drop. I read that autovacuum should be canceled automatically, when submitting DROP TABLE ...
0
votes
0answers
10 views

How to model mappings at various levels

I'm trying to design the database model for my application and I'm finding it difficult to design the mappings for user access to various entities stored in the database. If access was only ...
1
vote
1answer
17 views

InnoDB deadlock with INSERT .. SELECT

I am trying to understand why a deadlock occurs when two workers in parallel are running INSERT .. SELECT queries on a table which has both 1) auto incremented primary key, 2) a unique index on ...
0
votes
0answers
8 views

What Is dummy bind in mainframe?

I am new into a mainframe project.Here after compiling when a program gets return code as 004,they do a dummy bind and it runs fine.Can someone please tell me what dummy bind is all about?
0
votes
1answer
27 views

How do I maintain high INSERT-performance on PostgreSQL

I'm working on a project which is parsing data from measurement files into a Posgres 9.3.5 database. At the core is a table (partitioned by month) which contains a row for each measurement point: ...
2
votes
3answers
185 views

Using expressions in the SELECT list to thin down a CASE statement

I have a query I'm working through rewriting - it has a huge bunch of case statements in the select list that all basically look like this: select Column1 = case when (Something = 2) and ...
1
vote
0answers
50 views

Why does my query end up with two seeks instead of one and how do I fix that?

I have these two tables: CREATE TABLE [TaskItems] ( [ItemId] UNIQUEIDENTIFIER NOT NULL, [LastOperationTime] DATETIME NULL DEFAULT GETUTCDATE(), [OwnerId] ...
0
votes
0answers
23 views

Storing DB credentials in an application source code?

I am making an app which connects to a DB, and the app will have plenty different userslogins. Is it a good design choice to have a specific DB login/password for the application, using which the ...
0
votes
0answers
5 views

How to migrate a mysql server in production to Percona XtraDB Cluster

I need some help : I have a mysql server in production and i want to migrate all the database to an existing cluster (percona xtradb). For now , my idea is : 1) Lock all tables 2) do a dump per ...
0
votes
0answers
5 views

PostgreSQL: Which connections is blocking ALTER TABLE?

I would like to add some fields to a table in all testing and production DBs, all of which are stored in PostgreSQL 9.3 on Amazon RDS. ALTER TABLE users DROP COLUMN IF EXISTS device_language; ALTER ...
0
votes
0answers
20 views

SQL query to return columns per value in value range?

I have a table like this: Date Value1 Value2 2009-12-30 23334 93 2009-12-31 21989 97 2010-01-01 18638 62 2010-01-02 ...
0
votes
0answers
21 views

Speed up sorting in this query

I'm trying to optimize the following plan and noticed that PostgreSQL spends a lot of time (relatively speaking) on sorting before the merge joins. Is there a way (using indexes, cluster the table, ...
1
vote
0answers
51 views

Outer Apply vs Left Join Performance

I am Using SQL SERVER 2008 R2 I just came across APPLY in SQL and loved how it solves query problems for so many cases, Many of the tables I was using 2 left join to get the result, I was able to ...
-2
votes
0answers
14 views

creat an Avilabilit Group SQL Server 2014

when i am gonna creat an AG the following error shown the following folder locations do not exist on the server instance that hosts secondary replica ...
0
votes
1answer
13 views

Best Mysql Settings for my server

I have The following server specification: RAM : 64GB CPU : 2 X 2.50GHz (total 8 cores) This server is only dedicated for mysql database with up to 30GB of data and to run complex queries that ...
0
votes
1answer
24 views

What's the difference between INSERT … SELECT and SELECT INTO

Let's say I have a table item and an other one versionned_item. From time to time, I want to copy data from item to versionned_item. What I did is WITH subset AS (SELECT ...) INSERT INTO ...
0
votes
2answers
9 views

SSRS Migration To a separate Network

We are building a new SSRS 2008R2 environment on a separate network. How can I migrate the reports from our current network to the new network? Can I backup the reports from the existing SSRS server ...
0
votes
1answer
25 views

Convert multiple databases into schemas MSSQL

Due to a high amount of databases being created on my project and the rising cost per databases I had the following question: Is there a way to convert multiple databases in MSSQL into one database ...
0
votes
0answers
29 views

What is the best approach to process huge amount of data insertion efficiently

I'm dealing with a HUGE amount of data entry. I need to know the best practice to insert/update table records after new entry inserted in another table. By huge i mean we get more than 2 million ...
0
votes
0answers
7 views

Users Characteristics

I'm really battling an issue where I have a Users table that has a growing number of user characteristics (regligion, smoking preferences, etc). The strategy I've used thus far has been to add a ...
0
votes
0answers
11 views

Launching an RDS in a private subnet in VPC and access it from a web application

I have setup a VPC which has two subnets. One is a public subnet (I have Internet Gateway attached to it) and the other one is a private subnet.My web application resides inside the public subnet and ...
1
vote
1answer
21 views

Unique constraint to enforce max one null per item

I am using PostgreSQL 9.3. Suppose we are manufacturing some items of certain types, at any moment we are producing at most one item of a certain type. The following table captures our history of ...
1
vote
0answers
6 views

How to restore everything (including “postgres” role) from pg_dumpall backup

I have a postgres 9.1 server running and I do backups with pg_dumpall -c -f /nfs/backup/fulldump.sql I'm testing restoring the backup to another server with psql -f /nfs/backup/fulldump.sql ...
0
votes
1answer
15 views

I cant figure out the error probably with the date field in this mysql stored procedure

This is my empDetails table I am trying to create a stored procedure on. mysql> describe empDetails; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | ...
0
votes
0answers
29 views

sql server grants access to specific login to database [on hold]

i have created website for intranet and hosted it on server. for that i needed to create login "IIS APPPOOL\hi" in sql server 2008 for my application to access my "reportdb" database. "IIS APPPOOL\hi" ...
0
votes
0answers
7 views

DBA View for Parallel Hints

Is there any DBA View to find details of parallel hint...The information i need is degree of parallelization (auto or fixed number) for all parallel hints used across all schemas in the DB.
0
votes
0answers
19 views

Schema Comparison [on hold]

DBAs, I'm in the market for a schema comparison and synchronization tool. I've personally never purchased one and have started looking at the various tools. I'd like to know if anyone has a suite ...
0
votes
0answers
35 views

Double subquery is very slow, but independently they are fine

I have this query: SELECT mac, pid, node_category.name, status, computername, user_agent, detect_date, regdate, unregdate, last_dhcp, node.notes, (SELECT ip FROM iplog WHERE iplog.mac = node.mac ...
1
vote
1answer
21 views

Changing compatibility level of database causes performance improvement of stored procedure

We have a Web Application in a Windows Server 2012 Datacenter (IIS 8), running under .NET Framework 4.0, which connects to another Windows Server 2012 Datacenter with SQL Server 2012. My Database has ...
0
votes
0answers
3 views

DB2 LUW 9.5 ignoring indexes

OK, Stack Exchange - got another good one for ya'. I am seeing something in DB2 that I’ve never seen before. DB2_VERSION: 09.05.5 AIX VERSION: 7.1.0.0 I’ve got a query that is properly indexed. In ...

15 30 50 per page