An acronym for "Structured Query Language" (it's not the name of a specific DBMS product), SQL can be used in relational database management systems (RDBMS) to query, update, delete, and insert data as well as modify the structure of the database. It can also be used to manage schemas and data ...

learn more… | top users | synonyms (1)

0
votes
0answers
37 views

Errors in the metadata manager. The process type specified for the Effect dimension is not valid since it is not processed

Trying to hunt down an issue with an SSIS package we have and I don't know what to look for to help correct this issue. Error: Errors in the metadata manager. The process type specified for the ...
0
votes
0answers
16 views

Get tp.address_from and tp.address_to from travel_point table

I'm building a view for get tp.address_from and tp.address_to but I can't get this works. This is the query I'm working on: SELECT `tp`.`address_from` AS `address_from`, `tp`.`address_to` AS ...
0
votes
0answers
13 views

A better database model for level of product-information in service and maintenance environment

This is a tough question and rewriting it now for a couple of times. I have a question about a good, more solid way to design my database model about service and maintenance. My main problem are the ...
0
votes
0answers
25 views

SQL Server very slow response

Sql server 2012 is very slow in response to any query from the application. Even using SSMS to try connect often results in time-outs. The log files were recently moved to their own drive as they were ...
0
votes
0answers
31 views

counting values of unread values using mysql and php

I am building a messaging system using mysql and php. I have gotten to a point where I want to select messages received by a user and also count the unread messages received from different users to ...
0
votes
0answers
27 views

how to check the condition before running the sequence container in ssis2005

I need to split the DB into Current(2012,2013,2014) and History(previous to 2012). Every year I need the oldest year should move to history DB i.e if 2015 enters then 2012 should move to history. ...
0
votes
0answers
39 views

Retrieve SPID For SSRS Request

Is it possible to determine what SPID was created to execute a SSRS report? I am trying to prevent users from running the same report multiple times. So what I was thinking of doing was retrieve the ...
0
votes
0answers
27 views

set error message on out variable in mysql stored procedure

I have a stored procedure: fill_DATA (serial varchar(20), OUT oError) I am doing an Insert operation here. so what I want is to SET value of oError for any error message in case the query fails to ...
0
votes
0answers
29 views

Starting up postgres on Ubuntu for the first time

I've installed postgres on ubuntu, created a node and now I'm trying to start up that node as per the instructions: postgres --coordinator -D /usr/local/pgsql/data -p 1281 But I get the following ...
0
votes
0answers
23 views

Multiple client tables or large overall table

I've recently taken over a project linking to a large MySQL DB that was originally designed many years ago and need some help. Currently the DB has 5 tables per client that store their users ...
0
votes
0answers
11 views

SQL-Count actions which are performed every 10 minutes

I have a table which shows the time when a user connects to the database.I want to count the number of Loggins which are performed every 10 minutes. for example here is some columns of my table user ...
0
votes
0answers
108 views

Error Code: 1133. Can't find any matching row in the user table

Im reading O'Relly "Learning MySQL" and it says that you can create a user in MySQL by doing just this: mysql> GRANT ALL ON *.* TO 'jill'@'%.invyhome.com' IDENTIFIED BY 'the_password'; Query OK, 0 ...
0
votes
0answers
44 views

Auto backup only for MySql database and selected folders in WHM or via cron job command

Hell all i have a VPS, WHM provide use auto backup feature. but i want only backup some selected database and folder. i try to use command via cron job but its not working. current code (not ...
0
votes
0answers
31 views

Oracle right outer join SELECT statement with a table

I am trying to find out the tables that are in MONITORING.USAGE_TRACKING table in first place, along with the other tables that need to be analyzed. SELECT A.JOB_NAME, A.START_DATE from ...
0
votes
0answers
18 views

Hide message to who deleted the message

Please I am building a messaging system,below are my tables. table --users |u_id | Name | | 01 | Aku | | 02 | Sika | | 03 | Admin| table --messages ...
0
votes
0answers
22 views

Select changes in table by date

I have following table schema name type id int key string count int date date url_id id with example data id key count date url_id 1 system 100 ...
0
votes
0answers
45 views

How to improve performance joining tables with no primary keys

Given two large tables of ~8,000,000 rows each. They are being joined on substrings of name address zipcode Naturally, the query is taking a long time. What are the best methods to improve it
0
votes
0answers
20 views

Installing database

I have created database in my system using mysql.I tried to use in one of my friend's system.How can install the database in other system?
0
votes
0answers
93 views

eCommerce product table design - MySQL

I am designing database for an web application, I have designed the product and specification details database as follows, create table pr_size ( size_id int not null auto_increment, ...
0
votes
0answers
17 views

Redesign tables, multiple foreign key and related table to same table

Hello I have this database: Table Teams is used in each one table. Match table contains teamA and teamB and round contains team that win the SET and team that start the set. But I dont know how I ...
0
votes
0answers
14 views

Reporting Services Scripter ScheduleID Error

I'm currently in a SQL Server 2005 environment that's being upgraded to 2012. I need a tool to script out all of my SSRS subscriptions, and I chose to use RSScripter. I'm having an issue whenever I ...
0
votes
0answers
27 views

Avoid using SOQL/DML query statements in trigger

SELECT field1 FROM sObject WHERE field = 'Myconst' LIMIT 50000; I need to replace this field = 'const' by storing this const in a variable which suppose is: String constVar = 'Myconst'; SELECT ...
0
votes
0answers
45 views

msdb 'backupset' log history

One of our production server‘s backup job is getting failed for one DB because of Low disk space when I looked into ‘physical_device_name’ column in ‘msdb.dbo.backupset’ to get the path of backups I ...
0
votes
0answers
18 views

Checking for records in lookup table before deleting

In my MySQL database, I have products table, a locations table and a lookup table (called location_products) where the ID of the product and ID of the location are stored. I am creating a transaction ...
0
votes
0answers
24 views

Would an INNER JOIN query in a sharded relational database hit the same shard when using a compound primary key?

In this question I have asked about modulus calculation in sharded tables, this design is used: CREATE TABLE Orders (order_id INT PRIMARY KEY, ...); CREATE TABLE LineItems (order_id INT, lineitem_id ...
0
votes
0answers
17 views

Modulus calculation for compound primary keys in MySQL Cluster (and other sharded databases)

In MySQL Cluster, and generally in sharded databases, how is a compound primary key's modulus calculated? Say, for example, there are two tables that have primary keys like so: CREATE TABLE Orders ...
0
votes
0answers
23 views

Indexed column INSERT vs. UPDATE

I have an indexed column. I could give it a value on INSERT. But it would be easier if I would add this value via UPDATE later (I have to update this row anyway). But I was thinking if it would be ...
0
votes
0answers
33 views

Low performance oci_execute

I work with a PHP application that connects to an Oracle database. Sometimes, the PHP executes a large query from a large database the page loads for ages (more than 200s). But I've seen something ...
0
votes
0answers
12 views

Datastructure to save relations between more than two entities and lists

I am trying to building an Information Extraction system(IE). I wrote a program that will detect entities and extract relations between them. Now I am saving the relations in the following SQLITE ...
0
votes
0answers
89 views

How to deploy a build from Visual Studio online to local SQL Server?

We are developing our SQL Server 2008 R2 database via Visual Studio 2012 as a database project which uses Visual Studio Online as its source control system. We would like to pull the latest build via ...
0
votes
0answers
35 views

Error on job - need to troubleshoot

Need Suggestions: One of our Production Servers contains a job (Daily run) which gets the Data from another Server and dump into local DB. From last couple of days, it is failing with the reason ...
0
votes
0answers
32 views

Cohort analisis for gamers activity

I want to do some cohort analysis of gamer activity in my games. By cohort I mean some set of users who registered (or had first activity) on some particular date. For example: users registered on 16 ...
0
votes
0answers
25 views

how to clean huge Dbwarden QueryHistory table

dbwarden is Comprehensive database monitoring solution for SQL Server 2005+ which i am using. i found that dba_LongRunningQueries – Runs every 5 minutes. This will run usp_LongRunningQueries to ...
0
votes
0answers
50 views

What would be the most efficient way to store a text messaging (SMS) database

I'm creating a database to store incoming and outgoing text messages for a program that will be responding to text messages. The app has multiple potential responses depending on the message it ...
0
votes
0answers
34 views

Microsoft Access Query: “System resource exceeded”

I have a simple query in my DB and I received this error message: "System resource exceeded". But the query is really simple! Here it is: PARAMETERS [@FILTRO] Text ( 255 ); SELECT [POLIZZE ...
0
votes
0answers
104 views

Using a `mysql_query` to insert category values

Ok I'm importing direct from a csv to MySQL, using a mysql_query to insert values. How do you insert category terms into the Wordpress database structure assigning them to a post. Below are two import ...
0
votes
0answers
13 views

Users_With_Messages Table normal form

I have the following tables in my database: Above these tables (not pictured) is a Users table where the SendingUserId and ReceivingUserId are keyed onto (they are foreign keys). Are these tables ...
0
votes
0answers
32 views

IBM data studio 4 - how to open a new sql script editor?

I have to use IBM Data studio 4 and for the life of me I cannot figure how to open another SQL script editor window. Luckily it opens with one, but then I am constrained to that single window. I ...
0
votes
0answers
12 views

Securing database from intruder DUMP

What would be the best way to secure a MYSQL database that contains customer information from being dumped by say a injected SQL or Remote file inclusion? Can the DUMP function be turned off globally ...
0
votes
0answers
54 views

Finding duplicate data

I have noticed dup’s generated in my mail system. some service was causing duplicate calls to my insert proc and generated multiple duplicate messages with about a 4 mili-second difference in a date ...
0
votes
0answers
15 views

Organizing trending posts

I have a page where a user can see the most trending posts under a hashtag name (e.g. #soccer). My question is, how should I be organizing the most trending posts? Should I create a cron job that ...
0
votes
0answers
54 views

Match unique id's on import- csv to sql

I have a csv file that I would like to import into a phpMyAdmin database (Wordpress). The CSV file is formatted as shown below: list-id | post_title | slider | ...
0
votes
0answers
20 views

How to create a good membership database for OpenID

I would like to know if it exist patterns, samples or good practices for creating a good membership database compatible with OpenID or connection with facebook, Google, Yahoo, Windows, ...
0
votes
0answers
32 views

Return multiple results from one table in one row

I have a table of time sampled data as follows: Meter Number|Sample Date|Meter Reading 1 30/04/2014 123 1 22/05/2014 456 1 29/06/2014 789 2 ...
0
votes
0answers
35 views

Need to implement some logic in DB2

I need to implement the below logic in DB2. Please help how to do so as I am new to DB. LOGIC: 1.Find the last year using LastYear = Current Year - 2 years 2.Check if LastYear equals value in ...
0
votes
0answers
22 views

How to select full text in the blob type?

There's some large text segments stored in database table BLOB column, and when I query that column against database , usually only part of that large texts get displayed. I am not sure whether this ...
0
votes
0answers
101 views

Suppressing the removal of trailing zeros in numeric data type in sql server

I initially declared the data type of the columns for some of the tables i am working on as "NUMERIC". cause of that, trailing zeros are being removed. Is there anyway to suppress this behavior? i ...
0
votes
0answers
58 views

How to find the estimated time for ORACLE SQL Query

Help to find out the following I have 8 million rows in an Oracle table, and this is being queried by a BI tool every day and taking more time. Is there any like explain plan that will give me a ...
0
votes
0answers
49 views

dynamic sql: merge partitioned tables (annual tables into a single table of all years)

I need to merge (UNION) data from annual tables into one large table. I am confused about how dynamic SQL (or else) should be used for this. Below is an updated version of my question on ...
0
votes
0answers
62 views

Installing SQL Server 2012 failed setup administrator

Can anyone tell me why this keeps failing? I am logged in as "Administrator" on Windows Server 2008 r2 I added Administrator to the "Backup ... " Group And I checked to make sure everything is as it ...