Graphical Query Plan Tutorial tutorial and example

Graphical Query Plan Tutorial tutorial and example

Using DBCC PAGE to Examine SQL Server Table and Index Data

Using DBCC PAGE to Examine SQL Server Table and Index Data

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