List Jobs and their respective programming.
List all active Jobs in SQL Server with the details of the schedule.
2013-02-25 (first published: 2013-02-07)
1,313 reads
Scripts
2013-02-22 (first published: 2013-02-05)
1,804 reads
Script to Rebuild/Reorganise Indexes
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
2013-02-19 (first published: 2013-01-29)
2,135 reads
2013-02-18 (first published: 2013-01-25)
2,782 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
6,070 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,270 reads
2013-02-13 (first published: 2013-01-25)
2,007 reads
Generate Column Metadata
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
766 reads
Tables and rows listing
Simple script which create a list of all the tables and rows of the selected DB.
2013-02-11 (first published: 2012-12-21)
1,180 reads
2013-02-08 (first published: 2012-12-27)
1,549 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers