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

518 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

864 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

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...

Search all Tables in DB for a String but using Postgres - What is the difference

By Oscar_Boots

Hi Forum, I want to search a Database for a String value and I...

SQL 2016 - Need help with complex calculations based on paycodes - New Changes

By DiabloSlayer

Hello Friends, Posting this for help as the client made more requirement changes. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers