hx_dbMaintancePlans
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
399 reads
Scripts
2001-08-22
741 reads
hx_GetPKLessTables
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
439 reads
2001-08-22
583 reads
2001-08-22
742 reads
hx_OLEDBproviders
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
449 reads
hx_ShowFixedDriveSpace
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
696 reads
2001-08-22
417 reads
2001-08-22
758 reads
Idle Spid Time
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
1,019 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
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers