All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
34 views

SQL Server - High buffer time

I'm noticing a high number of waitingRequestsCount on SQL server. The latch_class is buffer. See attached screenshots. Going through SQL server dashboard, I see high number (32221334) waits for Buffer ...
2
votes
0answers
31 views

Advantage of querying data outside a filtered index

Is there any way to take an advantage of having a filtered index to speed DML queries targeting data sets outside that index? My playground: Table with billion rows and 100 columns Unique clustered ...
-3
votes
1answer
25 views

Sql query to Clear existing email addresses from table [closed]

Sql query to Clear existing email addresses from table. please I need help
2
votes
1answer
22 views

Select IDS where all values can't be found in another table

Hey I'm pretty new to SQL and I've come up with a problem that I haven't been able to solve I'm trying to make a query to bring up ID's that have ALL null values and are located in another table. DB ...
0
votes
0answers
12 views

Return Value Corresponding to Latest Date (SQL)

Let's say that I have these tables: Widgets ID Widget 1 W1 2 W2 Widget_Making ID Person_Involved ID_Widgets 1 John 1 2 James 1 3 John 2 ...
0
votes
0answers
27 views

Why isn't my MS Access report showing info for all records? [closed]

I have created an Access database that contains information about wastewater treatment facilities, compliance, and maintenance project financial needs. It also has information about which facilities ...
0
votes
1answer
10 views

Interpolate values on Sorting in PSQL query

In the database, I have a field as status which can have a value of 1, 2, 11, 12, 21, 22 1, 11, 21 Stands for processing 2, 12, 22 Stands for completed. I am doing this query to get all data with ...
0
votes
0answers
32 views

Altering a SET colum Type [on hold]

ALTER TABLE `tablename_1` CHANGE `members` `members` SET('name von lastname','çiao dela cya','María L. Cyález', 'ćya Later','NewName Added') CHARACTER SET utf8mb4 COLLATE ...
1
vote
2answers
33 views

Update all values for given key nested in JSON array of objects

I have a jsonb column data in a Postgres table my_table. It contains the following data: [ {"id":"1","status":"test status1","updatedAt":"1571145003"}, {"id":"2","status":"test status2","...
1
vote
1answer
52 views

I would like to understand better the difference between “sql server stand alone” and “sql server failover instance”

AS these question asks: Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing? Shouldn't Windows Server Failover Clustering already ...
2
votes
1answer
40 views

SSMS - Openrowset maximum file size

Apologies if this has been answered elsewhere but I couldn't find anything here or online. Does openrowset have a file size limit? I'm trying to write a stored procedure, part of which checks if ...
0
votes
0answers
8 views

Shard an existing collection

I have one mongos server, one config server in replication. 3 shards as well in replication. Need to know how to shard existing collection in the shard and distribute data
1
vote
1answer
29 views

Logging security events in MSSQL

I need to log events of admin changing someone's password, and user changing his password. How do I do that? I've found a nice solution based on Service Broker, however the resulting table only ...
0
votes
2answers
45 views

Editing all columns

I have a db table with more than 200 rows (table name: ports). There is this column (port name). The data in the column is like: aaa 1/15. I want to edit all the data in this and turn the aaa 1/15 ...
1
vote
2answers
33 views

Regarding Always On Licensing (Secondary replica no license required) [closed]

I have few questions regarding the licensing of SQL Server when it comes to Always On: Under which scenario / settings we can say that secondary replica is truly passive and will not be considered ...
0
votes
3answers
33 views

Generate random timestamp taking into account shift to daylight saving time

I want to generate random big data in MariaDB. One of this columns is random timestamp which I generate like this: select (current_timestamp - interval (rand() * 60 * 60 * 24 * 365 * 10) ...
0
votes
1answer
14 views

Primary Key issue in MemSQL doesn't support case sensitive

Creating table in MemSQL and creating composite primary key. Lets create simple table with following structure: Table User Data Name userid Primary Key (userid) And assume application support case ...
0
votes
0answers
26 views

Template error handling in a SQL Server script

I have multiple SQL Scripts like the one below, and in each script I'm inserting data into a table or creating tables (separate scripts), all covered by error handling and logging the error or success ...
0
votes
1answer
36 views

DB Encryption Algorithm [closed]

Which DB encryption is best in SQL server 2016 SE as TDE is enterprise feature. I can't use always encrypted because my goal is to encrypt complete database, data on rest or on move is not the a ...
0
votes
2answers
16 views

Logging user's id with the query he executed

So, I am trying to log not just the postgres user but his ID from my table (for example) Person (person_id) when he calls functions. So far, from what I can tell I can get almost every information I ...
1
vote
1answer
65 views

Normalization of the this relation just want to know what are the functional dependencies

Consider the Customer account database of the ABC big bank, which keeps data for customers and their orders. A database of only one relation is designed, as shown below: ABC( customerNo, ...
0
votes
1answer
40 views

What firewall ports should be opened for central management server

Within my environment we currently have a MSSQL installation which serves as the Master in a Multiserver Agent environment (MSX). Due to this server being within a tightly controlled network the ...
0
votes
1answer
7 views

Join relation on itself and pull distinct rows

I have relation A (reviewer_id, book_id, trivalFields) Suppose at only 1 or 2 reviews exist for the book_id. I would like a result set that review_id (first), review_id (second), book_id. Example: ...
0
votes
0answers
17 views

ALTER TABLE causing transaction aborted

There are two transactions. One transaction I used BEGIN RO for read-only transaction. While the other one I used BEGIN to allow me adding a new column to my table called dummy_table. This is what I'...
0
votes
0answers
11 views

Error: Could not find host matching read preference { mode: “primary”, tags: [ {} ] } for set Cluster0-shard-0 :

I am trying to connect to the class Atlas cluster. In the cmd shell, running this command: mongo "mongodb://cluster0-shard-00-00-jxeqq.mongodb.net:27017,cluster0-shard-00-01-jxeqq.mongodb.net:...
0
votes
2answers
26 views

how to duplicate each row of a mysql table?

I've got a table of Product records from an old db that I must change to import on a new php system. They have the form: name, property1_IT, property1_EN, property1_FR I need to transform them by ...
0
votes
1answer
24 views

changing the connection string in SQL Server

we deployed the packages from old server to new server . how to change the connection string i.e initial catalog or server name parameter from Agent job > configuration > connection manger .Is there ...
1
vote
1answer
37 views

How to bulk insert data in vertical into sql server?

My data in below format. I have to insert into sql server table. agency NO booknbr 06000330 bookdttm 2006-07-19 10:56:00 arrdttm 2006-05-07 05:42:00 aj_id A000009454 casenbr 06006640 ...
0
votes
1answer
14 views

How to combine not like and like?

Using MariadB, how can I combine NOT LIKE and LIKE, so that I can search for the string FHD but exclude from the searches if the string H265 is also present? This didn't work for me: SELECT `id` ...
0
votes
1answer
23 views

Performance issues with CAST function

Observing this performance issue that can't be explained with EXPLAIN in a PostgreSQL 9.6 database. There is currently a table public.users, which has a cast on it to output a record to JSONb. (e.g. ...
0
votes
0answers
17 views

MySQL hidden files on ubuntu taking up space

I have a weird issue where my system (ubuntu 19) is showing that MySql 8 is using up 600gb of space, when it should be closer to 250gb. I ran ubuntu's baobab utility in sudo mode, and it as well, is ...
0
votes
3answers
30 views

Always Encrypted on Sql 2017 Express Edition

I am so tentative to decide to use Always Encrypted tool, however I have a question → I'm working on a project with SQL Server 2017 - 14 Express Edition. And I'm pretty sure they aren't going to buy ...
0
votes
0answers
15 views

Microservice - Catalog and inventory tracking on different tables

I'm currently exploring the microservice architecture and base on what I've read so far it's good to separate the catalog microservice/database to inventory and that's where I want to go. The ...
1
vote
0answers
35 views

Random deadlocks SQL Server 2012 using ODBC Driver 17 and simple “Select * FROM” Stored Procedures

I'm getting random deadlock errors in my application on sometimes the simplest of stored procedures. The application environment where I'm experiencing the error uses the GUNICORN server in ...
0
votes
0answers
40 views

Unable to access SQL Server from SSMS 2014

I'm unable to access the server after I installed Visual Studio Isolated Shell. No matter how I try to access the server, the result will always be the same (image below). How can I access it back ...
0
votes
0answers
12 views

Is my usage of triggers in postgresql json parsing causing a cpu bottlekneck?

I have recently started working with the Path of Exile API (https://api.pathofexile.com/public-stash-tabs) to track Items for sale by users The API json is 4 layers deep before I get to the items ...
0
votes
1answer
13 views

MySQL InnoDB add new instance to existing cluster

Server version: 5.7.23-log MySQL Community Server (GPL) I'm running an InnoDB cluster and trying to add a new node, the cluster is a couple of years old and binlogs are being cleared after 2 weeks. ...
1
vote
0answers
46 views

Querying system health data is sometimes fast and other times too slow

We get the data from system health XE within SQL server and load into tables for later querying. Part of that statements which gets pretty slow is INSERT INTO TABLE1 ( [object_name] ...
0
votes
1answer
23 views

“Diamond Shaped Relationship” What's the formal term?

Consider the following "Diamond-Shaped" entity relationship diagram: I'm trying to find some formal readings on why this is a bad design - but Googling "Diamond Shaped Table Relationship" only turns ...
0
votes
1answer
18 views

Search one array element with another

I have got tables: children_tab id name lastname parent_tab id name lastname children_parent_tab children_id parent_id There is also parent view that return in field children_ids elements from ...
0
votes
1answer
47 views

Column as an Included column or as a key column

I have a query which has an optional where condition on column classID(not unique). This same classID is being displayed as a select column in various other queries. Currently i have classID as an ...
0
votes
2answers
30 views

How to select values side-by-side

I have a table like this id_project id_field value 1 1 abc 1 2 xfe 2 3 ufj 2 4 osj And I have to export ...
1
vote
0answers
15 views

mysql data node not connecting to node manager on AWS EC2

I am trying to setup mySql manager + data node + sql server (Server A) and another data node cluster on (Server B). Both running on Ubuntu 16.04 amd_64 Server A /etc/hosts also on Server B Both ...
3
votes
3answers
80 views

I need help with a SQL Query. SQL beginner here! [closed]

I'm totally new to SQL and I've inherited a customer's server (the company that managed it no longer exists). They need me to run a SQL Query that shows their inventory sold for pots. Specifically, ...
0
votes
1answer
13 views

Merge multiple rows in table setting one column based on value in rows

I have some data that looks something like this: key B 1 true 1 false 2 false 2 false And I want to roll it up so that if column B has two false values then the resulting value for B is ...
0
votes
0answers
14 views

How do I manage SQL Server Management Studio (SSMS) Add-In?

A variety of vendors provide SQL Server Management Studio (SSMS) Add-Ins, such as Red Gate's SQL Prompt and the SSMS Tools Pack. Is there a way in SSMS to control or configure these add-ins (enable/...
1
vote
2answers
21 views

ALTER TABLE DROP COLUMN - server status 'Stopped'

I am in the process of removing 4 columns from my (MySQL/innodb) table, simple code, ALTER TABLE database_name.table_name DROP COLUMN A, DROP COLUMN B, DROP COLUMN C, DROP COLUMN D; It has been ...
0
votes
0answers
5 views

Barman + repmgr failover process

I am about to build a PostgreSQL 11 cluster with Repmgr and Pgpool II, and I want to use Barman for backups. The result will be a PostgreSQL cluster with one master node and two standby nodes: ...
-1
votes
0answers
28 views

SSIS Package won't run SQL agent

I've upgraded my sql server and moved all the Databases and agent jobs to a new server from 2012 to 2016 and exported and imported the SSIS packages. I have maintenance job which run a SSIS package ...
0
votes
1answer
24 views

MySQL - too large temporary table on disk

I have two servers with identical MySQL versions (5.5.50, pretty old), identical my.cnf, identical SHOW VARIABLES and three identical tables with identical indexes and different data. And I have a ...

15 30 50 per page