Scripts

Technical Article

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.

4.9 (30)

You rated this post out of 5. Change rating

2019-04-15 (first published: )

7,107 reads

Technical Article

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.

4.83 (69)

You rated this post out of 5. Change rating

2019-04-15 (first published: )

15,861 reads

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

By

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

By

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

Blob Storage automated downloads

By Brandie Tarvin

Dipping my toes into the waters of Azure and of course before I get...

Announcing SQL Server 2025

By Press Release

Comments posted to this topic are about the item Announcing SQL Server 2025

Running Steve's Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running Steve's Code

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error?

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers