Canadian Postal Code validator
This is a slight improvement on the script posted the other day. Uses PATINDEX for pattern match, and checks for forbidden characters D, F, I, O, Q, U.
2007-08-14 (first published: 2007-01-15)
994 reads
Scripts
Chunk Transfer
Work table method for transferring any table across replication in usable transactional chunks. Very useful for publishers requiring bulk insert operations on source tables.
2007-08-13 (first published: 2007-01-11)
792 reads
SSRS Multi-Select
Regarding:Multi-Select Parameters for Reporting ServicesRegular Columnist : Adriaan Davel Posted: 08/13/2007 Our solution:Create a table function to parse the values into a table.Usage:In a stored procedure called by SSRS, pass the multi-select values into this function to return a table of key/value pairs.ie:select * from fnCSV_Parse (',' , 'ca,de,ny,wa')yeilds:tblID Keys-----------------1 […]
2007-08-13
700 reads
Alter Index with online rebuild - SQL 2005
This is an Alter Index script i made up from the one found in BOL and some other scripts we had. You need to create a table to hold the fragmentation data and it has a date column so you can track historical data. You can also add a db_mail part at the end to […]
2007-08-10 (first published: 2006-11-30)
2,124 reads
Compare the Data in Two Tables
These queries are used to compare the data in two tables. In these examples all the rows in each table is retrieved and compared using the UNION ALL command. I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]
2007-08-09 (first published: 2006-11-29)
2,795 reads
Backup database (Red Gate/Native Backup)
This script create a store procedure which allow you to backup databases using Red Gate SQL Backup or native SQL backup.Backups will be stored in a database named folder in a backup folder.
2007-08-08 (first published: 2006-11-28)
1,512 reads
How to Find Beginning and End of Week
How to Find Beginning and End of Week(for more scripts goto http://www.siccolo.com/articles.html)
2007-08-06 (first published: 2006-11-21)
1,143 reads
How to Validate Bank Routing Using Check Digit
To verify bank routing number by calculating correct check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) and compare with digit #9 in given 9-digit routing number.(for more scripts goto http://www.siccolo.com/articles.html)
2007-08-03 (first published: 2006-11-21)
696 reads
How to Calculate Bank Routing Check Digit
To calculate bank routing check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) (for more scripts --> goto http://www.siccolo.com/articles.html)
2007-08-02 (first published: 2006-11-21)
1,408 reads
Database,Drive,Data file growth monitor
This script is to monitor drive\database file space. There are variations of this script. The one posted has 2 parts. The frist is one that loops through the databases on a particular server calling the second which is the proc that gathers the information.
2007-08-01 (first published: 2006-11-21)
1,180 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers