Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.
2013-07-26 (first published: 2009-01-16)
2,314 reads
2013-07-25 (first published: 2002-03-19)
3,748 reads
Job list cluttered?
This script will return a list of jobs that either have not run in X months or where the next schedule run date is older than today.
2013-07-24 (first published: 2013-06-25)
1,266 reads
2013-07-22 (first published: 2009-04-30)
3,893 reads
2013-07-19 (first published: 2013-07-01)
644 reads
Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.
2013-07-17 (first published: 2009-05-30)
2,772 reads
Split a string with separator without looping. Can be efficiently used with joins if necessary.
2013-07-12 (first published: 2013-06-15)
2,361 reads
2013-07-10 (first published: 2013-06-19)
1,619 reads
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
962 reads
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
808 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers