Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2018-04-26 (first published: 2009-10-06)
16,986 reads
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
35,985 reads
Generate large sample data for your performance and other uses
2018-04-24 (first published: 2018-04-18)
3,047 reads
Update the statistics starting from most accessed and modified ones, with a time limit. Procedure will exit when @MaxExecutionTime parameter is greater than the current execution time.
2018-04-19 (first published: 2018-04-16)
528 reads
2018-04-18 (first published: 2018-04-12)
4,351 reads
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
2,224 reads
Script powershell/SMO que gera os scripts de DROP/CREATE para cada JOB existente na instância
2018-04-16 (first published: 2018-04-13)
646 reads
It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details
2018-04-11 (first published: 2018-03-29)
754 reads
It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.
2018-04-05 (first published: 2018-03-22)
1,484 reads
It will help to development team to find their developed & DB server status check.
2018-03-28 (first published: 2018-03-22)
2,626 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers