T-SQL – How to Find Number of Words in a Given String

TSQL: To find number of words in a given string
Download the codehttps://gallery.technet.microsoft.com/T-SQL-How-to-Find-Number-533b6b39
DECLARE @DemoTable Table
(Col varchar(500));

INSERT INTO @DemoTable (Col)VALUES ('JOHN...

Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs

For more Information refer Technet Article

Introduction
sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount...

SQL – How to Find Missing Sequence in a table

Problem statement:-
 A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code...

Capturing DB Usage stats – sp_spaceused simulation using DMV’s.

SP_SPACEUSED
sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by...

Determine size of the file using T-SQL/Powershell/Ole Objects

There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...

PowerShell- Monitor Group Of Services on ‘N’ Servers & Notify Stopped Services

This post explains how to monitor a multiple services on a list of servers and send alert when the given...

T-SQL – Scripting Stored Procedure to Create backup copy on same database

This post is one of the request from OP.
Download SQL  Backup SP in the same database
The probelm statement 1:-
Create a...

SQL – List Primary key and Concatenate composite Keys into a single row separed by comma

The following query lists all the Primary keys of all the table. 
OP has requested to list all PK and composite...

USING SQL & POWERSHELL – Different Methods to List Databases WITH Recovery Models

USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS
One of op requested to list all the user defined databases...

PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credential

This post explains how to monitor a multiple services on a group of servers with alternate credentials.
This script will allow...