0
votes
0answers
3 views

Is it bad practice to launch more than 100 sql statements at once?

I have PHP code that is meant to updating the billing status of someone. I only want it to update if the bill has been successfully created and therefore I think a possible solution would be to ...
2
votes
0answers
8 views

What effect will reducing the size of a varchar column have on the database file?

We have a number of tables in our database that have VARCHAR(MAX) columns where a VARCHAR(500) (or something much smaller than max) will suffice. Naturally I want to clean these up, and get the sizes ...
0
votes
0answers
5 views

Trigger AFTER INSERT on tables with different collumns

I'm making a Trigger that works after an insert. this is what i have: create trigger trgInsereQuestao on tblquestaoOpcao after insert as begin set nocount on; ...
0
votes
0answers
4 views

Fencing a failed application node to isolate it from SQL Server

I have a multi-node server application that is backed by SQL Server 2012, often in a clustered or AlwaysOn AG/FCI HA configuration. My application monitors the health of the application nodes (not the ...
0
votes
2answers
12 views

Unable to find how a table is being populated

Using SSMS2014 w/ SQL Server 2008 R2. I have a table that I am trying to find out how and from where data inside it is coming from. (I didn't create the table and am unable to contact the person who ...
0
votes
0answers
7 views

How to sync two tables which are on different databases and servers using SSIS?

I am relatively new to SQL Server's tools. I am on the following situation: On several stored procedures on a database D1 on server S1, I need to use data that is stored on a database D2 on server ...
1
vote
0answers
7 views

How to get paged resultset from a table?

I am trying to get paged resultset from a table (Notes). So, I am passing the last offset id (@LastOffset) value along with the page size (@Count). My approach to achieving this is: Sort the table ...
0
votes
0answers
7 views

How to verify if a SQL Account is still used?

We have a SQL Server Login on a SQL Server 2008, and no one seems to know if the account is actually being used or not. It is assumed it is being used, as it is configured in a Linked_Server ...
0
votes
0answers
4 views

Sql develoeper Configuration File access denied

I have install Oracle 32 bit DB in Windows 7 (64 bit). When I try to run sqldeveloper, it asked me to enter full path for java.exe . I have set java.exe of 64 bit but it have to be of 32 bit java ...
-1
votes
0answers
2 views

Teradata SQL Assistant - List tables under DBC in the Database Explorer

I am able to query, but under DBC, in the Database Explorer, I do not see the list of tables. That also makes it impossible for me to qualify name and get any kind of ide support while writing my ...
0
votes
0answers
8 views

Numeric Latitude & Longitude values are rounded up when querying SQL Server Database

Developing an application that is using Google Maps. Lagitude and Longitude values are stored in the table as the correct value. However when they are pulled into a view the value is rounded to the ...
0
votes
1answer
10 views

Advisable number of foreign keys in a single table

I was wondering, keeping performance and optimizations in mind, while designing the database, is there any advisable number of foreign keys you should keep in a single table? At present, few of my ...
0
votes
1answer
9 views

SQL Server Service's Log On As account

I just inherited a set of new servers and whoever set them up left the "Log On As" account as the default "NT Service\MSSQLSERVER". I'd like to change that over to an Active Directory service name. I ...
0
votes
0answers
7 views

MS Access 32/64 bit interoperability

I don't have a copy of 64 bit MS Access installed so I can't try this. I'm a developer looking at what's involved with adding support for 64 bit. I'm just using the MS Access database as a back-end. ...
0
votes
0answers
15 views

delete millions of rows from multiple tables

Hi we have to delete between 40 and 55% of records from several tables that have between 40 million and 100 million rows. Is it better to copy the rows we want to keep to a new table, drop the source ...
0
votes
0answers
20 views

table not taking records sequencially [duplicate]

While inserting rows into a table in oracle 10g, the rows are not inserted in the order I am putting them, like for the following inserts: insert into emp values (1000, 'debjani', 30); insert into ...
0
votes
0answers
7 views

How to normalize a table that contains a CK not included in the PK?

I have the following table. The PK is model_ID. Assuming that the modelName field is unique(that is, no two brands can have an identical modelName), there is a transitive dependency between modelName ...
0
votes
0answers
27 views

Can I create a constraint to a subset of data?

Here's a simplified view of my database |---------------| |-----------| | ORGANIZATION | | CONTACT | |---------------| |-----------| | OrgId | | ContactId | | OrgName ...
0
votes
1answer
16 views

How to list all past remote login information on remote SQL server

Instead of using "Remote Desktop" for connecting to SQL server, I and my coworkers are using SQL Server Management Studio to apply the changes on remote server (each users have their own credentials). ...
1
vote
1answer
18 views

Duplicate database leaves orphan archivelog files

I am cloning the production database to another one, lets say CLONEDB, in a regular basis. I am using rman duplicate database script like: run { duplicate target database to CLONEDB FROM ACTIVE ...
0
votes
1answer
34 views

How to increase the performance of this 3 minute reporting query

We have a table MyTable with about 10.000.000 records which contains a record of all transactions processed in our application. This table has the user Owner who did the transaction, the date ...
0
votes
0answers
24 views

Rowversion column in every table - Bad practice?

I'm currently providing my application with concurrency checks. For that, I'm using Entity Framework combined with SQL Server's RowVersion / Timestamp column. Now I've thought about adding a ...
0
votes
1answer
24 views

optimizing init.ora oracle database server

Can anybody help me in optimizing my SGA, PGA and other paramters of the init.ora file. We usually have average of 159 sessions on the database server. I think there's some thing wrong with my SGA, ...
0
votes
0answers
24 views

SQL Server 2012: query to see queries that are consuming more resources

I'm trying to find/build a query to show me those queries that are consuming more resources in SQL Server so that I can optimize them or at least have a statistical idea of what is really happening. ...
0
votes
0answers
3 views

MongoDB GridFS delete operation too slow while mongod process takes up 100% CPU

I'm using Python (CPython 2.7.3 on Debian 7.8 amd64) with pymongo driver (version 2.7.2) to connect to a MongoDB (db version v2.4.12) database which has solely been used to store files in a GridFS ...
-2
votes
0answers
15 views

How to monitor sql server 2012 temp db 24/7?

Temp db growth is one of the major issue which i'm facing on sql server 2012 . Can any one suggest how could we identifies which queries are hitting temp db and how much space it is utilizing on the ...
1
vote
1answer
40 views

What is the query that updates the Column in a table

I have a column in a table that I don't know who is updating it . The table name is dbo.Events and the column name is [Status] and this column values are 1 or 2 . I am trying to find the query that ...
0
votes
1answer
16 views

Testing databasis for learning

I just instal oracle 12 c on Virtual Dub. I would love to get some sample of working database I can add in and use - to lear, how SQL works, how can I make an export to .xls and so on. Please, can you ...
0
votes
0answers
11 views

MySQL TRIGGER with test on minute datetime

I try to create a TRIGGER on MySQL 5.6. In this TRIGGER, I test if the minute of my Date is equal to 0, 15, 30 OR 45. So I test this : IF (MINUTE(NEW.tb_date) IN (0, 15, 30, 45)) THEN ...; END ...
1
vote
1answer
20 views

Incorrect unit allocation size. error comes when Tuning the Database

Here I am Using the SQL IDERA tool for checking the Index and performance of the Database, then i found below error, can any one tell what is it talking about. Incorrect unit allocation size. ...
0
votes
0answers
10 views

Fact table linked to Slowly Changing Dimension

I'm struggling to understand the best way to model a particular scenario for a data warehouse. I have a Person dimension, and a Tenancy dimension. A person could be on 0, 1 or (rarely) multiple ...
0
votes
0answers
19 views

What kind of data cannot be stored economically in a database / data-warehouse?

Someone mentioned this in a presentation but didn't provide any examples. This stuck with me and I am trying to figure out what kind of data couldn't be stored economically in datbases ever since. It ...
0
votes
0answers
15 views

Application is Hanging when database upgraded from MS SQL 2000 to SQL 2008 Server R2

Presently we are working with SQL Server 2000,the database is perfectly working with our software for retail sales counter application developed with VB 6.0. But after upgraded to SQL Server 2008 R2 ...
-1
votes
0answers
18 views

what is the role of database in deployment of server [on hold]

In deployment of server how the database can help us? what is the role of database in deployment of server?
0
votes
0answers
7 views

Sql Server 2014 AppRole not able to create temptable in tempdb

we have created Application Roles in sql server 2014 and grant the "Execute" permission on the tables and stored procedures. when i execute sp_setAppRole and then the stroredprocedure. the simple ...
3
votes
1answer
39 views

Impact of changing char(10) to varchar(12) on massive table

I have a table in a database in Microsoft SQL Server 2005 server that is 16gb in size and has 58 million rows. It has a column called 'balance_forward' that is char(10) (Unusual choice for a ...
0
votes
1answer
22 views

Optimizing a DMV query

I have found a query that is a major performance issue in my environment. I looked at the actual execution plan for this query and found out the main problem is the remote scan (98%). Its remote ...
0
votes
0answers
19 views

merge two column into single columns and show them in separate rows

My Table looks like this Name Date1 Date2 Date3 A 25 23 20 B 20 15 10 I want it like this Name Date A 25 A 23 A 20 B 20 B 15 B 10 how i can ...
0
votes
1answer
40 views

Is making joins between different table spaces slower?

In MySQL and PostgreSQL, is making joins between different tablespaces inherently slower, compared to joining tables in the same tablespace?
-1
votes
2answers
25 views

SQL Server Temp Database Monitor Tools [on hold]

Please suggest best tool to monitor temp db activity to find the objects which have excessive temp db usage.
-3
votes
0answers
28 views

Backup and Restore

What are the Negative Aspects backup and Recovery in sql server Over these points. Full Backup and Restoration Point in Time Restoration Restoration in Same Instance Restoration in Different ...
1
vote
0answers
9 views

Merge Replication: Updates to Schema

We have a main SQL Server which replicates to two backup servers via continuous merge replication. There are regular updates to the schema. Regular changes include: Adding new tables and ...
0
votes
1answer
36 views

If A and B are candidate keys, then AB is candidate key or not ?

If R{abc} is a relation, f{ a->b b->a a->c b->c }, then a and b are candidate keys. What about ab ? Is it a candidate key or is it a super key or both ?
-1
votes
0answers
21 views

query explain saidd row is a few but it took an hour to load

i have a query down here select if ( month(td.date) = month('2011-01-01') and year(td.date) = year('2011-01-01') and month(td.date) = month('2011-01-02') ...
0
votes
1answer
18 views

SQL Server error log entry : Error: 17806, Severity: 20, State: 14

I have error in my log for a few weeks, I searched a lot but I couldn't found useful answer. I did closed SQL Server port for public IP, but I have problem yet. Error: 17806, Severity: 20, State: ...
-1
votes
0answers
15 views

I have an Access 2013 split database. How can I save the data when the network is down? [on hold]

Sometimes the network goes out, and the front ends can't reach the back end. What is the best way to save the data in this situation?
0
votes
0answers
12 views

How to model role and different activities

I am new in the database design and I'm facing this problem, I hope somebody can help me. In my domain we have 3 roles, Non-Supervisor, Supervisor, Manager. I created a Person table and a role table ...
-1
votes
0answers
8 views

Access denied for user to database 'mysql' in amazon RDS

I am trying to restore the 'Mysql' database of my master in the DR and i am facing access denied issue. I have also tried to restore only user table with no luck. Tried searching google but dont see ...
1
vote
0answers
12 views

Rely on .pgpass in CREATE USER MAPPING

I am trying to create a script which creates a postgres-fdw connection between two postgres 9.4 databases. The script (which is checked in under version control), has been relying on pgpass to do ...
0
votes
0answers
10 views

Amazon RDS non superuser create function in C

I am asked to restore a Rails application to a postgresql RDS instance. There are many functions in C but looks like only superuser can create functions in C and I could not get superuser access on ...

15 30 50 per page