2009-09-09 (first published: 2009-08-31)
1,313 reads
Scripts
2009-09-08 (first published: 2009-08-31)
483 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
106 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)
964 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,414 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,573 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
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers