Let us learn about upgrade the rule failure error in this blog post and learn how we can fix the error. Locate RSReportServer.config
Parallel Plans: Reading Gather Streams and Repartition Streams
Read Gather Streams and other parallel exchanges, inspect rows per thread and spill evidence, and relate exchange waits to actual work.
Does GROUP BY Sort Results? Only ORDER BY Guarantees It
Does GROUP BY sort the rows it returns? No: only ORDER BY guarantees an order. This post builds a small demo, shows one GROUP BY query returning two different orders, and reads the plans that explain why.
SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service
An upgrade from SQL Server 2008 R2 to 2014 failed after the product key step with: the specified service does not exist. Here is the fix.
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.
Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247
Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
Operator Costs in an Execution Plan: Read Them Without Being Fooled
Interpret operator costs as estimates, compare actual rows and runtime evidence, and find expensive work without trusting plan percentages.