This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Question: Do Queries Always Respect Cost Threshold of Parallelism?
SQL SERVER – List Query Plan, Cache Size, Text and Execution Count
I love the curious questions from people who attended the class. Here is one such question during recent SQL Server Performance Tuning Practical Workshop. Let us see the question which I received about the Query Plan.
SQL SERVER – Difference Between Status in SP_Who2 – Running, Pending, Runnable, Suspended, Sleeping
One of the most popular questions I receive during my Comprehensive Database Performance Health Check is a difference between status in sp_who2 which discusses status as Running, Pending, Runnable, Suspended. Let us today understand them with regards to CPU.
SQL Monitor 9 – Proactively Monitor Large SQL Server Estates
The way it works out in most cases is, when organizations are small, the team put in place rock-solid plans to monitor their servers.
Changing Trends & Technology – Challenging DBAs
The biggest challenge as any technologies is that while you are getting super specialist at what you do, the world around you move so much ahead that when you look outside your windows you feel that you are expert at the technology which is actually history. This is indeed true in the world of changing trends and technology.
Business Secrets in SQL Server Performance Tuning Practical Workshop for EVERYONE
Lots of people often ask me – What Will Attendee Learn in SQL Server Performance Tuning Practical Workshop for EVERYONE scheduled on April 23rd, 2019? The answer is pretty straight forward – my business secrets.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.