A two step easy way to restore master database: start SQL Server in single user mode, then restore from a full backup of master. No full backup, no restore.
SQL SERVER – Simple Example of Reading XML File Using T-SQL
A simple example of reading XML file content using T-SQL: load the XML into a variable and pull out elements and attributes with value() in a SELECT.
SQL SERVER – Simple Example of Creating XML File Using T-SQL
I always want to learn SQL Server and XML file. Let us go over a very simple example, today about how to create XML using SQL Server.
JSON_PATH_EXISTS: Distinguish Missing and Null Properties
JSON_PATH_EXISTS tests path presence, including JSON null. Compare missing properties, empty arrays and SQL NULL on SQL Server 2022.
SQL SERVER – Start SQL Server Instance in Single User Mode
How to start a SQL Server instance in single user mode: add the -m; startup parameter in SQL Server Configuration Manager and restart the service.
SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2
Part 2 on force index query hints: instead of the inline WITH table hint, use the OPTION clause at the end of the query and name the table for each hint.
SQL SERVER – Introduction to Force Index Query Hints – Index Hint
An index hint lets you force SQL Server to use a specific index in a query. I show the WITH (INDEX()) syntax with examples, and why it is for special cases only.