Technical Article

Smart Index Manipulation system

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 […]

You rated this post out of 5. Change rating

2002-08-06

947 reads

Blogs

Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu SWAT tým

By

The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu...

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Read the latest Blogs

Forums

Copy Logins from on prem to Managed Instance

By BAM

Hello, I try to migrate SQL on Prem Instances to SQL Managed Instances. I'm...

Error while Simultaneous Switching and BCP in same table

By saum70

Hi, Our application is created in VC++. We have House keeping process in which...

Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Updating a Cryptographic Provider for...

Visit the forum

Question of the Day

Query Store for DDL

How do I configure Query Store to capture plans for CREATE and ALTER DDL commands in SQL Server 2022?

See possible answers