0
votes
0answers
2 views

How to get past the 5000 row limit in a SQL Server Reporting Services tablix report?

I have a report whose data returned exceeds 5000 rows in a tablix in SSRS 2012. When I Google this, I get all kinds of info concerning settings in Sharepoint, but this instance is running in Native ...
0
votes
0answers
4 views

Why is DistinctSort followed by TopNSort in my query plan?

I have the following definition: CREATE TABLE [dbo].[JobItems] ( [ItemId] UNIQUEIDENTIFIER NOT NULL, [ItemState] INT NOT NULL, [ItemCreationTime] DATETIME ...
0
votes
0answers
12 views

Total number of writes in a day in MySQL

Aside from using standard count queries with a date, is there a global way to get the number of writes (or reads for that matter) in a 24hr period on a table, or an entire schema?
0
votes
0answers
11 views

pgAdmin - Retrieve function's full source code

I would like to retrieve my function's source code. I've tried to obtain it from pg_catalog.pg_proc.prosrc column and pg_catalog.pg_get_functiondef(oid) but it always return a truncated source code ...
1
vote
0answers
12 views

Tuning MySQL MyISAM for large joined updates

I have a database with two tables that I would consider small. I need to update values on the larger of the two tables (1,100,000 rows, 75M MYD, 120M MYI) from the join of the two tables. The smaller ...
0
votes
0answers
17 views

backup only few tables in postgresql

I have PostgreSQL database with more than 20 tables. I need to take backup only certain tables along with schema that should stored as zip. So that i can restore to empty database with tables and ...
1
vote
1answer
44 views

Select Between Date Range Mysql

I want to select records between 2 dates: select * from orders where orders.created <= '2015-07-31'; select * from orders where orders.created >= '2015-07-01' and orders.created <= ...
0
votes
0answers
17 views

Versioning the DB scripts (MySQL)

We are a development team of 4 programmers. In order to manage the DB scripts we created some sort of update script that looks like this: DROP PROCEDURE IF EXISTS our_db.Temp; DELIMITER $$ CREATE ...
0
votes
1answer
10 views

Using mysqldbcompare help

Does anyone know how to use mysqldbcompare from dev.mysql.com/doc/mysql-utilities/1.3/en/mysqldbcompare.html Is it sql query or ...? I have figurate out that it should be used with mysql workbench. I ...
0
votes
0answers
19 views

mysql deadlock issues

we are having starnge deadlock issue. We have a deadlock in mysql and it appears conitously when we run engine innodb command. the webserver it is comming from do not exist as we have manually killed ...
0
votes
0answers
25 views

How to fetch two column different row values in sql [on hold]

I need emp table column name is ename 'Martin' and 'jones' details and in job column who every working as 'clerk' they both want to fetch Martin and jones are working in different jobs
3
votes
0answers
16 views

Compress backup taken from two different environments take different time to restore

I have two backup files one from Normal SQL Server and one from SQL Server from Azure VM. The restore of these backup files is totally different from each other. Though the database backups are ...
0
votes
0answers
4 views

mlagent: How to export remote task

When creating a new remote tasks via Sybase Central for mlagent, it is possible to import task from file. How to export remote task to a file so it can be imported into another Sybase Central ...
0
votes
2answers
29 views

Getting the last data update time of a specific table in Oracle

How can I get the last update time of table, i.e. at what time the last operation (insert/update/delete) was performed on a table in oracle? I have tried using: SELECT ...
0
votes
1answer
35 views

Select statements during long update

I've a table MESSAGES id (long) | attach_data (image) | ins_date | flag this table contains all messages of my application. During night, my job cleans old attach_data with query update messages ...
3
votes
1answer
19 views

Postgres query plan has high rowcount, slow execution

I've identified this snippet of a query as running at incredibly slow speeds, although it's quite simple. It aims to find all the records in Table1 which don't have a more recent entry in Table2 with ...
0
votes
1answer
23 views

what is the fastest way to restore MySQL database without using dump files

what is the best procedure to quickly restore the MySQL database without using dump files. can any body help me in this regard. Thanks in advance.
1
vote
0answers
32 views

SQL Server Profiler

I had run a SQL trace on SQL server 2008 r2 and had originally saved it to the table format. This table now resides in the database and I was wondering could I export the contents of the table to a ...
0
votes
0answers
9 views

i have a roll_no,semister_id and marks of semister i want to show result like roll_no semister_1 and semister_2 [on hold]

I have a roll_no,semister_id and marks of semester, and want to show result like roll_no , semester_1 and semester_2 [As shown below]
0
votes
0answers
6 views

Oracle 10g, Disable audit

I use oracle 10g(express) database, which I've tried to enable the auditing functionality for it. I failed (maybe not , but i couldn't see any audit information). It was some time ago, and now I want ...
1
vote
0answers
8 views

Table with composite unique cluserted key and non-clustered surrogate primary key

We are running a legacy application which is an OLTP SQL 2008 R2 database having all tables defined as heaps with non-clustered index on surrogate primary key. I am considering introducing ...
-2
votes
1answer
29 views

Performance Testing for Database

Is it possible to make a automatical performance testing in SQL server in the production phase? When data in the database increase you need to gain feedback in proactive approach. I would like it do ...
0
votes
0answers
7 views

Running `gman_servers_set` in PostgreSQL's startup

I've compiled PostgreSQL's gearman extension and now I can connect to a gearman server using triggers and such in PostgreSQL. As you may know, before a job can be registered in a gearman server, you ...
0
votes
0answers
15 views

Why does my SQL Server HAG fail from PRIMARY to RESOLVING and back again?

I recently noticed our SQL Server High Availability Groups failed from the PRIMARY to the RESOLVING state, and then from RESOLVING to the PRIMARY state, without failing to the SECONDARY state. Does ...
0
votes
0answers
11 views

Mysql 5.5 to Mysql 5.6 upgrade Insert query is breaking

Assume column with the following definition product_id INT NULL NO_DEFAULT product_id_nn INT NOT NULL NO_DEFAULT and query insert into table (product_id,product_id_nn) values ...
1
vote
0answers
12 views

MySQL SELECT blocking an INSERT?

Is it possible for a SELECT query to block INSERT / ALTER queries? I have the following (taken from ENGINE INNODB STATUS) on my slave database: ---TRANSACTION 26DA7060, not started mysql tables in ...
2
votes
0answers
11 views

Mysql transaction READ REPEATABLE and READ COMMITTED read view

I've come across something strage using Amazon RDS (MySQL 5.6.23). I had issues when concurrent transactions were locking and then calculating a value from multiple tables. The following is a quick ...
0
votes
0answers
11 views

MySQL - Seconds shown for query run time is incorrect

I came into work this morning, and first thing I noticed is that one of my Slave databases was running behind. I took a look at the processlist and could see that I had the following running. SELECT ...
0
votes
0answers
9 views

Trigger for different database host and remote server in MYSQL

I have two database server running on different host(Old host server,new host server). I want to create trigger i.e. If I insert any new record in new host server's table then that record is also ...
0
votes
0answers
4 views

Could not load file or Assembliy “SecureBlackBox.dll”

Task- To Send csv files to Secure FTP. Problem: Script Task using Third Party DLL for Secure FTP mainly "Eldos" is not able to load dll ,when deployed on integration server. Resolution Usually i ...
-1
votes
0answers
6 views

mysql incremental backup using percona [on hold]

Can anyone suggest me what are the pro's and cons of using percona xtrabackup to make incremental backups of mysql database..
0
votes
0answers
18 views

Multi-core PostgreSQL server - how to improve performance

I have a PostgreSQL 9.3.5 server with 8 CPU cores. I've noticed that adding cores to the server doesn't improve its performance. It is probably caused by the fact that Postgres doesn't support ...
-1
votes
0answers
27 views

How to check if all days of the month are in the database

This is my table wys_attendence: id studid adate amonth ayear acls_id attendence 1 28 02 07 2015 10 1 2 31 02 07 2015 10 0 4 ...
0
votes
0answers
28 views

How to tune a stored procedure that is fast on test data but slow in production

If you have a database (SQL server 2012) with testdata in development and preproduction phase and the real from the company's server take place only in the production phase. In other words, the real ...
0
votes
0answers
11 views

PostgreSQL 9.3: Minimize locking when updating a large table with primary key

I am building a DB solution to handle a fast stream of online events. Each event UPSERTs a row in a location_update table, using its car_id primary key. Since there are very few new car_ids, the ...
0
votes
0answers
10 views

UPSERT-ing large batches in PostgreSQL 9.3 on AWS RDS

Consider the following location updates table , which keeps the most recent location update of each car_id. The table has the following columns: car_id - a textual primary key geom - a PostGIS ...
-1
votes
0answers
11 views

simulate “do not match” in postgresql stream replication

I have setup database stream replication using pgqadm & londiste. I use comparison script provided in https://wiki.postgresql.org/wiki/Londiste_Tutorial_%28Skytools_2%29#Launching_replication I ...
0
votes
1answer
14 views

Extract four digits from a column by regexp

I am sitting on a database where one column contains two data types ;) Example "1";"When the Wind Blows 0275";"James Patterson " "4";"The Reluctant Fundamentalist 1026";"Mohsin Hamid"; The ...
0
votes
1answer
22 views

Deleting near duplicates based on one varchar field

I'm getting around to cleaning a database but I need some help with deleting near duplicates in MySQL database but is only off by one character in a column. I've searched and found ways to remove ...
0
votes
0answers
14 views

Compare values between columns in different tables

I have two tables that looks exactly the same: CREATE TABLE `_sync_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `object_name` varchar(45) DEFAULT NULL, `sync_time` datetime DEFAULT NULL, ...
1
vote
0answers
8 views

Move database from windows server 2003 to windows 7/8?

I am working with this company currently running their SQL Express database in a virtualized Windows Server 2003. What would you experts say about replacing that for a virtualized slimmed-down ...
1
vote
0answers
17 views

Caching impression counts to avoid mysql inserts

We currently get a LOT of mySQL inserts/updates on duplicate daily (millions) and we're looking at speeding up the application by using some form of counter with memcached and then clearing it on ...
2
votes
0answers
6 views

Caching impression counts to avoid mysql inserts

We currently get a lot of mySQL inserts/updates on duplicate daily (millions) and we're looking at speeding up the application by using some form of counter with memcached and then clearing it on ...
-1
votes
0answers
34 views

HAVING Clause syntax question

Can a sum be computed using a case statement inside the HAVING clause of a query? something similar to this: GROUP BY id HAVING SUM(CASE WHEN date1 BETWEEN DATE_SUB(date2, INTERVAL 30 DAY) AND ...
1
vote
0answers
37 views

Denormalization vs Cached Data [on hold]

I'm in a dilemma about denormalization of the database vs. caching the joint query results of the database. We have 2 tables. Let's say A and B. A may have many of Bs but B can be belong to only one ...
3
votes
0answers
29 views

Complete deadlock on PostgreSQL 9.3 after removing a numeric id

The problem - complete DB lock after a schema change Architecture I use a PostgreSQL 9.3 with PostGIS to store location updates. The updates are written to two tables - location_updates and ...
2
votes
0answers
28 views

How to store data where various subcategories have specific columns?

I'm new to database designing. I'll use MySQL and PHP. I'm designing a database in which I have a lot of categories and subcategories like given below: Product Table p_id p_title category_id ...
0
votes
0answers
22 views

Tables not updating and deleting the entries

I am facing the below problem on updating the tables ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB Main thread process no. 2376, id ...
0
votes
0answers
19 views

Performance Issue on Centos Server (Mysql)

I have performance issue on my centos server (vps). I asked about it in serverfault and I was said there is a problem with mysql and ask here. Here is serverfault topic, you can find details. ...
2
votes
1answer
87 views

Database Backup - In Process - Power Outage

I am using SQL Server 2008 R2. What happens if a database backup (Full/Differential/Transaction Log) is in process and there is a sudden power outage or the system crashes? Does that corrupt the ...

15 30 50 per page