2018-10-29 (first published: 2018-10-19)
1,468 reads
Scripts
Mechanism To Dynamically Build Pivot Table
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
1,010 reads
2018-10-24 (first published: 2018-10-15)
936 reads
Detect and Repair Non Trusted Foreign Keys
Create the code to detect and repair non trusted foreign keys
2018-10-23 (first published: 2018-09-27)
724 reads
2018-10-12 (first published: 2018-10-04)
1,175 reads
How to Identify backup tables within production databases
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
582 reads
number of rows and columns of an instance
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
519 reads
Data Collections restart and clear cache files
Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.
2018-10-02 (first published: 2018-09-25)
1,461 reads
Conditionally Order By Different Column
Order records based on a different column depending on which absolute value is greater.
2018-10-01 (first published: 2018-09-26)
656 reads
2018-09-26
482 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