EugeneChiang.com

SendGrid: How To Send An Email With Dynamic Transactional Templates

https://sendgrid.com/docs/ui/sending-email/how-to-send-an-email-with-dynamic-transactional-templates/

Check for Valid Email String

SQL Server Import and Export Wizard Tool

To import/export between Staging and Production server, use the SQL Server Import and Export Wizard Tool. Use “SQL Server Native client 11.0” Use query to import data to a temporary table and then insert into the destination table from the temporary table. 30 million records = 10 minutes to import data from source table to... » read more

TSQL Remove Duplicate Record

TSQL Merge

Sources: https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15

Syncfusion Grid: Make Field Required

Required Field Add the following to the GridColumn… ValidationRules="@(new ValidationRules{ Required=true })" Note: Make sure the required field is in the form or you will not be able to proceed to Save.

An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown.

Symptoms When you use SSMS to run an SQL query that returns a large amount of data, you receive an error message that resembles the following: An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown Cause This issue occurs because SSMS has insufficient memory to allocate for large results.... » read more

Convert Foreign Key to Check Constraint

Reason for converting a foreign key to a check constraint After partitional a table where the primary key was modified. If an additional column was added to the primary key, all the foreign key reference will now error out. You can either drop the foreign key or create a CHECK constraint insteac. If the table... » read more

View Historic Deadlock

Favicon Icon Generator

https://favicon.io/