Before Sql server 2017 we only had LTRIM and RTRIM function available to remove spaces from left and right separately. …
SQL Server concat_ws function available starting 2017: Concat_ws is a new function introduced in sql server 2017. Syntax: CONCAT_WS (…
If you have loaded a table manually in Power BI and you want to add a new row to…
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.
Below query can be used to find heap table in sql server. SELECT T.Name 'HeaptableName' FROM sys.indexes I INNER JOIN…
A HEAP table in a sql server is a table without a clustered index. It can have non clustered index…
When you are troubleshooting or working on any enhancement activities you may want to see the details of the table…