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 […]
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, […]
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 > […]
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 […]
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 […]
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 […]
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 […]
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 ?