2
votes
2answers
244 views

List the underlying objects used in a SQL Server Function

I use the below to get a list of underlying objects in a View: SELECT view_name, Table_Name FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE WHERE View_Name IN ( 'View1', 'View2' ) ORDER BY ...
1
vote
1answer
113 views

Limit of Generating Script for Schema Only from SQL Server 2012 to SQL Server 2008R2

Is there a limit on this method? I've tried a 35GB Database and it works, but my question is how about if my Database is like 100-150GB? Will I encounter some error? Or it will work smoothly but a ...
1
vote
0answers
125 views

How to make sqlplus more user-friendly anyone? [closed]

Note: I've tried using Toad from the Mac, but that's another fine mess so I'd rather bite the bullet and run commands through ssh. This is to edit and run interactive discovery SELECTs, not to run ...
0
votes
2answers
106 views

How to get several specific records from a query result?

I know by using Like with "LIMIT 1, OFFSET x" I can get the Xth record from a returned query result. But what if I want to get X, Y, and Z all at once? Currently I do a for loop and it's like I'm ...
0
votes
1answer
47 views

Having trouble designing my preferred backup scheme

First some background: I have two Windows servers running MS-SQL-2014 setup in an availability group (synchronous auto-failover, preferred backup on secondary). They host many databases. Right now ...
0
votes
0answers
56 views

Is doing an online alter on a MySQL table to add comments safe?

Is doing an online alter on a massive MySQL table to add or edit table or column 'comments' safe? Or do you need to take precautions like you would while adding, removing columns, etc on that table?
0
votes
2answers
93 views

How can I find table name for each row result?

How can I find the table name for each row result in my query? I have tried ideas suggested on the stack network (overflow, dba) 1 How to make a table name an attribute in PostgreSQL? 2 ...
0
votes
3answers
235 views

Is It Needed to Normalize of Date Columns

I am designing a small database with relatively small data. The question is about normalization of Datetime columns. The dates of year occured many times and should I create a Days tables with a ...
1
vote
1answer
80 views

How to mimic a full outer join using mysql views?

I have all kinds of views in mysql with employee data. I have tried to use methods like this -http://stackoverflow.com/questions/2384298/why-does-mysql-report-a-syntax-error-on-full-outer-join but ...
0
votes
1answer
97 views

What is the most efficient way to exclude records with a particular ID in a MySQL query for random records?

I have an api endpoint that returns X amount of random posts from a table called "posts". This endpoint is used by a mobile app. It retreives random posts by doing a SELECT COUNT(*) on the posts table ...
4
votes
1answer
2k views

Oracle paging query performance

I'm new to Oracle and I've noticed that pagination queries take the format. select * from ( select /*+ FIRST_ROWS(n) */ a.*, ROWNUM rnum from ( your_query_goes_here with ...
0
votes
1answer
460 views

PL/SQL recursive lookup with cursor

I basically have a need for recursing through data in my Oracle table so I can find related rows and send them out. It is a single table, a single ANSI SQL query seems not possible due to turin ...
0
votes
1answer
891 views

How to GRANT/REVOKE user permissions for user on Firebird 1.5?

I need to create a user in firebird 1.5 and give him permissions to access only some specific tables. I have managed to create the user, but apparently GRANT/REVOKE operations only work on version 2.1 ...
2
votes
2answers
156 views

How can I query a remote server using a local function?

I am querying a remote server for which I only have read permissions. I set up a local server with a UDF (since I cannot create one on the remote) that I would like to utilize for the query. When I ...
1
vote
1answer
292 views

mongodb 3.0.3 Ubuntu 14.04.2 AWS m3.medium Upstart PID mismatch

(Cross posted from stackoverflow, seems like this belongs here but 10gen link to stackoverflow explicitly from their site...) Is it possible to run mongod via upstart and keep track of the PID ...
0
votes
1answer
19 views

What does MySQL “USE INDEX()” without any arguments do?

Does the USE INDEX() have any effect here? SELECT `posts`.`id` FROM posts USE INDEX() where `posts`.`size` > 1024; (I have it presently in some SQL because of the way the query is ...
2
votes
1answer
139 views

How to display the query result separately for each item in an IN clause? [closed]

Maybe it's a novice question, but I am trying to get the sum of balances for each account present in the table. I am trying the below Select SUM(BALANCE) from dbo.account_balances ...
2
votes
2answers
115 views

DENY access to EXEC for a role

I have a read-only database user that I do not want to be able to run the EXEC command. I ran the following: DENY EXECUTE to db_USERROLE_deny That completed successfully; however, when I sign in as ...
0
votes
0answers
25 views

Mass update taking to long [duplicate]

After searching through many posts I have come up with the code below to handle updating 200,000 to 2 million records daily. The problem is its still takes hours to complete, I have tried to narrow ...
4
votes
2answers
169 views

AlwaysOn Availability Groups back up schedules

We have AlwaysOn Availability Groups primary and secondary replicas where the secondary replica is preferred for back up jobs to take place as long as it is available. I created back up jobs on both ...
0
votes
0answers
29 views

UPDATE from CSV generated with SQL JOINs

I want to do an UPDATE operation on DB by importing a CSV file. The complication is that I am creating the CSV by exporting the results generated by a Query containing SQL JOINs. How can I do an ...
3
votes
1answer
159 views

How to reverse-engineer SQL statements issued by a legacy application

I am re-writing the question below to provide more details. We have a legacy application and are now developing it using a new technology. The database is SQL Server 2014. We know 90% of the tables ...
0
votes
1answer
57 views

Change MySQL default installation directory in OS X

I install mysql in default installation directory /usr/local/mysql Is it possible to change mysql installation directory to another path? I am running OS X 10.10 & MySQL 5.6
0
votes
0answers
52 views

MySQL - Get actual precision and scale of number

I would like to query the integer part and fractional part of all decimal(8,4) values in a column. By that I mean, I want to know the actual given values, and not the max allowed by the data type, ...
0
votes
0answers
18 views

MySQL ignores ZWNJ character in string comparison

If you add a unique index to a char columns you can not add two string that differ only in having ZWNJ characters (e.g. 'فا' and 'ف‌ا'). However I need to store both of them. How can I overcome to ...
1
vote
1answer
337 views

Unable to update table after creating an After update trigger

I have a table like this /*Table: pageprivilege*/ ------------------------ /*Column Information*/ ---------------------- FIELD TYPE COLLATION NULL KEY DEFAULT Extra ...
1
vote
1answer
38 views

psql with '-c' option or '-f' option is not terminating properly

When I run a command such psql -d database -c 'select * from table' or psql -d database -f sqlcommands psql does not terminate cleanly. Interestingly piping the the contents of the file instead of ...
0
votes
1answer
61 views

How is time stored in the FireFox sqlite database “places.sqlite”?

How is time stored in the FireFox sqlite database "places.sqlite" ? Looking to modify the stored visit time on a few entries but I can't seem to figure out how to, is it encrypted?
1
vote
1answer
125 views

Install PostgreSQL using source code or using apt-get?

I want to install PostgreSQL on a server that runs Ubuntu 14.04.2 LTS. I understand that I have two options: 1) Install PostgreSQL using the source code distribution e.g., ...
1
vote
1answer
104 views

Unknown sticky Problem after MySQL upgrade

few weeks ago we upgraded mysql server from 5.5 to 5.6 on 1st server few days ago (5May) I reboot mysql server , after this customer reported that some database data table not load to their site . ...
0
votes
1answer
72 views

is it possible to extract 'LifeCycle Status' using emcli ( Oracle Enterprise Manager )

It's easy to set the LifeCycle status ( and other properties ) with emcli, emcli set_target_property_value -property_records="sometestdatabase:rac_database:LifeCycle Status:Test" but getting the ...
4
votes
1answer
399 views

Alternative of DBCC CHECKDB

I am running DBCC CHECKDB on one of my database but its taking very very long time. I have some questions please help me. Is there any alternative of it that can check my database integrity? Should ...
3
votes
1answer
94 views

how would i merge a column where matches a different column? [closed]

It's very similar to the below post How to merge column in mysql depending on match table user I would like to Merge customer_id from table user to table cust where customers_firstname AND ...
0
votes
1answer
387 views

Social file sharing database schema

I have a project called social media file sharing. I have this database schema and I need your opinion about what I should remove or add or edit on my database schema. Every user can upload media ...
0
votes
2answers
18 views

Import/Exporting certain columns of a table across two databases and excluding duplicate emails in mysql

I have run into a problem with mysql queries: Basically, I have two databases that both contain a table called tblclients however db1 has far more records than db2 and there are some duplicate ...
1
vote
0answers
446 views

Oracle 12c database cannot log in as a local user

I met a problem from Oracle 12C Database, when I try to login to the user account with commandconn test/test, I got prompt of "invalid username/password, logon denied". when I use conn ...
0
votes
1answer
84 views

SQL Blocking causing timeouts

We have a long running transaction (with nested trans), it runs for about 2min. In this time it does a heap of insert, update and selects. At the same time users still need to be able to use the ...
0
votes
1answer
2k views

cannot log in to mongo from command line - using MongoDB 3.0 and WiredTiger - I've followed all instructions

NOTE: I have tried not setting bind_ip and also setting it to 0.0.0.0 -- neither one fixed my issue. This is my mongod.conf file: systemLog: destination: file path: "/root/mongodb.log" ...
0
votes
1answer
883 views

Memory usage on select for large number of rows

I am trying to dump the entire contents of a large table, from the command line using pqsl, but am running into a problem where memory usage goes up, to the point where the process is killed, before ...
1
vote
0answers
49 views

oracle bulk loader processing columns with newline characters

I'm trying to load a file with description columns which may contain newline characters. The file is Unix format utf16, tab separated and description columns are enclosed in ". The problem is bulk ...
2
votes
1answer
127 views

search xml column inside large table (7 million rows)

Database design: Table Name : Plays ( 6 million records) Columns: Play id, col1, col2......col7, PlayFieldValues PlayFieldValues xml column. sample xml stored in this column <PlayAttributes> ...
0
votes
2answers
43 views

is it a good practice to ip block dev/test app servers from production database server? [closed]

I would like to do this as somewhat of a last line of defense as we will be replicating production to test regularly. Is this good practice?
1
vote
1answer
213 views

How does the table scan in an UPDATE WHERE predicated on an unindexed column work?

I was looking into a deadlock caused by two concurrent UPDATE statements: UPDATE [table] SET [column] = 0 WHERE [unindexed_column] = @id My understanding is that because the column the WHERE is ...
1
vote
1answer
146 views

PostgreSQL: restore a record from a backup

We have a Rails app backed by a PostgreSQL DB and hosted on Heroku. We recently had a bug that deleted some (very few before we caught it) records. Excuse my ignorance but is there a straightforward ...
0
votes
1answer
56 views

MySQL Join is the same as Cross Join?

I'm learning mysql. Under all cases, is Join the same as Cross Join? For example, this query SELECT * FROM table t1 JOIN table t2 Will always be the same as SELECT * FROM table t1 CROSS JOIN ...
0
votes
1answer
219 views

Select records as groups based on sequence and date

I have data stored as: CompID | Seq | Udate | Utime --------+-----+-----------+------- mx433 | 1 | 1/1/2012 | 13:54 mx433 | 1 | 1/2/2012 | 13:43 mx433 | 2 | 1/4/2012 | 14:23 mx433 ...
2
votes
0answers
318 views

Sync a local MySQL database and a live server MySQL database

I want to store data in my local MySQL database and after a time interval or when system connected to internet it will update my live MySQL database remotely. Is it possible? I have an inventory ...
0
votes
0answers
193 views

Promo Codes - should I create a separate table or add a code column to a join table for Students and Courses

I'm creating a promo code and invitation system and I want to understand the best way to structure the database to include the Promo Codes. This is what I have currently: User: has_many Courses ...
1
vote
1answer
69 views

Selecting the correct row given multiple input value combinations

I have a table that stores part numbers for various items like so: +------+-------------+-------------+-------------+ | Item | Color | Type | Part Number | ...
4
votes
1answer
206 views

Finding all joins required to programmatically join a table

Given a SourceTable and a TargetTable, I would like to programmatically create a string with all joins required. In short, I am trying to find a way to create a string like this: FROM SourceTable t ...

15 30 50 per page