All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

why innodb use gen_clust_index instead of table lock when table have no any custom index?

My mysql version is 5.7. I try to test some case about innodb lock.I know: a. query using table lock when table have no any index. b. table have no any index, innodb will auto create gen_clust_index. ...
0
votes
1answer
104 views

Polybase with Cloudera 5.9

We are working on a Proof Of Concept using Polybase with Cloudera. In the polybase documentation it says we can connect to Cloudera 5.5: https://msdn.microsoft.com/en-us/library/mt143174.aspx We ...
0
votes
0answers
4 views

can I be helped? my querey should = something like .000534 however I get 0

can I be helped? my query should = something like .000534 however I get 0. Could you have a suggestion to help me? Thanks psql -Upostgres -dcans -c "select(select COUNT()FROM brd.gaf_info where ...
1
vote
1answer
359 views

jsonb and numeric precision and scale

I'm using a jsonb column, where the JSON documents contain large integers (PostgreSQL 9.5). I've noticed that when the value stored has too many significant digits, it gets truncated. As an example, ...
0
votes
0answers
5 views

I'm trying to run the following query to provide the % of a count by a count

Query should select ( select COUNT(*) FROM brd.gaf_info where can_piecesre_subcategory = 'pr' and gaf_start_date > '2019-11-13 01:01:01.754' ) / ( select COUNT(*) FROM ...
0
votes
1answer
19 views

How to know needed UNDO_RETENTION for a specified query of long duration?

I'd like to know whether there is some way to know the undo_retention needed for a specified query with long duration that need keep the consistence. In other words, I'd like to know how long my ...
0
votes
2answers
105 views

How to decide that a new table is needed?

This might seem a vague question but I am going through a bit of a dilemma here. How do you people decide when a new table will be need? For example, when creating a table for storing user ...
0
votes
0answers
24 views

How to add identifier column based on date in SQL?

I have the following table (here is a sample of it): name date_time jon 10/01/2019 jon 11/01/2019 jon 12/01/2019 jon 25/01/2019 sam 03/04/2019 sam 18/04/2019 sam 19/04/2019 sam 29/04/2019 ...
1
vote
2answers
82 views

How to deal with a person that may have multiple alias names?

I am designing a neo4j database which will be primarily be used to store information about people. One of the requirements is that it must be able to store an alias name of a person. I'm having ...
0
votes
2answers
34 views

How to change the default output format for boolean values

In a Postgres database, I know how to use case statements to get only TRUE or FALSE for a boolean field but was wondering whether there is a cleaner way to set this up like changing any configuration ...
0
votes
1answer
19 views

read slow query log

I m new to MySQL .MySQL version is 5.0.95 . I have enable slow query log and edit in cnf file the location of slow query log but i couldn't see slow query log files in the server location after i edit ...
0
votes
1answer
28 views

Locating all records relevant for a specific date

I have a MySQL InnoDB table with about 1GB of records and growing. each record in this table has, among other fields two date fields : AddedDateRecord - The date the record was added (datetime). ...
0
votes
1answer
13 views

What are the right ways to analyse and tune up innodb_thread_concurrency in mysql 5.7?

I'm in a plan to increase thread concurrency in my production MySQL server 5.7 but not sure, before what are the params/configurations that need to be measured and configured to increase the thread ...
6
votes
2answers
12k views

Is there a Portable MySQL

For teaching and testing purposes I would like to run MySQL without actually having to install it. I have found portable PostgreSQL for both Macintosh and Windows, which is good, but have been unable ...
0
votes
0answers
5 views

Apply a DDL statement with zero downtime with Aurora Mysql

I have an Aurora Mysql 5.6.10a db cluster with one master and one read, that I need to apply a migration to with near zero-downtime. I'm trying to get a comments field to accept emojis by updating ...
1
vote
1answer
215 views

Temporary Resolving State on Synchronous HA, is there a way around this?

So we're having an issue whereby any loss of communication between our 2 HA nodes causes the primary node to temporarily go into a 'resolving' state. This is for all of 1-3 seconds however we serve a ...
0
votes
1answer
83 views

Is it safe to use pt-online-schema-change in a multimaster environment?

I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for each other (active-active master-master setup). If I understand it correctly pt-osc creates ...
7
votes
9answers
34k views

Error Authenticating Proxy Account when Executing SSIS job

I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages. These packages have been running for years and the associated steps run via a Proxy Account (...
6
votes
4answers
3k views

How do I find the next saturday in MySQL

I have trigger and a stored procedure in it (so SP runs when trigger runs). I need a function which finds the next saturday to put in SP. So lets say, it is Wednesday (2015-7-22) today. If my ...
2
votes
1answer
62 views

Missing master.dacpac publishing dacpac Azure Devops

The problem I have been trying to get a build pipeline to work in Azure DevOps to demo how we could build and test our databases. I've come to the point where I want to publish my DACPAC but it ...
0
votes
0answers
17 views

What is the most efficient and effective way to learn SQL? [on hold]

I need to learn SQL for a current project. What recommendations do you have on the fastest way to learn SQL Server Management Studio?
0
votes
0answers
40 views

Question about the design of a database [on hold]

I'm a little new in database design, and I have a question, I guess, very simple. I am working on a database for transformers, and I have 2 types of transformers. I thought about storing each type ...
0
votes
0answers
22 views

Schema size in Oracle

I have this query - SET SERVEROUTPUT on; DECLARE input_owner NVARCHAR2(128) := 'APP USER'; segment_size_blocks NUMBER; segment_size_bytes NUMBER; used_blocks NUMBER; ...
110
votes
11answers
94k views

SQL: SELECT All columns except some

Is there a way to SELECT all columns in a table, except specific ones? IT would be very convenient for selecting all the non-blob or non-geometric columns from a table. Something like: SELECT * -...
2
votes
0answers
6 views

SSIS package deployment. Changing protection level takes a very long time

We are in the process of migrating our servers to a new data center. Currently we are on SQL Server 2014 and SSIS packages deploy in seconds. The new data center has several SQL server 2016 installs ...
0
votes
0answers
16 views

Oracle 11gR2 can I delete datafiles to reduce tablespace?

I have the following doubt, maybe a little silly, if I have a tablespace for example TBS_MYDATA of 155 GB, this tablespace is composed of 5 datafiles of 31GB each, in turn, each of these datafiles ...
2
votes
1answer
168 views

Relationship between two multi-valued child tables

Scenario In my system, there are a number of different TradeBaskets. Each TradeBasket contains a number of different Securities. The Securities have a Type, Value, Sector etc... and new Securities ...
0
votes
0answers
13 views

Like '%' search for value withing longblob column in MySql is slow

MySQL version is 5.7.25 I have table like CREATE TABLE `applications` ( `id` varchar(25) NOT NULL, `application` longblob NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; '...
0
votes
0answers
12 views

Is there a way to figure out an executing query's plan handle by the query text?

Is there a way to determine the plan handle for the query plan of an executing query by that query's text? Perhaps in any of the DMVs? (I'm trying to find the query stats on an ad-hoc query.)
0
votes
0answers
10 views

I'm not a DBA just a humble developer. I'm using MySql Workbench to migrate a simple database

I have an old database with two tables: customers, addresses The customers table has a link column to the addresses table's id The new database has a different structure for both the customers table ...
4
votes
2answers
7k views

Is it possible to uninstall SSRS?

I installed SQL Server with Reporting Services package by mistake and I will never have a requirement to use the Reporting Services part. Is it possible to uninstall Reporting Services (and anything ...
4
votes
5answers
4k views

How to uniquely identify SQL instance

I need to find a way how to identify SQL Instance no matter what changes were done to SQL Server and\or Windows Server where it is running, because we're collecting remotely information about ...
1
vote
1answer
22 views

Infix search on large table when majority of rows can be filtered out

We have a Postgres table, which looks like this: +-----------+---------+---------+---------+ | CLIENT_ID | VALUE_1 | VALUE_2 | VALUE_3 | +-----------+---------+---------+---------+ | 11234 | ...
0
votes
1answer
8 views

Using Temp Tables in Azure Data Studio Notebooks

tl;dr I want to use temp tables across multiple cells in a Jupyter Notebook to save CPU time on our SQL Server instances. I'm trying to modernize a bunch of the monitoring queries that I run daily as ...
0
votes
2answers
23 views

Using IMPORT FOREIGN SCHEMA with Greenplum database

I have setup a PostgreSQL 12 database and am trying to connect to a Greenplum database in order to create proxy tables. I am able to connect to the Greenplum db, but I get an error when I try to use ...
0
votes
0answers
6 views

How to change admin password on Windows Server 2016 on Virtual Box? [on hold]

I forgot my admin password for Windows server 2016 in virtual box and i was wondering if there's any way to recover or change it
0
votes
0answers
14 views

Archiving Huge table with Foreign Key dependencies

We have a huge table of ~ 1TB (data+Indexes) which has ~7 child tables with Foreign key relation ship We have decided to archive the huge table but not the child tables(since they are not that big ) ...
2
votes
1answer
226 views

GSSAPI on MariaDB

I'm using Maria 10.2.13 on Windows Server 2012 and I want to use GSSAPI authentication with it so that we can continue using windows auth. I have followed this tutorial: https://mariadb.com/kb/en/...
-5
votes
3answers
59 views

Oracle trigger with checking day routine doesn't work correct [on hold]

CREATE OR REPLACE TRIGGER SYS.Restict_user AFTER LOGON ON DATABASE BEGIN IF(TO_CHAR(SYSDATE, 'DAY')) = UPPER('SUNDAY') OR (TO_CHAR(SYSDATE, 'DAY')) = UPPER('SATURDAY') THEN ...
-3
votes
0answers
13 views

How to find previously saved records

Supposed doctor is allocated unique id to all patients.Using that id he used to save all the records of patients in sql server. What will be the sql query, if doctor want to know previous visiting ...
0
votes
0answers
12 views

COPY … FROM STDIN command failing on null values exported as “\N”

I initiated a table dump and wherever the NULL value comes, the dump file has \N for that. During the restore I'm getting this error. invalid command \N The database encoding is UTF8. I took ...
1
vote
1answer
658 views

Oracle losing connection ( ORA-03114 ) after some time not using the software

After some time idle, if users try to use the our system, we receive the error: ORA-03114 - not connected to Oracle. I know there's a parameter called SQLNET.EXPIRE_TIME. the recomendation is ...
2
votes
4answers
6k views

Need to get identify all tables and columns in a SQL Query

I have a massive task to go through hundreds of SQL scripts and identify the Table and Columns in each query as we are updating our system and some of the columns and tables may be renamed or ...
6
votes
3answers
9k views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
0
votes
1answer
34 views

Why is this datetime index not being used?

I have a table like this: CREATE TABLE TestTable ( [TestTableID] [int] IDENTITY(1,1) NOT NULL, [IntField1] [int] NOT NULL, [IntField2] [int] NOT NULL, [IntField3] [int] NOT NULL, [...
0
votes
0answers
18 views

SSIS Package Failing since Database failed over to Secondary (Basic Availability Group)

Our SSIs package running via SQL Agent Job on a dedicated Reporting server had been running fine since deployed more than 3 weeks ago. Due to performance issue we had to fail over the database to ...
1
vote
1answer
14 views

migrate users from mariadb10.1 to mysql5.7

My company is moving our databases from self-hosted mariadb 10.1 to Google CloudSQL (which is essentially MySQL 5.7). Dumping / restoring our application schemas looks straightforward. However I'm ...
2
votes
3answers
1k views

Multi-core vs Multi-CPU

I am requesting a new server from our Server team. Which is better for SQL Server performance: 2 CPUs with 8 cores per CPU or 1 CPU with 16 cores?
1
vote
2answers
191 views

Pulling SQL Server data into Excel

I'm trying to pull data from an SQL Server database into Excel 2016 via ODBC / Microsoft Query (built in to Excel). I'd like to have a dropdown of companies, where after a company is selected from ...
1
vote
0answers
24 views

Variable to select database in SQL query

If I want use a variable in the FROM clause of a SQL query I need to use dynamic SQL. Which might be a pain if the query is long and complex. There are few different ways of running a query from a ...

15 30 50 per page