Joshua Feierman


SQLServerCentral Article

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.

4.92 (12)

You rated this post out of 5. Change rating

2018-05-18 (first published: )

4,875 reads

Blogs

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

Can an AI Help Me Find a Job?

By

I’m not looking for a job, but I ran across an article about using...

EightKB 2025

By

EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Pitfalls to avoid while feeding events into CrowdStrike

By Pablo Echeverria

Comments posted to this topic are about the item Pitfalls to avoid while feeding...

Column Adds and Drops

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Column Adds and Drops

Visit the forum

Question of the Day

Column Adds and Drops

I run this batch on SQL Server 2022. What happens?

ALTER TABLE dbo.Accounts
 ADD AccountAccessType INT
GO
ALTER TABLE dbo.Accounts
 DROP AccountAccessType
GO

See possible answers