0
votes
1answer
26 views

Fast migration of field in MySQL

Right now I have the following tables items name (varchar) category (varchar) id ...etc I want to create a categories table and items_categories mapping table so i can start tracking categories ...
4
votes
1answer
287 views

Secondary replica indexing

I have a question, about a question, that is part of the 70-462 Microsoft exam. I had this question today, and I'm not completely sure of the correct answer. While I did pass the exam, I would like ...
-1
votes
1answer
36 views

Retrieve Column name as Data [closed]

Based on this code below from adventurework, I would like to display the name of the column as a data in the first row and the remaining rows are data of the column. I do not know how to do it. ...
2
votes
0answers
183 views

SELECT stuck giving results from the query result cache, though table has changed

A process that runs every two minutes or so started to misbehave. We noticed it was because the cursor fetched repeatedly 0 rows, even if indeed there were new rows satisfying the conditions in the ...
1
vote
3answers
528 views

Is it possible to change recursion level of a CTE in a function?

I have created a function that takes a string and it returns a table with the position and character of each letter in the string. However as CTE recursion is limited to 100 levels, it fails if a ...
6
votes
3answers
1k views

Get MS SQL Server to release disk space

A poorly managed database table has grown to be enormous. 48+gigs of orphan records. I am trying to clean it up and put my dangerously full hard drive back to a normal state. I will be deleting approx ...
2
votes
1answer
670 views

Why do these concurrent MySQL inserts deadlock?

I am baffled by this deadlock: ------------------------ LATEST DETECTED DEADLOCK ------------------------ 150511 18:42:43 *** (1) TRANSACTION: TRANSACTION B8972CA4, ACTIVE 0 sec inserting mysql ...
0
votes
1answer
32 views

master slave crashing daily

I have implemented a master slave config several times and each time the process goes well and works for a day or two but soon bombs out saying that replication stopped because such and such table ...
0
votes
1answer
613 views

ndbcluster: Error: 1114, The table is full, when using table

I have searched for a while about this error. I have a MySQL cluster running with 2 data nodes. The cluster houses a few other databases. I have a dump of a database in --tab format from another ...
1
vote
3answers
389 views

secure way to connect with remote Mysql database

I created my application using MySQL and it relies completely on the database I have around 190 tables, and I'm afraid of security breaches and another problem is for remote access I have to add the ...
0
votes
2answers
811 views

No suitable driver found Orientdb jdbc driver

I have some problems with Orientdb driver for jdbc. i´m using Netbeans, i have include the library JDBC+OrientDB libraries (orientdb-jdbc-2.0.8-all.jar) in the directory and in netbeans, i have also ...
1
vote
0answers
48 views

Statement succeeds, data missing [closed]

I have two reports from the same customer, where they claim that an error occurred that implies a SQL Statement didn't execute. These are very simple statements, setting a value in a single column. I ...
0
votes
0answers
68 views

Deep cloning a hierarchical database structure

I am trying to clone a hierarchical structure in my database, and I almost have it working; however I can't seem to get the output clause to access a column from a select statement. This is generally ...
0
votes
0answers
289 views

Plesk 12 Debian 7 MySQL CPU usage is too high

I have a problem with MySQL and MySQL CPU usage at Plesk. I have a news site with Joomla, and about 100-150 online user. CPU: AMD Opteron(tm) Processor 6366 HE 3 core Memory: 4GB HDD: 250 GB Plesk 12 ...
0
votes
1answer
971 views

Invalid object name 'sys.dm_os_volume_stats'

I am trying to select 15% of disk space available in a server. SELECT DISTINCT s.volume_mount_point [Drive], CAST(s.available_bytes / 1048576.0 as decimal(20,2)) ...
4
votes
1answer
233 views

Tempdb change settings and recommendation

In my production database I have below configuration in TempDb and needless to say I am facing a lot of IO issues on the drive . So, as per recommendation I am planning to change it Change #1 ...
3
votes
1answer
417 views

Pagination performance, with subquery, inner join and where

I am trying to optimize following query (this is most simplified version I could came up with): SELECT tr.Id, StatusDate FROM ( SELECT tr.Id, tr.StatusDate FROM mon.ArchivedTaskResults_201504 ...
1
vote
2answers
57 views

Mysql Query for Multiple table

I have two table question and answer. The structure is given below CREATE TABLE IF NOT EXISTS `question` ( `id` int(10) NOT NULL, `question` varchar(100) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 ...
2
votes
1answer
144 views

Postgresql performance issues when issuing many small inserts and updates one at a time

I have a production web server with postgresql database. My server gets data from another server every hour on the hour. The other server wakes up and sends many requests to my server, each result in ...
0
votes
0answers
613 views

DB_STARTUP blocking on spid 7

I have a sql server 2012 instance that I'm installing a new license on that had previously had an evaluation license. I've did this on two other servers with out incident, but this server is giving me ...
0
votes
3answers
1k views

Oracle database not open and ORA-00600 error

Whenever I try to open Oracle, I get following error : ORA-01109: database not open So as suggested by various blog and forum, I tried the following series of commands c:> sqlplus /nolog ...
0
votes
0answers
84 views

Temporary tables and Fetch times

We've noticed something curious in our office which no one seems to know the answer to. I'll explain: We have some mildly complex queries, one of which executes in under 3 seconds and then has a ...
0
votes
2answers
753 views

How to calculate mysql server reads per second,writes per second?

Can anyone let me know how to calculate mysql server writes,reads,deletes,updates per second.
0
votes
1answer
185 views

SELECT ROWS WITH SIMILAR ID AND MERGE THE FILED VALUES IN ONE

My situation is as follows. I have the query below and the query is doing its job pretty well. However I have excluded one able from it which is field_data_field_luogo and the rows inside this can ...
1
vote
0answers
95 views

Mysqlfailover command - No slave is listed in health status

I have suuccessfully created replication using GTID_MODE. It works perfectly. Now i need to setup automatic failover feature in it. I have run the following command. "mysqlfailover ...
1
vote
0answers
1k views

How to display all the dates between multiple two dates in a table?

I want to display all the dates between two dates for a particular record And this is the table : ID Start_Date End_Date 1 2013-01-14 2013-01-18 2 2013-02-01 2013-02-04 and now i want to get all ...
0
votes
2answers
763 views

MYSQL Row Count Limits?

What is the maximum row count for a table in MYSQL? I have a system with around 600,000,000 rows in three tables. Average Data Length (from data_length column) for these tables is 58,000,000,000 ...
0
votes
1answer
36 views

How to remove some data not needed on new row from mysql query with rollup

Hello I have a problem with the rollup mysql query. I want to get total of each column. I use mysql SUM() and ROLLUP to get the result. But on the new row that is added it copies the data of the last ...
-2
votes
1answer
42 views

Replace date function call with its functionality [closed]

I have zero knowledge of postgresql somehow I have to extract data from a postgresql database I am trying to replace function call in a query with its functionality. Function: -- Function: ...
0
votes
1answer
131 views

Saving SQL Server DMV's for later use [closed]

Is it possible to save DMV's in SQL server database backup, which can be restored on different server, I mean with master db details( views and all)? If not, what's the best way to maintain 2 ...
4
votes
1answer
221 views

Large Transaction Backup

On my SQL database I run a full backup at 6am and transactional backups every 15 minutes on week days starting at 8am. Every Monday the first transactional backup is 7 Gb. I want to know why, my ...
0
votes
1answer
885 views

Oracle RAC, unable to connect to node vip [closed]

I have a new oracle RAC installation running 11.2.0.4 on redhat 6. I can connect to sqlplus from a client using the node name but it is timing out when i use the node vip eg. first one works, second ...
0
votes
1answer
41 views

I need to select random groups of data

I am working on a query that requires the retrieval of 20 random rows from a cash book table, which I am doing using 'Top 20 & order by newId()'. Let me explain: The cash book table is a list of ...
0
votes
0answers
155 views

CREATE OLAP server

I have a MySQL database server along with replication server, i.e. OLTP system altogether. As I have very heavy data fetching queries for the decision making reports. I need to create data-ware house ...
0
votes
1answer
44 views

Unable to configure oracle 11g net server

I installed Oracle 11g on my Windows Server 2008 workstation. After I try to configure oracle net server with port number 1521. But ONS error say to me as "Use another port number. This port is ...
0
votes
0answers
455 views

slave mysql server crash : mysqld got signal 6

Hi I am trying import a mysql logical backup file on server A.Server A and B are in master slave configuration and both running on same unix server.slave is running while import is in progress.Due to ...
1
vote
1answer
487 views

Compact Spool file from Sqlplus

I have scripts that I run in Oracle SQL Developer and then export the result to my pc as a csv. I now started using sqlplus with a .bat to run my scripts and spool the result to my pc. But I noticed ...
0
votes
0answers
446 views

Firebird Guardian

Is there an opinion on running Firebird Guardian. According to the FAQ - The Firebird FAQ: On Windows, having guardian running can even be counter-productive as it would run fbserver.exe ...
0
votes
1answer
48 views

Database Default Locations doesn't persist

When I set the default location for the Data & Log in the Server Properties in SQL Server 2012, and click Ok, it resets back to the previous value immediately - if I reopen the Server Properties, ...
2
votes
1answer
203 views

MySQL: Why statement-based binlog format cannot work with Innodb READ UNCOMMITTED or READ COMMITTED Isolation levels?

In MySQL documentation it's written: If you are using InnoDB tables and the transaction isolation level is READ COMMITTED or READ UNCOMMITTED, only row-based logging can be used. Why ...
1
vote
2answers
1k views

Naming The SSRS Report Name based on the Parameters Passed

I want to save my SSRS Report Based on the Parameters Passed. i.e. Am passing P1 And P2 as parameters so I want my SSRS Report name as P1_P2_ReportName.Xtension. Any suggestions?
0
votes
1answer
96 views

Why temdb and log file size is not reduced by SQL Server

With a series of question Part1, Part2 and Part3. With the answers and research on internet I came to know that TemDb is use for holding different values (ex.: Temp variable, Temp table, CTE, Hash ...
4
votes
3answers
164 views

MySQL JOIN query produces wrong result

I have two tables complaints and complaints_reply in my MySQl database. Users can add complaints which are stored in complaints the complaints reply are stored in complaints_reply table. I am trying ...
2
votes
1answer
125 views

Is there any name for common sense / knowledge integrity constraints?

The Wikipedia page on data integrity lists 4 types of integrity constraints: entity integrity, referential integrity, domain integrity, and user-defined integrity. Is there a name for integrity ...
0
votes
2answers
1k views

unable to run postgres with pg_ctl

I was reading a postgresql book (PostgreSQL from Novice to Pro) and it says you can start the postmaster daemon by invoking the postgres binary which was part of the installation: ...
1
vote
1answer
587 views

Failed installation of SQL 2012 on Windows Server Core

I'm in the process of building the lab for 70-462 exam. On page 49 of the text, it provides the command to install SQL 2012 on Windows Server Core: Setup.exe /qs /Action=install ...
2
votes
1answer
69 views

Can't create an Availability Group with Powershell when instance uses non-standard port

I am trying to create an Always On Availability Group with PowerShell, something I have done many times before but am hitting an issue now that I am using non-standard ports for the SQL Instance I ...
0
votes
2answers
300 views

Index on Column with only 3 status?

I have a table with millions of rows. This table has a column which we frequently filter(means we use it in WHERE clause frequently), the values are Insert/Update/Ignored. Is it make sense to add ...
0
votes
1answer
69 views

Having four different tables or having one table with one more field?

I have a website with 4 translation (That is Arabic with 4 different Persian translation), and I had exported each of these translations to different tables. Which one of these ways are faster and ...
0
votes
1answer
98 views

How to design a main list and sublists schema

I am finding it difficult to design a database schema for a list feature. there would be a master list which then can be subsectioned into further lists. each user is able to mark a candidate as a ...

15 30 50 per page