2014-01-17 (first published: 2014-01-03)
1,785 reads
Scripts
TEMPDB Configuration per vCPU
A simple script for automation of additional secondary data files of tempdb.
2014-01-14 (first published: 2013-12-27)
2,418 reads
To check the full backup duration of an SQL Instance
This script will check the full backup time taken by all the databases of an SQL Server instance.
2014-01-13 (first published: 2014-01-07)
1,372 reads
To check the Backup Status for an SQL Instance
This Script will fetch database backup information from msdb and give the idea about full, diffrential and log backup.
2014-01-10 (first published: 2014-01-04)
1,417 reads
Total Space Used for all databases per disk
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
2014-01-08 (first published: 2012-05-04)
3,988 reads
Generate MERGE statements with Table data
A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.
2014-01-07 (first published: 2012-03-14)
7,998 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,315 reads
Advanced Display Table and Column Info
A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.
2014-01-03 (first published: 2013-12-10)
1,740 reads
List all Usernames, Roles for all the databases.
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
2013-12-30 (first published: 2008-07-24)
45,320 reads
Get all user def table info
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,708 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers