XML value extracts one typed scalar. Use a singleton path, review conversion, and distinguish first-item selection from uniqueness.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU
The MAXDOP query hint limits how many CPUs a query can use, though not which ones. With OPTION (MAXDOP 1), the parallelism operator leaves the plan.
Loading Large Files Fast With BULK INSERT
BULK INSERT loads large SQL Server files through a tested format, accessible path, staging table, measured batches, and final validation.
A Learning Path for a New SQL Developer
A new SQL developer can build skill in a clear order: relational basics, T-SQL, data modeling, plans, testing, and safe deployment habits.
Connecting Java Applications With the JDBC Driver
Choose a current JDBC driver for SQL Server, verify its connection URL and encryption settings, and test integrated authentication on the app host.
SQL SERVER – Checklist for Analyzing Slow-Running Queries
Before you call support, go through this Books Online checklist for analyzing slow-running queries: network, memory, statistics, indexes and more.
SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint
How do you force index scan instead of a seek, or read a table without using any index? Two reader questions with a similar answer, using a query hint.
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.