0
votes
0answers
5 views

MySQL - Pivot-style (row -> column) results in subquery

SELECT j.departure, stopDepartures.* FROM journey j JOIN journey_day ON journey_day.journey = j.id JOIN service ON service.id = j.service JOIN pattern ON j.pattern = pattern.id JOIN ( SELECT ...
1
vote
2answers
13 views

Unexpected result from query based on old column value

I need to update a column and based on the old value, update a second column. After googling I came up with THIS (*nr 4) solution: copy the table to have the old value at hand. The table looks like ...
0
votes
0answers
4 views

Deploy Database to Windows Azure SQL Database show error in exporting database

When i try to deploy database to azure or export data tire application its successfully creating schema but it show error in exporting database
0
votes
0answers
10 views

increasing Mysql DB Size and Server Size

I have installed xampp on my windows machine, i'm using MySQL, How to increase the size of mysql server and databases in it? Kindly help me..! Thanks in advance...!!!?
0
votes
0answers
9 views

Password of the oracle user in oracle linux?

I am trying to install oracle 12c on my virtualbox oracle linux 6.5. I ran the command oracle-rdbms-server-12cR1-preinstall , which created a user oracle . But I can't seem to login to the user cause ...
0
votes
0answers
5 views

Apply settings to multiple output columns in SSIS flat file source

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to ...
-1
votes
2answers
18 views

how to resolve Stored procedure out parameter error?

Stored procedure displays the following error. Procedure or function 'getFavoriteList' expects parameter '@category_name', which was not supplied. I have code SET ANSI_NULLS ON GO SET ...
0
votes
0answers
10 views

MySQL keeps getting “connect” commands 100X per minute!

My server was having performance issues, things loading slow, pages not loading, etc so I ran the "top" command after logging in via SSH. I noticed the CPU kept jolting up to 40%, on and off, when ...
0
votes
0answers
12 views

i want to create a timewise monthly report parking vehicle

i am working in parking company. we need a data of timewise monthly vehicle out report. i write a query look like:- select hour(datetimeout) as 'dateout',count(*) from to_leaveveh where ...
0
votes
0answers
11 views

How to load data from MySql to MS SQL Server database?

I have the similar schema in both MySQL and MSSQL Server database. How can I migrate data from MySql to an empty (no data) MSSqlServer database? MSSqlServer DB is empty with just the schema. I could ...
0
votes
0answers
17 views

composite index vs normal index

I need to index some tables and for that i found that there are different kinds of indexing. I am kind of clueless on their proper place of usage. Should i create index on all the fields that want ...
0
votes
0answers
5 views

How can I load csv data into mongodb and choose the types I'd like to have created for each column?

I'm looking for a way to load csv data in mongodb and specify the types that I'd like to have created for each column? I've been using mongoimport but I find it quite painful because there doesn't ...
2
votes
0answers
17 views

SQL cluster resource won't come online unless its on port 1433

The 2-node 2k8r2 cluster works fine until one of the resources got removed. I successfully added it back. However, the cluster is not able to online the SQL Service unless it is on 1433 and not the ...
-1
votes
1answer
22 views

How do I select data with a case statement and group by?

I'm trying to manipulate data a little by using a case statement but can't seem to figure it out. Stops -------------------- 1Stop 1-Stop 1 stop 1 Stop 1stop 1 Stop 2-Stop Im trying to come up ...
0
votes
2answers
49 views

Tsql Query speed slow due to Or within where clause, causing index scan instead of seek

I have been working on making this query work more efficiently. I found that the number of Ors within the where clause are the biggest problem within this query. This query sits in a stored ...
0
votes
1answer
19 views

Can you store PHP code in mysql database?

I'm creating a codex that will store example of functions and examples on how to use functions. Can I store this information in a database? Also, is there a proper way of displaying code on a page?
0
votes
1answer
16 views

dm_exec_query_stats in PostgreSQL

I recently started using PostgreSQL after using SQL Server for a while. Is there something like dm_exec_query_stats? I haven't been able to find anything other than logging every long running query. ...
0
votes
1answer
10 views

Update a date_modified MySQL Record Field ONLY when other fields have changed using CASE statement not working?

I have asked my question on Stackoverflow but have not really gotten any answers so I am trying over here now. I have the MySQL query that is ran in a PHP script below. What it does is Inserts a new ...
1
vote
1answer
19 views

convert string allow null col to int?

I want to convert string to int my string type [DT_WSTR] and my expression ISNULL(col) || TRIM(col) == "" ? (DT_I4)0 : (DT_I4)col I get this error [Derived Column [518]] Error: The conditional ...
0
votes
2answers
27 views

Change SQL Server backup destination while retaining server's knowledge of location

I currently have a number of SQL Server (2008 R2) databases that are receiving tlog and differential backups. The backups are currently being stored on a NAS that is going to be repurposed. I need to ...
0
votes
0answers
11 views

Best upgrade path for MySql 4.1 to 5.5?

Background Our production environment runs on a system that nobody wanted to update for a long period of time. With a new sherrif in town, we're going to update it. Production is MySql 4.1 with ...
0
votes
2answers
17 views

MySQL Count Rows with Two Cells the same

I have a db where the cells are height and width. (It's for banner ads) Some banners are the same width, but different height, or visa versa. for example: row1 hieght = 600 width = 120 row2 hieght = ...
1
vote
1answer
9 views

postgres: Database replica with some schemas writable

I have two computers. Computer A is dedicated to collecting data and storing it in its local database. Computer B is for analysis. A is running flat out just with the data collection, so I want to ...
0
votes
0answers
7 views

Couchbase - Get document creation date

Is there a way we can get a document's creation date in Couchbase (2.2.0). We are currently not storing creation date in our documents, so wanted to know if couch stores that as part of document ...
0
votes
1answer
28 views

How to add a linked server to a sql server management studio?

I have an account in sql server management studio, which I can login to database B, which is on server X. I also have a crystal report on my local PC. Using the crystal report, I can access a ...
0
votes
0answers
15 views

How to find non utf8 data in mysql

Ok so I have a mysql database containing data that is input from various customers. The customers are told that their data should only be encoded as utf8 however I have become aware that this is ...
2
votes
1answer
16 views

How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?

Let me state up front that I'm not proficient in Oracle at all, MS SQL yes but not Oracle; which is why I'm asking this. Current Setup Oracle 10g Release 1 running on Red Hat Ent. 3 (no support) ...
0
votes
2answers
17 views

no pg_hba.conf entry for host “10.1.1.91”, user “user” database “testing”, SSL off

I've come across different versions of this same issue on stackoverflow and on this forum. I've tried the recommendations posted on these forums but I am still unable to connect to a database. I've ...
0
votes
0answers
9 views

Inserting into a table and getting the column names from a collection in PL/SQL

I want to copy data from one table to another and would like to have a rather dynamic insert statement. I have the column names I want to insert into in a collection col_names and was wondering if ...
2
votes
2answers
153 views

Foreign key without referenced columns specification

I noticed in the SQL Server documentation that the list of referenced columns is not a required parameter of a foreign key constraint: <column_constraint> ::= [ CONSTRAINT constraint_name ...
1
vote
2answers
93 views

Backup without using SQL Server Management Studio

I am trying to take a backup on a Windows Server 2003 and SQL Server 2005 installed on it. But, there is no SQL Server Management Studio on it. How can I take full backup of a particular database.
0
votes
0answers
4 views

DSN connection and RODBC on windows 8

I wish to run queries on a PostgreSQL database in R using the RODBC package. Before I had windows 7 and it was working but now trying to make it work on windows 8 I have not yet succeeded to find ...
0
votes
3answers
41 views

Copy data from SQL Server 2000 to SQL Server 2014 Express

I need to copy only data (not tables) from a SQL Server 2000 database to a SQL 2014 Express database. I tried to do this using DTS but it loses keys and indices. Backup (2000) and restore (to 2014) ...
1
vote
0answers
23 views

Adding custom meta data to a table in oracle

I'd like to know if there's a possibility to add some custom metadata to a oracle database table. The problem at hand is the following: I'm importing a table from another DB. It might happen that I ...
2
votes
1answer
35 views

How to resolve logon trigger and EXCEPTION_ACCESS_VIOLATION?

My production sql server is running... Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Sep 18 2014 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows ...
0
votes
0answers
11 views

Automatic slave reconfiguration after updating master

I have development mysql master and slave servers and a prod server. I need to set up regular (once a week) syncronization of dev and prod databases. It would be easy for me to use prod# mysqldump > ...
2
votes
1answer
35 views

Is tlog backup on replica clearing VLFs on the primary?

Is it true that a transaction log backup made on the secondary database is clearing the inactive VLFs on the tlog file on the primary database (in case of Availability Groups)? I was not able to find ...
0
votes
0answers
14 views

Is it possible to run a trigger on Table Creation in MySQL

Simple Question. Is it possible to create a Trigger that runs everytime a Table is created. The goal is to create a metadata table for each table, but I can worry about dynamically passing the table ...
2
votes
2answers
35 views

Fetch all words from column with like

I have a column with description and inside it can contain # value . what I want is all the words searched from that column with #tag This is my query SELECT description FROM photo where ...
0
votes
0answers
19 views

Can I store “personal data” in a Google Sheet and comply with UK Data Protection Act 1998? [on hold]

Context: I am working with an education non-profit. Based on my research I think it would be very beneficial for them to migrating their data and systems to the Google App Suite for a host of reasons. ...
-1
votes
1answer
16 views

how to identify why lookup failed in SSIS

i have created an ETL package and having a lookup to match userid in db. i checked in dataviewer what data is going as input to my lookup. the data is correct and the table i used in lookup to match ...
1
vote
1answer
15 views

Connection refused when adding ApplicationIntent

Environment : AlwaysOn HA group, 2 nodes, 1 database, SQL2012, Server2012R2. Here is my .NET C# code : string connectionString = ...
0
votes
0answers
21 views

Performance degradation after partioning tables using DBMS_REDEFINITION package

We have created partitions on per-existing tables in my application using DBMS_REDEFINITION package. just for the sake of improving performance. Now , We are facing an issue in the performance ...
1
vote
2answers
81 views

Is SQL Server Thread Safe?

If I need to update same row with two concurrent thread then is it possible in SQL Server? Suppose I have one table that contains Id and Name columns and now I want to update the third number Id with ...
1
vote
0answers
40 views

DB Design: Looking for Performance improvement with a Column used in all SQL Queries

I recently got added to a new ASP .NET Project(A web application) .There were recent performance issues with the application, and I am in a team with their current task to Optimize some slow running ...
4
votes
1answer
62 views

Find reason long running stored proc SQL Server

I have a stored proc which is called every 2.5 seconds by a program, 24-7. This proc normally runs under the 10 milliseconds. A few times a day (3 -5 times) it takes around 42953 milliseconds to run ...
0
votes
1answer
18 views

Encrypted Connection on Sql Server

I want to make SQL server connection encrypted. Well I know for that we need some certificate and all and it is not like that I am asking without trying any thing, but the fact it whatever I try it is ...
1
vote
3answers
54 views

How to force SQL Serve *not* to maintain a log file

I have a situation that I need some advice to overcome. I have a SQL Server 2012 database that has been set to Simple recovery model. At times, my SQL Server transaction log file grows out of ...
0
votes
0answers
10 views

Need help on renaming clusters and tables within a cluster - Oracle

clusters is something totally new to me (my knowledge is limited to knowing the technical definition of a cluster!) I need to import additional data into my DB, and that data is also cluster based. ...
1
vote
0answers
4 views

MySQL Server 5.6 wont start on Windows

I'm having an issue getting MySQL Server 5.6 (community edition) running. it was working just fine until I restarted my server. Now it wont start at all. after doing a bit of research, I discovered ...

15 30 50 per page