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
Diagram of ADD FILE for E:\SQLAuthority.ndf on the primary replica, sent to the secondaries as a log record: a secondary with drive E: creates the file, a secondary without drive E: fails with error 5123 and is suspended

ADD FILE in an Availability Group: What Happens on the Secondary Replica

August 8, 2015
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL High Availability, SQL Scripts, SQL Server

ADD FILE on the primary of an availability group reaches every secondary as a log record. If the same path doesn’t exist on a secondary, the operation fails and data movement is suspended. Here is how to resume it.

Read More
SQL SERVER - Inserting into Sparse Column Sets and Errors Associated With It

SQL SERVER – Inserting into Sparse Column Sets and Errors Associated With It

July 27, 2015
Pinal Dave
SQL Tips and Tricks
SPARSE Columns, SQL Scripts

You can write to sparse column sets directly, not just read them. I show how to insert into column sets and the errors you hit without an explicit column list.

Read More
Gouache painting of four wheelbarrows in parallel each carrying part of a pumpkin pile, one pumpkin painted red

How to Find Queries Running in Parallel in SQL Server

July 25, 2015
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server

To find queries running in parallel, read max_dop and the CPU to elapsed ratio from the query stats view, then confirm with the plan XML. This post tests both on a two million row table. It also explains why the same query stays serial until its cost passes the threshold.

Read More
SQL SERVER - FIX – Property IsLocked is Not Available for Login

SQL SERVER – FIX – Property IsLocked is Not Available for Login

July 24, 2015
Pinal Dave
SQL Tips and Tricks
SQL Lock, SQL Scripts

Opening sa login properties in SSMS failed with Property IsLocked is not available for Login. I used Profiler to find the query returning NULL, and here is the fix.

Read More
SQL SERVER - Querying Performance Counters from SQL Server

SQL SERVER – Querying Performance Counters from SQL Server

July 14, 2015
Pinal Dave
SQL Performance
SQL Scripts

When SQL Server is slow, where do you start? I look at querying performance counters from inside SQL Server as a quick way to see what is going on.

Read More
SQL SERVER - How to Change Server Name?

SQL SERVER – How to Change Server Name?

July 13, 2015
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

I renamed my VM and needed SQL Server to match. Here is a query that shows the host and server names from every source, and how to change server name.

Read More
Gouache painting: an open wooden cupboard holding one glass jar with a lid and a single vermilion mango inside it, every other shelf empty

PostgreSQL Local Variable: DECLARE in a plpgsql Function

July 11, 2015
Pinal Dave
SQL Tips and Tricks
PostgreSQL, SQL Function, SQL Scripts, SQL Variable

A PostgreSQL local variable is declared in the DECLARE section of a plpgsql function or DO block. This post tests a function with two variables, the NULL start value, scope, CONSTANT, STRICT, a name clash error and the psql alternative.

Read More
Previous 1 … 160 161 162 163 164 165 166 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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