The index entry of length exceeds the maximum length of 1700 bytes for nonclustered indexes

SQL Server 2016 and Azure SQL database have increased the maximum size for index keys for non-clustered indexes. note1.The new maximum key size for non-clustered indexes is 1700 bytes. note2.T ...

How to Encrypt and Decrypt a string in SQL Server

To encrypt and decrypt a string we SQL Server 2008 and newer versions have predefined Cryptographic functions. h2.EncryptByPassPhrase (Transact-SQL) This function encrypts data or string with a p ...

SQL Server MERGE Statement to insert, update and delete

MERGE statemen runs insert, update, or delete operations on a target table from the results of a join with a source table. At least one of the three MATCHED clauses must be specified, but they can be ...

SQL Server Replication Issues with Computed Columns

What is the Replication in SQL Server? Replication is a technology for copying and distributing data and database objects from one database to another and then synchronizing databases to maintain ...