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

Backup Report

A handy script for DBAs to find the last healthy backup of a database.

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.

SQL Server Memory Configuration, Determining MemToLeave Settings

Tweaking SQL Server memory settings to provide support for managed code.