This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Title card: Upgrade Rule Failure: No Custom Security Extensions

SQL SERVER – Upgrade Rule Failure Error: No Custom Security Extensions

October 25, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Upgrade

Let us learn about upgrade the rule failure error in this blog post and learn how we can fix the error. Locate RSReportServer.config

Read More
A railway yard where wagons roll into four sidings, one siding far longer than the other three.

Parallel Plans: Reading Gather Streams and Repartition Streams

October 24, 2019
Pinal Dave
SQL Performance
Execution Plan, MAXDOP, Parallel, SQL Performance, SQL Server

Read Gather Streams and other parallel exchanges, inspect rows per thread and spill evidence, and relate exchange waits to actual work.

Read More
Title card: The Specified Service Does Not Exist as an Installed Service

SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service

October 22, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation, SQL Upgrade, Starting SQL

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.

Read More
Title card: Log Shipping: Only Members of Sysadmin Can Do This

SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform This Operation

October 21, 2019
Pinal Dave
SQL Tips and Tricks
Log Shipping, SQL Error Messages, SQL Scripts, SQL Server

They have observed that Log Shipping Copy and Log Shipping Restore jobs have been failing with log shipping error. Let us fix them.

Read More
The beginning of an ordered line of pebbles occupies a separate tray compartment

Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247

October 20, 2019
Pinal Dave
SQL Interview Questions and Answers
MariaDB, MySQL, PostgreSQL, SQL Server

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.

Read More
Hands holding a huge airy meringue and a small dense fruitcake, the hand with the fruitcake sinking lower.

Operator Costs in an Execution Plan: Read Them Without Being Fooled

October 19, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Operator, SQL Performance, SQL Server

Interpret operator costs as estimates, compare actual rows and runtime evidence, and find expensive work without trusting plan percentages.

Read More
Gouache painting of several rowboats waiting at a canal lock with one vermilion boat edging ahead

Priority Boost in SQL Server: Check It and Turn It Off

October 18, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio

Priority boost sounds like a speed setting, but it can make a server slower. This post explains what the option does, checks it with a query that works when Management Studio doesn’t show it, prints the statements that turn it off with their undo, and explains why a restart is needed.

Read More
Previous 1 … 66 67 68 69 70 71 72 … 420 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com