DotNetNuke - SiteLog T-SQL for deleting everything except newest 100000 rows

DotNetNuke

Unless you master the art of DotNetNuke logging engine most dreadful feature of DNN is its vast log tables which tends to skyrocket size of DNN databases.
This script is no legit solution you should understand and properly configure DNN logging but until then it does the job...

select * into sitelog100000 from SiteLog s
where s.SiteLogId in (
select top 100000 SiteLogId from SiteLog order by SiteLogId desc)
truncate table sitelog


--select * from sitelog100000
set identity_insert sitelog on
INSERT INTO [dbo].[SiteLog]
           ( SiteLogId, [DateTime]
           ,[PortalId]
           ,[UserId]
           ,[Referrer]
           ,[Url]
           ,[UserAgent]
           ,[UserHostAddress]
           ,[UserHostName]
           ,[TabId]
           ,[AffiliateId])
select * from sitelog100000
set identity_insert sitelog off
drop table sitelog100000