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)
1,024 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)
817 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
726 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,144 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,816 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,537 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,181 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)
745 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,471 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,201 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Cara Refund Pesawat Pelita Air Telp/wa 08559003331
Untuk cara Refund atau Reschedule tiket Pelita Air. Anda bisa hubungi di 0855-900-3331 Merefund...
Cara Refund Pesawat Transnusa Telp/wa 08557033334
Untuk cara Refund atau Reschedule tiket Transnusa. Anda bisa hubungi di 0855-703-3334 Merefund atau...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers