Author: Jessica Alba

Whether your next job interview is related to data science or machine learning, you can bet that artificial intelligence questions will come up.

Database Development

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

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags I am new in this field, 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, it would be highly appreciated!, like what is the benefit of this structure? basically, so if you could provide some intuitive examples and applications

Android User Help

Does Android save videos from Instagram live in the cache?

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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, […]

Tags and in movies and downloads, as well as switching off flight mode and switching on data in case it was the network, but cannot find it. Would it be saved somewhere on my phone? Would the reason for the error be insufficient storage space or more likely net, cache and videos, I had to abandon the video. It is not saved in my stories or my archive on Instagram or anywhere on IGTV. I've looked in the Android files o, 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, it was a 57 min live video.) Eventually after editing the title and text multiple times thinking it was a character limit or doesn't like pu

Database Development

Unexpected query execution plan on MySQL 8 when using Datetime range

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 > […]

Tags 'datetime', "access_type": "ref", "attached_condition": "((`B`.`key1` = `A`.`key1`) and (`B`.`datetime` > TIMESTAMP'2020-05-28 00:00:00') and (`B`.`datetime` < TIMESTAMP'2020-, "const", "cost_info": { "query_cost": "10202799.44" }, "cost_info": { "read_cost": "62738.00", "cost_info": { "read_cost": "9211170.19", "data_read_per_join": "1G" }, "data_read_per_join": "96M" }, "eval_cost": "313.69", "eval_cost": "6273.80", "filtered": "0.03", "filtered": "100.00", "ix_B_key2_datetime" ], "key_length": "258", "key_length": "5", "key": "ix_A_type_active", "key": "ix_B_key2_datetime", "nested_loop": [ { "table": { "table_name": "A", "possible_keys": [ "ix_A_type_key1", "possible_keys": [ "ix_B_key1_datetime", "prefix_cost": "10202799.44", "prefix_cost": "69011.80", "ref": [ "A.key2" ], "ref": [ "const", "rows_examined_per_scan": 147, "rows_examined_per_scan": 62738, "rows_produced_per_join": 3136, "rows_produced_per_join": 62738, "used_columns": [ "active", "used_columns": [ "key1", "used_key_parts": [ "key2" ], "used_key_parts": [ "type", [Type], ], { "table": { "table_name": "B", $key2, active, 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 s, key1), Name

Database Development

Unbale to replicate schema changes in transactional replication

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags @article = 'tEmployees', @article = 'tEmployees' alter table tEmployees alter column Forename varchar(100) null exec sp_addarticle @publication = 'tTestFName, @article = N'table_name', @destination_db = 'testrep' exec sp_droparticle @publication = 'tTestFNames', @destination_db = 'testrep' exec sp_startpublication_snapshot @publication = N'tTestFNames'; Go, @force_invalidate_snapshot =0, @force_reinit_subscription =1 GO The error I get while making changes is something like this: Cannot perform action on the table because it, @property =schema_option, @source_table = 'tEmployees' exec sp_addsubscription @publication = 'tTestFNames', @subscriber = 'RSCOMPUTER', @value= '0x000003454DFD7FDF', basically replicating each and every column and everything associated(like a complete replica). use [db_name] exec sp_changearticle @publica, by removing the article from publication, 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, I used following customized script in accordance to my requirements, make changes to it and then add it back to publication. But every time i do this I have to generate a new snapshot and reinitialize the subsc, which doesn't seem to be much efficient. What can I do to resolve this issue. Any alternative? exec sp_dropsubscription @publication = 't

Database Development

Design partitions key format – DBMS-agnostic

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags but I kind of still miss the big picture. Why do some DBMS-s/DBMS engines require partition key to be string format, but is there anything more behind it ? Example - pyspark: Caused by: MetaException(message:Filtering is supported only on partition keys of, cause all file names are strings, I ran across this problem few times in the past and I think I get it on the surface, that if DBMS stores data in folder format (e.g. hdfs) string is a natural format, what's the rationale behind it. I can understand

Database Development

MySQL: OR in SHOW TABLES?

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags 1 warning (0.00 sec) mysql>, and what not. E.g. mysql> SHOW TABLES; +---------------------------------------+ | Tables_in_information_schema | +---------------, but this query doesn't work Desired Output +-----------------------------------------+ | Tables_in_information_schema | +-------, I'm not a DBA, I've just installed MySQL and wondering if SHOW TABLES output can be combined. Btw, please be patient if this question doesn't make sense to you. I just want to know how SQL query works

Database Development

Microsoft recommended best practices to maintain the auto-growth settings

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags I am analyzing the database usage - so based on the above statistics: Is the database within the recommended limit? If not, In our SharePoint farm, most of the databases are only with 5-10% empty (some with 47%). Now, the database growth is set to auto-growth(database growth is set to 5000), what are the action I should take now? Microsoft recommended best practices to maintain the auto-growth settings?

Database Development

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

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags -11, :10 ) How is it possible that INSERTs, :12 ) Query 2a (from DB trigger, :B1 is a payload): SELECT COALESCE(ERROR_DETAILS, "ttl", (packet, [Type], 10, 2, 3, 4, 5, 6, 7, 8, 9, are blocking the sessions? I was looking into V$ACTIVE_SESSION_HISTORY but don't find anything yet (I'm not a DBA yet) Note 1: APPEND hint i, BATCH_SKID, ERROR_CODE FROM XMLTABLE( '//*:DataHandlerWebServiceException | //*:Fault | //*:PLMDataHandlerError' PASSING XMLTYPE(:B1 ) COLUMN, ERROR_CODE VARCHAR2(8) PATH '*:errorCode', ERROR_MESSAGE VARCHAR2(256) PATH '*:errorMessage', error_message))), FAULT_REASON, FAULT_REASON VARCHAR2(256) PATH '*:Reason/*:Text', HAS_FAILED, having session_id and serial#. Is it possible to connect to such session? How? Background: using V$SESSION_BLOCKERS I see sessions are block, I have blocked sessions and see which session is blocking them, IS_PROCESSED, Name, PARENT_SKID, REQUEST_SKID, REQUEST_SKID) values (:1, RESPONSE_BODY ) values ( :1, RESPONSE_HTTP_STATUS, retry_delay, revision, see Note 1): INSERT /*+ append */ INTO _response( RESPONSE_SKID, service_name, SOAP_ERROR VARCHAR2(256) PATH '*:COMMON_LOG_MESSAGE/*:LOG_MESSAGE' ) Query 2b (we already know APPEND is ignored here, SOAP_ERROR) AS ERROR_MESSAGE, SOAP_REQUEST_TIMESTAMP, SOAP_RESPONSE_TIMESTAMP, to different tables, WAS_TIMEOUT

Database Development

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

Post author By Jessica Alba
Post date June 2, 2020
No Comments on 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 […]

Tags as per my understanding, can someone direct to right resource (if there is a similar question please comment) which can help me figure out this thing?, I want to connect to a mysql db instance on my Mac from a remote server. Imagine I am logging into this remote linux machine from my Mac and, it was easy (mysql -uroot -h x.x.x.x -p) Imagine a scenario for my own learning, 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 conne

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 ?

Tags 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 ?, When we request CSR for SSL encryption renew