Find Most Expensive Queries Running on a Table I was investigating SQL Server performance issue on a table where I was getting more locks, query timeout expires, on a table that has more than a hundred columns. So I was just wanted to know what are the most expensive queries running on that SQL Server table. I would like to share my script that will return most expansive query running on a table, Hare I am using DVM to find the most expansive query. Suppose we have a table called calls SELECT TOP 15 SQLQueries=SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time, qs.last_worker_time, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time, qp.query_plan FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp where SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)+1) like '% calls %' -- ORDER BY qs.total_logical_reads DESC -- logical reads -- ORDER BY qs.total_logical_writes DESC -- logical writes ORDER BY qs.total_worker_time DESC -- CPU time The above script will return the most expansive query running on “calls” table. you can change the order by clause on Logical reads, Logical writes or on CPU time. Please note : Running in your environment replace “calls” from script to your table name. ie % calls %

CSS on a custom embed sender on a dashboard

Seema

Hello i cant make this work, im making an embed sender with my bot on dashbaord, and i cant make color input good, when i put height auto its broken. I want it to look like a discord embed. The color on embed isnt going to the bottom. The color cant be fixed cause theres textarea and if it we resize it then its not gonna go to the bottom. Also textarea must be resiable.

Image

HTML (ejs):

<html>
   

    <body>
        <div class="mainBoxDash">


            <div class="settings">

                       

                <form method="POST">

                        <div class="customEmbed2">
                            <p class="changeEmbedSettings">Change all embed settings down below</p>
                            <div class="lineWelcome"></div>

                            <img class="embedImageBot" src="<%= bot.user.avatarURL()%>" alt="">
                            <p class="botName"><%= bot.user.username%></p>
                            <img class="botTag" src="https://cdn3.emoji.gg/emojis/bot.png" alt="">
                            <div class="embed">

                                <input type="color" id="embedColor" class="embedColor" accept="hex" name="embedColor" value="#0076ff">
                                <%- guild.icon ? `<img src="https://cdn.discordapp.com/icons/${guild.id}/${guild.icon}" class="authorImage">` : `<img src="https://maki.gg/static/app-assets/images/portrait/default.png" class="authorImage">` %>
                                <input class="authorName" name="authorName" maxlength="100"  value="<%= guild.name %>">
                                <textarea name="descriptionBot" id="descriptionBot" class="descriptionBot" maxlength="4096" required="required">Embed Description</textarea>
                                <input class="footerName" name="footerName" maxlength="32"  value="<%= bot.user.username %> • <%= new Date().getFullYear();%>">
                            </div>
                            <div class="invisibleEmbed"></div>                            
                        </div>

            

                    <button type="submit" class="saveSettings">
                        <p class="saveText">Send Embed</p>
                    </button>

                </form>

            
            </div>

            <%- include('footer'); -%>
        </div>
    </body>
</html>

CSS:

.embed{
    background-color: #2f3136;
    width: 70%;
    height: auto;
    margin-left: 85px;
    margin-top: 5px;
    border-radius: 5px;
}

input[type="color"] {
    -webkit-appearance: none;
    border: none;
    width: 3px;
    height: auto;
    
}
input[type="color"]::-webkit-color-swatch-wrapper {
    padding: 0;
}
input[type="color"]::-webkit-color-swatch {
    border: none;
}