Author: SSWUG Research

Community

Murach’s SQL for SQL Server

One way to help educate your current developers (or become a SQL Server savvy developer on your own) is to loan or give them a copy of the new book, Murach’s SQL for SQL Server. If you have been in the computer field for a little while, you have probably heard of Murach, which is a publishing compan

Community

Definitive Datafile Data Report

by Jonathan Reinharz – The following script quickly and, more importantly, efficiently provides both tablespace status and structural data. Datafiles are grouped by tablespace and ordered by the percentage of free space in them. Output is made clearer with the use of literals (%, MB).