Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Why SQL server errorlog files are extremely require, coz it captures system and user related errors and to troubleshoot the issue or as a pro-active …
Continue reading Reading SQL server error logs and its configuration
Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Azure Synapse Dedicated SQL Pools is that while they have auto create stats, there is no auto update stats. So statistics will become stale faster. …
Continue reading Find last statistics update & outdated and missing stats in Synapse SQL Pools
Disclaimer: Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Introduction: Microsoft re-written its legacy Cardinality Estimator in SQL server 2014 to help provide more accurate data to optimizer to prepare more efficient query plan thus …
ADsql-Tech Forever 
You must be logged in to post a comment.