• Interests: Spending time with family

Dynamic DBCC DBREINDEX

This script uses sysobjects and sysindexes to ID all tables in a database that are indexed, and/or clustered.  It then runs through per table all of the indexes and runs DBREINDEX with their fillfactor.  This eliminates having to maintain a list of all indexes and having code fail when it tries to modify indexes that […]

2002-12-19

1,716 reads

Blogs

Speaking about Latches & Spinlocks at the EightKB Online Conference

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

SQL server Linux and SQLCMD

By

Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common...

Azure Platform Series: cloudshell code -your (brilliant) online editor

By

This post is about code which is an online editor you can use with...

Read the latest Blogs

Forums

Error in bcp query out

By SQL_Surfer

I've been playing around wiht bcp out the data into csv file but been...

Multi subnet failover cluster

By sqlguru

My goal is to have an FCI across 2 nodes with shared storage (node...

Power Query or SQL Server? Which, when and why

By vsanchezjauregui

Comments posted to this topic are about the item Power Query or SQL Server?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Strange Code

See possible answers