XML value extracts one typed scalar. Use a singleton path, review conversion, and distinguish first-item selection from uniqueness.
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.