2009-09-09 (first published: 2009-08-31)
1,313 reads
Scripts
2009-09-08 (first published: 2009-08-31)
481 reads
Nth occurrence of a weekday in a month and year
To find date at nth occurrence of a weekday in a month and year
2009-09-07 (first published: 2009-09-01)
755 reads
2009-09-04 (first published: 2009-08-31)
2,297 reads
Move one Filegroup to another
This script copies all tables found in a specific filegroup to another specific filegroup.
2009-08-19
105 reads
Find all Procedures, Views, Functions that have been renamed
Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.
2009-08-17 (first published: 2009-08-06)
963 reads
BCP Format File Builder
Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.
2009-08-14 (first published: 2009-08-04)
2,412 reads
Sending SMTP email from SQL Server using CDO
If you would like to send email from SQL Server, use this CDO method and store proceudre.
2009-08-13 (first published: 2009-07-29)
4,572 reads
Automatic Generation of Insert, Update and Delete stored procedures
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,205 reads
Backup Both Full and TLog Database Backup within a single Job
This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.
2009-08-11 (first published: 2009-07-23)
1,621 reads
Blogs
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...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
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...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
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