Technical Article

Defragment all table indecies

To help maintain index quality, defragging of any given index is a good thing. This will defrag ALL indecies in the current DB. NOTE: Schedule for off-hours operations. For a massive re-write of indecies, change the remarking on "--IF @indid" lines to use reindex instead of just defragging.

2004-09-21

561 reads

Blogs

Copying large files from SharePoint Online

By

I recently worked on a project where we needed to copy some large files...

How Long has Your SQL Server Been Online

By

This week’s blog post will help you check your SQL Servers up-time. There are...

The less you hear from or about the DBAs the better they are doing their job.

By

Something I’ve been thinking about recently is that DBAs are best when they are...

Read the latest Blogs

Forums

Ordering String_Split()

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering String_Split()

Worse Before Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Worse Before Better

Azure SQL Managed Backup for on-prem databases

By database diva

I have a SQL 2017 on-prem database server that the client wants to back...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers