In SQL Server 2014 version the limit of index size is 900 bytes.
In SQL Server 2016 version the limit of index size is increased to 1700 bytes for non clustered index 900 bytes for a clustered index.
The attribute value in Dimension table are going to change slowly over time and they…
Changing Database compatibility level will be required when you upgrade your database from one…
To know what is compatibility Level check this post link. You can view the compatibility…
SQL Server Compatibility level will be used to decide how SQL will use it features.…
A view is a virtual table. View will not store any data physically. The data…
Below is the error which I was getting today while deploying the SSIS pacakge for…