Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
SQL SERVER – Always On Availability Groups and Full-Text Index
One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well. In a recent engagement, one of their developers asked a question about the coexistence of full-text index and always on availability groups. In this blog, we would learn about one common issue which you might face when full text and availability group is used together.
SQL SERVER – Unable to Create Always On Listener – Attempt to Locate a Writeable Domain Controller (in Domain Unspecified Domain) Failed
This is one of the common causes in Always On for which my clients contact me – “Unable to create listener”. In this blog we would learn about how to fix event Id 1212 – Attempt to locate a writeable domain controller.
SQL SERVER – Always On Secondary Replica Huge Redo Queue – Version Store is Full. New Version(s) Could Not be Added
One of my earlier clients to whom I helped in configuration Always On Availability Group came back to me with strange behavior. In this blog, we would discuss error Version store is full. New version(s) could not be added. In this situation, I also found that the redo queue was increasing continuously on the secondary replica.
SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault
Along with my performance consulting, I also help many clients in fixing some quick issue. You can refer to various consulting services which I provide. This blog is an outcome of one such engagement where the has Azure Key vault and was not able to delete it. In this blog, we would learn about how to fix error Vault ‘Name’ cannot be deleted as there are existing resources within the vault.
SQL SERVER – Configuration Manager Error: The Server Threw an Exception [0x80010105]
In my previous blog, I showed one of the errors caused due to disabled WMI service. In this blog, we would learn how to fix error “The server threw an Exception [0x80010105]” while using SQL Server Configuration Manager.
How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
Question: How to Find Queries Using an Index From SQL Server Plan Cache?