Question: How to Use Multiple Hints Together for a Query?
Answer: Of course, you can use multiple hints for a query. Here is an example of the same.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Query Runs Slow Occasionally: Five Checks to Find Why
When a query runs slow occasionally, the cause sits around the query: a lock, a job, a file growth, tempdb or a shortage of worker threads. This post gives one tested T-SQL check for each and a small demo for blocking and file growth. It also says what to do when all five checks find nothing.
Long-Running Query for Demonstrations You Can Control
A long-running query for demonstrations has to run long enough to watch and stop when you say. This post builds one from a counting table, shows how its run time grows with the row count and explains how to watch and stop it. It also compares it with WAITFOR DELAY.
In-Memory OLTP Migration Checklist: Which Features Block You
An In-Memory OLTP migration checklist from SSMS lists the tables and procedures the engine will refuse. This post tests those refusals on SQL Server 2025, shows which old limits are gone, and adds a query that finds blockers in your own database.
SQL SERVER – Active Parallel Requests and Cached Parallel Query History
I Identify parallel running requests separately from parallel queries recorded in the cache. Those lists answer different performance questions.
Listing Driver, Encryption and Auth Scheme for Every Connection
Inspect the auth scheme, encryption, driver interface, and protocol for current SQL Server connections, then group the results clearly.
A Schedule Table That Repeats Every Other Week
Build an every other week schedule in T-SQL, skip holiday dates, find the next occurrence, and check rota weeks from one anchor.
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.