Indexing

DBCC SHOWCONTIG in all Tables

  • Script

Use this script to see showcontig for all tables in the context of the database in which its called. Very handy to schedule during off peak hours prior to any re-indexing to see how bad things are and re-build certain indexes sooner than you thought for peak performance.

2001-08-20

3,471 reads

Quickly Enable/Disable Triggers and Constraints

  • Script

When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]

5 (1)

2001-08-08

2,973 reads

Blogs

Daily Coping 6 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

All jobs that ran during a given time frame.

By

Short post today. Simple query that will tell you every job that ran between...

Instructions for Handling Errors of MySQL and PHPMyAdmin

By

One of my clients, Justin Williams, is a blogger. He owns a website named...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Self-Joined to Find if Archived Versions of Record Exist w/o Duplicate Records

By brandon 94807

I have a table keeping client notes that can be updated and the previous...

Licensing question

By noobdba

Thinking of getting a perpetual standard licensing with certain number of cores. Was wondering...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers