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

13,864 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,983 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,920 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,920 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Trying to get output of PRINT command after select in Transaction

By boughrogers

Hi I am looking to select the output of the data that I plan...

Patches

By mtz676

How do I generate a report which tells me if my sqlservers are upto...

Use Domain Account for SQL Server service on Linux

By S_DBA

Currently, while installing SQL server we use a local linux account to run the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers