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.
SQL SERVER Management Studio – ALT Keys Trick to Select Vertical Text
Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.