I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Capture Query Plans Using Extended Events and Traces.
SQL SERVER – Stored Procedure and RETURN Keyword
The stored procedure was very long and we had to debug that one step at a time. Let us learn about Stored Procedure and RETURN Keyword.
SQL SERVER – Creating a Nonclustered Columnstore Index on Temp Table
I was delivering training on SQL Server Performance Tuning, I received a question on nonclustered columnstore index on a temp table.
SQL SERVER – Getting Second Row from Table
The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset.
SQL SERVER – Group By Orders Data by Columns Ascending
The question was about Group By Orders Data by Columns Ascending. DBA asked me an interesting question referring to my older blog.
SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service
During an upgrade, as soon as they enter the product key and hit next, setup was failing with an upgrade error. Let us learn how to fix the error.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform This Operation
They have observed that Log Shipping Copy and Log Shipping Restore jobs have been failing with log shipping error. Let us fix them.