Jeff Weisbecker

  • Interests: Fly Fishing, Bicycling, and Set Theory

Find Duplicate Indexes

There are plenty of scripts out there that find duplicate indexes, but they all seem to use cursors.  I didn't want to use a cursor so I ended up creating a few that could handle the duplicates and decided to share this one.  This will return the table name and the names of the two […]

5 (4)

2003-12-04

2,707 reads

GetFileInfo2

An Improved version of GetFileInfo that now includes the space utilization of each datafile.  Provides more detail per file.  Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server.   A cursor is used to get the information from each database.  The […]

2002-06-28

521 reads

Get File Info

This script organizes information about the database files on the server.   A cursor is used to get the information from each database.  The information is reported in Megabytes, including the next allocation from disk.  No bells and whistles...and if I can find how dbcc showfilestats works I will add the amount of space used in […]

2002-06-24

896 reads

Blogs

Audit Columns

By

One of the easiest ways to collect information about table activity is to add...

Daily Coping 28 Sep 2021

By

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

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

Read the latest Blogs

Forums

Adding a PRIMARY KEY CLUSTERED

By DaveBriCam

Is there a T-SQL way to add the following to an existing table that...

Result set different after breaking up case expression in where

By scarr030

I'm back again with more dumb questions. This time I am dealing with refactoring...

Sending Locking Alert

By Bruin

I have 2 tables the first one holds the dbwait information(locks), and the second...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers