Custom cleanup procedure for backup files

There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.

Find SQL Server Error Log Path

Script to Find SQL Server Error Log Path

Part 2: Why you should be using the Full Recovery Model

Part 2 of the SQL Server Essentials Series looks at why you should be using the Full Recovery Model to protect your data assets.

Managing Free Space

A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.

Fixed to varying length

sysobjects

How to isolate the current running commands in SQL Server

Examining what has already occurred, while valuable in some cases is most likely not as important as what is currently taxing your server. This being the case, how do you examine the currently executing statement for each of the requests issued against your SQL Server instance?

Identify last statement run for a specific SQL Server session

The process to return the last query statement executed is quite straight-forward and works in all versions of Microsoft SQL Server since DMOs (dynamic management objects) were integrated into SQL Server.

Reclaiming freed space