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)
973 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)
788 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
696 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,122 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,791 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,511 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,138 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)
690 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,399 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,178 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts