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,688 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: )

7,025 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,957 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,550 reads

Blogs

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Read the latest Blogs

Forums

Unlocking Your Potential: Expert Assessment Help for Academic and Career Success

By williambuyer

​Assessment Help is an online forum that provides a platform for students, educators, and...

Managed Instance Link and SQL Server 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managed Instance Link and SQL...

Passing parameters to query without TVFs

By seanachim@hotmail.com

Comments posted to this topic are about the item Passing parameters to query without...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers