Find tables unused since last SQL Server restart
This script will return tables that haven't had any user activity since the SQL Server Service was last restarted. SQL 2005+
2011-07-22 (first published: 2010-01-28)
5,591 reads
Scripts
Backup or Restore progess
This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.
2011-07-18 (first published: 2010-02-19)
2,374 reads
consolidated script generator for multiple stored procedures
Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go
2011-07-15 (first published: 2011-03-28)
2,070 reads
2011-07-12 (first published: 2011-07-01)
1,142 reads
2011-07-11 (first published: 2011-07-02)
2,116 reads
Get information from tables
Give information in tables such as type size and description of each of the columns
2011-07-08 (first published: 2011-07-06)
1,478 reads
Email Long Running SPID Info
This script will email info about the longest running SPID in an HTML formatted table
2011-07-07 (first published: 2011-06-27)
2,199 reads
Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,177 reads
Date Dimensions in T-SQL using CTE
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,828 reads
Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,362 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Alamat BCA KCU ALAM SUTERA Telp/WA 0817839777
Phone Cs: 0817839777 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong,...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers