1
vote
1answer
108 views

Full backup at 1am, not started by my maintenace plan

I set up a complete set of Maintenance Plan. Full backup of all databases at 3AM. Differential backup at 6h30, 12h30, 18h30 and 00h30. Log backup at each hour, at 45 minutes (1h45, 2h45...) In my ...
1
vote
2answers
1k views

How to restore a “contained” database? [closed]

I recently tried to restore to my local development SQL Server a backup from a network instance. To my surprised I received the following error message: Msg 12824, Level 16, State 1, Line 3 The ...
1
vote
1answer
187 views

parent child records - cascade deletes or transactions?

I'm about to create a parent and child table. In planning how to do CRUD operations on this data, I was wondering what is better design when it comes to deleting data. I'm using SQLite. I know ...
2
votes
1answer
78 views

Wrong results from joining two CTEs

I've had some help to create a query to solve a problem I had and the solution seemed to be to create two CTE's and then join and query them. If I run the two CTE's as single queries each table ...
1
vote
0answers
34 views

Linker Server data import

I have three servers, A, B, and C. Each with a individual database. A and B are linked B and C are linked All queries most be run on server B for security reasons. I have data on server C which I ...
2
votes
1answer
43 views

How SQL Server distributes queries between Database Engine and FTS Engine

When a client submits a query to the database server, then SQL Server and its Database Engine parses, compiles, and execute those queries. But, if the client's application submits a query which ...
0
votes
0answers
26 views

is it possible to get the lost data deleted from rails console?

The command I ran in rails console is Product.delete_all("id > 44 AND id < 51") Is there any way to get the records back? Thanks
1
vote
0answers
36 views

Quorum disk conundrum

I'm working on a problem for one of my company's clients where they are having a problem with their 2-node active-active cluster and which has been failing over lately but not bringing resources back ...
1
vote
2answers
101 views

Is this db/table structure sensible?

I'm not very experienced in database design so bear with me. I've taken over a ruby/rails app. with a connected MySQL/innodb database. As I'm updating the server to the latest ruby/rails version I ...
2
votes
0answers
152 views

MEMORYCLERK_SQLOPTIMIZER in SQL 2012 Memory usage extremely high and causes server to crash

I have been having issues with our SQL server for a while now. It seems to run out of memory every few days and when I look at the memory dump, the MEMORYCLERK_SQLOPTIMIZER seem to take over memory ...
2
votes
1answer
249 views

sp_GetAppLock slow performance unusual behaviour

We had a critical issue yesterday where by a 1 second stored procedure started to take minutes to execute. I don't know the business logic as of yet, however want to understand the impact of using ...
2
votes
1answer
503 views

Remove duplicate records from table, leaving one copy

I have inherited a MySQL table from one of my colleagues, and am in need of a little advice. The table has the following structure: | PHONE_NO | ACC_NO | GET_MAIL | DATETIME_CRE | INT_ACC |...
0
votes
2answers
38 views

Mysql query is using some other index

We have 2 tables: CREATE TABLE `allcallers` ( `id` varchar(50) NOT NULL DEFAULT '', `company_id` varchar(50) NOT NULL, `clid` varchar(30) NOT NULL, `clid_raw` varchar(50) NOT NULL, `uid` ...
1
vote
0answers
39 views

Replication Data Issue

After configuring replication all the data from tables has replicated from publisher to subscriber. Now my requirement is whenever I insert new record in publisher only that record should replicate ...
3
votes
2answers
188 views

Index Seek on SQL Server

Sorry folks if this sounds obvious. But does index seek always work on index pages not data pages? If so, which I think it is, it can only be used on its own if the output list are the same as index ...
1
vote
0answers
81 views

Innobackupex restore steps from 1 incremental and multiple incremental steps

My current backup plan is: Full -> Incremental1 based on full -> incremental2 based on incremental1 -> incremental3 based on incremental2... Please validate if this steps is correct during emergency ...
0
votes
1answer
178 views

Getting error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value [closed]

I am getting the error The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. for the following query. After checking some questions here I was able to know ...
3
votes
2answers
491 views

Setting shared_buffers in postgresql.conf does not seem to take effect

We're on CentOS release 6.6, PostgreSQL version 8.4.20. (Yes, this is not bleeding edge.) In postgresql.conf, we have: shared_buffers = 4096MB kernel shm values are set nice and high: [root@green ...
2
votes
1answer
84 views

Difference between clustered index and partitioning column

As I understand partitioning, the column that you partition on is how things are divided into partitions. But does the partitioning column have anything to do with order on the disk? (Aside from ...
1
vote
1answer
127 views

How to determine if a mysql binary log file is empty?

In order to determine whether a database backup is needed or not, I'm trying to see whether a mysql binlog file has any data in it. (During a backup, we make a fresh binlog file and record the ...
0
votes
0answers
59 views

SQL Server Phantom Login

I have log shipped a database from one SQL Server 2008 R2 server to another in standby mode for reporting purposes. Permissions are granted via a Windows AD Group called DOMAIN\DB Access Group which ...
0
votes
2answers
62 views

is Master-Master replication ok for me?

I have two separated locations connected by a not too reliable VPN. I have a common system that depends on MYSQL that read/write tables. Will master-master replication keep both locations in sync? I ...
1
vote
1answer
91 views

RDS Postgres Peformance

I have recently set up a new RDS instance to test out working with a AWS postgres instance vs a heroku postgres instance. What I've found is that when I load an instance of 1000 entries in RDS its ...
2
votes
1answer
169 views

Filtering by minimum value per group problem

I have a select statement, which when simplified produces the following: +------------+----------+-----+ | Group | Name | ID | | vegetables | potatoes | 1 | | vegetables | carrots | 6 |...
0
votes
1answer
140 views

Result occurs often with fast random select query

I have this query to display 4 random photos on a website (I have it from here (when I asked for something faster than ORDER BY RAND())): (SELECT `p1`.`id`, `p1`.`url`, `p1`.`hits`, `p1`.`...
1
vote
2answers
41 views

Is checking for optional characters required in mysql REGEXP?

I have a few rows, in a users table with a name column: SELECT name FROM users; +--------------------+ | name | +--------------------+ | Administrator Core | | Marketing Guy | +----...
5
votes
2answers
9k views

ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'

I am trying to grant privileges for a user to a new database mysql> grant all on db_test.* to 'user_test'@'localhost' identified by 'usersexistingpassword'; I get the following error ERROR 1054 ...
4
votes
1answer
208 views

Column Store Index over an clustered index (created when primary key is declared) - SQL Server

When a clustered index is created, the table itself becomes the index structure sorted by the index key. Imagine now that we have 5 columns in a table XPTO (a,b,c,d,e) and "a" is the primary key and ...
3
votes
1answer
237 views

Partially contained databases and Windows Logins - best practices?

In versions of SQL Server prior to 2012, in order for anyone to log in to a database using Windows credentials, you first had to create a server-level login, them map that login to a user for each ...
0
votes
2answers
68 views

Can I Show Multiple “WHERE” Filtered Results In A Single Query/Output Table?

I am using Postgres 9.2.4 on Red Hat 6. Tables --------------------------------------- | Table 1 | --------------------------------------- | WorkflowID | DataSet | ...
5
votes
2answers
1k views

Scripting the copy of SQL Server production database to test environment

We are introducing continuous integration on our project and we decided to automate the refresh of our test database instance with fresh production data. I'm currently looking for the best way to go ...
2
votes
1answer
225 views

compare 2 tables with minus with a SDO Geometry shape column

if I have a column like SHAPE: CREATE TABLE SOL_PUBLIC.PUNCTE_PERIMETRU_SIT ( ID NUMBER(10) NOT NULL, NUMAR NUMBER(19), X ...
1
vote
2answers
196 views

DB2 10.5 - When inserting, the database is trying to reuse index keys on GENERATE ALWAYS

I am trying to insert a row into a database table which has a GENERATED ALWAYS primary key column. The table has over 1000 rows, and the primary keys start at 1. When I try to do an insert, the error ...
4
votes
1answer
169 views

Restoring database without worring about partitions

On our our production database there is a partitioned table called FullLog. This is updated via triggers so we know who changed the database and when. Which is a problem for me when I restore the ...
1
vote
1answer
447 views

Using TEXT or even MEDIUMTEXT for all text columns in a MySQL table?

I'm using a PHP script to insert millions of rows into a MySQL. Each of the rows contain a diversity of columns that are very different across the rows. Basically I'm using MySQL as a key-value pair ...
1
vote
1answer
1k views

Oracle cannot connect to SQL developer as sys account

I am trying to connect to SQL developer as sys account. It is always giving the error invalid username/password. When I try to connect it through SQLPLUS, it gets connect with any wrong password also....
0
votes
1answer
273 views

Table partitioning in MYSQL Master Slave

I have to Partition a MYSQL table using Range partitioning. Table is 200M rows big and I have Master/Slave replication. What I want to do is to stop replication on slave, partition the table on ...
1
vote
1answer
66 views

Combining data from 3 tables depending values stored in 1 table

I'm trying to make a SQL query to return values potentially from 3 tables. This will combine all booking information for a booking which can span over multiple days with multiple guests and a single ...
1
vote
1answer
42 views

MySQL: Incorrect binary log format - OFF.000

I have a Percona MySQL 5.5.30 as a master(Debian 6.0.7). I got a weird issue that all my binary logs started saving in format OFF.00* instead of the specified format in .cnf file. mysql> show ...
6
votes
2answers
2k views

Tracking down a stored procedure's parameters after execution

I have been asked to identify a permissions issue with a stored procedure. This stored procedure behaves in two possible ways depending on what values are used for its parameters. exec ...
0
votes
1answer
37 views

Entries with 2 variables. Do I need to make 2 more tables by entries?

In the case of shipment carriers, I have a table with products which price and delay will vary with 2 variables. PRODUCT | SHIPPING DATE | PRICE Carrier 1 | A | B Carrier 2 | ...
0
votes
1answer
65 views

How can i update table when counter reach a specific value? (thread safe) [closed]

I increase a field when somebody click the image. Also i want to update (decrease) customer budget when counter value reach to 1k. It is like that: UPDATE click SET count = count + 1 WHERE ...
0
votes
1answer
121 views

Cross Join and Left Join within a query

I have query which has a cross join and also a left join which produces an error Unknown column 'a.hour' in 'on clause' simplified version of query is like this SELECT b.*,a.hour,c.datetime FROM ...
2
votes
1answer
311 views

unknown variable 'log_slow_verbosity=query_plan'

What is the use of log_slow_verbosity = query_plan parameter in my.cnf ? I got an error when installing MySQL in my machine because of this parameter.
1
vote
1answer
40 views

UPDATE with Nested Query

This is what i've tried UPDATE (SELECT * FROM music GROUP BY songalbum) SET albumID = (SELECT albumID FROM albumList GROUP BY album ) WHERE songalbum = albumList.album this give the error #1248 ...
1
vote
1answer
18 views

incorrect result when filtering by association

I have a docket, which has many entries. I want only dockets, where none of the associating entries contains the text "PENDING". For example, if docket A has 10 entries, and one of those entries' ...
0
votes
1answer
92 views

How to prevent #Error values derived from Nulls in an outer join

Suppose I have two tables to outer join Tab1: ID Nam 1 Joe 2 Moe 3 Flo Tab2: ID Val y w 1 stuff 66 33 2 duff 67 44 and one of the resulting columns is derived -- i.e., it'...
2
votes
1answer
90 views

How to optimize this MySQL query?

Hi can someone help me to optimize this MySQL query, it's taking very long to complete, I have set indexes correctly, but it seems that string operations are slowing this query SELECT vendor_products....
1
vote
0answers
30 views

Why do I get this syntax error? [duplicate]

Here's the create statement pulled out of the database itself for a trigger: CREATE DEFINER=`walkdot_logan`@`67.53.251.66` TRIGGER `wd_artists_bi_trg` BEFORE INSERT ON `wd_artists` FOR EACH ROW BEGIN ...
0
votes
1answer
66 views

Version error while restoring database [duplicate]

Can anybody resolve the issue where I am trying to restore a database to a SQL Server 2008 server from a backup file taken from a SQL Server 2008 R2 server?

15 30 50 per page