0
votes
0answers
8 views

Query to extract all SQL database roles with INSERT and/or UPDATE privileges

I've taken over the support for a SQL 2008 database and there are a multitude of custom roles (25+) associated within. I'm trying to figure out which of the custom roles have the ability to perform ...
0
votes
0answers
10 views

max value and min value with date

I'm trying to get max and min values for the current month and dates for these values I'm getting the max and min values but I'm not getting dates for these values, instead I get the first day of the ...
0
votes
1answer
12 views

Clearing Log Shipping config Secondary server inaccessible

We are using SQL 2012 Our Secondary server in a log shipping configuration went offline never to come back (the VM was permanently deleted before log shipping configuration was updated). On the ...
0
votes
0answers
6 views

Install oracle 12c database preinstallation RPM without yum

Question: Is it possible to install oracle 12c database pre-installation without yum? If so how? What I have found on the internet is to use yum, I cannot use yum because the proxy just does not ...
0
votes
0answers
6 views

PostgreSQL: pg_upgrade failing because hstore incompatible

I'm trying to migrate from PostgreSQL 9.4.5_2 -> 9.5.3 I'm trying to use pg_upgrade (from 9.5.3 distribution) and getting the following error: pg_dump: [archiver (db)] query failed: ERROR: ...
1
vote
1answer
17 views

Security and Performance Implications of SQL Tuning Advisor

I work on a relatively small development team that works with an Oracle (11g) database. It's recently been requested that all the developers be given the Advisor role so that we can utilize SQL Tuning ...
0
votes
0answers
10 views

Postgres - Regroup rows with at least one common attribute

I have the following table : Letter | Figure -------|------- A | 1 B | 1 B | 2 C | 2 C | 3 D | 3 E | 4 I would like to group rows that share ...
2
votes
1answer
26 views

Dynamic Parameters In Pivot

I know the premise of a PIVOT() this syntax produces it perfectly for me: Select * FROM ( Select field1 ,annual ,dv As Amt FROM Testing ) x pivot ( SUM(Amt) ,for annual IN ...
0
votes
0answers
8 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

I try to use this on my vps with mariadb: # Optimized MySQL configuration for cPanel servers by Fotis Evangelou - Updated Feb 2016 # # The settings provided below are a starting point for a 4GB-8GB ...
1
vote
0answers
6 views

Oracle 12c Rman Duplicate Archive Log Not Verified

I am trying to duplicate a DB from live to dev but it is failing. Can anybody advise what is going wrong? Both databases are running Oracle 12c. All database files seem to be copied over but it fails ...
-4
votes
2answers
38 views

Extract string from varchar

How I can extract the substring of a string from end to beginning? I have the following text, and I need extract the last "Modificado Por" and the "Creado Por" /* CREADO POR : Wxxwww ...
0
votes
0answers
7 views

What run-time configuration parameters are used for concurrent index creation

Suppose I were to run the following. The first line shows the server's default maintenance_work_mem value. mhildreth=# show maintenance_work_mem; maintenance_work_mem ---------------------- 16MB (1 ...
2
votes
1answer
165 views

Capitalize only the first letter of each word of each sentence in SQL Server

I do want to capitalize only the first letter of each word of each sentence from a SQL column. i.e: if the sentance is 'I like movies' then I need the output 'I Like Movies' Query: ...
3
votes
1answer
62 views

Most useful stored procedures for a new DBA? [on hold]

I am a new DBA working with several more experienced DBA's. When I am scratching my head one of them says "oh just run SP_xx_xx", and sure enough that begins the path to solution. Of course they all ...
0
votes
0answers
7 views

Monitoring streaming replication

We're setting up streaming replication with one master and one (read-only) slave. We're now looking for a way to monitor the replication; mostly to verify that the slave server is still up-to-date. ...
-3
votes
0answers
23 views

if increase table in a database (20 to 20000) on there database performance is effected or not in sql [on hold]

in that time in my database having only 20 table but now our business model change and there need 2000 table in future. so i cant understand that database performance is effected or not.if effected ...
1
vote
2answers
24 views

DBCC CHECKDB consistency-based I/O error

Running: DBCC CHECKDB(DatabaseName) with NO_INFOMSGS gives me the following error: Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: ...
0
votes
0answers
19 views

SSMS Error - Parameter is not valid

I have both SQL server 2005 and SQL server 2008 management studio installed on a windows server 2003 32 Bit. My issues is that both the SSMS opens fine but i face this below error messages when i ...
0
votes
0answers
13 views

What are the general practices considered to constitute a good user id?

I could not settle on a good pattern to generate my user ids for an upcoming project. On what basis are the user ids decided and populated. Would like to know if there are any patterns or formats or ...
0
votes
0answers
5 views

parallel postgres libpq copies with different db connections

At the moment I'm doing bulk database inserts with the libpq copy command (PostgreSQL 9.5): copy abc (col1, col2, col3) from stdin delimiter ";" NULL 'Null'; (PQexec) PQputline PQendcopy I know ...
0
votes
0answers
11 views

Combine WHERE NOT EXISTS with ON DUPLICATE KEY UPDATE

I have 2 tables uz_params and uz_params_exceptions where uz_params is supposed to be updated frequently by an external script. INSERT INTO uz_params (extension, type, subtype, paramvalue) VALUES ...
1
vote
0answers
4 views

How does the use of derived tables speed up sorting?

In the article 45 Ways To Speed Up Firebird Database, it states that Use derived tables to optimize SELECT with ORDER BY/GROUP BY Another way to optimize SQL query with sorting is to ...
0
votes
0answers
16 views

Log shipping with active active cluster configuration

Scenario: We are planning to configure active active cluster for our SQL Server. Both will be having separate instances(A instance on node 1, B instance on node 2). 'A' instance will have Production ...
1
vote
1answer
13 views

SQL Server Integration Services 2012 - Legacy deployment

I'm currently reading a lot about SSIS and I have read that there are now two models for deploying a solution : the one using "Projects" and the one using "Packages". Starting SQL Server 2012, a ...
1
vote
1answer
24 views

Decomposition and lossless joins

If someone walk me though the following questions I'd be very grateful. Consider a relation R(A, B, C, D, E) with the following functional dependencies: A, B → C D, E → C B → D i) ...
7
votes
2answers
208 views

Create a “INTO” table with primary key

maybe for this community my problem is easy, but for me (a simple java programmer) it's a BIG problem. I have a Big DB with more and more data. So, the external db admin had create a job that show me ...
2
votes
1answer
52 views

Is it worth to optimize queries with EarlyTermination Timeout?

Right after running Ola's IndexOptimize to rebuild all indexes and statistics, I cleared the data and plan cache and ran a very complex ugly query to get a baseline of it's performance. The query ...
0
votes
0answers
11 views

Query Across Multiple MySQL Databases

The majority of our clients use the same MySQL schema and a number (subject to the usual conditions) are willing to give us a copy of their data for research. I have written a utility which merges the ...
0
votes
0answers
3 views

Failed transaction replicated and thrown errors on remaining Percona XtraDB cluster nodes

I am using Percona XtraDB cluster 5.5.37. I have run one alter command (to add unique constraint) on node1. But due to duplicate keys,alter command failed on it. But that failed statement passed to ...
0
votes
0answers
10 views

potgresql foreign key index unused for some columns on one specific server

I have a table publication, with two columns type_id and sub_type_id (there are, of course, more columns, but they are not important) on a server, all containing int8 foreign keys to tables type and ...
0
votes
0answers
9 views

Why ST_Distance is not using Index?

I have a table tbl_table with column geo of type GEOGRAPHY(POINT,4326). I have created a index using below query. CREATE INDEX index_name ON tbl_table USING GIST(geo); I am doing following queries ...
-1
votes
0answers
13 views

Mirrored Backup or Disk to Disk Replicated Backup

What would be preferable? Performing a database backup and mirroring the backup to two separate locations as part of the backup process. or Backing up to disk to disk backup and replicating that ...
1
vote
1answer
33 views

Very slow insert performance on large table (EF)

One of our systems has a table that receives around 20k inserts per day - it currently contains ~10m rows. We've just pushed out a system upgrade and I'm intermittently getting some shockingly slow ...
-1
votes
0answers
17 views

try_parse differences from SQL Server 2012 to 2014? [on hold]

My queries which ran correctly in SQL Server 2012 are now failing. I Isolated this down to declare @d datetime2 select @d=TRY_PARSE('3.3.2019' as datetime2 using 'de') select TRY_PARSE(@d as date) ...
0
votes
0answers
9 views

Dynamic script to Drop Indices of a specific column

I´m currently writing an sql script to update our database and for that I need a script to drop indices that rely on a specific column (cause I also what to drop the column). In my script I have used ...
1
vote
1answer
15 views

What happens to mysql information_schema after switching to innodb_file_per_table?

We're switching our mysql dev deb instance to innodb_file_per_table and moving the data dir onto another mounted drive so we can free up space on our dev box. We've backed all our dbs up and about to ...
0
votes
0answers
18 views

How to connect to a password protected Access 2010 database from SQL Server 2014 x64

I have the following situation: An Access 2010 database (.accdb) on a shared folder of a remote server. A domain account that can access the shared folder and files. A SQL Server 2014 x64 running on ...
1
vote
1answer
17 views

Setting up HA and a synced up reporting box all together using SQL Server 2014 Standard Edition

Scenario: We are going to upgrade our third party application. Also we are going to upgrade our DBMS from SQL Server 2008 R2 to SQL Server 2014 Standard edition. We also wanted to have a high ...
1
vote
1answer
48 views

Should I remove this clustered index?

I have lots of tables designed similar as the following (slightly simplified) sample. The original table on different servers has between 50,000 and 200,000 rows (around 12,000 - 150,000 pages). ...
1
vote
1answer
18 views

MySQL error 1593 on replication between 5.5 on WIndows and 5.6 on CentOS 7

I'm setting up replication between the live server (running Windows 2008 R2 and MySQL 5.5.19) and a dedicated replication server (running CentOS 7 and MySQL 5.6.30). The CentOS box does have MySQL not ...
0
votes
0answers
22 views

Database tempdb deadlock

I have been getting a deadlock error for a long time : Could somebody please help me as to what kind of deadlock this is and how to resolve the same. Please ask for any additional details if ...
0
votes
1answer
37 views

which version SQL server can Install Windows 10? [on hold]

I have Os Windows 10. I am trying to install SQL Server 2012. After installing I try to connect to the server, the connection to the server returns the following error message: A network-related ...
0
votes
0answers
14 views

MySQL Innobackupex and Triggers, Events, Routines, Partitions

I am using Innobackupex (from Percona Xtrabackup) to take a physical backup of my InnoDB and MyISAM tables. I'm also backing up the system MySQL table, but skipping Information_Schema. Information ...
0
votes
0answers
7 views

PostGis - How to handle exception using function?

I am using this code to update a table and when there is any exception it should handle it, So how to do it ?? UPDATE Schema.Table1 SET Column3 = ...
1
vote
0answers
9 views

Too many open connections with MongoDB 2.6 + PyMongo 2.7.2

I was running MongoDB 2.4 with a replica set which contains 1 primary, 1 secondary and an arbiter. We were using PyMongo 2.6 and MongoEngine 0.8.2. Recently, we performed an upgrade to MongoDB 2.6, ...
0
votes
0answers
26 views

How to run a execution plan and how to make use of it [on hold]

I am new to the SQL. Can you please explain about EXECUTION PLAN and EXPLAIN PLAN in TOAD with some examples?
1
vote
1answer
20 views

How to run a job in snapshot isolation?

We have a long running job for report data generation and we are not worried about changes to the source data after the job has started. For this case the SNAPSHOT isolation mode seems to be a good ...
1
vote
1answer
15 views

Decompose this relation into BCNF

Today, I'm reading about BCNF decomposition algorithm. It says that: BCNF Decomposition Algorithm Input: a relation R0 with a set of functional dependencies S0 Output: a decomposition of ...
1
vote
0answers
14 views

UTF8 Trouble while migrating from MSSQL to MySQL with MySQL Workbench

I am tasked with migrating part of our database from an on-site MSSQL server to an Amazon RDS MySQL. This will be my first attempt with a database migration, so I am doing a dry run from our MSSQL ...
1
vote
0answers
28 views

Transactional replication unspecified error SQL Server 2008 R2

I have a set up of Transaction Replication with the Publisher being the distributor. It works on Push mode. While replicating, more frequently for the past few weeks, the data is not being pushed to ...

15 30 50 per page