0
votes
1answer
3 views

SQL server query is slow *without* including execution plan

I have just set up fresh installation of SQL Server 2012 on a new server and I'm experiencing very strange performance problems. Long story short, for some reason not including execution plan makes my ...
0
votes
0answers
2 views

restoring huge MySQL database would location of sql file on a mount significantly slow restore (linux)

Hi I neglected to move the sql file from the mount before starting the mysql -h localhost -u root 'my_data' < /mnt/mirrorserver/huge.sql and the restore has been running all night as my mysql ...
0
votes
0answers
2 views

Linked Data graph database - best solutions for scalable RDF graph database

I am building a Semantic Web application that performs recommendations, etc etc, and I'm looking for a scalable database that can be deployed to a cloud hosting service easily (like AWS). In the past ...
0
votes
0answers
6 views

How to make a role from schema A “grantable” in schema B

There are two schemas in the same database: A and B. Schema A has a role A_ROLE. I want to be able to give grants to A_ROLE from schema B ( so that the users with A_ROLE were able to query tables from ...
0
votes
1answer
7 views

Are the contents of all control files the same?

I understand that one needs to multiplex and back up the control file. Also one can have multiple control files in the database instance parameter setting. If one of these files get corrupted or is ...
-1
votes
0answers
8 views

Oracle 12c installation error on windows 8.1 x64

The following error is getting while installing Oracle Database 12c on my local pc. I have only one user account and I logged on as administrator. I also tried Run as Administrator to the setup.exe. ...
0
votes
0answers
9 views

Drop database while query is active

I have a big innodb table on which a huge delete statement is running. I want to stop this statement since it is running too long (> 14 days now). Problem is that killing the statement will result in ...
1
vote
1answer
13 views

What does this mean - ~/.my.cnf

When I run $ mysqld --verbose --help | less I got information like Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf As per my ...
1
vote
0answers
10 views

Ternary relationship: what's the difference between having single table and having multiple tables?

Consider the following ternary relationship: Suppose that all entities have only two attributes (PK and Name). Here are the tables I derived (5 tables): Sector ------------------------- ...
0
votes
0answers
12 views

Conversion of simple ERD to Table: is the solution below any good?

Consider the following ERD: Suppose that all entities only have two attributes: a PK plus a name/number. I want to convert that ERD to tables. Is it needed 4 tables (1 for each relationship ...
1
vote
0answers
12 views

Tools and techniques for untangling monster views (nested views)

First a bit of context (venting). I'm working with a new vendor product which is really nothing more than a SQL Server database with a .NET interface. First few weeks with this client and users are ...
0
votes
0answers
11 views

High volume data aggregation

I need to aggregate incoming data and save the resulting aggregates to a table. A sample of the data is below. id,time 1967,2014-04-12 00:42:55+00 1967,2014-04-12 00:42:51+00 1972,2014-04-12 ...
0
votes
0answers
12 views

SQL Server 2008 - How to schedule a copy of view to another database?

I am a Sharepoint admin and need to copy the log data in database to another temp database for analysis. The data is stored in a view ([WSS_Logging].[dbo].[RequestUsage]). There is a column [LogTime] ...
0
votes
1answer
16 views

Select row with MAX(), or choose one if no MAX() exists

I have a MySQL InnoDB table with the following columns: id: UNSIGNED bigint(20) AUTO_INCREMENT (PRIMARY KEY) name_id: UNSIGNED bigint(20) time_stamp: decimal(26,9) event: enum('add', 'init', ...
0
votes
1answer
19 views

Please explain how this query generates a calendar table in MySQL

This page has a pretty neat way of generating a robust calendar table. I've copy-pasted it below: CREATE TABLE calendar_table ( dt DATE NOT NULL PRIMARY KEY, y SMALLINT NULL, q tinyint ...
0
votes
1answer
14 views

Require uniqueness with group by

I'm not sure how to couch this question. I have a table that has multiple columns including an id column, a foreign key column 'JobId', and a 'GxpId' column. I have a requirement that a 'JobId' can ...
0
votes
1answer
22 views

Database analysis

I have database which that store the sold products in Orders Table and another table called Transaction to set the time and the total price for the individual order ,my question is: How to combined ...
0
votes
0answers
4 views

Error generating mysqldump with flush tables read lock option

I wrote a simple bash script that generates mysqldump while locking the tables. # Generate mysqldump that will be used on client side Q1="USE test;" Q2="FLUSH TABLES WITH READ LOCK;" Q3="SYSTEM ...
1
vote
0answers
24 views

Clustered Index with nightly ETL process

We have a nightly ETL process that involves data from many different sources being flattened, and loaded into a completely denormalized table on SQL Server 2008 for reporting. The clustered index on ...
0
votes
2answers
18 views

Archiving data from logging db (high writes, no reads)

I have a logging database into with a few lookup tables and one massive event table that has 79 million rows. On busy days my code inserts over 3 million rows, so the event table would be enormous in ...
1
vote
0answers
19 views

best practice for 'staging' relation in stored procedure: use temp table, or view?

When I write stored procedures that take relation A and output relation Z, I like to create 'staging' relations along the way, so I can inspect the state of the data after each step in the programming ...
0
votes
1answer
11 views

mongodb 2.6 mongos start up failed

I'm trying to run mongodb 2.6, everything followed my 2.4 version setup steps. but when i start mongos i got the following problems and just cannot make it. 2014-04-24T03:38:31.001+0800 [mongosMain] ...
1
vote
1answer
15 views

Is there any difference between these two version of MySQL - 5.1.73-community-log Vs 5.1.73-community

I have installed MySQL 5.1.73 in Oracle LINUX 5 server. Just after RPM installation, I checked system variables and found that version is 5.1.73-community. When I copid ...
0
votes
1answer
23 views

SQL Server Audit Specification - filter DML by all but one user

I'm setting up a database audit. I'd like to capture any DML change that is issued by database user other than the service account related to the application. In short, this is to prove to our ...
2
votes
1answer
41 views

Huge MSDB database

I have a very large MSDB database and have been working on clearing this out and setting up maintenance tasks - something my predecessor should have done years ago! So far I've managed to truncate ...
2
votes
0answers
10 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
-1
votes
0answers
19 views

Report Builder 3 error

Connecting to a report server running Win 2k8 R2 with SQL 2012. The dataset is coming from a linux box running MySQL. I can create a report in Report Builder fine. All the data pulls from MySQL ...
0
votes
0answers
5 views

Connecting Access 2010 front end to Pervasive database with ODBC

We have an Access 2003 front end attached to a Pervasive database used with Sage Platinum. Access is used for reporting and its running on XP. We switched to Access 2010 on a different client machine ...
1
vote
1answer
28 views

Converting a VARCHAR to VARBINARY

I've been keeping a log of expensive running queries, along with their query plans, in a table to allow us to monitor trends in performance and identify areas that need optimising. However, it's come ...
2
votes
4answers
58 views

What are the risks of building a database outside IT control?

I've been looking for the best StackExchange community to ask this. I hope it fits well here. As a risk analyst in a trading business, I'm often confronted with large volumes of data, way beyond the ...
0
votes
0answers
3 views

ODBC connection Issue from windows 8.1 workstation

Having an issue with inconsistent connectivity to SQL from Windows 8.1 workstation. I access SQL using an ODBC connection. I connect in the beginning of the day then an hour later try to connect ...
2
votes
0answers
18 views

Does MySQL guarantee atomic upgrade from read lock to write lock?

If a client session is currently holding a read lock (to allow concurrent reads while already preventing writes), and then acquires a write lock on the same table(s), does MySQL guarantee that the ...
0
votes
0answers
11 views

Choosing a better configuration for Windows Server 2008 R2 Standard

Currently we have a dedicated server running the following configuration Intel Xeon E3-1230, 4C/8T, 3.20GHz, 8M Cache 16GB Memory, DDR3, 1333MHz 2 x 146GB, SAS, 3.5-in, 15K RPM Hard Drive (RAID 1) ...
1
vote
1answer
35 views

SQL Server Group By Very Slow unless using temp tables

I have a simple query: INSERT INTO #Values SELECT 2, MONTH(f.Datum), SUM(Quant * Price) FROM r_Fakt_Otpr_Data fd INNER JOIN r_Fakture f ON fd.FK_Faktura = f.ID_Faktura WHERE f.Type = 2 AND f.Stock = ...
0
votes
1answer
27 views

Sql statement to count sum and campare it with another table

I would like to write an sql statement in microsoft access that group items and count their sum in order to compare it to another table I have two table like below : Product: list of demanded ...
2
votes
0answers
48 views

Sql Server 2012 Enterprise Backup with no file

We currently have a database which increments 5TB a day. The current backup solution we have uses Avamar, which I believe does a kind of block comparison backup where there is no need for an actual ...
0
votes
0answers
4 views

MySQL Workbench EER Diagram and ENUM data type

I am creating EER model diagram using MySQL Workbench (version : 5.2.47) The version for MySQL, I am using is 5.5.35-0ubuntu0.13.10.2. I have created a schema with 'Default Collation' set to 'utf8 - ...
0
votes
0answers
21 views

Database structure for maintenance planning

I'm currently working on a solid way of creating a sort of planning system. In this system, I need an productgroup to be made (= category name for a list of items, like cars) with producttype as ...
0
votes
2answers
22 views

Sorting of results is slow some times but fast at other times

I have a mysql query that is joining a few tables and then uses order by field for sorting. It sometimes runs quite fast at other times it is slow. While it was slow i profiled the query to find that ...
2
votes
0answers
17 views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work ...
3
votes
1answer
31 views

App domain is marked for unload due to memory pressure

In my sql server log (2005 SP4) I have this message every couple of seconds : "AppDomain XXX [DataBase.dbo[runtime], YYY] is marked for unload due to memory pressure" Our server : Windows Server ...
0
votes
1answer
23 views

How to check if several tables exist in database, and how to show it in Mysql

I would like to check if several tables exist in a database, and return a easy to understand return, I know you can check if a single table exists by running show tables like "foo"; but is there ...
0
votes
2answers
28 views

How can I genereate a string from the returns of a SELECT query in Mysql?

I need to create a string from data that is extracted from an SQL query, and wish to accomplish it within the SQL Query. The return is something like +---------------+ | foo_ids | ...
0
votes
1answer
12 views

Mysql tar ball installation

I need to install two different versions of Mysql in one server OS RHEL6 and it will be separated by user called mysqlprod and mysqlpreprod. I need to separate their binaries, softwares,data ...
1
vote
1answer
60 views

How to Move All tables from one Database into Different Database?

I am using Oracle SQL Developer and I have ten tables. Now I want to move all 10 tables from Oracle SQL Developer into a SQL Server 2008 R2 database. Is there any easy solution for this task?
0
votes
0answers
17 views

MySql query keep running for a long time

Following query keep running for a long time and I'm using MySql 5.5.34 on XAMPP on Windows SELECT id_package, `pck`.`fk_sales_order`, `pck`.`fk_picklist`, count(pci.id_package_item) as items, ...
0
votes
1answer
24 views

Inserting empty string on Windows MySQL doesn't use default value

Why inserting '' on a column with default integer value on MYSQL/WINDOWS produces ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1 The query is: insert into test2 (id,test) ...
-3
votes
0answers
13 views

how can insert multipal data from table1 one column data can copy from another table2 from sql server [on hold]

how can insert multipal data from table1 one column data can copy from another table2 from sql server eg insert into Voterinfore(CustID) select CustID from CustomerVoterInfo --SET IDENTITY_INSERT ...
0
votes
0answers
9 views

How is the key length determine in an index?

Aside from explicitly setting the key length when creating an index, how does MySQL determine the appropriate key len shown when running "explain"? Thanks
-2
votes
0answers
26 views

Error after SQL Server upgrade [on hold]

I upgraded my SQL Server from 2008 to 2014 and I can no longer get online. All web sites say waiting on website to load. Does anyone know what happens during this upgrade that might have caused this?

15 30 50 per page