0
votes
1answer
37 views

Update a set of SQL statements

dbo.MatchFirstName(@FirstName) and dbo.MatchLastName(@LastName) are table Value Functions(TVFs). Problem: In my Update statement i.e Update #Temp after Insert, I want only those rows to be ...
-1
votes
1answer
31 views

Why there are so much restriction on LONG datatype in Oracle [on hold]

Why there are so much restrictions on LONG datatype in Oracle? Why it is recommended to use CLOB instead of LONG? EDIT Its deprecated and the usage is also highly restricted. Moreover, I am not ...
1
vote
1answer
59 views

Query on 250 million records

I have a table with below structure CREATE TABLE [dbo].[ColumnValues]( [Id] [int] IDENTITY(1,1) NOT NULL, [ColumnId] [int] NOT NULL, [Value] [nvarchar](max) NULL, [OutputArea] ...
0
votes
0answers
24 views

Performance issue after reorganizing table in MYSQL

There is MYSQL(5.6.22-log Community Edition) database environment which has databases size varies between 1-40GB and using INNODB storage engine, it's serves for the several number of OLTP based ...
0
votes
2answers
40 views

SQL Server tuning: Disk queue to OS drive: How to optimize?

I expect to see the disk queue move on the data, tempdb, log and backup volumes. I do not expect to see the OS drive (C:) which has zero SQL files present, show disk queue impact. Assume it is to ...
0
votes
1answer
40 views

Exclusive access to edit rows [on hold]

I'm developing a program that allows users to view and edit data. My question: Is there tools (sql server tools, may be users/roles) to implement the following: There are two users: A and B. User A ...
0
votes
1answer
17 views

what databases have the implementation of sort merge join? [on hold]

So many databases and distributed data warehouse frameworks, which have the sort merge join implementation?
1
vote
1answer
8 views

Upgrade PostgreSQL 9.1 to 9.3 and server no longer starts

Technically, I didn't upgrade from 9.1 to 9.3, I built a new server with Ubuntu 14.04 and used my old 9.1 config files. PostgreSQL wouldn't start: * Starting PostgreSQL 9.3 database server * The ...
0
votes
1answer
27 views

Row size too large (> 8126)

I'm facing the following problem. Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, ...
1
vote
1answer
19 views

Can I use SPARSE somehow on a non-nullable bit column with mostly false values?

I have a table that stores the results of queries that are run at least once a day. There's a bit column that represents whether the row is from the most recent run of a particular query with a ...
0
votes
1answer
7 views

Alter doesn't show in processlist

I'm performing an alter. It's currently running on a large table (300,000,000). MariaDB [my_database]> ALTER TABLE my_table -> add INDEX a (x, y, z), -> add INDEX d (x); Stage: 1 of ...
0
votes
0answers
5 views

looking for mysql tablespaces introduction

What would be a good place to read about the advantages of splitting data across several MySQL table spaces (as well as limitations that come along with that) ?
1
vote
1answer
24 views
+50

what would be the primary disadvantages of splitting my tables into table spaces and/or separate schemata

I would like to organize the MySQL tables of a complex application into some groups, to avoid looking at a one big bin of tables. One big bin is harder to administrate when e.g. I would like to reset ...
0
votes
1answer
49 views

Uexpected values inserted in table

I have a table called FunctionWeights which contains data as follows: My query is as follows: select @constVal = FunctionWeight from dbo.FunctionWeights where FunctionWeights.FunctionName = ...
-3
votes
0answers
28 views

why i am getting “Table 'DATABASENAME.INTOusers' doesn't exist” actually this table present in db [on hold]

I am trying to INSERT values from temp_table table to another table users both are present in same database i am successfully performing operations on temp_table. when ever i am trying to insert the ...
0
votes
2answers
34 views

Oracle StartUp Issue [on hold]

I am facing the following issue while starting the Oracle instance. SQL> Connected to an idle instance. SQL> SQL> ORACLE instance started. Total System Global Area 1269366784 bytes Fixed ...
-1
votes
1answer
29 views

Debugging Remote Connection Failure of SQL Server 2012 [on hold]

I am running SQL server 2012 web edition on Windows Server 2008 R2. I have followed all these steps http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/. But still unable to ...
0
votes
1answer
18 views

How to know if 'mysql index' are used or not in all database or table? [on hold]

I read similar topics without success :/ I'd like to know how can i determine which index are used in my database or table : DATABASE Is there any tools, or SQL to use on the database, which can give ...
0
votes
1answer
27 views

Update does not working while select returns right results

I am trying to execute the query below: UPDATE( SELECT Ord.Completed FROM Product P INNER JOIN Order1 Ord ON Ord.OrderID = P.OrderID WHERE EXISTS( SELECT * FROM Delivery ...
1
vote
3answers
53 views

how to check whether Oracle database is accessed or not?

I am an Oracle DBA. Application owner is asking me when was the last time Oracle database was accessed? How do I find information about the DB usage timeline? I mean, I want to check whether it is ...
0
votes
1answer
21 views

Storing latitude and longitude

I know there are similar questions on here that have been answered but unfortunately none of them work for me. I am hacking my way through creating a page which will display multiple locations on a ...
0
votes
1answer
33 views

Files not getting deleted using Powershell [on hold]

I have written the following script using a post on this forum. The script deletes the files which are older than 15 days: cls $servers = Get-Content server.txt $limit = (Get-Date).AddDays(-15) $path ...
4
votes
2answers
58 views

Take advantage of monotonic columns in PostreSQL

I have a PostgreSQL table with, among the other, two columns named col1 and col2, both of integer type (there are around 10M rows in the table). I want to perform SQL queries like: SELECT * FROM ...
0
votes
0answers
14 views

How to store likes to posts in Parse.com database?

In my parse database I have a classed called Post and Like. Should I create a field likes in Post class with Relation<Like> type or there is another better option of storing likes in Parse DB?
0
votes
1answer
32 views

Converting sql into mongodb nosql

I am trying to convert oracle sql into its mongodb equivalent version. create table my_hll as select mod(ora_hash(n), 1024) bucket, max(num_zeroes(trunc(ora_hash(n)/1024)))+1 val from previous_data ...
0
votes
0answers
4 views

What is the way to store calculated value (CNXwindow) in same table (postcotoffbookings) of (Pricingmodel) Mysql Databse?

This is the image of calculated cnxwindow after running the query, so kindly let me know how can i store this value in the same table after calculation.
0
votes
1answer
16 views

MySQL profile on query “Creating Sort Index” using 75% of the total time

We are trying to figure how to optimize a query (taking around 100ms), and running profile we see Creating Sort Index using 75% of the total time. First, what exactly effects creating the sort index? ...
-2
votes
0answers
11 views

which one is better for connecting vb.net to sql? wizard or ado.net coding? [on hold]

What is the solution for this picture? Data is not saving in SQL database. I think it happend when i added the grid-view.
0
votes
1answer
19 views

Difficulty with nested query order & grouping

I'm trying to identify the count of objects a user updated during a given day, but only where the user was the final update. Each object can have multiple updates in a day from any user, but the ...
0
votes
0answers
22 views

How can I track changes across 60 local databases with 1 million+ rows each?

The files are mdb and I have them locally on my computer. Just trying to track changes across the 60 databases. Realistically I want to compare two at a time and find the differences in the reports, ...
0
votes
1answer
26 views

Error in trigger: table X is mutating, trigger/function may not see it

Having looked at the following Trigger, still getting the Row 2 error: "ORA-04091: table SUMMITTEST.APL_LOG is mutating, trigger/function may not see it" Please can anyone provide any help in ...
2
votes
1answer
23 views

How to pass multi-valued characters in SSRS Report?

I have a SSRS report that has 3 data sets feeding off one data source. The main dataset is a stored procedure that is aggregating some data based on a set of parameters powered by the other two ...
0
votes
0answers
30 views

PostgreSQL Performance - Many Large Databases

I run an internal (development) database server containing 25 databases each ~71GB in size. There are usually between 50 and 100 active connections at any given time. What can I do to help improve ...
0
votes
2answers
32 views

Initial Discovery process

I am looking to better my knowledge without actually being in the field, I was wondering what initial steps you take when you are assuming the responsibility of a server with SQL-Server installed on ...
0
votes
0answers
19 views

Replication Strategy for Multi-Office Database

I'm considering options for setting up a repository of large spatial datasets that can be used by employees across our company. We have offices scattered around the US. Our employees utilize ...
0
votes
0answers
10 views

Get memory in Oracle R Enterprise [on hold]

How can I increase memory for ORE? My server have 10G free memory, but I can't use all of them for ORE. These commands have error: begin sys.rqscriptDrop('clustering_test'); ...
5
votes
1answer
144 views

Why can a non-clustered index not be dropped using online=on option

When attempting to drop a non-clustered index using the online option such as DROP INDEX [IX_MYINDEX] ON [dbo].[myTable] WITH ( ONLINE = ON ), I receive the following error message. Msg 3745, Level ...
1
vote
2answers
23 views

SSMS (2012) limit # of characters on editor window line

Is there a way to enforce a hard limit on the number of characters allowed on a line in the SSMS editor window? I have searched, but am unable to find an option to set this. I'd like to force the ...
0
votes
2answers
39 views

Are some these indexes redundant?

Let's say I have a table of 4 columns: A, B, C, D. A primary key is on A, B, C. Index1: is A, D, B, C in that order Index2: A, B, C, D in that order and the primary key index: A, B, C There are ...
0
votes
0answers
14 views

Can I log which stored procedure issued a delete statement?

We have an issue where rows are deleted from a table and we can't figure out where this is happening. We have a trigger on the table to move the rows to another table, so that we can move the data ...
1
vote
1answer
31 views

How do I drop all constraints from all tables?

I want to drop all default constraints, check constraints, unique constraints, primary keys and foreign keys from all tables in a SQL Server database. I know how to get all the constraint names from ...
1
vote
1answer
32 views

Confused about sys.dm_io_virtual_file_stats num_of_reads/writes column

I'm trying to use the sys.dm_io_virtual_file_stats DMF to generate so IO wait information across a number of my servers. I came across this post by Paul Randall: ...
0
votes
1answer
32 views

Server 2012 Linked Server From An Instance

I have 3 SQL Server 2012 Instances, 2 on SiteA on the same server SiteAServer. I have 1 on SiteB on server SiteBServer. SiteADefaultInstance, SiteASecondInstance SiteBDefaultInstance ...
1
vote
0answers
18 views

SSMS login fail to Linked Server

i have one server with SQL server 2012 standard on cloud environment and one linked server with sql express on remote location connected with VPN , im using transactional replication every time when ...
1
vote
0answers
16 views

choosing between the slaves on streaming replication

We are building a new streaming replication setup on postgres 9.3 integrated with pgpool for load balancing and failover, and repmgr for replication business. We have seperate daemons running on all ...
1
vote
0answers
21 views

Update SQL Server .net version

I have used this article to detect the latest install .net version and here is the result: Its .net 4.0 and I want to know if the SQL Server is using the latest installed version? I want to ...
0
votes
0answers
20 views

Best engine type for WHOIS data [on hold]

I'm trying to decide on the better engine I should use for an application that will solely be used to store WHOIS data. Looking at the DB engines site, I see two types that may meet the criteria ...
0
votes
0answers
34 views

DBMS_SCHEDULER JOB interval not working

I've created DBMS_SCHEDULER job, which type is CHAIN. Chain has 2 steps and 2 rules. Each step has PL/SQL "program" (which inserts SYSDATE to table). First rule's condition is TRUE. Second rule has ...
-1
votes
0answers
23 views

Database migration for Large Data Set from MySQL to NoSQL

I have an existing APP that has N types of products that is normalized with MySQL. Each types of products have over 500K skus, and one of them are in the in 2M currently. We are currently tracking on ...
2
votes
1answer
35 views

Can I throttle individual databases instances on one SQL Server 2005 box

I am running a very old server that has a database that is being permanently retired within 14 months. My company will not invest anymore in hardware or software for this system as we are moving to a ...

15 30 50 per page