Question : Microsoft buying REvolution results (amongst other things) in the integration of R in SQL Server 2016. Looking through […]
Tag: statistics
Postgres date_trunc quarter with a custom start month
Question : I’m trying to create quarterly average for player scores, however the default behaviour of postgres date_trunc(‘quarter’, source) is […]
Mysql.innodb_table_stats & mysql.innodb_index_stats not updating
Question : This question was migrated from Stack Overflow because it can be answered on Database Administrators Stack Exchange. Migrated […]
What permissions are required for UPDATE STATISTICS #table WITH ROWCOUNT = xxx?
Question : Can anyone point me to the correct documentation or additional permissions I need besides SA to do the […]
Cardinality Estimator Question after 2014 SP1 + CU4 Upgrade
Question : We recently upgraded from SQL Server 2008R2 to SQL Server 2014 SP1 + CU4. After a couple of […]
Where are Statistics physically stored in SQL Server?
Question : Where are the Statistics used by the Query Optimizer physically stored inside a SQL Server database file and […]
Questions on updating statistics and index maintenance jobs
Question : Since my question Index and statistics optimization scripts duration and log bloat problem. Looking for good strategy? has […]
Can’t understand results of pg_stat_statements view
Question : I configured my postgresql.conf (my version is 9.1) with the normal persistent configuration: shared_preload_libraries = ‘pg_stat_statements,plperl’ custom_variable_classes = […]
Statistics disappearing/empty randomly throughout the day
Question : I’ve got a SQL Server 2017 (CU9) database that is exhibiting some performance related issues that I believe […]
Quickest Method To Invalidate Statistics
Question : I’m doing some testing on sync vs async auto statistics updates. I’d like to quickly invalidate all statistic […]