Andrew Jenkins

What is The Best Data Type to Store the Result of HASHBYTES('MD5', ...)?

The output conforms to the algorithm standard: 128 bits (16 bytes) for MD2, MD4, and MD5; 160 bits (20 bytes) for SHA and SHA1; 256 bits (32 bytes) for SHA2_256, and 512 bits (64 bytes) for SHA2_512.So despite the fact that the function technically returns varbinary(8000), you'll only ever get 16 bytes with MD5. If…

SQL Server

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

What ports does SQL Server require to communicate with a web server?

To resolve what port does SQL Server use, I would suggest following the guidelines provided by Microsoft here: TCP/IP port numbers required to communicate to SQL overall a firewall By default, when an application requests a socket from the system for an outbound call, a port number between the values of 1024 and 5000…

SQL Server

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

What are the scenarios to update SQL Server statistics?

For the large tables, we need to update 20% of a row to auto-update the SQL Server statistics. For example, a table with 1 million rows requires 200,000 rows updates. It might not be suitable for the query optimizer to generate an efficient execution plan. SQL Server 2016 onwards, uses a dynamic statistics update…

Salesforce

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

Questions tagged [lightning-datatable]

A lightning-datatable component displays tabular data where each column can be displayed based on the data type. For example, an email address is displayed as a hyperlink with the mailto: URL scheme by specifying the email type. Steps involved in creating lightning datatable: Create Apex class Name It as you Like) ->…

Data Science

Answered Apr 17, 2021 · 1.2K Views Read answer →

Global variables in AngularJS

In ANgularJS you have got two options for "global" variables to solve angularjs global variable: use a $rootScope use a service

Salesforce

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

What is the difference between spark.sql.shuffle.partitions and spark.default.parallelism?

SQL Server

Answered Mar 18, 2021 · 1.7K Views Read answer →

Java switch statement: Constant expression required, but is it constant?

Java

Answered Mar 9, 2021 · 3.7K Views Read answer →

I have 4 reports in the dashboard and want to use the 1st chart as a filter to filter the 2nd chart but don't want to impact the 3rd and 4th chart. How I can do this?

To do that just ignore the filter on the charts where you don’t want to apply filter. For example, if you don’t want to apply the filter on 3rd and 4th reports then just click on it and select ignore filter.

Tableau

Answered Dec 15, 2019 · 1.4K Views Read answer →