Ankur Vaish

How can I quickly get today's date in a Lightning Component? (for use in an attribute)

You need a slight modification to the JS you proposed, as you will run into comparison errors if the day is a single digit as well. Modifying the script like so fixed the problem: var today = new Date(); var monthDigit = today.getMonth() + 1; if (monthDigit

Salesforce

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

What is my Username and Password when I CLONE a sandbox?

Users can log in to an active sandbox by using the following URL: https://test.salesforce.com and entering a modified username, which is from production, with a suffix for the name of the sandbox. So after testing in Another org logging in worked just fine, using this username as expected.…

Salesforce

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

How to Error Message Saying "Invalid Object Name" [closed]

Your SQL Query is in the wrong database incase you are facing sql server invalid object name error. You are trying to select from the AdventureWorksLT2012 database, but you're connected to the Master database.If you look at the top left of your window, you will see a bar at the bottom of the ribbon that contains a…

SQL Server

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

If Exists - Select Prevent Repeating Code, how to solve?

Unfortunately, I'm afraid by trying to prevent repeating code you might end up in writing more code and making the query less readable, you can solve sql server if there is an error. But I believe this can be advantageous for you - take into account situations where in the test you would only have to search in one or…

Salesforce

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

Can Adding an extra condition to a regex validation rule work efficiently?

If you are facing a regex or condition in your coding then please note that beginning an expression with ^ and ending it with $ (^...$) make it so the expression will only match the entire string. You use this pattern in one expression but not the other. Whichever you desire, you should probably be compatible. As for…

Salesforce

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

T-online email client don't receive emails sent through Marketing Cloud

T-Online email is notorious for repeating delivery problems coming from Salesforce Marketing Cloud domains. Case in point: In the course of an IP warming, we precisely sent 1 (one) email off a new, cold IP to t-online email, and got a blocked bounce message back. This clearly shows, t-online seems to block even if you…

Salesforce

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

jquery UI icons not loading when using static resource

I had the same issue with the jquery icon and finally find the solution to add custom styles in the visualforce page to modify the jquery icon path. After the modification, it works as expected now.The result (The previous and next arrows are icons that were missed before the modification and now they are displayed as…

Java

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

Is ALTER TABLE DROP COLUMN SQL Server really a metadata-only operation?

There are certain circumstances where dropping a column can be a meta-data-only operation. The column definitions for any given table are not included in each and every page where rows are stored, column definitions are only stored in the database metadata, including sys.sysrowsets, sys.sysrscols, etc. When dropping a…

SQL Server

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

SQL Server: How do we track the progress of the CREATE INDEX command?

I guess we can remove the @SPID variable with a reference to sys.dm_exec_requests: Example of SQL Server CREATE INDEX The SQL statement shown below creates an index named "idx_lastname" on the "LastName" column in the "Persons" table: However, if you want to create an index on a combination of columns, you can list…

SQL Server

Answered Apr 16, 2021 · 3.0K Views Read answer →

Page Life Expectancy (PLE), where to start?

You basically asked, "What should I do when Page Life Expectancy changes?" My answer: nothing. I don't start by looking at SQL server page life expectancy. That metric made sense in the SQL Server 7/2000 days when it was all that we had, but today, in 2018, we can do better. Start by looking at wait stats - that tells…

SQL Server

Answered Apr 16, 2021 · 1.6K Views Read answer →

Format column length in SSMS output

You need to use CONVERT(VARCHAR(xx), ColumnName) on all columns if you want the column to appear shorter in the text output view. Convert your query into something like: SELECT [Server] = CONVERT(VARCHAR(30), SERVERPROPERTY('Servername')) , DatabaseName = CONVERT(VARCHAR(30), '''' + bs.database_name + '''') ,…

SQL Server

Answered Apr 16, 2021 · 2.7K Views Read answer →

How does Excel Data Connect to SQL Server using Windows Auth from an untrusted machine?

When a user connects with a specified login name and password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. You need to let SQL Server know the username and…

SQL Server

Answered Apr 16, 2021 · 2.4K Views Read answer →