0
votes
0answers
7 views

Dynamic Filters in SQL server

I have problems with my dinamic filter in 'sql server'. I'm new with this. alter PROCEDURE Member_WS @Program int ='', @Card nvarchar(30)= '', @Account nvarchar(128) ='', @Member bigint =0, @Email ...
1
vote
0answers
6 views

Sql Server Services Empty in sql server configuration

As I upgraded from Windows 8.1 to Windows 10, I noticed that the Sql Server Services in Sql Server Configuration Manager is empty. Sql Server still works perfectly well at the moment. Sql(2014 ...
1
vote
0answers
26 views

Using Join to get data from multiple tables in SQL Server

A(a_id, a1, a2) B(b_id, b1, b2) C(c-id, a_id, b_id) Now, I want to fetch all the data of table A, and from table B, I only need a record of b1. How can I use join query in SQL Server to fetch the ...
1
vote
1answer
8 views

Access to Server and Real Data for Performance Tuning [on hold]

I'm newbie in performance tuning (PT) in SQL server and I have read some document about how to do it. It is based on theory from the articles or books. The next step to is to learn about it by ...
1
vote
1answer
19 views

Oracle data dictionary, tell built-in roles apart from custom roles

In Oracle, if you describe the DBA_ROLES view, you only get three columns: SQL> describe dba_roles; Name Null Type ------------------------------------------------ ROLE ...
1
vote
0answers
39 views

Should the PK on an identity column be non-clustered? [on hold]

For a table with PK on an identity column, it will be clustered by default. Could it better be non-clustered? The reason is other indexes will be created for queries. A query which uses a ...
2
votes
1answer
39 views

Stats Maintenance after Restoring to Newer SQL Server

What's the ideal (or necessary) sequence of call when restoring a SQL Server 2012 backup onto a SQL Server 2014 instance and updating the compatibility level? -- Update Statistics for all tables EXEC ...
0
votes
1answer
22 views

How to verify the password generated by ENCRYPT?

I use the ENCRYPT function to generate password for my email users. SELECT ENCRYPT('password', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))) This function will generate a long encrypted string which ...
0
votes
0answers
17 views

Create an AD user from a SQL Server trigger

Running SQL Server 2008 (10.0.5520) - I have a trigger that is executed when a new record is added to the security table. I would like to extend this trigger, and create an entry in the AD system with ...
0
votes
0answers
15 views

Why does this simple insert fail sometimes? [on hold]

I have the following insert which I suspected might be failing frequently. I just tested it manually by making a small series of http requests manually from my browser to execute it, making sure ...
1
vote
2answers
40 views

Inserting emoji - smartphones in MySQL database with PHP?

Well with the the asks from is quite high explanatory will only strengthen the question. APP have a chat system which be late the HTML , send it to PHP with ajax , but the usurer try to insert some ...
1
vote
1answer
10 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 ...
1
vote
1answer
39 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
2answers
32 views

Total number of read/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
16 views

pgAdmin - Retrieve function's full source code [on hold]

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
23 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
21 views

backup only few tables in postgresql [on hold]

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
2answers
87 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
21 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
17 views

Using mysqldbcompare help [on hold]

Does anyone know how to use mysqldbcompare. I use xampp server in mac. Is it sql query or what type of query is it? I have not found any clear tutorial how to use it. What directory i have to be in ...
0
votes
0answers
29 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
31 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
19 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 ...
1
vote
1answer
7 views

Replication with fail over cluster in SQL Server 2014

Presently I am Using Replication Feature in SQL Server 2012 .I want to migrate to SQL server 2014 .I want to use fail over cluster feature .Does it effect the replication feature which we are using ...
0
votes
2answers
32 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
2answers
45 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
25 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
25 views

what is the fastest way to restore MySQL database without using dump files [on hold]

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
38 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
9 views

Table with composite unique cluserted key and non-clustered surrogate primary key [on hold]

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
30 views

Performance Testing for Database [on hold]

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
10 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
18 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
1answer
20 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
1answer
17 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
12 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
13 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
10 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
8 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
8 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
20 views

Multi-core PostgreSQL server - how to improve performance [on hold]

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
30 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
31 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 [on hold]

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
15 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 ...

15 30 50 per page