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,547 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,782 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,876 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,897 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

http://www.mainlinemedianews.com/calendar/free-afc-vs-nfc-live-stream-pro-bowl-t

By idhdvsLIVE2020

http://www.mainlinemedianews.com/calendar/game-nfc-vs-afc-live-stream-online-free-afc-vs/event_046eaab2-3ce4-11ea-bf71-e7ca5a321b53.html http://www.mainlinemedianews.com/calendar/livestream-nfc-vs-afc-live-stream-online-free-pro-bowl/event_cb7a04cc-3ce3-11ea-9801-0fe90f2a3431.html http://www.mainlinemedianews.com/calendar/nfl-afc-vs-nfc-live-stream-online-free-pro-bowl/event_57120508-3ce3-11ea-960e-308d99b27d1b.html http://www.mainlinemedianews.com/calendar/nfl-nfc-vs-afc-live-stream-online-free-pro-bowl/event_ab5a228a-3ce3-11ea-9407-308d99b2b460.html http://www.mainlinemedianews.com/calendar/free-afc-vs-nfc-live-stream-pro-bowl-tv-coverage/event_803d910e-3ce3-11ea-a315-c31b8954cb60.html http://www.mainlinemedianews.com/calendar/stream-pro-bowl-live-stream-online-free-pro-bowl-tv/event_9c907336-3ce2-11ea-8b0d-308d99b2b460.html http://www.mainlinemedianews.com/calendar/nfl-pro-bowl-live-stream-online-free-pro-bowl-tv/event_78d2b580-3ce2-11ea-8d6e-77a5877b2a36.html http://www.mainlinemedianews.com/calendar/nfl-nfl-pro-bowl-live-stream-nfl-pro-bowl-k/event_5d4a33cc-3cfd-11ea-a29c-308d99b27d1b.html http://www.mainlinemedianews.com/calendar/ustv-pro-bowl-live-us-stream-nfl-pro-bowl-k/event_29f72066-3cfd-11ea-97f5-af05638cc28d.html http://www.mainlinemedianews.com/calendar/k-stream-pro-bowl-live----stream-get/event_c41cc21e-3cfc-11ea-a080-308d99b2945b.html http://www.mainlinemedianews.com/calendar/stream-pro-bowl-live-stream-get-pro-bowl-k-tv/event_94669f5e-3cfc-11ea-9943-47dffd19a9e7.html http://www.mainlinemedianews.com/calendar/nfl-sports-nfc-v-s-afc-live-stream-pro-bowl/event_a1df78e6-3cfb-11ea-9fb9-5cb9017b09f3.html http://www.mainlinemedianews.com/calendar/stream-afc-vs-nfc-live-live-stream-big-tv-channel/event_3fc2c5fe-3cfc-11ea-b710-bbd3ee53281c.html http://www.mainlinemedianews.com/calendar/nfl-sports-afc-vs-nfc-live-stream-pro-bowl-big/event_c05bc234-3cfb-11ea-956d-3b2ad72f4a06.html...

How to update status with conflict data where chemical temp table have same chem

By ahmed_elbarbary.2010

How to update status with conflict data where chemical temp table have same chemical...

Blob to ADF to Stored proecure

By SQL_Surfer

I'm reading file from BLOB through ADF and I would like to pass the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers