Using temporary tables with OUTPUT clause

Database Properties

Using table hint TabLock

Simulating locking in page level

Through the shared script, you can see the Paglock table hint.

Files with larger disk consumption

This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.

User Stored Procedure for Backup of user databases

This script is intended to demonstrate how we can create a stored procedure for the user responsible for backing up user databases in a default storage location.

Arithmetic

Entering random data into a table

Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.

Page considered Suspect in SQL Server 2017

Manage the suspect_pages Table on SQL Sever 2017