All Questions

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 ...

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 ...

Sql query to Clear existing email addresses from table. please I need help

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 ...

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 ...

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 ...

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 ...

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 ...

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","...

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 ...

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 ...

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

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 ...

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 ...

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 ...

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) ...

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 ...

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 ...

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 ...

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 ...

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, ...

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 ...

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: ...

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'...

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:...

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 ...

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 ...

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 ...

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` ...

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. ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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. ...

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] ...

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 ...

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 ...

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 ...

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 ...

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 ...

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, ...

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 ...

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/...

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 ...

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: ...

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 ...

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 ...