Update Statistics With Full Scan in SQL Server We all know to keep auto statistics update ON for a SQL server databases little overkill the performance and query may or may not use correct statistics and may choose the non-optimal execution plan. This may slow down the performance of complex queries to be run faster. Also, it is not a good idea to rebuild fragmented indexes every day in a busy production environment where thousands of query already running and there is no window for database maintenance task. When you will run index rebuild operation on a busy database you may encounter Query Timeout error for other running queries on a larger database. So the alternative and best solution are to update statistics with a full scan. Assuming you already knowing update statistics with sp_updatestats only update statistics a sample of records of the table and with full scan, it will scan the entire table. DECLARE @tablename varchar(80),@shemaname varchar(80) DECLARE @SQL AS NVARCHAR(200) DECLARE TblName_cursor CURSOR FOR SELECT t.name,s.name FROM sys.tables t join sys.schemas s on s.schema_id=t.schema_id OPEN TblName_cursor FETCH NEXT FROM TblName_cursor INTO @tablename,@shemaname WHILE @@FETCH_STATUS = 0 BEGIN SET @SQL = 'UPDATE STATISTICS '+@shemaname+'.[' + @TableName + '] WITH FULLSCAN ' EXEC sp_executesql @statement = @SQL FETCH NEXT FROM TblName_cursor INTO @tablename,@shemaname END CLOSE TblName_cursor DEALLOCATE TblName_cursor Instead of updating statistics for each table we can use below script to update statistics for all tables of a database

Issue getting the correct timeout timestamp

Bhuvneshwar

I'm having an issue getting the correct timeout timestamp when a timeout has been set for a user in the Discord client.

Basically the timestamp gives me a duration -27675028 minute and expiry like this Thu, 01 Jan 1970 00:00:00 GMT (sometimes the previous timestamp) if a timeout was set before.

What I'm trying to do is use the guildMemberUpdate event to listen for when a timeout has been added to a member and then log the details such as duration, expiration etc to a channel.

Here is what I'm working with:

module.exports = new Event("guildMemberUpdate", async (oldMember, newMember) => {


const log_channel = oldMember.channels.cache.find(c => c.name == config.log_channel);

let entry = await newMember.guild.fetchAuditLogs({limit: 1, type: AuditLogEvent.MemberUpdate}).then(audit => audit.entries.first());


if (oldMember.communicationDisabledUntilTimestamp !== newMember.communicationDisabledUntilTimestamp) {
    
    if (!oldMember.communicationDisabled || oldMember.communicationDisabled > new Date().setUTCDate()) // new timeout added
    
    {

        const expiresAt = new Date(newMember.communicationDisabledUntilTimestamp).toUTCString();  // expiration date of timeout

        let duration = newMember.communicationDisabledUntilTimestamp - new Date().valueOf(); // duration of timeout 

        if (duration < 3600000) {
            if (duration <= 60000) {
                duration = Math.ceil((duration / 1000) / 60) + ' minute';
            } else {
                duration = Math.ceil((duration / 1000) / 60) + ' minutes';
            }
        } else {
            if (duration <= 3600000) {
                duration = Math.ceil((duration / 1000) / 60 / 60) + ' hour';
            } else {
                duration = Math.ceil((duration / 1000) / 60 / 60) + ' hours';
            }
        }


        const embed1 = new Discord.EmbedBuilder();

        embed1
        .setTitle(`Member Timeout`)
        .setColor("Orange")
        .setTimestamp()
        .setFooter({text: `Time out by ${entry.executor.username}`})
        .setFields(
            {
                name: 'Member',
                value: `${newMember.user}`,
                inline: true,
            },

            {
                name: 'Duration',
                value: `${duration}`,
                inline: true
            },

            {
                name: 'Expires',
                value: `${expiresAt}`,
                inline: true
            },

            {
                name: "Reason",
                value: `${entry.reason || "No reason provided"}`,
                
                inline: false
            }
            
        )

    log_channel.send({ embeds: [embed1] });

   }

}

Here is what the issue looks like:

Help appreciated