Sean Smith


Technical Article

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)

2019-04-15 (first published: )

15,056 reads

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)

2019-04-15 (first published: )

6,977 reads

Technical Article

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)

2019-04-15 (first published: )

4,943 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)

2019-04-15 (first published: )

15,297 reads

Blogs

Daily Coping 24 May 2022

By

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

Notes on SQLSaturday Jacksonville 2022

By

I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...

TSQL Tuesday #150: Your first technical job. Rollup.

By

This months subject for T-SQL Tuesday was Your first technical job. I have to...

Read the latest Blogs

Forums

Is this If Condition Expression Valid?

By Stamey

I hate to be a pain, but I am a beginner at this and...

SSRS 2012 Email Relay question

By wentigels

Hi All,   I am trying to figure out if it is possible to...

Interviewing for a SQL Server DBA role, any tips?

By subevenis

Hi all, as the title says, I'm interviewing for a job as a SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers