terça-feira, 30 de agosto de 2022

How to make a HTML element focusable

 


  • tabindex="0" means that the element should be focusable in sequential keyboard navigation, after any positive tabindex values and its order is defined by the document's source order.

domingo, 21 de agosto de 2022

How to enable or disable forced parametrization on Microsoft SQL Server / Azure SQL Database

 

This enables the forced parametrization:

ALTER DATABASE [MyDatabaseName] SET PARAMETERIZATION FORCED

This disables the forced parametrization:

ALTER DATABASE [MyDatabaseName] SET PARAMETERIZATION SIMPLE


Read the Documentation:

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-ver16#syntax


How to show INDEXES on Microsoft SQL Server / Azure SQL Database

To show the indexes on a Table, use the sp_helpindex:

EXEC sp_helpindex N'MyTableNameHere'

For example:

EXEC sp_helpindex N'dbo.CMS_Article'

This will produce a table with the INDEXES listed:





Remarks
If indexes have been set by using the NORECOMPUTE option of UPDATE STATISTICS, that information is included in the index_description column.

sp_helpindex exposes only orderable index columns; therefore, it does not expose information about XML indexes or spatial indexes.

See the Documentation: