Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. Today I will share another script which I have written which I frequently use with my consulting engagement Comprehensive Database Performance Health Check.
How to Compile Queries and Not Execute Them? – Interview Question of the Week #219
Question: How to Compile Queries and Not Execute them?
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.
How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213
Question:Â How to Find Table Cardinality from the Execution Plan?
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Question: Does Parallel Threads Process Equal Rows?
SQL Server Performance Tuning Practical Workshop – Relaunched
In the year 2017 just for an experiment, I decided to start a SQL Server Performance Tuning Practical Workshop. I had no idea, that I will be the biggest and most popular service delivered by SQLAuthority.com. Since the year 2017, I have been delivering one or two workshops every week.
SQL SERVER – Performing IF…THEN In T-SQL With IIF Expression
Today, we are going to see one of the most underutilized features of SQL Server IIF. In SQL Server we can performance IF…THEN logic in T-SQL with IIF Expression but I hardly see it being used at most of the organization.