Thank you guys for your time 🙂

TDE is enabled, do you think page compression will work?

thanks for your time. One more question, how can I track what causing GB growth? Is there any script I can run to track table size growth/index size?

that is so complicated. Just need little help to tweak in my script!!

Thank you much for you time and inputs

Hello Mr. Gila,

I have a huge database 600+ GB and it is TDE enabled. I want to make database little smaller. I found some tables are more than 1 million...

You're right Perry Whittle!!!! That is just for more VLFs.

salute to you sir!!!

ONLY Full backup and Differential Backup, No T log backup!!!!!!!

Source: Glenn Berry

-- Switch to your database

USE ngmetadata;

GO

-- Check VLF Count for current database

DBCC LogInfo;

-- Check individual File Sizes and space available for current database

SELECT name AS [File Name] ,...

Thanks Jack!!

Yes it is single db. Only 3 log files. I think you can have as many as log file (not a good idea, i believe).

Check the free space (space available)and Initial size. you might have lot of free space that make DB size bigger.

Hi Erin,

I am not able to use your script. I am trying to capture 'AdventureWorks' data file and log file growth every week, using SQL agent job. Can you help...

Thank you Mr. Shawn!!!!