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,709 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

522 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

917 reads

Blogs

Webinar with Pavilion Data 2022.02.09

By

Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion...

VS Live Cancelled

By

I got a note this week from the organizers of VS Live. They let...

Daily Coping 28 Jan 2022

By

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

Read the latest Blogs

Forums

Clustered Standard Edition

By cantoris

Hi, I've inherited a two-node Windows Failover Cluster (SAN storage) with a SQL Cluster...

dbmail failing to send intermittently

By Louis Hillebrand

I'm using sp_send_dbmail to send mails to an Office 365 account. All mails have...

Options to restrict users to select nothing but views only?

By Coriolan

We have 2 databases Database1 and Database2 on the same server box that very...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers