Categories
Database Development

what is difference between uniform extents and mixed extents in Database file storage structure?

I just went to some resources saying: uniform extents are owned by single object and mixed extents can be shared by maximum 8 objects. But I’m unable to grasp their insight meaning, like what is the benefit of this structure? basically, I am new in this field, so if you could provide some intuitive examples […]

Categories
Android User Help

Does Android save videos from Instagram live in the cache?

I hosted an instagram live interview yesterday and when it came to saving it to post to IGTV there was an error. I believe it was either due to a network error or that there may not have been enough space on my phone to save or process the video (I have 3.1 GB available, […]

Categories
Database Development

Unexpected query execution plan on MySQL 8 when using Datetime range

I have a MySQL 8 database with about 900 millions of rows. When I run the following query the response is very slow because table B doesn’t seem to be using the right index: SELECT B.name FROM A JOIN B ON A.key1 = B.key1 AND A.key2 = B.key2 WHERE A.active = True AND B.datetime > […]

Categories
Database Development

Unbale to replicate schema changes in transactional replication

I have implemented a transactional replication on one of my db. In the documents provided by Microsoftsql (here and here), I should be able to change the schema and that these changes will be replicated at the subscriber side as well. But I am unable to do so. My question is there anything I am […]

Categories
Database Development

Design partitions key format – DBMS-agnostic

I ran across this problem few times in the past and I think I get it on the surface, but I kind of still miss the big picture. Why do some DBMS-s/DBMS engines require partition key to be string format, what’s the rationale behind it. I can understand, that if DBMS stores data in folder […]

Categories
Database Development

MySQL: OR in SHOW TABLES?

I’ve just installed MySQL and wondering if SHOW TABLES output can be combined. Btw, I’m not a DBA, please be patient if this question doesn’t make sense to you. I just want to know how SQL query works, and what not. E.g. mysql> SHOW TABLES; +—————————————+ | Tables_in_information_schema | +—————————————+ | CHARACTER_SETS | | COLLATIONS […]

Categories
Database Development

Microsoft recommended best practices to maintain the auto-growth settings

In our SharePoint farm, the database growth is set to auto-growth(database growth is set to 5000), most of the databases are only with 5-10% empty (some with 47%). Now, I am analyzing the database usage – so based on the above statistics: Is the database within the recommended limit? If not, what are the action […]

Categories
Database Development

How to connect to specific session id & serial# ? Blocked sessions

I have blocked sessions and see which session is blocking them, having session_id and serial#. Is it possible to connect to such session? How? Background: using V$SESSION_BLOCKERS I see sessions are blocked by each other by INSERT statements to one of two tables: _REQUEST and _RESPONSE Blocked sessions wait event: enq: TX – row lock […]

Categories
Database Development

Connecting to mysql db server from a remote server to a local machine

As per my understanding, there are two main things to check before connecting to a remote mysql db server. 1. Bind address. 2. Grant privileges. I was able to connect to a remote mysql db server from my Mac, it was easy (mysql -uroot -h x.x.x.x -p) Imagine a scenario for my own learning, I […]

Categories
Database Development

SSL Encryption Renew

When we request CSR for SSL encryption renew , can we use same label or different label could be used ? After importing the signed certificate into Db2 server ,What steps we need to follow on db2 clients during renewing expired certificate ?