Sean Smith

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.

4.72 (53)

2018-04-26 (first published: )

12,102 reads

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)

2016-01-11 (first published: )

14,707 reads

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)

2015-12-31 (first published: )

6,837 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.

5 (19)

2015-12-23 (first published: )

4,893 reads

Blogs

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

SQL Server Quick Tips

By

Earlier this year I made a series of videos that were played before the...

The 2019 State of DevOps Report–Webinar

By

Tomorrow I get to chat with another giant in the world of DevOps: Jez...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Tsql/SP Code Optimization

By sizal0234

Hi, I am working on optimizing some of Tsql code for SP's. I know...

Powershell

By sizal0234

Does PS help in performance. Like instead of TSQL code used in sql agent...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers