Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.
SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure
First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.
SQL Saturday Prague 2019 – Pre-Con: 21 Essential Scripts: Performance Tuning for EVERYONE
I will be visiting SQL Saturday Prague 2019 and will be presenting my most popular pre-conference on September 20, 2019, at 9:00.
What are the Different Types of SQL Server CHECKPOINT? – Interview Question of the Week #230
Question: What are the Different Types of SQL Server CHECKPOINT?
Answer: There are four different kinds of checkpoints in SQL Server.
Personal Technology – Blinking or Flashing Yellow Light in Alexa – Solution
I am going to write about an issue which I am facing in my home office about Blinking or Flashing Yellow Light in Alexa and the solution.Â
SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure
SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.
Techorama Netherlands 2019 – 0 (Zero) to Hero: 21 Essential Performance Scripts for Every DBA #TechoramaNL
Techorama Netherlands I will be presenting my most popular pre-conference 0 (Zero) to Hero: 21 Essential Performance Scripts for Every DBA.