1
vote
1answer
309 views

Design DB for users with different information fields?

Let's say I want to register all faculty of a university and they are in different fields and have different resume information. Here we have some common fields and some field specific fields. for ...
0
votes
0answers
85 views

MySQL: Optimizing for large but discrete data sets

In brief: I'm developing a database that handles GTFS datasets from multiple transit agencies. Each dataset contains millions of rows in the stop_times.txt file (and thus its corresponding table). ...
0
votes
1answer
72 views

Cannot create stored procedure

I have the following piece of statement entered into MySQL5.6 Command Line Client. However, the following error was received. I haven't even been able to add in END// Delimiter; after the select ...
0
votes
3answers
934 views

“sqlplus as sysdba” startup error

My setup: Oracle 11g 32G RAM 8 CUP threads Three oracle instances have been running. But running this: sqlplus "/as sysdba" gives me a prompt: Connected to an idle instance. When I issue ...
0
votes
1answer
339 views

Help with a PIVOT

I have a view that gives data which looks like this: Rank | Score -------------------------- 1 | 1 2 | 2.5 ...
0
votes
1answer
2k views

How to show NULL results from query?

i'm trying to create a procedure with filters for search. If the parameter is "NULL" the value of parameter will be column value; Here my problem: When my parameter and column value is NULL. I have ...
1
vote
2answers
234 views

How can I create an ad-hoc domain user on SQL Server

Okay, so here's the problem. I have an application I need to install and run locally for testing and debugging. The application has been designed to run on a domain and as such expects to log into the ...
-1
votes
1answer
80 views

COUNT WITH JOIN [closed]

I've the following tables: fss_post(post_id,text) fss_comment(idComment, post_id, text) Is possible to write a query that give me as result a row for each post_id with total comment count for ...
0
votes
1answer
579 views

Getting MySQL User Variable in Sequence, While Using ORDER BY RAND()

I am running a SELECT statement, which ultimately will be in an INSERT..SELECT statement. I want a result like this ID COUNTER 3 1 7 2 1 3 20 4 12 ...
0
votes
3answers
1k views

Trigger needs dbms_alert declared

A trigger has given me the following: ORA-04098: trigger 'adminuser.DB_ERROR_CHANGE_TRIG' is invalid and failed re-validation and this is when working on altering schemas/triggers/etc from an ...
2
votes
2answers
283 views

Best Practices for Testing Application Dashboard Data

We have a dashboard that contains metrics based on a 6 month reporting period. Users log in and see their metrics based on the current 6-month reporting period. Every 6 months, we load new metrics ...
1
vote
1answer
395 views

MySQL Query Optimization - Indexes & Joins 12 million+ records

I'm running the following query: SELECT `track_title`.`title`, `track`.`id`, `artist`.`name` artist, `album`.`title` album, `st_tag`.`tag`, `track`.`year` FROM `track` ...
0
votes
1answer
182 views

Are de-normalised tables preferred in any aspect of a project? [closed]

While going through interview , My Interviewer asked me a question about Denormalization of tables and its usage in applications. On guess, I answered, Yes it might be. Being denormalized , you have ...
2
votes
0answers
736 views

Understanding how sys.dm_exec_requests represents queries being rolled back

I'm not sure whether this was an actual problem or just a normal situation where I needed to wait for rollback to finish. In either case, some insight would be appreciated. Background details I ...
3
votes
1answer
310 views

What is Required to use Oracle Performance Manager to monitor SQL Server?

I am working with a customer who has several SQL Server and Oracle DBMS server instances. My customer would like to setup up performance data collection, monitoring and alerting for all of their ...
1
vote
1answer
3k views

Override/kill when Code 3/SQLSTATE=57016 Occurs

I have encountered issues a few times when a process of mine performs a bulk load to a temp table we use for pre-processing purposes. The Bulk load fails for one reason or another (this we are looking ...
1
vote
0answers
256 views

SQL Server 2008 100% CPU lock/hang [closed]

Our application is a SAAS web application and uses Microsoft ASP.NET MVC application with LINQ to SQL and SQL Server 2008. It is hosted on Amazon’s cloud services (EC2). The SQL Server and IIS are ...
1
vote
0answers
175 views

Mysql replication trouble with event_scheduler

I'm running replication Master-Slave in MySQL 5.5. One day, my replication is broken. The show slave status given me 1032 error: Last_SQL_Error: Could not execute Update_rows event on table ...
0
votes
1answer
374 views

use function arguments or variable in postgres function

I want to set the default value for the column building and floor in my table points in the below function called test(b,f) Create or replace function test(b text, f text) returns void as $$ Begin ...
0
votes
2answers
105 views

synchronizing local and server database

I am developing a billing system software. For this I have created a database it contains many tables database and this is in local system all transactions data will be stored in local systems ...
0
votes
2answers
272 views

Converting MySQL 5.6.10 - 32 bit to 64 bit version

I am currently using MySQL DB Version 5.6.10 for 32 bit running in 64 bit Window OS.I want to change it to 64 bit without taking any dump..Can anyone help in this?
0
votes
1answer
5k views

Declare variable mysql

I am new to mysql, I have been using SQL in the past. I am trying to insert rows into a table via creating a loop. But struggling with it. Any help? DECLARE @minid INT = (SELECT MIN(Product_ID) FROM ...
2
votes
0answers
62 views

Syntax for restoring SQL Server backup from non-disk source [duplicate]

I have backed up and restored many a SQL Server database using T-SQL script, but always FROM DISK or TO DISK. I am not a provisioning-concerned database administrator, though, so don't have as much ...
1
vote
1answer
3k views

Db2 Express doesn't start TCP/IP listener (SQL5043N)

At home, I've installed DB2 Express on my Win7 notebook, as a part of the IBM WebSphere installation. At first it was working, but then I restarted Windows and moved to the office, and since then I am ...
0
votes
3answers
462 views

The column order of composite clustered primary key on a partitioned table? [closed]

I have the following table. create table T (K1 date, K2 int, ....) on partitionScheme(K1) The table will be partitioned by K1 (K1 has low selective. the data will be appended in the order by K1). ...
0
votes
3answers
11k views

Can't backup a Postgres database: FATAL: Peer authentication failed for user “postgres”

I can connect to my database no problem remotely, either from PHP scripts on our webserver or using PGAdmin3. Unfortunately, when I try to run pg_dump backups locally on the server itself, I get: ...
2
votes
2answers
9k views

Should I join datetime to a date using cast or range?

This question is a take-off from the excellent one posed here: Cast to date is sargable but is it a good idea? In my case, I am not concerned with the WHERE clause but in joining to an events table ...
4
votes
3answers
844 views

Inserting two rows from single row

I have to import users from the usersToImport table into the userContact table. usersToImport contains telephone and e-mail information in a single row for each user, but userContact stores one kind ...
0
votes
0answers
864 views

PostgreSQL Cascade Delete not working

What am I missing here? I have two tables: CREATE TABLE source ( "sourceid" serial, "state" character varying(255) REFERENCES states (state), "leadtime" character varying(255), CONSTRAINT ...
1
vote
1answer
582 views

SSIS Package Execution From Visual Studio Unit Test

Hello I am attempting to run a test which contains the following code: string pkgLocation; Package pkg; Application app; DTSExecResult pkgResults; ...
1
vote
0answers
503 views

What is the best process for merging packages to use SSIS package configurations?

I have several packages with hard coded connection managers which I would like to merge into one package. Each individual package is currently loading a single data file to a single table is a single ...
1
vote
0answers
215 views

Multi Server Query generating Login failures

My problem is that when using multi server queries using SSMS from SQL Server 2008 R2 against SQL Server 2008 R2, 2005 and 2000 I occasionally get error messages such as: SQL Server 2008R2 Login ...
1
vote
0answers
287 views

SQL server taking too much time in opening properties in SSMS

I am using sql server express 2008 r2 SP2 from about 2 years. Now a days when i try to check properties of database using sql server management studio it takes too much time(25 to 30 seconds) to open ...
1
vote
3answers
392 views

Aggregating data - Getting data inserted after last time query was run

On a SQL Server 2008 R2 DB, I'm running an aggregation query every hour or so, on data that's being constantly inserted into a table, and what I'd like to do is pull all the "new" records that were ...
1
vote
2answers
1k views

Why does OBJECT_ID return NULL in a computed column?

I'm trying to produce a usage report for some stored procedures in my database. The view view sys.dm_exec_procedure_stats contains some of what I need, so I decided to start here. SQL Server keys ...
4
votes
1answer
2k views

Using AD groups vs roles in SQL Server

What is best practice for sql server security? Using AD groups that are given rights on schema objects or should I add the AD groups to a database role which is given rights on schema objects ? If the ...
0
votes
1answer
387 views

Can this query be optimized further?

I have 100K records in my Documents table. This is my query which gives a page of 50 records in roughly 750 ms. I would like to further bring it down if possible. I am using Row_Number function to ...
1
vote
2answers
922 views

Returning Right of a string with no specific known length

I want to return the data from a column from the right. This would mean using the RIGHT() function, however this means entering a length of what to return. For example, I have the following data: ...
1
vote
2answers
103 views

A Separate Oracle Database at work

I recently started working at a company (Junior Web Developer) and so far loving it. The company's all and only database is one giant Oracle database that takes care of all their data persistence ...
1
vote
2answers
2k views

SqlAnywhere 12- service started but stopped

I've been running my *db file on window 7 platform, but recently i have encountered a problem where i try to revoke the SqlAnywhere server but i received this error ::The Sql Anywhere- myserv service ...
6
votes
1answer
1k views

Extremely Slow StatMan query issue with #SP2010 farm

The issue I’m experiencing is explained in a blog-post I created for this, (easy to refer to and to manage the responses / solutions in 1 location) which can be found here: ...
1
vote
3answers
5k views

Duplicating database on the same server without data loss

I want to duplicate an innodb database on my mysql server for testing another version of the software. Using tools for example phpmyadmin reduce the database around 20 MB and a "lot" of rows are ...
-1
votes
1answer
418 views

Should I create a table separately for each employee or one table for all? [duplicate]

I'm trying to figure out how to set up the Database structure. There are ~10000 employees.There will be a table to store the basic details of the employee, and another table for storing transactions ...
4
votes
1answer
202 views

Disk usage spikes: good, bad or indifferent?

I'm working on a project where we're receiving data from multiple sources, that needs to be saved into various tables in our database. Fast. I've played with various methods, and the fastest I've ...
0
votes
0answers
209 views

Error creating spatial index sqlserver

I am creating spatial index on sqlserver table. CREATE SPATIAL INDEX [SIndex_udt_cell_SP_GEOMETRY] ON [udt_cell] ( [SP_GEOMETRY] )USING GEOMETRY_GRID WITH ( BOUNDING_BOX =(80.0713, 26.389581, ...
0
votes
1answer
1k views

SQL Server Transactional Replication over Internet

I have 2 instances with SQL Server 2008R2 and i would like to build Transactional replication between those server, one is in the Local Network (Local_Instance) and the second server is over Internet ...
4
votes
0answers
209 views

ENABLE_BROKER vs NORECOVERY

I have two nodes with MSSQL2012 which work with AlwaysOn High Availability After some crash I had to remove db from availability group on the one of the nodes. For restoration I've made backup ...
6
votes
1answer
624 views

calculate days and equally distribute remaining

I'm having difficulty with calculating remaining days from hours being distributed over a date range within a given time period. For this example, the time period would be 2013-11-01 through ...
1
vote
1answer
3k views

The specified @job_id does not exist

After deleting a SQL Server Agent job I continue to get notifications that the job attempted to run and failed. I am receiving the following error message. [000] Unable to retrieve steps for job ...
0
votes
1answer
4k views

mysql is locked; can't kill query

I have a mediawiki running on my local machine and just started running mysqldump last night: $ mysqldump -h localhost -u wikiuser --default-character-set=UTF8 wikidb --add-locks ...

15 30 50 per page