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

513 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

800 reads

Blogs

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Read the latest Blogs

Forums

Does SQL Server Backup Operation use Parallelism ?

By Giova

Hello everybody. Does SQL Server Backup Operation use Parallelism ? Until yesterday I was...

display value from a column in table in two separate columns

By sachinleo78

i have a value say 11 in one of my columns i need to...

MBR & GPT Disks

By VastSQL

Hi Experts,   Need to add a new 3TB disk to SQL Server cluster...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers