Find largest table in a SQL Server database Monitoring table size over time is very important to the SQL Server Engine. In performance point of view to run queries. At the most optimal and avoid performance issues due to larger table size as it important factor in SQL Server performance There are often many times people ask, how to find the largest tables/objects in a database, so below scripts, will determine which objects in a database are largest. SELECT t.name AS TableName, i.name as indexName, sum(p.rows) as RowCounts, sum(a.total_pages) as TotalPages, sum(a.used_pages) as UsedPages, sum(a.data_pages) as DataPages, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, (sum(a.data_pages) * 8) / 1024 as DataSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.object_id = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id WHERE t.name NOT LIKE 'dt%' AND i.object_id > 255 AND i.index_id <= 1 GROUP BY t.name, i.object_id, i.index_id, i.name ORDER BY TotalSpaceMB DESC

Getting wordpress menu to open submenu on click on the main menu item

Vikash

I've looked at many of the answers on this website but none of them are working on my website

I have the mobile version working with a workaround code

    window.addEventListener('load', function(){
    var menuItems = document.getElementsByClassName("menu-item-has-children");
    
    /*
     * Bij aanpassing mobiel menu, console.log(menuItems);
     * aanzetten, controleer de indexen van de mobiele menu items
     */
    // console.log(menuItems);
    
    menuItems[5].firstChild.removeAttribute("href");
    menuItems[5].firstChild.setAttribute("href", "#");
    menuItems[5].firstChild.addEventListener('click', (event) => {
        menuItems[5].firstChild.lastChild.click();
    });
    menuItems[6].firstChild.removeAttribute("href");
    menuItems[6].firstChild.setAttribute("href", "#");
    menuItems[6].firstChild.addEventListener('click', (event) => {
        menuItems[6].firstChild.lastChild.click();
    });
    menuItems[7].firstChild.removeAttribute("href");
    menuItems[7].firstChild.setAttribute("href", "#");
    menuItems[7].firstChild.addEventListener('click', (event) => {
        menuItems[7].firstChild.lastChild.click();
    });
    menuItems[8].firstChild.removeAttribute("href");
    menuItems[8].firstChild.setAttribute("href", "#");
    menuItems[8].firstChild.addEventListener('click', (event) => {
        menuItems[8].firstChild.lastChild.click();
    });
    menuItems[9].firstChild.removeAttribute("href");
    menuItems[9].firstChild.setAttribute("href", "#");
    menuItems[9].firstChild.addEventListener('click', (event) => {
        menuItems[9].firstChild.lastChild.click();
    });
});

But I want the desktop version to work the same way. The hover function can go if it's in the way.

I've tried this code, but it doesn't do the trick.

 if(clicked == false){
    document.getElementById("menu-item-has-children").style.display = "none";
    clicked = true;
}else if (clicked == true){
    document.getElementById("menu-item-has-children").style.display = "block";
    clicked = false;
}

The Satelite them is a real @#$ if it comes to the codes. I've looked and looked, but I can't find the code that works the hover anywhere (probably tucked away in a file I'll never find). But I'm using a child theme anyway, so I can add .php an .js files to overwrite anything. I just haven't found anything that works. Does anyone have any idea of how I could get this on click show of the sub menu to work?