Jeff Weisbecker

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

516 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

813 reads

Blogs

[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA

By

Happy Tuesday everyone… Today I am honored to have my first article published on...

Daily Coping 22 Sep 2020

By

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

Converting a Datetime to UTC

By

I was in a need of converting some datetime values (of which I know...

Read the latest Blogs

Forums

SCOM/SCCM alert when Always On High Availability dashboard is green

By webrunner

Hello experts, Does anyone know why SCOM (or is it SCCM?) would send the...

Restart SQL server from CMD

By SQLAddict01

We have a issue in SQL Server 2017 (RTM-CU21) with SSISDB when a server...

Replication issue

By premkuttan

my table is getting replicated from server 1 to server 2. I got a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers