Indexing

Script to show user indexes tables(Sql 2000)

  • Script

This script is supported only in SQL SERVER 2000, This shows only indexes created by users in tables.Parameter @tabela--> You can put the table name and get the information about users indexes in this table.OrYou can put nothing (NULL) and see all tables on the schema and how many indexes each table have.

2004-09-10 (first published: )

218 reads

Drop Indexes

  • Script

This script drop all indexes from table, including Primary Key contraint. First it del nonclustered indexes, then clustered and at last - drops PK contraint. This scirpt is useful, when you need drop all indexes, like when doing ETL process.

4 (1)

2004-03-17

525 reads

Stabilize Index

  • Script

This sp is used to update index in a database.  This sp has got three optional varchar parameters.  First parameter will take the tablename. Second parameter will take the indexname.  Third parameter will take the fillfactor.  The following option we can execute the sp in a user database.1.    exec StabilizeIndexIt will update all index in […]

1 (1)

2003-10-29

275 reads

Blogs

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Suggested Topics in Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

Abuse, Patience, and Understanding

By

I’ve been struggling with an author for a few months. I tried to work...

Read the latest Blogs

Forums

Setting up and using dbt (Data Build Tool) with SQL Server

By David Fundakowski

dbt, or Data Build Tool, is a piece of software that allows analysts to...

Elevated Thread! Best Home of Screen Printing

By mariakeith

Elevated is the best place for screen printing services in the USA. The event...

SSRS 2016 data source - Azure SQL DB not working

By PJ_SQL

Hello! I am trying to create data source to connect to Azure SQL DB...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers