0
votes
0answers
3 views
What will happen if I drop SYSAUX tablespace from Oracle 11G
As there are two mandatory tablespaces in Oracle SYSTEM and SYSAUX.
They have mention on docs 1 " You cannot drop the SYSTEM tablespace. You can drop the SYSAUX tablespace only if you have the SYSDBA ...
0
votes
1answer
6 views
Change the Row Order to alphabetical then numeral
I have a table with a username as unique & primary key.
I ran this Query to order them in ascending order
ALTER TABLE `table` ORDER BY `Username` ;
So the rows are ordered like this
...
0
votes
1answer
7 views
mysql 100% usage on all cpu
On mysql community 5.5 (centos 6), VM on hyper-v win 2008 r2, 4 CPU, 48 GB RAM
Which setting(s) that I would need to change to reduce cpu usage and get my web app (joomla) to respond faster without ...
2
votes
0answers
9 views
create smaller row from alias and preserve column names
Using Postgres:
SELECT users."name" AS "name"
, array_to_json(array_agg(sites)) as sites
FROM remodel.users AS users
JOIN
remodel.user_sites AS user_sites
ON users.id=user_sites.user
...
2
votes
1answer
11 views
Can PostgreSQL use nulls in its indexes?
I've been reading this book which says that
The database assumes that Indexed_Col IS NOT NULL covers too large a range to be useful, so the database will not drive to an index from this ...
1
vote
1answer
10 views
How do I create a global MongoDB Admin account to see all Dbs?
I'm working on MongoDB, sysadmin helped setup the install.
I'm confused about MMS the Cloud Manager, I created an account for @admin database
I authenticate successfully but do not see "test" ...
2
votes
1answer
36 views
Is it possible to validate more than one parameter simultaneously into a Stored Procedure in sql?
On Microsoft SQL Server 2008 I realized a stored procedure which contains more than 20 parameters, in this SP I update or insert data into table which does not accept null values.
I need to evaluate ...
1
vote
1answer
27 views
mysql update query almost 5 minutes slower in 5.6 vs 5.5
EDIT 6:
I always thought an ALTER table recreated everything. When I add the optimizes shown in edit 5; it is always fast. (no more 4 minutes waits). The odd part is; if I am doing a lot with my ...
8
votes
0answers
54 views
Sql Server : How are these two rollbacks different
In Sql Server 2008 R2, how are these two rollbacks different:
1) Run an ALTER statement, for a few minutes, and then hit 'Cancel Executing'. It takes a few minutes to rollback completely.
2) Run the ...
1
vote
1answer
8 views
Use PostgreSQL builtin operator <@ after including extension intarray
I added the intarray extension to my PostgreSQL database in order to make use of the - operator, but I still want to use the builtin <@ operator, not intarray's <@ operator. Is there a way to do ...
1
vote
1answer
15 views
SQL 2012 insert data into a table from another table and custom columns
I'm trying to insert data from one table into another table and I also have 4 columns that are not in the source table but need to be populated in the target table. Here is the Insert statement
SET ...
1
vote
0answers
7 views
SSRS Report drop down parameters. Use SP or embeded SQL query for datasource?
When I create SSRS reports I create stored procedures to bring data into my report. When I create the report parameters I just embed SQL code directly in to the parameter/SSRS report.
Should I also ...
1
vote
1answer
13 views
Get other columns with recursive cte
This works as far as getting the amount of childs a "thread" has but now I can't seem to get it to pull parent row columns. Where parent is null, is the parent of the childs, can be any level deep.
I ...
1
vote
1answer
18 views
Parsing out date_entered field to capture TIME 'hh:mm:ss' based on time range
Based on the date_entered column, which is a data_type of 'DATE' how would I parse out the data to pull the time.
Values in the DATE_ENTERED field (DATA_TYPE is DATE) looks like this 5/15/2015 ...
3
votes
0answers
51 views
Very High wait time?
We currently have one production SQL Server 2012 Standard Edition , running on Windows server 2008R2 standard ( 32 GB RAM , 16 cpu). there are around 22,000 connection. the Max worker thread is ...
1
vote
0answers
42 views
Supertypes and subtypes
I am trying to design a database that has supertype/subtypes. I have the following users:
- basic user
- business user
- administrator (super user).
All three users share a common table (users) ...
2
votes
1answer
46 views
Can Indexes mitigate untrusted Constraint
I using sp_blitz and found two tables that have foreign keys that is untrusted. tried to enable the trust with:
ALTER TABLE MyTableName WITH CHECK CHECK CONSTRAINT MyConstraintName;
GO
But got this ...
0
votes
1answer
27 views
How do I drop the TIME portion from DATEADD?
I am trying to create some test data where each Employee has a random birthdate. I accomplished the randomizing part but it did not return result in the format that I want.. NOTE: the DateOfBirth ...
1
vote
1answer
28 views
Uniqueness constraint with date range
Consider a prices table with these columns:
id (primary key)
product_id (foreign key)
start_date (date, non-null)
end_date (date, non-null)
quantity (integer)
price (numeric)
I'd like the ...
0
votes
1answer
18 views
What is “CSS operation: data query” wait event in an Oracle StatsPack report?
Has anyone seen the CSS operation: data query Oracle wait event and know what it means? There was a bug 8299200 in 11.2.0.1 which is fixed in 11.2.0.3.
STATSPACK report for
Database DB Id ...
-5
votes
1answer
48 views
Split after comma into separate row [duplicate]
id name books
1 dan history,physics,english
2 ron chem,social,biology
3 mon it,ece,eee
I need an output as
id name books
1 dan history
1 dan physics
1 dan english
2 ron chem
2 ron ...
0
votes
1answer
38 views
Is unique index combined with a “not null” constraint equivalent to a PK constraint?
I have these legacy table definitions (from here):
CREATE TABLE [dbo].[JobItems] (
[ItemId] UNIQUEIDENTIFIER NOT NULL,
-- lots of other columns
CONSTRAINT [PrimaryKey_GUID_HERE] ...
0
votes
0answers
8 views
resource manager consumer group OTHER_GROUPS is not part of top-plan Test_plan
I want to use resource manager to limit execution time, with this parameter MAX_EST_EXEC_TIME. but running the below is giving me following error. how to fix it ?
ORA-29382: validation of pending ...
0
votes
0answers
16 views
Creating a Create Table Query in Access with only the columns from one table [on hold]
In Access I wrote up a Query in SQL to do a join I want this query to make a table with only the columns from one of the tables, but they always create a table with all of the fields from both source ...
0
votes
0answers
30 views
SQL Server Profiler performance
I was wondering if I set a filter for just a particular user does it limit the amount of resource consumption used by sql server and does using a filter(depending on the filter) limit the performance ...
2
votes
1answer
72 views
Which DBMS are more standard compliant? [on hold]
I find it frustrating that the same queries don't work in different DBMS.
Example, some DBMS (such as Microsoft SQL Server and MySQL) seems to support the information_schema table, while others (such ...
0
votes
1answer
31 views
copy tables from one database to another
I have two Databases on mysql. They are used for completely different things and contain different tables. The problem is I need them both on the same server that can only host 1 db (and I can't ...
0
votes
3answers
24 views
Mysql privileges and replication
I want to recreate the whole privilege system in my database, and that includes the slave user on the master. It means i have to stop the slave, run a set master command again and than start it. My ...
2
votes
1answer
15 views
Compact and Repair Database (db1.mdb?)
When compacting and repairing a database, Access doesn't actually compact the current copy of the database, it just saves it as db1.mdb? Am I correct?
If so:
I am building an application for which ...
6
votes
2answers
107 views
Why can't I see my table (PostgreSQL) when I use \dt(+) inside psql?
I have created the table donor in the schema reference as per:
CREATE TABLE reference.donor (
donor_code smallint PRIMARY KEY,
donor_name character varying NOT NULL,
donor_type smallint ...
2
votes
3answers
31 views
SQL Server restore database with active connections [duplicate]
I am trying to run this SQL script on a SQL Server instance to restore a test database to a newer copy of the live database.
RESTORE FILELISTONLY
FROM disk = ...
1
vote
1answer
21 views
MongoDB Upgrade to 3.0: HostAndPort Exception
I want to upgrade my small MongoDB-Cluster (1 mongos, 3 config-servers, 2 shards a 3 nodes) running on OpenSuSe 13.1 (64bit) from 2.6.7 to 3.0.5. But it fails at the second step of the upgrade guide: ...
2
votes
1answer
50 views
SQL server restore readonly file group without backup from .ndf file
We have SQl Server database with ReadOnly file group. Common file groups except readonly are backuped regulary.
We restore the database from backup but readonly file group has not restored, its *.ndf ...
3
votes
0answers
39 views
DBCC TempDB Space Usage
We are using DBCC CHECKDB on a VLDB 1TB in size. Previously when on our 2008 platform the check ran successfully on a drive that was 150GB in size for TempDB, but since moving to SQL 2012 and ...
0
votes
1answer
27 views
SQL Server 2012 AlwaysOn Availability Group
We have an application that needs access to the database all the time to work properly and we are planning on deploying SQL Server 2012 AlwaysOn Availability Groups on Windows Server 2012.
We have ...
2
votes
3answers
181 views
cumulative sum of quantity [on hold]
I want to have cumulative sum of quantity of similar category. I know one approach that is given below. Does anyone know the other one?
select category,
product_name,
quantity,
...
-1
votes
0answers
14 views
OSTICKET mysql database [on hold]
i am using osticket help desk version 1.9. PHP and MYSQL. since they do not have reports feature, i am designing query to take the details of all report but there isnt any guide on how the tables are ...
0
votes
1answer
18 views
What is the best way to update a Production database with Test instance changes
I have deployed a Mysql database into Production.
As I work on the next release of software I am making changes to a test database. I now need to update our Production system without losing the data ...
0
votes
1answer
8 views
Debugging Postgres error: “could not send data to client: Broken pipe”
I'm running a Django 1.8 site, served by nginx and Gunicorn, with a Postgres 9.4 backend.
When I make lots of data-intensive calls to the site's API in succession, I've noticed about 1 in 100 ...
0
votes
3answers
73 views
Creating one stored procedure for all CRUD operations
I'm very inexperienced at writing stored procedures with conditional logic and I could really use some help. I have a data model with 7 tables and I'm trying to write a stored procedure for each table ...
1
vote
2answers
28 views
Why is replication stopped?
Got the following nagios alert this morning for our MySQL replica:
14:49 PROBLEM: mysql2/MySQL replication check is CRITICAL, 10.1.0.133 is 72870 seconds behind, Aug 09, 21:49 UTC
When I look at ...
1
vote
1answer
120 views
PostgreSQL: How to get a sum of values and the total rows that went into each value? [on hold]
I have a table, MyData in the following format:
|id|theme_id|priority_id|value|
I am trying to get the following result for all the rows:
theme_id | priority_id | total | sum
...
1
vote
0answers
14 views
Oracle Enterprise Manager - stats split by user (schema)
Is there any way to split all the stats by user (schema) when looking at the Performance tab in the Oracle 11g Enterprise Manager?
or effectively some other tool to retrieve that information - e.g. ...
3
votes
1answer
39 views
Remove mixed extents in SQL Server
In SQL Server you can make sure that the engine uses the whole extent for a single object (i.e. a table). I know how to enable the trace 1118, but that only applies to newly written data as I recall.
...
0
votes
0answers
25 views
How should massive effect update queries and scripts be performed?
I have some MongoDB databases in production (at a Mongolab AWS deployment) for which I've sometimes required to apply queries or scripts effecting on whole collections.
As collections got over 20k ...
-2
votes
0answers
42 views
Stored procedure in SQL Server not running [on hold]
I keep getting the following error:
Msg 102, Level 15, State 1, Procedure InsertCustomer1, Line 15
Incorrect syntax near ';'.
The code that I am using is:
SET ANSI_NULLS ON
GO
SET ...
-1
votes
2answers
42 views
Optimize query or split in two queries and process result separately?
I have this DB schema:
As you may notice already there is no relationship between tables and won't be on the future. If I run the following queries I will get a lot of rows per table:
SELECT ...
1
vote
1answer
49 views
How does one identify if Oracle Data Guard is enabled in Oracle database?
How does one identify if the Oracle Data Guard feature is enabled in Oracle database?
If this can be determined by a query, what is the query for finding the same?
2
votes
2answers
36 views
Extracting two particular values from a multi valued column
I have a table SUBSCRIBER and in it the data is stored in a way that bars is a multi-valued column . Different values of bars are stored in different rows with the ID as following :
ID BARS
1 , ...
2
votes
0answers
34 views
Better performance to have nullable columns or an extra table? [duplicate]
There are many ways to get rid of nulls in tables, and I have heard of various reasons to get rid of them, but can anyone show me some real numbers as to how your database might perform differently ...
