Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: statistics

Which version of SQL Server 2016 supports R

By adminPosted on January 31, 2023

Question : Microsoft buying REvolution results (amongst other things) in the integration of R in SQL Server 2016. Looking through […]

Postgres date_trunc quarter with a custom start month

By adminPosted on January 23, 2023

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

By adminPosted on January 23, 2023

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?

By adminPosted on January 23, 2023

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

By adminPosted on January 22, 2023

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?

By adminPosted on January 19, 2023

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

By adminPosted on January 13, 2023

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

By adminPosted on January 3, 2023

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

By adminPosted on December 28, 2022

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

By adminPosted on December 24, 2022

Question : I’m doing some testing on sync vs async auto statistics updates. I’d like to quickly invalidate all statistic […]

  • 1
  • 2
  • 3
  • …
  • 25

Recent Posts

  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication
  • Is the overhead of frequent query cache invalidation ever worth it?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding