My database size is huge, and recently I noticed that a new table added few months ago is the culprit.
Here is the table script.
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Entry_tracker]( [S.Number] [int] IDENTITY(1,1) NOT NULL, [EntryId] [varchar](50) NOT NULL, [EventNumber] [varchar](18) NOT NULL, [Data] [varbinary](max) NOT NULL, [TrackDateTime] [datetime] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[Entry_tracker] ADD CONSTRAINT [DF_Entry_tracker_TrackDateTime] DEFAULT (getdate()) FOR [TrackDateTime] GO
Still, I think that the table size is huge for the no. of records.
This table is not queried by the application. It just stores different versions of same entries from another table.
Since I am using SQL Server 2016, I though I could use table compression, so tried
sp_estimate_data_compression_savings to estimate possible space savings.
However, the results shows no savings.
size_with_current_compression_setting(KB) is equal to
Can anyone direct me in finding the issue with this table?
It is really important, as this is taking a lot of disk space.
Appreciate your help.