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

2002-08-06

929 reads

Blogs

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

How not to have sql to restart on the same node but failover on 1st failure in a

By SQLRocker

Hi, By default sql tries to restart on the same node in case of...

Do I need to update statistics after compressing table?

By VoldemarG

I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows....

Iterating Over Calculated Tables using Power Query

By Gouri Shankar

Comments posted to this topic are about the item Iterating Over Calculated Tables using...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers