Indexing

Technical Article

Smart Index Manipulation system

  • Script

We are constantly having to drop indexesfrom tables while repopulating the datain the table. We then have to rebuild the indexes as they were before dropping them.This requires writing a custom drop and recreate index script for each unique situation. If we tryto write scripts ahead of time as soon as the indexing schemechanges on […]

2002-08-06

936 reads

Technical Article

Index Locking Strategy

  • Script

This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]

4 (1)

2002-07-04

1,376 reads

Technical Article

DBCC SHOWCONTIG in all Tables

  • Script

Use this script to see showcontig for all tables in the context of the database in which its called. Very handy to schedule during off peak hours prior to any re-indexing to see how bad things are and re-build certain indexes sooner than you thought for peak performance.

2001-08-20

3,672 reads

Technical Article

Quickly Enable/Disable Triggers and Constraints

  • Script

When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]

5 (1)

2001-08-08

2,993 reads

Blogs

Honored to be a Microsoft MVP Again

By

I was renewed this week as a Microsoft MVP. This is my 15th award...

Thank You Kevin!

By

I don’t think I’m going too far out on a limb to call Kevin...

Daily Coping 6 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Establishing a Connection to PostgreSQL with GoLang

By sabyda

Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...

SSIS - Name of Excel Sheet - How to Clear Dropdown List?

By AMCiti

I am trying to create an SSIS package inside Visual Studio 2019.  This package...

How to create a linked service to a VM where I will copy files from Blob storage

By dndaughtery

I have files in Blob Storage that I'd like to copy over to a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers