MSSQL Server :: Tips-n-Techniques

To Drop Indexes:

Drop INdex CusAccAssGrpAK on CusAccAssGrp
Drop INdex CusAccAssGrpDel on CusAccAssGrp
Drop INdex CusAccAssGrpPK on CusAccAssGrp

To Create Indexes:

• exec BuildTableIndexes 'CusAccAssGrp'
• exec BuildDelIndex 'CusAccAssGrp'

----- ----- ----- ----- ----- ----- ----- ----- -----

Useful SQL System Stored Procedures:

- sp_spaceused 'tablename'
- sp_helpdb 'databasename'

Useful SQL System Schemas:

- InformationSchema.Columns