Question : I need to read data from a linked server and insert into a local table. I need to […]
Category: Query Performance
Understanding MAXDOP behaviour for queries going parallel
Question : For my current server as below 4 Sockets with 10 cores per socket and 20 logical processors per […]
High CPU usage on Azure SQL Server ~1.6m rows
Question : I’m currently running into an issue with one of our databases in Azure where 1 table is forcing […]
Get the id_user_app if not exists in id_user_rq
Question : I’m building a application and have this table for users relationships. I need to build some queries like […]
MY Sql group by taking too much time [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
PostgreSQL query very slow when subquery added
Question : I have a relatively simple query on a table with 1.5M rows: SELECT mtid FROM publication WHERE mtid […]
mysql query takes too long for a million row table using count() and group by
Question : I want to retrieve phone_num and their count of unread message for each phone number from the table […]
Optimizing ORDER BY for simple MySQL query
Question : I’m trying to optimize this really simple query, and it gives me grief for a day now 🙁 […]
Unable to understand correlation between MaxWorkers created and CPU utilization
Question : I am having a strange issue which i am unable to understand: On my server with 64 Logical […]
T-SQL Query or DB Engine Optimization? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]