Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 21

I'm considering removing SQL Server Partitioning from a Database. Is there anything I should watch out for?

I am considering removing SQL Server partitioning from a Table. I believe that it was implemented for performance reasons, which is not required due to the low volume of data...

Asked on 10/28/2021 by user8440261

0 answer

Perform SELECT using WHERE IN clause on JSON Object in MySQL

I have a json column in MySQL which contains a list of items for eg."style": {"style1", "style2", "style3", "style4", "style5"}I want to search all the rows which contain the...

Asked on 10/28/2021 by girish

1 answer

Is Buffer Pool Extension (BPE) needed if my database is already on SSD?

Here is my simplified scenario, let's say I have one (and only one) database of 500GB on SQL Server 2016 EE, this database is on SSD drives already (both data...

Asked on 10/28/2021 by jyao

1 answer

Cannot connect after Availability Group automatic failover

We have a SQL Server setup with Availability Groups. In the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on...

Asked on 10/28/2021

1 answer

What is branching factor of mysql myisam's b-tree

I am doing some research but I am struggling to find what is branching factor of MYISAM's b-tree, e.g. how many keys per page (node). I also would like to...

Asked on 10/28/2021

1 answer

Table as an Index?

PostgreSQL 11 Requirements:Uniqueness must be guaranteed (not duplicated)MUST not lose any data.The data I get is NOT uniquely identified, so I am left with semantic comparison of the values to...

Asked on 10/28/2021 by akagixxer

0 answer

How do you combine multiple update statements for the same row using MySQL trigger

Background: Each time a column is modified, I need to update the associated column (which has the same name) in a second table. This is my first attempt at using...

Asked on 10/28/2021

1 answer

Index usage for database: where are the sys tables located

I have seen a couple of scripts that query some sys.someName tables to find usage of indexes in a database. My guess is that these tables are tied to a...

Asked on 10/28/2021

0 answer

How to get the list of foreign key together with the index name on that foreign key?

I am using this query to list all the foreign key, but I also need to have the index name on that foreign key.select a.*from INFORMATION_SCHEMA.TABLE_CONSTRAINTS as awhere a.CONSTRAINT_TYPE...

Asked on 10/28/2021 by anony mous

0 answer

Source Control Dynamics

What ways are there to do version control of an MS Dynamics database? I've found mentions of DACBAC, and obviously SSIS packages could just be dumped in a git repo....

Asked on 10/28/2021 by JohnFF

0 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 21)

Ask a Question