Jeff Weisbecker

  • Interests: Fly Fishing, Bicycling, and Set Theory

Technical Article

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,712 reads

Technical Article

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

526 reads

Technical Article

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

944 reads

Blogs

SQL Homework – July 2022 – Update your resume.

By

Resumes have been on my mind a lot recently. I’ve been thinking that I...

A Blogging Break

By

Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...

Daily Coping 5 Jul 2022

By

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

Read the latest Blogs

Forums

First responders kit - BlitzIndex question

By Siten0308

Hello, hope someone can help, maybe a simple question so i am using the...

Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)

By ScottPletcher

(1) Sort rows with year column and month column == Jan, Feb, Mar, etc....

Designing a table

By Johnson330

Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers