Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Heaps, Scans and RID Lookup
The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
Capturing sp_WhoIsActive Snapshots to a Table Every Minute
Capture sp_WhoIsActive snapshots every minute, keep seven days, and query past blockers and long requests from a logging table.
AUTO_UPDATE_STATISTICS_ASYNC Fixes WAIT_ON_SYNC_STATISTICS_REFRESH
AUTO_UPDATE_STATISTICS_ASYNC is the setting that cleared a new wait type, WAIT_ON_SYNC_STATISTICS_REFRESH, for my client. With auto update statistics on and stale statistics, the query halts while the statistics update. Switching the update to asynchronous removed the wait.
Find All Columns With a Specific Name in 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.
Provisioning Computer Object Failed With Error 5: Always On Listener Failure
Provisioning computer object failed with error 5 is a cause of Always On listener creation failure. The cluster log showed the cluster computer object being denied access while changing the listener’s password. Giving the CNO Full Control over the listener object fixes it.
SqlServerWriter Missing in vssadmin: Causes and Fixes
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.