Buffy Heaton

AreLOBs also backed up if I take a dump of all partitions of the table individually?

Yes, they should be. Unless, you have configured data pumps to exclude them somehow. Please share the command (and parameter file) that you use to make the data pump export. Reasons why the dump file is smaller could be that you have large areLOB indexes (which are not included, and should not be), or you are using…

Salesforce

Answered Mar 7, 2023 · 992 Views Read answer →

What's the way to terraform lint?

VSCode has a Terraform Lint "l2fprod.terraform-fork" Have NOT tried it. Did a simple search terra + lint. HTH DrewBai

Devops

Answered Mar 7, 2023 · 1.3K Views Read answer →

How does the neutral network visualization work?

Tensorflow, Keras, MXNet, PyTorchIf the neural network visualization is given as a Tensorflow graph, then you can visualize this graph with TensorBoard. Here is how the MNIST CNN looks like: You can add names / scopes (like "dropout", "softmax", "fc1", "conv1", "conv2") yourself.Interpretation The following is only…

Data Science

Answered Feb 13, 2023 · 1.1K Views Read answer →

What needs to be done when your transaction dataset contains more than 10000 rows?

In case when your transaction dataset contains more than 10000 rows - If you try to insert the records within the 10000 limit, then if one record fails, the remainder of the DML operation can still succeed. but if you try to insert the record above 10000, say 15000 then it will throw an error like…

Salesforce

Answered Feb 10, 2023 · 408 Views Read answer →

What are the number of standard profiles in Salesforce?

There are six (6) standard profiles in Salesforce. Additional standard profiles will appear when certain conditions are met within an organisation, such as enabling Chatter, Partner Portal, Customer Portal, or Sites. The link posted in the original question does not appear to include all possible profiles that are…

Salesforce

Answered Feb 8, 2023 · 1.2K Views Read answer →

How can I stop slow insert on a table?

To remove slow insert on a table, try using: SET STATISTICS IO ON and SET STATISTICS PROFILE ON STATISTICS IOCan be useful in telling you which tables it is doing the most amount of table scans, logical reads & physical reads (I use these three to focus on which part of the query plan needs the most tuning) STATISTICS…

SQL Server

Answered Feb 7, 2023 · 427 Views Read answer →

Is the server running locally and accepting connections on unix domain socket "/tmp/.s.pgsql.5432"?

The answer to your question - is the server running locally and accepting connections on unix domain socket "/tmp/.s.pgsql.5432"? is: For pure installing postgresql on Mac OS, the process will be (using brew command):brew install postgresql then if you want to automatically run postgresql at login: ln -sfv…

SQL Server

Answered Feb 7, 2023 · 1.7K Views Read answer →

Which method should I choose to postgres cast split string to double precision?

The problem is that an empty string '' isn't a valid number and thus the postgres cast fails. One way to deal with this is to use nullif() to turn an empty string into a null value: cast(nullif(split_part("cost", ' ', 2), '') as double precision) Maybe even combine that with trimming leading and trailing spaces:…

SQL Server

Answered Feb 7, 2023 · 1.1K Views Read answer →

Cleaning `Inf` values from an R dataframe

To clean 'Inf' values from a data frame, you can use the following functions: Using do.call and replace on the data frame: You can also use the set function from the data. table package which uses references instead of internal copying. Or To remove inf in r, you can also use the following functions: Using do.call and…

Tableau

Answered Jul 17, 2021 · 1.9K Views Read answer →

What is Script to find the list of stored procedures in all databases?

SQL server search stored procedures A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it. You can use the following code for SQL…

SQL Server

Answered Apr 23, 2021 · 2.1K Views Read answer →

Why can't I create a new schema with the authorized owner set to dbo?

The db_datareader, db_datawriter, and db_ddladmin permissions will not give the necessary privilege for this action. db_datareader: Members of the db_datareader fixed database role can read all data from all user tables. db_datawriter: Members of the db_datawriter fixed database role can add, delete, or change data in…

Salesforce

Answered Apr 22, 2021 · 1.5K Views Read answer →

You must specify a region You can also configure your region by running aws configure

When you installed AWS CLI for the first time in your local system, you have to configure AWS credentials using the below given command. C:UsersNadeem Akhter>aws configure AWS Access Key ID [****************4JTQ]: AWS Secret Access Key [****************r1xF]: Default region name [None]: Default output format…

Salesforce

Answered Apr 22, 2021 · 1.4K Views Read answer →