Monitor space used for disks, DBs, tables and filegroups

I pieced this script together from solutions I found on this and from Brian Knight's excellent book. It creates 3 tables: - tblDriveLogs. Collects free drivespace info for each drive for each time the script is run. - tblIndexLogs. Collects info on spaceused for each index and table. Please note that when only af single […]

1 (1)

2003-11-26

887 reads

Blogs

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Read the latest Blogs

Forums

Query Help Needed

By rjjh78

To all: I am trying to create a query that will be able to...

Linked server and SQL Server 2019

By Johan_1975

Hi, I searched the infomation but I didn't found it so... Is Linked Server...

able to add the roles db_datareader and role db_datawrit

By samirca007

Hello, I am asked to configure a user so that he can create users...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers