0
votes
2answers
171 views

Transfer data from database1 to database2 using task queue

We have a SQL Server legacy database, db1, to put data of Project1. With change of certain tables(insert/update) in db1, we need to transfer the changes in another postgres database, db2 (used by ...
4
votes
4answers
301 views

Recommendation for free event monitoring software

I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough. There are some interesting suggestions in this ...
1
vote
2answers
1k views

Using SQL Profiler on SSIS package

Is it possible to use SQL Server Profiler to trace a running SSIS package? I tried to do that, but all I can see in the trace is executing dp_sqlagent_... and the other internal commands! None of the ...
2
votes
1answer
433 views

query generate the information one column in two columns in one query

I have a question related with a query in sql. I have the next table: id name 1 name1 2 country1 3 name2 4 country2 I need to call the results so: ...
6
votes
1answer
2k views

OPTION FORCE ORDER improves performance until rows are deleted

I have a somewhat complex SQL Server 2008 query (about 200 lines of fairly dense SQL) that wasn't performing as I needed it. Over time, performance dropped from about .5 seconds to about 2 seconds. ...
2
votes
3answers
282 views

designing multiple tables while eliminating duplication?

As I'm working on an educational website, I'm facing a problem with my database design scheme - I can't find the correct design that eliminates duplication in the tables I'm creating. What I'm trying ...
4
votes
2answers
356 views

Designing an aggregation schema

The only thing closest to what I'm developing is Facebook's activities log for users. So I figured if I could ask about how FB might possibly implement such a feature at the database layer, then it ...
2
votes
2answers
5k views

Oracle 11g r2 standard edition installation - set environment variable PATH and create tnsnames.ora

I have installed Oracle 11g R2 standard edition (server software, 2GB download from Oracle). I found that the 'Environment Variable PATH' has not been set. Which of these directory should I use for ...
5
votes
2answers
95 views

Per person weighted answers

Hi I'm new to database design but am trying to make sure I get things right first time so as not to pick up bad habits. My question is I have a set of people for which I want to record needs mapped to ...
2
votes
2answers
218 views

Writing to a DKNF database, but reading from a de-normalized table for performance?

Would the following approach be reasonable? The Goal: queries have to be relatively fast, but without the hassles incurred by writing to a de-normalized database. The Context: A database for ...
0
votes
2answers
73 views

Tiered permissions to generate conditional data access

I am working to improve the confidentiality and access level of the information presented within a program interface over top of a MySQL database. My goal is to create a two tier system: one based on ...
1
vote
2answers
818 views

mysql transaction vs lock

I have a question regarding MySQL locking and transaction management. My Question is ..does mysql takes lock on the the tuple/table on which I am doing select/update in a transaction ?
2
votes
3answers
2k views

Does the MySQL primary key affect the efficiency of a SELECT query?

Does the primary key serve any purposes apart from uniquely identifying a specific row? For example, a table with an autoincremented primary INT key could greatly aid in search due to the option of ...
2
votes
1answer
750 views

Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?

We run a background task on one of our servers which polls sys.dm_exec_requests for long-running queries, gathering diagnostic information when it finds them, including wait type. I'm seeing a number ...
2
votes
3answers
931 views

How can I delete duplicates records in a table efficiently

I know there are several options to delete duplicate rows, eg: ROWID Analytical fn's like Rank(), row_number() What would be the most efficient way?
2
votes
1answer
850 views

PostgreSQL schemas and search_path

I'm reading Oreilly's PostgreSQL: Up and Running, and in the section Organizing Your Database Using Schemas it says the search_path may be set at the database level: For example, if we wanted all ...
1
vote
2answers
392 views

UDF in check constraint — downside?

I have a table where all actions affect single rows (insert and update, no delete's but if there were, they would be individual as well). I'm considering using a UDF in a check constraint so I can ...
2
votes
3answers
2k views

Memory problems with MySQLWorkbench

I'm currently using MySQLWorkbench 5.2.40 on my PC (8GB rRM, Corei7). I have a table with almost 1.5 million records, which I need to visually look over. Surprisingly, the total size does not exceed ...
9
votes
1answer
1k views

Best way to re-import large amount of data with minimal downtime

I need to import about 500,000 records containing IP lookup (read-only reference) data about once a week (only three int/bigint cols). I don't really want to worry about merging the data with the ...
1
vote
1answer
195 views

SQL Server Database Corruption Problem [closed]

I have developed a simple App in Microsoft VB.Net 2008 in which I have implemented database connectivity with SQL Server 2000. After 4 to 5 executions of the program I often find my database goes ...
3
votes
1answer
256 views

How can I conditionally summarize multiple rows in Microsoft Access?

I have a table of data, in Microsoft Access 2003, listing multiple rows for each person. I want to conditionally summarize a subset of these rows for each person, for instance, if entry for columnA = ...
1
vote
2answers
1k views

Similar function NOWAIT in MySQL

Select for update nowait doesn't work in MySQL 5x (innodb). Is there any function like NOWAIT in MySQL?
0
votes
1answer
315 views

Creating a bar chart from datatable

I'm writing a console application that fetches data from database (SQL) and writes to an excel sheet. Now I want to add a chart in the workbook according to the datatable values. How can I create ...
3
votes
1answer
2k views

error 1118: row size too large. utf8 innodb

I have tried to find a solution guys, and I am guessing that someone has met this before. But I cannot get hits down below 5000... most of which don't match my question. Using MySQL 5.6 - windows ...
4
votes
3answers
136 views

Can anyone describe the step by step process of recovery , backup and restore in sql server

Can anyone describe the step by step process of recovery via backup and restore in SQL Server 2008. If possible please include some examples.
5
votes
1answer
212 views

Query for data that is not there

I have this setup attendance table: ------------------------------------------ | member_id | attendance_date | event_id | ------------------------------------------ attendance indeces ...
4
votes
1answer
111 views

Problem joining two tables in MySQL

I'm new to MySQL. I'm having trouble in joining two tables: SELECT e.resourceName FROM resources_in_room r JOIN resource e ON r.resourceId=e.resourceId WHERE r.roomId=2; Table resources in room: ...
0
votes
1answer
275 views

Escaping a single quote in SQL Server 2005

I am using SQL server 2005 and using the northwind database. I need the supplier id of Grandma Kelly's Homestead and I used this query: select supplierid from suppliers where companyname ='Grandma ...
3
votes
2answers
113 views

How can I track the last modified user of a file in an SQL Server 2012 FileTable

Other than through a custom interface to store/fetch files using the old filestream way, is there a way to log which user modified a file opened directly from the share exposed by Sql Server 2012?
3
votes
1answer
539 views

How do you extend the tablespace when using innodb_file_per_table?

With innodb_file_per_table off, you can create multiple tablespaces on multiple devices if necessary to manage growth, balance I/O, etc. With the option on, how do you control growth of the files? Do ...
1
vote
1answer
86 views

Where can I find guidelines for building a SQL Server machine specifically for DBCC CHECKDB work?

I'm working on defining specs for a new server to run DBCC CHECKDB scans on all databases in our portfolio (85 instances, 1300 DBs, 15 TB allocated). I have a custom application that copies dump files ...
0
votes
1answer
343 views

InnoDB - Use combined index with primary key on GROUP BY

As far as I know, an InnoDB index always contains the primary index. I cannot get the following to work: SELECT t1.a FROM table_1 t1 LEFT JOIN table_2 t2 on t1.id = t2.refid WHERE t1.b = 99 GROUP ...
2
votes
1answer
372 views

Option to tell Toad to never split a file which contains multiple objects?

Is there an option to tell it to stop prompting me to split a file which contains multiple objects when opening .sql files from an edit window? I never want to split the file!
1
vote
1answer
8k views

Oracle DBCA utility: “Listener is not up or database service is not registered with it”

I'm a software engineer with some experience on SQL Server but a newbie on Oracle. I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
5
votes
3answers
200 views

Difficulty in moving a SQL Server database

I'm trying to upgrade from SQL Server 2008 R2 Express to Developer. My plan is to remove the Express edition, then install the Developer edition. I have one database I need to bring over to the new ...
3
votes
4answers
11k views

SQL Server CREATE FILE encountered operating system error 5 (Access is denied.)

I'm trying to execute the following script in SQL Server Management Studio but I'm getting the error: Msg 5123, Level 16, State 1, Line 2 CREATE FILE encountered operating system error 5 ...
1
vote
3answers
86 views

Generally speaking, what pecking order should be used when tuning SQL Server?

When tuning SQL Server, what generally is the pecking order to use when trying to decide what to tune first? I'm asking in regards to an existing database that would I would have little ability to ...
3
votes
1answer
65 views

In SQL Server Replication, at what point is it recommended that one separate the distributor?

Is there a general rule of thumb for when it becomes good practice to assign distribution responsibilities to a separate server that is not also a subscriber? e.g. "At n publishers/publications ...
2
votes
0answers
231 views

Help with normalization - Homework

I'm confusing myself a lot here. I did this before however have never got the hang of it. So I really need help, main issue is 2nf I just get the dependencies completely wrong. So I am practising ...
2
votes
0answers
1k views

MySQL re-install fails under Mountain Lion

I have problems to reinstall MySQL on Mac OS X after it was running on my system. I uninstalled it because the PreferencePane wasn't working as expected, using the procedure described here: ...
0
votes
1answer
89 views

Table and query design options

We have a alert table which have deviceID as a foreign key. At present one alert just refers to one devive so things works smoothly with join. The problem start now when one alert now is to refer to ...
3
votes
3answers
345 views

Is it possible to pass parameters to pt-table-checksum using an options file?

We're using Percona's pt-table-checksum for MySQL replication integrity check. Is it possible to pass some or all of the options using some sort of configuration file? For instance, can we write the ...
3
votes
1answer
92 views

Reporting Table Design

I'm writing a system that allows users to store values against each week in October and November and each day in December - starting from the first Monday. I'm holding the raw data entered by the ...
2
votes
2answers
359 views

Make sure two columns are sorted in the same order

I have a table like this: CREATE TABLE T ( ID INT NOT NULL IDENTITY PRIMARY KEY, CreateDateTime datetime2 NOT NULL, --other columns ) How can I make sure that ID and CreateDateTime are both ...
12
votes
2answers
2k views

SQL Server does not optimize parallel merge join on two equivalently partitioned tables

Apologies in advance for the very detailed question. I have included queries to generate a full data set for reproducing the problem, and I am running SQL Server 2012 on a 32-core machine. However, ...
1
vote
1answer
94 views

group by and having query need help?

I am using the pub database in SQL Server 2005. Which stores have at least 5 orders? Should diplay the store name and store id. I have come up with a query something like this: select ...
0
votes
1answer
145 views

Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)

I am sure there are some easy ways to do this... I have a simple flat Oracle table which is 13 terabytes or so in size due to a large number of rows accumulating over the years. I need to do a search ...
2
votes
1answer
215 views

Is having all entity tables inherit from one main entity table a bad idea?

My co-worker is designing a schema where most entities (like contacts, quotes, tasks) inherit from an "entity" table, which keeps track of things like which tenant owns the entity, and chagnes to the ...
2
votes
3answers
1k views

How can I speed up “show columns” on MySQL?

My application depends on running "show columns" for certain tables. It takes about 60ms to run, whereas all our other queries take under a ms. Querying information_schema directly is even slower. ...
2
votes
1answer
127 views

Can I move data and full text search files to another drive and change the drive letter?

My server's G: drive is rapidly running out of space. It mainly contains data files (*.mdf) for both system and user databases. The FullText Catalogs also exist on that drive. IT added a much lager ...

15 30 50 per page