When you are troubleshooting or working on any enhancement activities you may want to see the details of the table like how many column table has , the data type of those column or where the table is being used in view ,triggers..
You can simply select the table and press ALT+F1 to view all this details quickly.
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…