Changing Database compatibility level will be required when you upgrade your database from one version to another and you…
To know what is compatibility Level check this post link. You can view the compatibility of SQL Server Database in…
SQL Server Compatibility level will be used to decide how SQL will use it features. By setting compatibility level will…
A view is a virtual table. View will not store any data physically. The data is pulled from the underlying…
What You Know About Maximum Number Of Non Clustered Index In Sql Server ? You may not be creating so…
For SQL Server 2012 the limit of columns that can be included in the index is 16. SQL Server 2016…
In SQL Server 2014 version the limit of index size is 900 bytes. In SQL Server 2016 version the limit…
No we cannot fire a trigger manually. It will only occur when an event occurs like insert,update or delete.
A HEAP table in a sql server is a table without a clustered index. It can have non clustered index…