#work_to

Rebuild Script with Sort in TempDB ON, FillFactor = 80 and ONLINE=ON

-- Ensure a USE <databasename> statement has been executed first. SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET...

Kunal Ranpura

Jul 28, 20192 min read

-- Ensure a USE <databasename> statement has been executed first. SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET...

Kunal Ranpura

Jul 28, 20192 min read

-- Ensure a USE <databasename> statement has been executed first. SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET...

Kunal Ranpura

Jul 28, 20192 min read

-- Ensure a USE <databasename> statement has been executed first. SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET...

Kunal Ranpura

Jul 28, 20192 min read

The below script rebuild all the indexes that are fragmented higher than 30%. Reorg indexes that are fragmented between 10%-30% -- Ensure...

Kunal Ranpura

Jul 28, 20192 min read