2019-06-14
1,045 reads
Junior Galvão - MVP
2019-05-14
578 reads
2019-03-21
660 reads
2019-02-27 (first published: 2019-02-20)
284 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.
2019-01-15 (first published: 2019-01-08)
512 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.
2018-07-10 (first published: 2018-07-05)
351 reads
2018-06-22
906 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.
2018-06-14 (first published: 2018-06-12)
376 reads
2018-05-22
801 reads
2018-04-20
677 reads
Blogs
SQL Server Containers Are Boring
Not really, but sort of. The beauty of containers, at least in a dev/test...
Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you...
It’s interesting how an OR short circuits.
I recently did a post on the case expression short circuting and received a...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Always on AG and SQL Upgrade
Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...
Migration from server to server
I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...
Ask SSC