Querying agent job status, executing and waiting for job completion from within T-SQL

Querying agent job status, executing and waiting for job completion from within T-SQL

Simple process to track and log SQL Server stored procedure use

Simple process to track and log SQL Server stored procedure use

minimum account permissions for service broker

USE USERDB
go

CREATE SCHEMA [office\user] AUTHORIZATION [office\user];

GO
CREATE USER [office\user] WITH DEFAULT_SCHEMA = [office\user];
GRANT CREATE PROCEDURE TO [office\user];
GRANT CREATE QUEUE TO [office\user];
GRANT CREATE SERVICE TO [office\user];
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [office\user];
GRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO [office\user];
GRANT RECEIVE ON QueryNotificationErrorsQueue TO [office\user];
GRANT CONTROL ON SCHEMA::[dbo] TO [office\user];
GRANT IMPERSONATE ON USER::DBO TO [office\user];
GO

Script to Get Available and Free Disk Space for SQL Server

Script to Get Available and Free Disk Space for SQL Server

Procedure Execution Statistics

SQL Server 2005 Stored Procedure Execution Statistics | Glenn Berry's SQL Server Performance

Monitoring Stored Procedure Usage Count

Monitoring Stored Procedure Usage — DatabaseJournal.com

Finding Missing Indexes from SQL Plan Cache

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes

SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): Cool CROSS APPLY Tricks, Part 2

SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): Cool CROSS APPLY Tricks, Part 2

SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): T-SQL Tuesday #017: APPLY: It Slices! It Dices! It Does It All!

SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): T-SQL Tuesday #017: APPLY: It Slices! It Dices! It Does It All!

Parse string characters and separate them

DECLARE @String NVARCHAR(99) = N'abcdefghijk' ;

;WITH Numbers
AS ( SELECT 1 AS Number
UNION ALL
SELECT Number + 1
FROM Numbers
WHERE Number < 99
)
SELECT SUBSTRING(@String, Number, 1) AS SingleChar
FROM Numbers
WHERE Number <= LEN(@String) ;