SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Junior Galvão - MVP

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Simulating locking in page level

Through the shared script, you can see the Paglock table hint.  Read more...
By Junior Galvão - MVP 2019/02/27 | Source: SQLServerCentral.com | Category: table hint
Rating: |  Discuss |   Briefcase | 123 reads

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.  Read more...
By Junior Galvão - MVP 2019/01/15 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 329 reads

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.  Read more...
By Junior Galvão - MVP 2018/07/10 | Source: SQLServerCentral.com | Category: user database
Rating: |  Discuss |   Briefcase | 314 reads

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.  Read more...
By Junior Galvão - MVP 2018/06/14 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 347 reads
   Items 1 to 4 of 4