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

Firebase setDoc results in a async/await error

Vikash

Right now, I am making an app for my client and I have a form that should register a new user. I have initialized my firebase app, both in project and in the console. I put setDoc operation in my submit function(and I used async/await), but in the console I get the following error:

Uncaught (in promise) FirebaseError: Missing or insufficient permissions.

I am making my project using react, if that helps. Here is my function:

const submit = async () => {
        if(name.length >= 3 && surname.length >= 3 && phone.length >= 9 && code.length == 3)
        {
            const userName = name + surname
            const ref = doc(db, 'users', userName)
            const data = {
                name: name,
                surname: surname,
                phone: phone,
                code: code,
                userName: name + surname
            }
            console.log(data)
            await setDoc(ref, data).then((res) => {
                window.alert('?????????????? ? ???????!')
                router('/')
            })
        }
        if(name.length <= 2) setNameError(true)
        if(surname.length <= 2) setSurnameError(true)
        if(phone.length <= 8) setPhoneError(true)
        if(code.length != 3) setCodeError(true)
        
    }

Thanks in advance to the people that will answer this question :)