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
A flock gathered at a gate gives a concrete scene for counting a collection

What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261

January 26, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Counter, SQL DMV, SQL Scripts, SQL Server, SQL Server Management Studio, SQL System Table

Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.

Read More
RID Lookup

SQL SERVER – Heaps, Scans and RID Lookup

January 25, 2020
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Heap, SQL Index, SQL Scripts, SQL Server

The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.

Read More
Gouache painting of a chest of drawers pulled partly open, each drawer holding a sage ball of yarn and one vermilion ball

Find All Columns With a Specific Name in SQL Server

January 22, 2020
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Datatype, SQL Scripts, SQL Server

To find all columns with a specific name, query sys.columns and join sys.types for the data type. This post lists the matches with their schema, leaves out system objects, and then uses the same catalog to find names that appear with different data types.

Read More
Gouache painting of a freight train of coupled cars along a track, the nearest car vermilion

SqlServerWriter Missing in vssadmin: Causes and Fixes

January 20, 2020
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Command, SQL Error Messages, SQL Scripts

SqlServerWriter missing from the vssadmin output means a backup tool that relies on VSS cannot back up SQL Server. This post checks the three causes: a space at the end of a database name, a login without sysadmin rights, and a stopped writer service. It tests the name check with a demo database.

Read More
An unfinished knitted square can be unravelled and worked anew from the same yarn

How to Recompile Stored Procedure? – Interview Question of the Week #260

January 19, 2020
Pinal Dave
SQL Interview Questions and Answers
Parameter Sniffing, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:

EXEC sp_recompile ‘NameofSP’

Let us read more about it.

Read More
Illustrated cover: Temp Table vs Table Variable

SQL SERVER – Temp Table vs Table Variable – Cardinality Estimation

January 17, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server, SQL TempDB, Temp Table

I had a very interesting conversation with one of my clients about Cardinality Estimation for Temp Table vs Table Variable. Let us discuss it today.

Read More
Gouache painting of an old wooden rowboat tied to a dock cleat with a vermilion rope pulled into a tight knot

Error 15141: Upgrade Fails Because a Login Owns an Availability Group

January 14, 2020
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Scripts, SQL Server, System Database

Error 15141 means the server principal owns one or more availability groups and cannot be dropped. The msdb110_upgrade.sql script failed on a DROP LOGIN, and the script level upgrade for master failed with it. Changing the group owner to sa let the upgrade finish.

Read More
Previous 1 … 50 51 52 53 54 55 56 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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