Question : On a fairly busy SQL server, we sometimes need to do large index-building operations (after importing ~6GB tables). […]
Category: Performance
Database design for varying amount of relations
Question : I am currently trying to design a database model to store all the possible nutrition data, but for […]
Implicit Conversion of VARCHAR Column to NVARCHAR does not cause expected table scan
Question : Given the following script, I can see implicit conversion and Data type precendence have a negative impact on […]
Execution plans behavior after a restart in SQL server
Question : I have been thinking about how the execution plans act in SQL SERVER after a restart of service. […]
Optimize PostgreSQL server setting for extremely wide tables
Question : We do have a dedicated server where only PostgreSQL 9.4.4 server is running, 2 physical cores, 16 logical […]
How to improve Procedure Cache Hit Ratio?
Question : From what I can tell Procedure Cache Hit Ratio below 95% is a problem. On my box, the […]
What’s the overhead of updating all columns, even the ones that haven’t changed [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
How can I speed up this query on table with 65 million records
Question : select hash_id, hash_value, substring(T.cri, 1, 7), substring(T.cri, 9, D2.Pos-9), substring(T.cri, D2.Pos + 1, D3.Pos – D2.Pos – 1), […]
Unused index in range of dates query
Question : I have a query that is not using existing indices and I do not understand why. The table: […]
MySQL Performance Problems
Question : Started having issues with our central production MySQL Database Server today. We have 1 central production MySQL 5.7.11-log […]