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.
2018-07-10 (first published: 2018-07-05)
505 reads
Testing Transaction Logs restore
2018-07-09 (first published: 2018-07-04)
489 reads
The T-SQL script created a databases using the default file locations from SQL server configuration and prints them in the end.
2018-07-05 (first published: 2018-06-28)
1,932 reads
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
418 reads
2018-06-15 (first published: 2018-01-04)
2,090 reads
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.
2018-06-14 (first published: 2018-06-12)
1,409 reads
2018-06-12 (first published: 2018-01-03)
1,960 reads
Find out-of-date statistics for 30 days
2018-06-11 (first published: 2018-01-03)
2,648 reads
Database-based Transaction Counting Find Script
2018-06-08 (first published: 2018-01-03)
2,530 reads
What are the indexes and types found in our tables?
2018-06-07 (first published: 2018-01-13)
2,366 reads