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
SQL SERVER - Error in Validation: Listener in Workgroup - Unable to determine if the computer exists in the domain 'WORKGROUP'

SQL SERVER – Error in Validation: Listener in Workgroup – Unable to determine if the computer exists in the domain ‘WORKGROUP’

April 5, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server

A client’s domain-less Always On cluster in Azure could not create a listener: Unable to determine if the computer exists in the domain ‘WORKGROUP’. Here is why.

Read More
Use query governor to prevent long-running queries.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 8649, State 1, Severity 17

April 4, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Upgrade

Patching SQL 2017 failed at msdb110_upgrade.sql with error 8649: the query cost exceeded the configured threshold. Here is the cause and the fix.

Read More
A paper roll releases a limited length while the rest remains on the spool

How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218

March 31, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL String

How do you limit the output of Varchar(max) or Nvarchar(max) in a SELECT statement? A simple trick does it, and it works for varbinary(max), text and ntext too.

Read More
Two hands passing a jar of sourdough starter across a counter, a loaf from it cooling behind

Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers?

March 28, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Scripts, SQL Server

Keep performance tuning scripts with explanations, before-values, undo steps, and a configuration history your team can compare later.

Read More
Two facing doors have paired brass handles, suggesting two interpretations of the same enclosure

How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217

March 24, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Configuration

How Does QUOTED_IDENTIFIER Works in SQL Server? I explain it in very simple words, using SELECT “Order By” with the setting OFF and then ON.

Read More
Different weighted bags balance on a simple beam, illustrating cost comparison

Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216

March 17, 2019
Pinal Dave
SQL Interview Questions and Answers
Parallel, SQL Performance, SQL Scripts, SQL Server

Do queries always respect the Cost Threshold for Parallelism? Not always, and a quick AdventureWorks test with the execution plan shows why.

Read More
Gouache painting of a rack of spice jars of different sizes with one worn jar lid in vermilion

Plan Cache Size in SQL Server: List Every Cached Plan

March 16, 2019
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Cache, SQL DMV, SQL Scripts

Plan cache size shows how much memory each cached query plan takes. This post lists every plan in one database with its size, its text and its execution count. It also explains why the cache entry and the plan itself report different sizes.

Read More
Previous 1 … 76 77 78 79 80 81 82 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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