A reader restored a full backup, then hit Error 3117: the log or differential backup cannot be restored. Here is why it happens and what to do.
SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist
My friend kept getting the server network address cannot be reached error while testing mirroring configured without domain on his laptop. Here is why.
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.
XML value: Select One Typed Scalar
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.
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.