Return X Day of Month
This function will return the first, second, third, fourth or last day of a given month.
2009-03-03 (first published: 2009-02-10)
1,203 reads
Scripts
TEXT/NTEXT Find and Replace
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
900 reads
Default Trace Load of All 5 Files
The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.
2009-02-25 (first published: 2009-02-07)
1,265 reads
2009-02-16 (first published: 2009-02-03)
2,643 reads
sp_wcProject
A stored procedure which provides wildcard column selections plus some additional bells and whistles
2009-02-03 (first published: 2009-01-28)
894 reads
Two scripts to spell out numbers in words
These SQL functions will allow you to convert decimal numbers to words
2009-02-02 (first published: 2009-01-22)
2,006 reads
Growth remaining for SQL Server 2005 databases
This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.
2009-01-30 (first published: 2009-01-19)
951 reads
2009-01-23 (first published: 2009-01-14)
2,018 reads
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,262 reads
2009-01-21 (first published: 2009-01-08)
946 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers