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 dialog box.

SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.

March 2, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Configuration

After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.

Read More
Gouache painting of white card model houses on a drafting table with a vermilion waste bin nearby

Hypothetical Indexes in SQL Server: Find and Drop Them All

February 28, 2019
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Statistics

Hypothetical indexes are leftovers from the Database Engine Tuning Advisor. They hold a name and statistics but no data. This post lists them, shows they cannot serve a query, and drops them in two steps: a list you read first, and a drop second.

Read More
A sieve retains two kinds of smooth pebbles while unwanted sand falls into a bowl

How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214

February 24, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Datatype, SQL Scripts, SQL Server, SQL String

A reader wanted only the values that mix letters and numbers from a column. Here is how to extract alphanumeric values from a string with simple pattern matching.

Read More
Gouache painting of a cabinet of drawers each holding a bolt and washers, one bolt in vermilion

Index Key Columns and Included Columns in SQL Server

February 21, 2019
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts

Index key columns and included columns show what each index really stores. This post builds one query that lists them for every index, then a second query that finds indexes with the same keys or a shared leading key. It ends with the rules for merging them safely.

Read More
SQL Server authentication mode.

SQL SERVER – Windows Authentication or System Admin Account (SA)

February 18, 2019
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

Windows Authentication or the SA account? A client asked me in a Health Check, and here is why my advice is Windows Authentication wherever you can.

Read More
A small scoop holds a sample in front of a broad full tray

How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213

February 17, 2019
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Statistics

How to find table cardinality from the execution plan? I answer this health check question in two different ways, using a simple AdventureWorks query.

Read More
Gouache painting of a toll plaza with two crowded lanes and one idle lane with a vermilion barrier arm

Update Statistics With FULLSCAN and MAXDOP in SQL Server

February 15, 2019
Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Scripts, SQL Statistics

To update statistics with FULLSCAN in parallel, add MAXDOP to the statement. This post builds a table of 3 million rows, times the update with MAXDOP 1, the instance default and 8, and shows which statistics speed up and which do not.

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

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