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,202 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,263 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,017 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,260 reads
2009-01-21 (first published: 2009-01-08)
945 reads
Blogs
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers