Hello Mr. Gila,

Can you please help me to understand this scenario:

Log file size right now 100 GB

Big translation took place, size of 125 GB.

would the Log file size be 100+125...

The Log file space use always 99% free, so what's the point keeping same size?

Yes it does, some time Transaction log file (backup from Log shipping) is 100+ GB,...

Thank you guys for your time and input.

Sorry guys for late response. Not sure what is this table created for . I have scripted out:

CREATE TABLE [dbo].[ABCD](

[A] [uniqueidentifier] NULL,

[uniqueidentifier] NULL,

[C] [nvarchar](100) NULL,

[D] [nvarchar](max) NULL,

[E] [nvarchar](max) NULL,

[F]...

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!!