Leonid Sheinkman

Show Database and Log sizes, free space and location

This script helps to identify which database/log takes most of the disk space and how much is free.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(8)

You rated this post out of 5. Change rating

2015-04-15 (first published: 2013-06-18)

3,012 reads

Next week I’m at VS Live in San Diego (register and join me) and...

Ten years ago today, I filmed a Pluralsight Play by Play on open source...

It’s time for T-SQL Tuesday again and this is a great prompt to start...

Comments posted to this topic are about the item Stored Procedures for Server-Level Object...

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)