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

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.