All Questions

-4
votes
2answers
43 views

How to List out all the tables on the SQL server which do not have a Clustered index? [on hold]

SQL Query to retrieve the tables on the server which does not have the clustered index.
2
votes
2answers
59 views

SQL Server Backup Job failed multiple times

I am getting the same error as mentioned by Mr.Ali Sql Server Backup Job failed Can anyone please explain the possible ways to fix this error as the backup is failing since 1 month. Here is the ...
1
vote
1answer
22 views

Correlated query Issue [on hold]

In the below query i have 2 tables product and productstatus. In product table I have productId and productName and in productstatus table there are locationid,productid,currentstock and ...
2
votes
1answer
98 views

How Do I Use PowerShell to Get a SQL Server Backup Status?

I need a power-shell script to obtain the following information Name of the database , LastBackupDate of the database and this information should be sent via an email converting the results to HTML ...
0
votes
1answer
24 views

Replication MariaDB problem

I followed the "Mariadb High Performance" ebook and i saw on page 121 has this : The last thing to do is to replicate, from the master node, the debian.cnf file from /etc/mysql/ to the slave one. ...
0
votes
0answers
10 views

ORACLE Query error contains lots of caret at symbols (i.e. ^@^@^@)

I made a query using Oracle DB, and the error contains the error code, followed by several thousand ^@ symbols. This would look like: Error at query 298 ORA-00942: table or view does not exist ...
0
votes
1answer
11 views

Tokudb storage engine as mysql-cluster storage engine

Can we use tokudb storage engine as mysql-cluster storage engine? If can, how? I search over google and found nothing
1
vote
1answer
27 views

is there some way to give me the order in which inserts should be made so all FK constraint are met? [on hold]

I have a mysql 5.6 schema with about 60 tables. I need to write some code (not sure if it will be Sql or java) to populate the data. The schema has lots of FK etc. Is there some good way (I am ...
0
votes
0answers
8 views

Improve processing of data and structure design from flat file to CMS DB (using intermediate DB)

I have a flat file (CSV) that brings me the data I want, but it needs to be cleaned and processed before it can be used, so I built an intermediate Database (MySQL) in order to get the structure from ...
0
votes
0answers
11 views

Simplest way to log in as Oracle user different from schema user and still see all tables,… of schema?

What is the simplest way to log in as user X and see all tables,... of schema Y as if they belonged to X? With an Oracle 11g database, I would like to log into the database using user X but all the ...
1
vote
2answers
42 views

SELECT in federated table is to slow

When i test select * from myFederatedTable (for test there is 50k rows) it take 0.3732 seconds now I have two federated tables with data < 20000 in both tables, and have query like : SELECT ...
1
vote
2answers
34 views

Is a Postgres long-running query aborted if the connection is lost/broken?

If I open a connection to Postgres and issue a long-running query, and then break the connection (e.g., kill the client process that opened the connection), will the long-running query continue to ...
0
votes
0answers
9 views

How to make sqlplus output appear in one line when running using shell script?

For example i have an output as below : exec dbms_stats.gather_table_stats(ownname =>'ABC',tabname=>'XYZ', no_invalidate=> FALSE, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt=> 'FOR ALL ...
1
vote
1answer
19 views

Postgres: modify existing search_path (preserve current values)

Sometimes I would like to extend the existing search path, rather than replace it, say: To start with say it is already set like so: SET search_path TO schema_b, schema_c, public; I want to add my ...
2
votes
1answer
70 views

Filter table before join

I have a stored procedure that populates the temp table #employee_benefits with a list of Ids. This table ends up being roughly 10,000 rows long. The query below then selects from a table called ...
2
votes
0answers
53 views

what could be a good value for “Cost Threshold for Parallelism”? [on hold]

I would like to reduce the WAIT time that I have on the CXPACKETS, as you can see on the pictures attached. I believe I could raise the cost threshold for parallelism to 50, because 5 is too low. I ...
0
votes
1answer
55 views

Why is Excel File Opened Exclusively By Another?

I'm creating an SSIS package to loop through a series of Excel files (.xls). I create my while loop container and then create my data flow, which includes an Excel source. When I edit my Excel ...
0
votes
1answer
15 views

Where to put my.ini file for 5.6.21 MySQL Community Server on Windows

I have copied the C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini to C:\Program Files\MySQL\MySQL Server 5.6\my.ini and changed some settings including setting table_definition_cache=400. When ...
0
votes
0answers
40 views

Wait Stats, Server Up Time and CXPACKET

I have been looking at the following post and using the query to look at my top wait stats: http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/ My top wait stat is ...
-3
votes
1answer
35 views

Char in select why [on hold]

In sqlplus query eg: select a.phonumber from customers a where User = 'mark' Why using the character a -- what is benefit? Thanks
0
votes
0answers
26 views

Oracle 10gR2 - fix for SSL version following Poodle attack

We use Oracle utl_http to send https requests from within our database (10gR2). As SSLv3.0 is now considered insecure (POODLE) we need to upgrade to TLS. How can we ensure TLS usage when sending ...
0
votes
1answer
20 views

Query perfomance with multiple JOINs on MyISAM-based DB

I'm working with Enron Email Dataset in MySQL database. After I executed data import from dump-file into MyISAM-based DB, I got the set of tables without any connections between them via foreign keys. ...
0
votes
1answer
20 views

MySQL UDF - wrong ELF class: ELFCLASS32

I'm having a problem creating a MySQL udf on my server (I was able to do it locally on OS X). I am compiling it like this on the server: gcc $(mysql_config --cflags) -I /usr/include/mysql -I. -shared ...
6
votes
4answers
481 views

Does SQL Server ever delete old error log files?

I know I can cycle the current error log easily by running sp_cycle_errorlog, but I'm wondering if SQL Server will ever delete the old/archived error log files at all. Can't seem to find an answer to ...
1
vote
1answer
20 views

Most efficient way to cascade delete in MySQL

I have several 1-to-many FK relationships in my MySQL schema, with tables as follows: AGENCYS 1-*> ROUTES 1-*> TRIPS 1-*> STOPTIMES At present, there are roughly 1300 agencys, 16000 ...
0
votes
1answer
17 views

How can i make dump of big mysql table?

I have server with db(36Gb data), only mysql access. When i'm trying to use mysqldump utility, i get connection timeout(or something like this). I doesn't have ssh access for copy /var/mysql/data. ...
-2
votes
0answers
11 views

create table and insert to tablespaces

So, I have this statement CREATE TABLE JURUSAN ( ID_JURUSAN SMALLINT NOT NULL, ID_FAKULTAS SMALLINT NOT NULL, JURUSAN VARCHAR(60) NULL, PRIMARY KEY(ID_JURUSAN), INDEX ...
2
votes
1answer
96 views

Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)

We have some code that pages through a SQL result. (Currently running on SQL Server 2008) We notice that when paging is done, some rows are not returned. Let me clarify this a bit: nHibernate ...
2
votes
1answer
13 views

postgresql - a local replication entry doesn't work

Maybe it's just too early in the morning, but I can't seem to get pg_basebackup working for a local user. This is part of testing for an hourly backup automated script. I added a line to pg_hba.conf ...
0
votes
0answers
21 views

Expdp with metadata_only gives way too large dump. Why?

There is an oracle 11g schema with amount of data about 700 Gb. There are tables/indexes only in that schema, no procedures/packages. Doing expdp on that schema expdp schemas=TheSchema directory=dir ...
1
vote
2answers
92 views

Currently all connections getting “Timeout expired”

I have an application which connects to SQL Server. Currently I am getting, Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because ...
2
votes
3answers
171 views

SELECT all substrings (n-grams) of length n?

How could I select all n-grams, ie. substrings of length n from a string using SQL? For example, the 3-grams of string example are exa, xam, amp, mpl, ple. I'm using PostgreSQL to be more precise.
1
vote
1answer
53 views

WITH RECOMPILE option in SQL Server [on hold]

When you have multiple connections concurrently trying to execute the query by using different parameters in the filter condition with recompile option, Is there are any chance that it may produce ...
1
vote
1answer
31 views

many Servers of SQL server 2012 needs mirroring

I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database. My questions are: How can it automatically change host of one if the other one was dropped ...
1
vote
1answer
13 views

many Servers of SQL server 2012 needs mirroring [duplicate]

I have now simply 2 SQL Server 2012. I want to configure database mirroring between the 2 servers. My questions are: How can it automatically change host of one if the other one was dropped ? Is ...
1
vote
2answers
54 views

Need help about normalizing database to 3NF

I am currently working on a city travel guide application which let users explore places and plan trip. In the account module, the following functions are to be considered: User can register by ...
1
vote
0answers
13 views

How to keep the sync active with Bucardo

I have a master-master sync setup between 3 nodes or 3 different host machines using bucardo. All works good. However when one of the database or a host is not reachable or goes down for some reason, ...
2
votes
2answers
43 views

Postgresql and UTF8 to Latin1 conversion?

We have a Postgresql database where the data is in Latin1. Apparently someone loaded some UTF8 encoded data into it since when I select data from some of the columns, I get stuff like: SELECT ...
0
votes
1answer
8 views

Running identical queries in sysbench

When benchmarking using sysbench and utilizing concurrency (multiple threads) for example on a table with 1,000,000 records, does sysbench run "identical" queries in a loop on the table?
3
votes
2answers
211 views

Physical Server or a Virtual Machine SQL Server?

Is there a anyway to figure out via a SQL Script to know whether SQL Server is running on a Physical Server or Virtual Server ?
0
votes
0answers
9 views

What are the advantages and disadvantages of Firebase for a database?

I am currently developing a site to track credits gained from exams, and how these stack up against the user's goal credits. I am looking for a database system that will store all the possible exams ...
3
votes
0answers
70 views

SQL server 2014 locks up on insert query, while SQL server 2000 runs fine

One of the applications I am supporting, is running into a weird issue. In a particular page, there is an insert query. INSERT INTO TBL_Parts_In_Arrival_Details ( PIAD_Parts_In_Arrival_Detail_ID, ...
0
votes
0answers
29 views

Which bitness of MS SQL Server Express will be compatible?

I need to install MS SQL Server Express on Win 7/64 but I must have MS Office 2010/32 installed. would I be correct in assuming I must use the 32 bit version of MS SQL Server Express because I must ...
-1
votes
0answers
113 views

Please help me, bro/sister? [on hold]

what can i do if oracle XE service instance status is failed ? like this picture :
0
votes
1answer
39 views

SQL Query - How do I Select Into new columns

I'm trying to write a query that will put values in three different columns. I have the query pulling the information I need, I just don't know how to split the values out into different columns. ...
0
votes
1answer
24 views

PostgreSQL Auditing Tool [on hold]

Does PostgreSQL 9.3 have any auditing tool that close to Oracle Audit Vault? Audit Trigger, pgaudit or Cyan Audit look behind than Oracle Audit Vault.
-3
votes
0answers
20 views

Database information [on hold]

Where should I put all the database? Where do you put it as a reference? I am not doing this I haven't begin but, I need to know where does it go I can't save it in a desktop that's why.
2
votes
0answers
31 views

AFTER DELETE trigger will not fire during a cascade delete

I've got two tables, corresponding to Nodes in a graph and Aisles to which they may belong. In addition, each Aisle has a Node at which it starts and ends. Aisle Table: Aisle char(4) Start_Node ...
1
vote
1answer
32 views

How to recover a database from a failed Availability Group?

We are currently testing a SQL Server 2012 AlwaysOn HA implementation where we have 2 out of the 3 nodes are synchronous. The third, asynchronous node, does not have a vote in the quorum. There is a ...
0
votes
1answer
20 views

Achievement Table [on hold]

I have a table with the offers and I need to relate this table to some requiremnts to get such an offer. For example let's say the offer say 50% of discount on the ticket if you buy 3 cokes and come ...

15 30 50 per page