interfaceState { } typeProps=CounterState&DispatchProp const instructions = Platform.select({ ios: 'Press Cmd+R to reload,\n' + 'Cmd+D or shake for dev menu', android: 'Double tap R on your keyboard to reload,\n' + 'Shake or press menu button for dev menu', }); classHomeextendsComponent<Props, State> { constructor(props:Props) { super(props); } _add = ()=>{
-- CREATE FUNCTION fn_Index_CreateIndexName --drop FUNCTION [dbo].[fn_Index_CreateIndexName]; CREATEFUNCTION [dbo].[fn_Index_CreateIndexName] (@equality_columns NVARCHAR(4000),@Inequality_columns NVARCHAR(4000), @index_handlE INT) RETURNSVARCHAR(128) AS BEGIN DECLARE @IndexName NVARCHAR(MAX)
SET @IndexName = ISNULL(@equality_columns,@Inequality_columns)
SET @IndexName = LTRIM(REPLACE(@IndexName,'[','_'))
SET @IndexName = RTRIM(REPLACE(@IndexName,']','_'))
SET @IndexName = REPLACE(@IndexName,',','')
SET @IndexName = REPLACE(@IndexName,'_ _','_')
IFLEN(@IndexName) > 120 BEGIN
SET @IndexName = SUBSTRING(@IndexName,0,120)
END
SET @IndexName = @IndexName + CAST(@index_handlE ASNVARCHAR(15)) RETURN @IndexName END
GO
-- CREATE FUNCTION vw_Index_MissingIndex --drop VIEW [dbo].[vw_Index_MissingIndex] CREATEVIEW [dbo].[vw_Index_MissingIndex]
AS SELECT'[' + d.name + ']'as DBName, [dbo].[fn_Index_CreateIndexName](mid.equality_columns,mid.Inequality_columns,mid.index_handlE) ASID, REPLACE(mid.equality_columns,',',' ASC,') AS equality_columns, REPLACE(mid.Inequality_columns,',',' ASC,') AS Inequality_columns, mid.Included_columns, mid.[statement] FROM sys.dm_db_missing_index_details mid INNERJOIN sys.databases d on d.database_id = mid.database_id
GO --Drop PROCEDURE [dbo].[usp_Index_MissingIndexCreationStatements]; CREATEPROCEDURE [dbo].[usp_Index_MissingIndexCreationStatements] AS
SET @IndexCreationPlaceholder_Start = 'IF NOT EXISTS (SELECT * FROM {2}.sys.indexes WHERE [name] = ''IX_{0}'' ) BEGIN CREATE NONCLUSTERED INDEX [IX_{0}] ON {1}'
SET @IndexCreationPlaceholder_End = ' WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] END;' + char(13) + char(10)
USE YOUR_DBNAME; DECLARE @namevarchar(100) DECLARE authors_cursor CURSORFOR Select [name] from sysobjects where xtype='u'orderbyid OPEN authors_cursor FETCHNEXTFROM authors_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN DBCC DBREINDEX (@name, '', 90) print @name FETCHNEXTFROM authors_cursor INTO @name END deallocate authors_cursor