SQl Hunt

  • Interests: Like to make friendship with people.

Technical Article

Backup Database Size calculation Report - Monthwise

The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.

5 (1)

You rated this post out of 5. Change rating

2019-05-03 (first published: )

1,530 reads

Blogs

T Sql Tuesday 170: Learning From Abandoned Projects

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Read the latest Blogs

Forums

File share witness in an Always On cluster

By robinpryor

Another DBA mistakenly created a file share witness for one of our ao clusters....

Improve Delete Performance in Table With Many Related Tables

By tgitchel

This simple delete statement drives CPU to 100% for long periods of time when...

Transpose table by Row number

By scott@lucsam.com

I want to transpose the attached table of data so that all the data...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers