1
vote
0answers
28 views

Error when trying to install SQL Server 2012 Ent in to a Server Core 2008 VM

I have a problem that I hope you can help with. I am studying for my 70-462 exam and in order to do so, must setup virtual labs as follows. DC: Windows Server 2008 R2 Enterprise (Full Installation) ...
1
vote
0answers
35 views

UPDATE based on the occurence of the same string within two other columns

I am currently using Microsoft Access 2007. I wonder if there is a way to find whether two specific columns in one table contain the same (undetermined) string. The table may look as follows: ...
1
vote
0answers
20 views

SSIS: Is it possible to process excel file with dynamic column headers

SSIS: Is it possible to process excel file with dynamic column headers. For instance: Excel file has 5 columns and we process that and save data in a table for all the 5 columns. Now, the scenario ...
1
vote
1answer
19 views

SQL Update column with another table column

I'm using Postgres 9.4, and already seen others asking the same (simple) question, but theirs answers do not solved my problem and I can't see why. Suppose that I have these table A with common data ...
1
vote
0answers
42 views

Query to find plan details for a specific stored procedure, searching by name

I'm trying to write a query to find information about query stats and the query plan for a specific stored procedure, but I can't manage to find the right DMV or query to look for a specific stored ...
1
vote
0answers
56 views

SQL Server tempdb high IO

Using SQL Server 2016 Enterprise, having just recently upgraded from 2008 R2. The server has 192GB of memory, 24 logical codes, and is running around 30 databases with a total size of around 500GB. ...
1
vote
0answers
39 views

SQL Server 2012 AvailabilityGroups - Preferred Backup Replica

I currently have a 2 node SQL Server 2012 HA Availability Group setup. Currently we have a number of SharePoint databases that exist in this availability group. I'm attempting to ensure our backups ...
1
vote
1answer
25 views

Move a database (from decomisioned server) to an existing server with heavy ongoing loads

We have a situation where one of our database approx. 60 GB in size with transactions running every 2-3 mins 24*7 has to be moved, since the server it is on is going to be decommissioned. Now, we ...
1
vote
0answers
24 views

Database design - many-to-many relationship between three columns [duplicate]

I'm noob in database. So don't mind if its a silly question.This is used in my application and is the first one. I need a database design for it. value 4 is dependent on the other value 1,2&3. ...
1
vote
1answer
30 views

Incorrect key file for table error. How can I change location of MySQL's temp folder to another part of drive with more disk space?

I am using MySQL with Sequel Pro on a Mac Pro OSX Mavericks and am trying to run the code for a stored procedure in order to add two new columns to a table. The procedure does math operations on ...
1
vote
1answer
33 views

DELAYED User at MySQL

mysql> show processlist; | Id | User | Host | db | Command | Time | State | Info || 27098 | DELAYED | localhost | ...
1
vote
1answer
39 views

Impact of OS timezone change on Postgres Database

I want change OS time zone to UTC. This will shift back time by 2h. Can this possibly damage data in any way (for example overwrite data)? What should I do to safely change the OS time zone?
1
vote
0answers
26 views

SQL Server 2008 : Agent's scheduled jobs [closed]

I have a situation with some of the scheduled tasks when they are completed a messages appears on the activity monitor that reads performing completion action and in some cases it is taking very long ...
1
vote
0answers
39 views

Sybase IQ identify hot partitions

I need to identify hot partitions of Sybase IQ table (Sybase IQ 16). In Sybase ASE i can use MDA tables (monOpenPartitionActivity), is there any way to measure logical, physical reads for individual ...
1
vote
4answers
43 views

20 mysqld processes using only 1 port?

These are from Aliyun Cloud DB Servers,20 mysqld processes using one 3306 port Has anyone seen this before ? Can anybody explain how to do that ? Are there any advantages to this ?
1
vote
0answers
12 views

I cannot fetch the value of a mysql alias [migrated]

I have the following code: $query = " SELECT distance, outcodepostcodes.lat, outcodepostcodes.lng FROM ( SELECT $table.*, outcodepostcodes.lat, outcodepostcodes.lng , outcodepostcodes.lat*3 AS ...
1
vote
1answer
35 views

what is oracle universal installer in oracle database products

I am new to oracle database products. I am planning to install oracle 11g express edition in my PC,it looks like a standard installer.But in many of the oracle database installation tutorial mentions ...
1
vote
1answer
43 views

Accept remote TCP/IP request from aLL IPs in SQL server

I have problem with access to SQL server with TCP/IP. I would like to SQL instance accept client from all network adapter that machine has. I go to configuration manager console and enable TCP/IP, ...
1
vote
1answer
32 views

Securely manage and dynamically create multiple databases

Background I have inherited a system that has several hundred databases. The primary "Clients" Database represents all clients with several tables like: WebUsers = username | password | server_id ...
1
vote
0answers
38 views

SQL Server 2012 failover cluster node won't start cluster services

We have 2 node SQL server failover cluster setup in our environment. Node2 SQL server machine got shut down. I turned it back on and connect back to the failover cluster. It successfuly connected ...
1
vote
1answer
12 views

help me to migrate single myslq5.6 server to mysql5.6 Cluster, follow this error! [closed]

I try to migrate a single myslq5.6 server to mysql5.6 Cluster. I do not understand why I get the follow this error: ERROR 1297 (HY000) at line 1 in file: 'load_dept_emp.dump': Got temporary error ...
1
vote
1answer
31 views

Restrict access to Edition- or instance-specific databases

I have the following issue with SQL Server. On my Windows Sever, SQL Server 2008 Express Edition is running. Now I have installed SQL Server 2008 Web Edition on the same server. My problem is, when ...
1
vote
0answers
23 views

Windows Domain User with Admin privileges cannot access a drive with full permissions in psql

I have installed the standard PostgreSQL 9.5 from Enterprise DB with a domain-level postgres user who has domain-level admin group membership. I have explicitly added full permissions for this user to ...
1
vote
1answer
52 views

Why can not user set current schema to SYS?

See the example bellow. User is created with dba (but not sysdba) privs. He's allows to access v$session (which is public synonym to view in schema SYS, having different name). When executing alter ...
1
vote
0answers
10 views

Plpgsql function array plus replace

Please be indulgent to my question, 'cause I am newbee at plpgsql/sql. :) I need to do a replace in table and the insert 'replaced' data in the same table. How to replace some values using array with ...
1
vote
1answer
22 views

Postgres latency issues during memory compaction on EC2 (Ubuntu 14.04)

We've recently upgraded our EC2 instance that hosts our Postgres database to an i2.8xlarge with 244GB of memory (this is to utilise the large amounts of ephemeral storage it comes with). Since ...
1
vote
0answers
25 views

Question about MySQL triggers performance [duplicate]

I currently have a database that stores some transactions for several users, for example purchasing or selling products is stored as 1 entry in the transactions table. It can also store profits made ...
1
vote
0answers
17 views

Mysql to MS SQL Migration and synchronization

Database migration from MySQL to MS SQL using SSMA tool is very nifty, however, I have one question around this. I have 2 MySQL Db's want to migrate to MS SQL, one sizes around 850 GB and another one ...
1
vote
0answers
43 views

SQL Server 2012 database stuck restoring

I'm trying to restore my development database DEV with a backup of my production database PROD. Every time I go through this process, the DEV database gets stuck in a Restoring state. Using the SQL "...
1
vote
1answer
25 views

task eats 100% cpu on Mongodb

I got app server with MongoDB installed. Every 3 hours I run some nodejs script that updates data, and my server consumes 100% CPU and becomes slow. Is there any way to improve that? Can I create ...
1
vote
0answers
11 views

Estimate amount of downtime from RDS backup

I have an Multi-AZ RDS instance. Due to some maintenance I want to create a consistent snapshot of the database during the day, but this means shutting down all our services. I noticed from the AWS ...
1
vote
1answer
59 views

Questions and answers database design for Core Data

I am designing database for a question and answer projects , and I am stuck. I do not know how to do it. Here is information: There will be many users There will be many questions Each question ...
1
vote
1answer
25 views

Configuration.ini file feature codes

I have searched but not been able to find a list of the codes and descriptions available when using the configuration.ini file. Is anyone able to link me some information?
1
vote
0answers
10 views

MySQL replication just hangs, then Database wont shutdown

I have recently set up some new MySQL Databases on a remote site. They are all 5.5.47, running on Debian Servers. They are set up as one Master with multiple slaves. The Master is itself a slave from ...
1
vote
0answers
34 views

Do not want to allow Queries to take more than x minutes?

Do not want to allow Queries to take more than x minutes ! What System variable can I set to automatically terminate it.
1
vote
0answers
21 views

How to ensure NULLed encryption key columns are permanently erased

We are storing BLOB data (call recordings) in commodity cloud storage. These are encrypted and the keys stored in an SQL Server database. I am working on a project to implement "Retention", i.e. ...
1
vote
0answers
27 views

Retrieve data from OLTP MySQL to SQL Server DWH using SSIS

I'm running a BI solution currently reading data from an OLTP SQL Server 2008 to a SQL Server 2012 data warehouse. The ETL phase is implemented with SSIS and runs twice a day. This phase relies on a ...
1
vote
1answer
45 views

Installing SQL Server version 10.50.4000 is failing

I am attempting to install SQL Server 2008 R2 version 10.50.4000 on a virtual machine running Microsoft Windows Server 2008 R2. When I try to install SQL Server, I get an error that, when I look it ...
1
vote
0answers
33 views

How can I have SQL Server send Job Notification alerts to an API

I am trying to get the notifications for a job out of my email and into a chat client(HipChat). So far my googling has been less than successful so I will put the question to the community: Is there ...
1
vote
0answers
29 views

MySQL max connections [closed]

MySQL keeps crashing, but after futher research, I found this error SQLSTATE[08004] [1040] Too many connections but I have this line #max_connections = 100 commented in my.cnf.
1
vote
1answer
42 views

Log and Data Drive Configuration in VM environment

Anyone have any good feeling on how to arrange the underlying disk configuration for a VM (Hyper-V) implementation of SQL Server vs installing straight up on the hardware? For a native Install, best ...
1
vote
0answers
13 views

NuoDB Statistics

I'm currently doing a research using a TPC-H table and I'm trying to get the running time for 3 queries in NuoDB: SELECT * FROM LINEITEM SELECT * FROM LINEITEM WHERE L_PARTKEY BETWEEN 1 AND 80000 ...
1
vote
1answer
38 views

SSRS error - A scope is required for all aggregates in the page header or footer which reference fields

I had the following textbox expression in my SSRS report and it was working fine. = First(Fields!FirstName.Value) +" " + First(Fields!LastName.Value) + ", MD" When I moved the textbox to the ...
1
vote
0answers
16 views

log_bin_trust_function_creators deterministic always throws an error on server restart [duplicate]

Everytime my rackspace server restarts because of some maintenance or an outage, all of my mysql functions stop working due to this deterministic error. To fix this, I have to manually pull up the ...
1
vote
0answers
35 views

Inserting rows into a temporary variable causes plan cache pollution in SQL Server

In my database I use stored procedures to insert multiple rows from a temporary table variable. Inserting data into the temporary table variable causes a new adhoc plan to be created prior to each ...
1
vote
0answers
15 views

SSRS Scale-Out Deployment: cannot decrypt the symmetric key

I have a single 2008 ssrs instance (#1) up and running and need to add a 2nd server also running ssrs 2008 (#2). The error message on the 2nd server is: The report server cannot decrypt the ...
1
vote
2answers
84 views

CMD prompt can't display Unicode characters that are stored in oracle database correctly

I've been meddling with charset/encoding problems of Oracle database, PL/SQL developer and JDBC and these are what I want to achieve: Input Unicode characters from a browser into the database ...
1
vote
0answers
65 views

PostgreSQL Partitioned table update trigger

I have a date-partitioned table (inheritance partitioninng just like the one pg_partman does) which is referenced by quite a few tables in my database. To resolve the FKs checking for referenced field ...
1
vote
1answer
55 views

How to search by text in SSIS packages? [duplicate]

Is there a way to search by text in SQL Server Integration Services packages using T-SQL statement (or other language)? I want to check if certain table is used in any package as I am going to drop ...
1
vote
2answers
33 views

Access to folder is denied (log shipping)

i am trying to log ship from server A to B.I have done everything to configure log shipping but i try to run the job then at Server B while coping backup from server A gives me an error (can not ...

15 30 50 per page